T-SQL Querying Fundamentals (DP-080)

Learn the Transact SQL language to query SQL Server or Azure data sources

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.
After this course, students will be able to:
- Use SQL Server query tools
- Write SELECT statements to retrieve columns from one or more tables
- Sort and filter selected data
- Use built-in functions to returned data values
- Create groups of data and aggregate the results
- Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE

In this module you will learn about the basics of the Transact-SQL (T-SQL) language, as well as general properties and terminology of relational databases. This module will also introduce the basic SELECT statement for retrieving data from a table.
Lessons
- Introduction to Transact-SQL
- Using the SELECT statement

Lab : Get started with SQL Server query tools and writing queries in T-SQL
After completing this module, students will be able to:
- Using a query tool to write and execute queries in Transact…