Mastering SQL Certification Training Bundle

Teachers

Study247

Category:

Microsoft Courses/ Bundle Deals/

Mastering SQL Certification Training Bundle

Trusted by professionals from some of the world's leading companies

Price Original price was: £595.00.Current price is: £295.00. Includes VAT

Bulk Discounts

Bigger orders = better discounts

Title	Courses	Discount
Discount	3 - 14	10% £265.50
Discount	15 - 49	20% £236.00
Discount	50 - 99	30% £206.50
Discount	100 - 999	40% £177.00

Enquire

Duration: 210 Hours

Awarded By : Microsoft

Access : 12 Months

Type : Online Course

Eligible to Apply : Yes

Learn How It Works Book Your Exam Buying for your team?

Course Description

Mastering SQL certifications series covers the essential skills needed for administering and developing database solutions and for leveraging business intelligence (BI) tools. Whether your focus is SQL Server administration, programming or business intelligence and reporting, we help you to prepare for your SQL certification exams through these series of courses.

Today's IT Industry demands that professionals cover the latest technology on the marketplace. Many IT professionals separate themselves from their competitors by achieving certifications in the most current technologies and giving themselves skill-sets that are unmatched by many of their peers. Get the Business Intelligence Skills to Deliver Breakthrough Insights with SQL Server. Prove your knowledge and skills in designing, building, and maintaining the next wave of cloud-ready database and information solutions.

Entry Requirement

Working knowledge of relationship databases.
Basic knowledge of the Microsoft Windows operating system and its core functionality.

Who Is This Course For?

This course is Ideal for IT professional that have System Center Configuration Manager 2012, Windows Server, security and networking experience in an enterprise environment. They should also have basic Microsoft SQL Server and Windows PowerShell knowledge, mobile device management and application configuration experience.By choosing online learning instead of a classroom based course, it eliminates the need for time away from work, saving you valuable time and money. It is ideal for those with tight schedules as our online courses give you 12 months unlimited access to all the course materials, so you can study at a pace that suits you. Allowing you to easily resume your studies whenever you have the time. All you need is internet connection to study, so you can study from the comfort of your home or any environment that suits you.

Certification Details

In order to earn your certification, you’ll have to sit an exam after completing your course with us. To prepare you for your exam, we provide interactive quizzes after each module and a mock exam at the end of your course to ensure you’re fully prepared for the real thing. Once you’ve passed with at least 85%, you’ll be ready to book your exam as a private candidate.

Booking your exam is pretty simple, just purchase your exam voucher and schedule your exam. To make life easier, we can help you find an appropriate exam centre and give you all the information you need to secure your place.

Please note that the exam fees aren’t included in the course price.

Got a question about exams? Contact one of our course advisors. We’re happy to help!

Requirements

Our training works on all devices including Mobile phones, IPad’s, Android tablets, Macs and PC’s.

For the best viewing experience on our state-of-the-art eLearning platform we recommend an internet connection of 10Mbps or better. Please also use Google Chrome or Mozilla Firefox as your browser with Adobe Flash Player.

Course Outline

Microsoft 70-461: Querying SQL Server 2012

Module 1

Module 2

Module 3

Module 4

Module 5

Module 6

Module 7

Module 8

Module 9

Module 10

Microsoft 70-462: Administering SQL Server 2012 Databases

Module 1

Module 2

Module 3

Module 4

Module 5

Module 6

Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012

Module 1: Introduction to Data Warehouses

1.1 Overview of Data Warehouses
1.2 Examine Data Warehousing Concepts
1.3 Introduction to Data Analysis and Reporting Concepts

Module 2: Creating Dimensions and Changing Granularity of Dimensions

2.1 Create Dimensions
2.2 Change Granularity

Module 3: Creating Fact Tables and Column store Indexes

3.1 Create Fact Tables
3.2 Create Column store Indexes

Module 4: Implementing Data Warehouses in SQL Server 2012

4.1 Overview of Data Warehouse Components
4.2 Install Integration Services

Module 5: Working with Integration Services

5.1 Create an SSIS Project
5.2 Add Packages to an SSIS Project

