After these two days you can write your own T-SQL queries: you filter and sort data, join tables, build totals and groups, and change records without accidentally hitting too many rows. You can apply this in SQL Server, Azure SQL Database, Azure Synapse Analytics and Microsoft Fabric. The course suits you if you work with data but have so far relied on exports or on queries written by other people.
What you’ll take away.
- Write SELECT queries and filter and sort the results
- Combine data from several tables using joins and subqueries
- Use built-in functions and group and aggregate data
- Change rows in a controlled way with INSERT, UPDATE and DELETE
Your training in detail
- Who is it for?
- Anyone who works with data and needs to write their own queries, for example in data analysis, data engineering, database administration or development.
- Prerequisites
- You do not need any SQL experience. It helps if you know what tables, rows and columns are.
- Format & planning
- Standard length: 2 training days. A different length can be arranged for companies.
Agenda: from understanding to application
Our independently developed agenda proposal. Focus areas, lab environment and scope are agreed before booking.
Getting started with relational databases and T-SQL
Querying, sorting and filtering data
Combining tables with joins
Subqueries and built-in functions
Grouping and aggregating data
Inserting, updating and deleting data
You answer business questions about a sample database of orders and customers, such as revenue per region, then correct faulty records with a carefully checked UPDATE.
Exams, licences & credentials
This course has no certification exam of its own. It teaches T-SQL basics for further data topics, and it does not lead to a Microsoft certificate. This is not an official Microsoft course.
Vendor references & review date
Sources checked on 2026-11-04. These sources describe the technology or external exam requirements. They do not imply a partnership with NextNowa.
Your learning content
These objectives describe the training topic. The specific syllabus, dates and trainer are agreed before booking; the written offer is binding.
Frequently asked questions
Does this course lead to a Microsoft certification?
No. It covers the basics of T-SQL and is not tied to its own exam. If you then want to administer databases, DP-300 is a logical next step.
Which systems can I use it on?
T-SQL is Microsoft's dialect of SQL. You can use it in SQL Server, Azure SQL Database, Azure Synapse Analytics and Microsoft Fabric.
Does DP-080: Query and modify data with Transact-SQL include a certificate?
This course has no certification exam of its own. It teaches T-SQL basics for further data topics, and it does not lead to a Microsoft certificate. This is not an official Microsoft course.