DP-080: Query and modify data with Transact-SQL

Course Information

Course Name

DP-080: Query and modify data with Transact-SQL

Duration

2 Days

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.

Audience Profile

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.

Prerequisites

Familiarity with working with tables of data, for example in a spreadsheet.

At Course Completion

Course Outline

Module 1: Introduction to Transact-SQL

Module 2: Sort and filter results in T-SQL

Module 3: Combine multiple tables with JOINs in T-SQL

Module 4: Write Subqueries in T-SQL

Module 5: Use built-in functions and GROUP BY in Transact-SQL

Module 6: Modify data with T-SQL

All Microsoft certification courses are conducted by certified trainers from Iverson.

Digital Methods acts as the official training partner and assists with program consultation, registration, coordination, scheduling, and administrative arrangements to ensure a seamless and professionally managed training experience.