DP-080: Querying Data with Microsoft Transact-SQL
Course Overview
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.
🤖 AI Agent-Led Learning Experience
Intelligent Learning Support
AI agents provide 24/7 personalized and expert instruction, adapting to your learning pace and style.
Personalized Practice
Receive customized exercises and scenarios based on your progress and areas for improvement.
Continuous Assessment
Real-time feedback and progress tracking help you stay on track and achieve your learning goals.
Hands-On Labs
This course includes practical, hands-on laboratory exercises to reinforce your learning:
Module 1: Getting Started with Transact-SQL
Overview of SQL Server and T-SQL
Module 2: Filtering and Sorting Query Results
WHERE clause for filtering data
Module 3: Querying Multiple Tables Using Joins
INNER JOIN basics
Module 4: Writing Subqueries
Using subqueries in SELECT, FROM, and WHERE clauses
Module 5: Using Built-in Functions
Scalar functions: string, numeric, date/time
Module 6: Modifying Data
INSERT statements
Module 7: Using Table Expressions
Views overview
Module 8: Combining Query Results
UNION and UNION ALL
Module 9: Transforming Data Using Pivot and Unpivot
Using PIVOT to rotate rows into columns
Module 10: Programming with Transact-SQL
Variables and control-of-flow constructs (IF, WHILE)
Module 11: Creating Stored Procedures
Syntax for creating stored procedures
Module 12: Implementing Error Handling
TRY...CATCH blocks in T-SQL
Module 13: Implementing Transactions in T-SQL
BEGIN TRANSACTION, COMMIT, ROLLBACK
Ready to Get Started?
Join thousands of professionals who have advanced their careers with our training programs.
Join Scheduled Training
Find upcoming sessions for this course and register for instructor-led training with other professionals.
View ScheduleCustom Training Solution
Need training for your team? We'll create a customized program that fits your organization's specific needs.
Get Custom Quote