🤖 AI Agent-Led Learning

DP-080: Querying Data with Microsoft Transact-SQL

Course Code: DP-080
Duration: 16 hours
Level: Foundational
Category: Database Administration
Course Price: $499.99

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

~60 minutes

Module 2: Filtering and Sorting Query Results

WHERE clause for filtering data

~75 minutes

Module 3: Querying Multiple Tables Using Joins

INNER JOIN basics

~75 minutes

Module 4: Writing Subqueries

Using subqueries in SELECT, FROM, and WHERE clauses

~75 minutes

Module 5: Using Built-in Functions

Scalar functions: string, numeric, date/time

~75 minutes

Module 6: Modifying Data

INSERT statements

~75 minutes

Module 7: Using Table Expressions

Views overview

~75 minutes

Module 8: Combining Query Results

UNION and UNION ALL

~75 minutes

Module 9: Transforming Data Using Pivot and Unpivot

Using PIVOT to rotate rows into columns

~75 minutes

Module 10: Programming with Transact-SQL

Variables and control-of-flow constructs (IF, WHILE)

~75 minutes

Module 11: Creating Stored Procedures

Syntax for creating stored procedures

~75 minutes

Module 12: Implementing Error Handling

TRY...CATCH blocks in T-SQL

~75 minutes

Module 13: Implementing Transactions in T-SQL

BEGIN TRANSACTION, COMMIT, ROLLBACK

~75 minutes

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 Schedule

Custom Training Solution

Need training for your team? We'll create a customized program that fits your organization's specific needs.

Get Custom Quote