Certification Learning Path

MCSA: SQL Server 2012/2014

Demonstrate your essential skills and breakthrough insights in developing and maintaining the next wave of mission-critical environments. Earning an MCSA: SQL Server certification will qualify you for a position as a database developer or database analyst. The exams required for this certification are Querying Microsoft SQL Server 2012/2014, 70-461; Administering Microsoft SQL Server 2012/2014 Databases, 70-462; and Implementing a Data Warehouse with Microsoft SQL Server 2012/2014, 70-463. source: http://www.microsoft.com/learning/


70-461: Querying Microsoft SQL Server 2012/2014
Course TitleRuntimeVideosTrailer
SQL Server 2014, Part 1 of 9: A Tour of SQL Server 2h 52m 9
SQL Server 2014, Part 2 of 9: Installing 1h 43m 4
SQL Server 2014, Part 3 of 9: Working with Management Studio 1h 47m 4
SQL Server 2014, Part 4 of 9: Designing and Creating a Database 2h 25m 6
SQL Server 2014, Part 5 of 9: Security Basics 1h 39m 5
SQL Server 2014, Part 6 of 9: Permissions and Data Protection 1h 50m 5
SQL Server 2014, Part 7 of 9: Introduction to T-SQL 2h 6m 7
SQL Server 2014, Part 8 of 9: T-SQL Select, Where, and Clauses 1h 38m 5
SQL Server 2014, Part 9 of 9: T-SQL Working with Data 1h 18m 4
SQL 2014 Developer, Part 01 of 13: Views 1h 18m 5
SQL 2014 Developer, Part 02 of 13: Stored Procedures 1h 46m 6
SQL 2014 Developer, Part 03 of 13: Functions 1h 4m 4
SQL 2014 Developer, Part 04 of 13: Transactions 1h 37m 4
SQL 2014 Developer, Part 05 of 13: Common Language Runtime 1h 26m 5
SQL 2014 Developer, Part 06 of 13: Advanced SQL CLR 1h 2m 4
SQL 2014 Developer, Part 07 of 13: Design and Deployment 1h 50m 7
SQL 2014 Developer, Part 08 of 13: Advanced T-SQL Queries 3h 4m 11
SQL 2014 Developer, Part 09 of 13: Advanced Data Types 2h 37m 11
SQL 2014 Developer, Part 10 of 13: Partitions 1h 22m 4
SQL 2014 Developer, Part 11 of 13: Complex Querying 1h 15m 4
SQL 2014 Developer, Part 12 of 13: Coding Techniques 1h 19m 3
SQL 2014 Developer, Part 13 of 13: Working with XML 1h 13m 4

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

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