* Premium upgrade option is available at checkout.
The main purpose of this course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.
Working knowledge of relational databases; Basic knowledge of the Microsoft Windows operating system and its core functionality.
After completing this course, students will be able to:
This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused; namely, report writers, business analysts and client application developers.
Module 1: Introduction to Microsoft SQL Server 2016
Lab: Working with SQL Server 2016 Tools
Module 2: Introduction to T-SQL Querying
Lab: Introduction to Transact-SQL Querying
Module 3: Writing Select Queries
Lab: Writing Basic SELECT Statements
Module 4: Querying Multiple Tables
Lab: Querying Multiple Tables
Module 5: Sorting and Filtering Data
Lab: Sorting and Filtering Data
Module 6: Working with SQL Server 2016 Data Types
Lab: Working with SQL Server 2016 Data Types
Module 7: Using DML to Modify Data
Lab: Using DML to Modify Data
Module 8: Using Built-In Functions
Lab: Using Built-In Functions
Module 9: Grouping and Aggregating Data
Lab: Grouping and Aggregating Data
Module 10: Using Subqueries
Lab: Using Subqueries
Module 11: Using Set Operators
Lab: Using SET Operators