Course Outline
1 - Course Outline
- 1.Introduction to Microsoft SQL Server
- 2.Introduction to T-SQL Querying
- 3.Writing SELECT Queries
- 4.Querying Multiple Tables
- 5.Sorting and Filtering Data
- 6.Working with SQL Server Data Types
- 7.Using DML to Modify Data
- 8.Using Built-In Functions
- 9.Grouping and Aggregating Data
- 10.Using Subqueries
- 11.Using Table Expressions
- 12.Using Set Operators
- 13.Using Windows Ranking, Offset, and Aggregate Functions
- 14.Pivoting and Grouping Sets
- 15.Executing Stored Procedures
- 16.Programming with T-SQL
Target Audience
This course is intended for Database Administrators, Database Developers, BI professionals, and Business reporting users.