Module 6: Managing Control Flow

6.1 Deploy a Control Flow
6.2 Execute Packages from Different Control Flow

Module 7: Working with Dynamic Variables

7.1 Create Expressions with Variables
7.2 Create Package Templates

Module 8: Implementing Data Flow

8.1 Add Data Flow Components to a Data Flow Task
8.2 Perform Transformation Tasks
8.3 Track Changed Data

Module 9: Managing Data Flow

9.1 Add Script Tasks and Script Components to an SSIS Package
9.2 Profile OLTP Data
9.3 Cleanse Data Using DQS

Module 10: Managing SSIS Package Execution

10.1 Execute SSIS Packages on the Server
10.2 Configure the Package Execution Strategy

Module 11: Debugging and Troubleshooting Packages

11.1 Debug Package Execution Components
11.2 Troubleshoot Package Failures

Module 12: Deploying Packages

12.1 Deploy SSIS Packages
12.2 Examine MSI Packages

Module 13: Securing Packages and Databases

13.1 Secure Packages
13.2 Secure Databases

Module 14: Working with MDS and Windows Azure

14.1 Configure MDS
14.2 Work with MDS Databases
14.3 Work with Windows Azure

Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases

Module 1: SQL 2012 And The 464 Test

Module 2: Working with Data Types

2.1 Working with Data Types Part 1
2.2 Working with Data Types Part 2
2.3 Working with Data Types Part 3
2.4 Other Data Types

Module 3: Tables

3.1 Tables
3.2 Creating Tables

Module 4: Data Constraints

4.1 Data Constraints Part 1
4.2 Data Constraints Part 2

Module 5: Planning in Indexing

5.1 Planning in Indexing Part 1
5.2 Planning in Indexing Part 2
5.3 Planning in Indexing Part 3
5.4 Planning in Indexing Part 4

Module 6: Table Structures

6.1 Table Structures
6.2 Working with Clustered Indexes
6.3 Clustered Indexes
6.4 Designing Effective Clustered Indexes

Module 7: Improving Performance with Non-Clustered Indexes

7.1 Improving Performance with Non-Clustered Indexes Part 1
7.2 Improving Performance with Non-Clustered Indexes Part 2
7.3 Improving Performance with Non-Clustered Indexes Part 3

Module 8: Using Indexes and Execution Plans

8.1 Using Indexes
8.2 Execution Plans Part 1
8.3 Execution Plans Demo
8.4 Execution Plans Part 2

Module 9: Working with Views

9.1 Working with Views Part 1
9.2 Working with Views Part 2

Module 10: Designing and Implementing Stored Procedures

10.1 Designing and Implementing Stored Procedures Part 1
10.2 Designing and Implementing Stored Procedures Part 2
10.3 Designing and Implementing Stored Procedures Part 3

Module 11: Merging Data and Passing Tables

11.1 Merging Data and Passing Tables Part 1
11.2 Merging Data and Passing Tables Part 2
11.3 Merging Data and Passing Tables Part 3

Module 12: Designing and Implementing User Functions

12.1 Designing and Implementing User Functions

Module 13: Creating Highly Concurrent SQL Server Applications

13.1 Creating Highly Concurrent SQL Server Applications Part 1
13.2 Creating Highly Concurrent SQL Server Applications Part 2
13.3 Creating Highly Concurrent SQL Server Applications Part 3

Module 14: Handling Errors in TSQL

14.1 Handling Error in TSQL Part 1
14.2 Handling Error in TSQL Part 2

Module 15: Triggers

15.1 Triggers

Module 16: Implementing Managed Code

16.1 Implementing Managed Code Part 1
16.2 Implementing Managed Code Part 2
16.3 Implementing Managed Code Part 3

Module 17: Storing XML in SQL

17.1 Storing XML in SQL Part 1
17.2 Storing XML in SQL Part 2
17.3 Storing XML in SQL Part 3

Module 18: Querying XML

18.1 Querying XML Part 1
18.2 Querying XML Part 2
18.3 Querying XML Part 3

