Training Microsoft

Training goals

code: DP-080T00 | version: A

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, Azure Synapse Analytics, and Microsoft Fabric.

 

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.

 

Skills earned upon completion:
Skills earned upon completion were not available in the Microsoft source.

Conspect Show list

  • Query and modify data with Transact-SQL
    • 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 T-SQL
    • Module 6: Modify data with T-SQL
Download conspect training as PDF

Additional information

Prerequisites

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

Difficulty level
Duration 2 days
Certificate

The participants will obtain certificates signed by Microsoft (course completion).

Trainer

Microsoft Certified Trainer (MCT)

Other training Microsoft | Data & AI

Training thematically related

Cloud and DevOps

Data Analytics and Databases

Contact form

Please fill form below to obtain more info about this training.







* Fields marked with (*) are required !!!

Information on data processing by Compendium - Centrum Edukacyjne Spółka z o.o.

TRAINING PRICE FROM 1000 EUR

  • In order to propose a date for this training, please contact the Sales Department

Upcoming Microsoft training

Training schedule Microsoft