This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.
Instructor did a great job, from experience this subject can be a bit dry to teach but he was able to keep it very engaging and made it much easier to focus.
Excellent presentation skills, subject matter knowledge, and command of the environment.
Instructor was outstanding. Knowledgeable, presented well, and class timing was perfect.
Click here to print this page »
Detailed Class Syllabus
Module 1: Getting Started with Transact-SQL
Introduction to Transact-SQL
Using the SELECT statement
Module 2: Sorting and Filtering Query Results
Sorting query results
Filtering the data
Module 3: Using Joins and Subqueries
Using JOIN operations
Module 4: Using Built-in Functions
Getting started with scalar functions
Grouping aggregated results
Module 5: Modifying Data
Inserting data into tables
Modifying and deleting data