Querying Microsoft SQL Server

The course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. The main purpose of the course is to prepare people for the exam "70-461: Writing Queries Using Microsoft® SQL Server® TransactSQL. " This exam will be the underlying exam for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.
Audience:
• Database Administrators
• Database Developers
• BI professionals

The Course outline
Module 1: Introduction to Microsoft SQL Server 2014
Module 2: Introduction to T-SQL Querying
Module 3: Writing SELECT Queries
Module 4: Querying Multiple Tables
Module 5: Sorting and Filtering Data
Module 6: Working with SQL Server 2014 Data Types
Module 7: Using DML to Modify Data
Module 8: Using Built-In Functions
Module 9: Grouping and Aggregating Data
Module 10: Using Subqueries
Module 11: Using Table Expressions
Module 12: Using Set Operators
Module 13: Using Window Ranking, Offset, and Aggregate Functions
Module 14: Pivoting and Grouping Sets
Module 15: Querying data with Stored Procedures
Module 16: Programming with T-SQL
Module 17: Implementing Error Handling
Module 18: Implementing Transactions