Microsoft 70-461: Querying SQL Server 2012

Microsoft 70-461: Querying SQL Server 2012

Regular price $0.00 Sale

Course Description

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012 and is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course is preparation for exam 70-461.

Course Outline

Mod 1 Getting Started with SQL Server 2012
Mod 2 Working with T-SQL Mod 3 Writing SELECT Queries
Mod 4 Working with SQL Data Types
Mod 5 Sorting and Filtering Data
Mod 6 Querying Data from Multiple Tables
Mod 7 Modifying Data
Mod 8 Working with SQL Server Built-in Functions
Mod 9 Programming in T-SQL
Mod 10 Implementing Stored Procedures
Mod 11 Working with Subqueries and Table Expressions
Mod 12 Working with Set Operators, Conditional Operators, and Window Functions
Mod 13 Working with PIVOT, UNPIVOT, and Grouping Sets
Mod 14 Managing Error Handling and Transactions
Mod 15 Querying SQL Server System
Mod 16 Optimizing Query Performance