DP-080: Querying Data with Microsoft Transact-SQL
In this course, students will learn the basics of an SQL query language (Transact-SQL) that can be used to querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems.
Microsoft SQL Server, Azure SQL Database, and Azure Synapse Analytics are the most typical uses of the T-SQL language.
Implementation: Class, Online
Length: 2 days
Starting dates: 26.4.2023
Material: Microsoft English Material (MOC)
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.
The SQL language can be used to easily perform queries that return insightful information and thus improve the understanding of the contents of a database. This course provides an excellent opportunity to study and practice with the SQL language in a training environment.
There are no specific prerequisites.
Knowledge of databases or programming in a language facilitates is helpful but not required.
Module 1: Getting Started with Transact-SQL
- Introduction to Transact-SQL
- Using the SELECT statement
Module 2: Sorting and Filtering Query Results
- Sorting query results
- Filtering the data
Module 3: Using Joins and Subqueries
- Using JOIN operations
- Using subqueries
Module 4: Using Built-in Functions
- Getting started with scalar functions
- Grouping aggregated results
Module 5: Modifying Data
- Inserting data into tables
- Modifying and deleting data