DP-080: Querying Data with Microsoft Transact-SQL
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.
- Category: Database Administration
- Level: Foundational
- Time Estimate: 16h 0m
- Price: $499.99 for 3 months of access
- Subscription: $189.99 per month after 7-day free trial
- Lab Environment: Included
- Free Trial: 7 Days
Lessons in this Course
Module 1: Getting Started with Transact-SQL
Overview of SQL Server and T-SQL
Duration: 1 h 0 m
Module 2: Filtering and Sorting Query Results
WHERE clause for filtering data
Duration: 1 h 15 m
Module 3: Querying Multiple Tables Using Joins
INNER JOIN basics
Duration: 1 h 15 m
Module 4: Writing Subqueries
Using subqueries in SELECT, FROM, and WHERE clauses
Duration: 1 h 15 m
Module 5: Using Built-in Functions
Scalar functions: string, numeric, date/time
Duration: 1 h 15 m
Module 6: Modifying Data
INSERT statements
Duration: 1 h 15 m
Module 7: Using Table Expressions
Views overview
Duration: 1 h 15 m
Module 8: Combining Query Results
UNION and UNION ALL
Duration: 1 h 15 m
Module 9: Transforming Data Using Pivot and Unpivot
Using PIVOT to rotate rows into columns
Duration: 1 h 15 m
Module 10: Programming with Transact-SQL
Variables and control-of-flow constructs (IF, WHILE)
Duration: 1 h 15 m
Module 11: Creating Stored Procedures
Syntax for creating stored procedures
Duration: 1 h 15 m
Module 12: Implementing Error Handling
TRY...CATCH blocks in T-SQL
Duration: 1 h 15 m
Module 13: Implementing Transactions in T-SQL
BEGIN TRANSACTION, COMMIT, ROLLBACK
Duration: 1 h 15 m