SKU: cert-mcsa-microsoft-sql-2012 Category:

MCSA: SQL Server 2012/2014

$139.00

Looking to get a SQL certification? The Microsoft Certified Solutions Associate (MCSA) SQL Server 2012/2014 certification requires you pass three primary courses and is focused on the administration, installation, maintenance, configuration, querying, and ETL processes using the Microsoft SQL Server 2012/2014 series. The three courses included in this SQL certification path are:

About The Exams for SQL Certification

Exam 70-461: Querying Microsoft SQL Server 2012/2014

During this exam, you will be tested in the following core areas:

  • Create database objects (20–25%)
  • Work with data (25–30%)
  • Modify data (20–25%)
  • Troubleshoot and optimize (25–30%)

The cost for this exam is currently $165.00. Check the Microsoft site for confirmation and if any, updated information.

Exam 70-462: Administering Microsoft SQL Server 2012/2014 Databases

During this exam, you will be tested in the following core areas:

  • Install and configure (20–25%)
  • Maintain instances and databases (15–20%)
  • Optimize and troubleshoot (15–20%)
  • Manage data (20–25%)
  • Implement security (15–20%)
  • Implement high availability (5–10%)

The cost for this exam is currently $165.00. Check the Microsoft site for confirmation and if any, updated information.

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

During this exam, you will be tested in the following core areas:

  • Design and implement a data warehouse (10–15%)
  • Extract and transform data (20–25%)
  • Load data (25–30%)
  • Configure and deploy SSIS solutions (20–25%)
  • Build data quality solutions (15–20%)

The cost for this exam is currently $165.00. Check the Microsoft site for confirmation and if any, updated information.

For complete details related to this Microsoft certification, visit the Microsoft website.

Course Outline

Lesson 1: Introduction to Data Warehouse
  •  Introduction
  •  Introduction To Data Warehouse-Part1
  •  Introduction To Data Warehouse-Part2
  •  Introduction To Data Warehouse-Part3
  •  Introduction To Data Warehouse-Part4
  •  Introduction To Data Warehouse-Part5
  •  Introduction To Data Warehouse-Part6
Lesson 2: Creating Dimensions and Changing Granularity of Dimensions
  •  Creating Dimensions And Changing Granularity Of Dimensions-Part1
  •  Creating Dimensions And Changing Granularity Of Dimensions-Part2
  •  Creating Dimensions And Changing Granularity Of Dimensions-Part3
  •  Creating Dimensions And Changing Granularity Of Dimensions-Part4
  •  Creating Dimensions And Changing Granularity Of Dimensions-Part5
  •  Creating Dimensions And Changing Granularity Of Dimensions-Part6
Lesson 3: Creating Fact Tables and ColumnStore Indexes
  •  Creating Fact Tables And Column Store Indexes-Part1
  •  Creating Fact Tables And Column Store Indexes-Part2
  •  Creating Fact Tables And Column Store Indexes-Part3
  •  Creating Fact Tables And Column Store Indexes-Part4
  •  Creating Fact Tables And Column Store Indexes-Part5
Lesson 4: Implementing Data Warehouse in SQL Server 2012
  •  Implementing Data Warehouse-Part1
  •  Implementing Data Warehouse-Part2
  •  Implementing Data Warehouse-Part3
  •  Implementing Data Warehouse-Part4
Lesson 5: Working with Integration Services
  •  Working With Integration Services-Part1
  •  Working With Integration Services-Part2
  •  Working With Integration Services-Part3
  •  Working With Integration Services-Part4
  •  Working With Integration Services-Part5
  •  Working With Integration Services-Part6
Lesson 6: Managing Control Flow
  •  Managing Control Flow-Part1
  •  Managing Control Flow-Part2
  •  Managing Control Flow-Part3
  •  Managing Control Flow-Part4
  •  Managing Control Flow-Part5
Lesson 7: Working with Dynamic Variables
  •  Working With Dynamic Variables-Part1
  •  Working With Dynamic Variables-Part2
  •  Working With Dynamic Variables-Part3
  •  Working With Dynamic Variables-Part4
  •  Working With Dynamic Variables-Part5
  •  Working With Dynamic Variables-Part6
  •  Working With Dynamic Variables-Part7
  •  Working With Dynamic Variables-Part8
Lesson 8: Implementing Data Flow
  •  Implementing DataFlow-Part1
  •  Implementing DataFlow-Part2
  •  Implementing DataFlow-Part3
  •  Implementing DataFlow-Part4
  •  Implementing DataFlow-Part5
  •  Implementing DataFlow-Part6
  •  Implementing DataFlow-Part7
  •  Implementing DataFlow-Part8
Lesson 9: Managing Data Flow
  •  Managing DataFlow-Part1
  •  Managing DataFlow-Part2
  •  Managing DataFlow-Part3
  •  Managing DataFlow-Part4
Lesson 10: Managing SSIS Package Execution
  •  Managing SSIS Package Execution-Part1
  •  Managing SSIS Package Execution-Part2
  •  Managing SSIS Package Execution-Part3
  •  Managing SSIS Package Execution-Part4
  •  Managing SSIS Package Execution-Part5
  •  Managing SSIS Package Execution-Part6
Lesson 11: Debugging and Troubleshooting
  •  Debugging And Troubleshooting-Part1
  •  Debugging And Troubleshooting-Part2
  •  Debugging And Troubleshooting-Part3
  •  Debugging And Troubleshooting-Part4
Lesson 12: Deploying Packages
  •  Deploying Packages-Part1
  •  Deploying Packages-Part2
  •  Deploying Packages-Part3
Lesson 13: Securing Packages and Databases
  •  Securing Packages And Databases-Part1
  •  Securing Packages And Databases-Part2
Lesson 14: Working with MDS and Windows
  •  Working With MDS And Windows Azure
MCSA: SQL Server 2012/2014

This Certification Path includes 3 courses and prepares you for the MCSA: SQL Server 2012/2014 certification.

Save For Later
Add to Wishlist