DP-080: Querying Data with Microsoft Transact-SQL
Audience: This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.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.
Estimated Duration: 6h 30mAdd to Basket
Skill Paths:
Software Engineering with .NET and AI
Lessons in this Course
Module 1: Getting Started with Transact-SQL
Overview of SQL Server and T-SQL
Duration: 0 h 30 m
Module 2: Filtering and Sorting Query Results
WHERE clause for filtering data
Duration: 0 h 30 m
Module 3: Querying Multiple Tables Using Joins
INNER JOIN basics
Duration: 0 h 30 m
Module 4: Writing Subqueries
Using subqueries in SELECT, FROM, and WHERE clauses
Duration: 0 h 30 m
Module 5: Using Built-in Functions
Scalar functions: string, numeric, date/time
Duration: 0 h 30 m
Module 6: Modifying Data
INSERT statements
Duration: 0 h 30 m
Module 7: Using Table Expressions
Views overview
Duration: 0 h 30 m
Module 8: Combining Query Results
UNION and UNION ALL
Duration: 0 h 30 m
Module 9: Transforming Data Using Pivot and Unpivot
Using PIVOT to rotate rows into columns
Duration: 0 h 30 m
Module 10: Programming with Transact-SQL
Variables and control-of-flow constructs (IF, WHILE)
Duration: 0 h 30 m
Module 11: Creating Stored Procedures
Syntax for creating stored procedures
Duration: 0 h 30 m
Module 12: Implementing Error Handling
TRY...CATCH blocks in T-SQL
Duration: 0 h 30 m
Module 13: Implementing Transactions in T-SQL
BEGIN TRANSACTION, COMMIT, ROLLBACK
Duration: 0 h 30 m