Module 19: Working with the Spatial Data

19.1 Working with Spatial Data Part 1
19.2 Working with Spatial Data Part 2
19.3 Working with Spatial Data Part 3

Module 20: Working with Full Text Indexes and Queries

20.1 Working with Full Text Indexes and Queries Part 1
20.2 Working with Full Text Indexes and Queries Part 2
20.3 Working with Full Text Indexes and Queries Part 3
20.4 Outro

Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012

Module 1: Designing A Database Server Infrastructure

1.1 Introduction
1.2 Designing A Database Server Infrastructure Part 1
1.3 Designing A Database Server Infrastructure Part 2
1.4 Designing A Database Server Infrastructure Part 3
1.5 Designing A Database Server Infrastructure Part 4
1.6 Considerations for Database Server Consolidation
1.7 Managing Server Resources

Module 2: Designing A Logical Database Scheme

2.1 Designing A Logical Database Scheme Part 1
2.2Designing A Logical Database Scheme Part 2
2.3 Designing A Logical Database Scheme Part 3
2.4 Designing A Logical Database Scheme Part 4
2.5 Designing A Logical Database Scheme Part 5

Module 3: Designing A Physical Database Implementation

3.1 Designing A Physical Database Implementation Part 1
3.2 Designing A Physical Database Implementation Part 2
3.3 Designing A Physical Database Implementation Part 3

Module 4: Incorporating Data Files into the Database

4.1 Incorporating Data Files into The Database Part 1
4.2 Incorporating Data Files into The Database Part 2
4.3 Incorporating Data Files into The Database Part 3
4.4 Incorporating Data Files into The Database Demo
4.5 Searching Data Files
4.6 Searching Data Files Demo

Module 5: Tuning Database Performance

Module 6: Designing Database Security

6.1 Designing Database Security Part 1
6.2 Designing Database Security Part 2
6.3 Contained Databases
6.4 Protecting Data with Encryption

Module 7: Policy Based Management

7.1 Policy Based Management
7.2 Policy Based Management Demo

Module 8: Monitoring Server Health

8.1 Monitoring Server Health
8.2 Monitoring Server Health Demo

Module 9: Designing Database Backup Solution

9.1 Designing Database Backup Solution Part 1
9.2 Designing Database Backup Solution Part 2
9.3 Designing Database Backup Solution Part 3
9.4 Designing Database Backup Solution Part 4
9.5 Disaster Recovery Plan Part 1
9.6 Disaster Recovery Plan Part 2

Module 10: Automating Multi Server Maintenance

10.1 Automating Multi Server Maintenance
10.2 Managing Multiple Servers

Module 11: Managing SQL Server with Windows PowerShell

11.1 Managing SQL Server With Windows PowerShell
11.2 Windows PowerShell Lab

Module 12: Replicating Data

12.1 Replicating Data Part 1
12.2 Replicating Data Part 2
12.3 Replicating Data Part 3

Microsoft 70-466: Implementing Data Models & Reports with SQL Server 2012

Module 1: Introduction to Business Intelligence and Data Modeling

1.1 Introduction to Business Intelligence and Data Modeling Part 1
1.2 Introduction to Business Intelligence and Data Modeling Part 2
1.3 The Microsoft Business Intelligence Platform Part 1
1.4 The Microsoft Business Intelligence Platform Part 2
1.5 The Microsoft Business Intelligence Platform Part 3
1.6 The Microsoft Business Intelligence Platform Part 4

Module 2: Implementing Reports The SQL Server Reporting Services

2.1 Implementing Reports the SQL Server Reporting Services Part 1
2.2 Implementing Reports the SQL Server Reporting Services Part 2
2.3 Implementing Reports the SQL Server Reporting Services Part 3
2.4 Implementing Reports the SQL Server Reporting Services Part 4
2.5 Implementing Reports the SQL Server Reporting Services Part 5
2.6 Implementing Reports the SQL Server Reporting Services Part 6
2.7 Implementing Reports the SQL Server Reporting Services Part 7
2.8 Implementing Reports the SQL Server Reporting Services Part 8

Module 3: Supporting Self Service Reporting

3.1 Supporting Self Service Reporting Part 1
3.2 Supporting Self Service Reporting Part 2

Module 4: Managing Report Execution and Delivery

4.1 Managing Report Execution and Delivery
4.2 Managing Report Execution
4.3 Subscriptions and Data Alerts

Module 5: Creating Multidimensional Databases

5.1 Creating Multidimensional Databases
5.2 Creating Data Sources and Data Source Views
5.3 Creating and Browsing a Cube

Module 6: Working with Cubes and Dimensions

6.1 Working with Cubes and Dimensions
6.2 Sorting and Grouping Attributes

Module 7: Working with Measures and Measure Groups

7.1 Working with Measures and Measure Groups

Module 8: Introduction to MDX

8.1 Introduction to MDX
8.2 Adding Calculations to A Cube

Module 9: Customizing Cube Functionality

9.1 Customizing Cube Functionality Part 1
9.2 Customizing Cube Functionality Part 2
9.3 Customizing Cube Functionality Part 3

Module 10: Implementing A Tabular Data Model

10.1 Implementing A Tabular Data Model Part 1
10.2 Implementing A Tabular Data Model Part 2

Module 11: Introduction to DAX

11.1 Introduction to DAX
11.2 Demonstration Making a Tabular Model Part 1
11.3 Demonstration Making a Tabular Model Part 2
11.4 Using DAX

Module 12: Implementing an Analysis Services Tabular Data Model

12.1 Implementing an Analysis Services Tabular Data Model Part 1
12.2 Implementing an Analysis Services Tabular Data Model Part 2
12.3 Deploying A Tabular Data Model

Module 13: SQL Analysis Services

13.1 SQL Analysis Services Part 1
13.2 SQL Analysis Services Part 2

Module 14: Creating Data Visualizations with Power View

14.1 Creating Data Visualizations with Power View

Module 15: Supporting Self Service Reporting

15.1 Supporting Self Service Reporting

Module 16: Performing Predictive Analysis with Data Mining

16.1 Performing Predictive Analysis with Data Mining
16.2 Using the Data Mining Wizard

Module 17: Predictive Analytics

17.1 Predictive Analytics Part 1
17.2 Predictive Analytics Part 2

Career Path

We've put together a list of relevant job titles you can apply for after achieving the Mastering SQL Certification Training Bundle certification (note that some careers may require further study, training and/or work experience):

Database Administrator
Database Developer
Database Analyst

Training Features

Flexible Learning

Study247 anytime, anywhere on any device.
World Class E-learning Platform

Study in a user friendly, state-of-the-art e-learning platform.
Expert Instructor-Led Training

Access step-by-step video tutorials delivered by leading industry experts.
Visual Demonstrations & Multimedia Presentations

Develop your skills based on real world scenarios.
Quizzes & Mock Exam

Interactive quizzes after each module and a mock exam at the end of your course to ensure you're fully prepared for your final certification exam.
Flash Cards & Educational Games

Allow you to train in ways that keep you engaged and focus.
Social Learning & Networking

Interact and collaborate with other students, form study groups, engage in discussions, rate different courses and stay up to date with all the latest industry knowledge.
Navigation & Controls

Allows you to study in bite-size chunks. You can pause, rewind or fast forward your tutorials, take study notes and more.

Need Practical Experience?

As a bolt-on option, we offer Practice Labs as it provides users with an online lab platform to develop their practical skills in IT technologies such as CompTIA, Microsoft, Cisco and VMWare.

In addition to the hardware you require, you also gain access to high quality practical exercises covering exam topics to help you to maximize your study time and increase your results. Practice Labs are highly effective and offer a cheaper alternative to setting up your own test environment.

You will gain unlimited access to the Practice Labs for 12 months- helping you to consolidate your learning and prepare you for work.Learn More

Apply for an XO Student Discount Card

When you enrol on a course with us, you automatically qualify for an XO student discount card which will enable you to enjoy savings from not only high street retailers, bars and restaurants, but also travel companies across the United Kingdom. Learn More