Public online class, per seat
€590
€590 / day · 2-day €1,090 (net)
- Live online, max 8
- Hands-on labs on your own environment
Official Microsoft courseDP-080T00
Query and modify data with Transact-SQL
Write the SQL you need at work, and understand why it works.
- Duration: 2 days
- Level: Beginner
- Max 8
- Live online
€1,090 / per seat
Built on Microsoft's official DP-080 course. You start from a blank query window and finish writing joins, subqueries, aggregations and data changes with confidence. Every exercise runs against a real database, and every pattern is one you will use again.
Who it's for
- Analysts
- Report and BI developers
- Developers new to SQL
Not for
Not for people who already write T-SQL daily — T-SQL performance for developers is the better fit.
After 2 days your team can:
- Write SELECT queries that sort and filter exactly what is needed
- Combine tables with inner and outer joins without duplicating rows
- Use subqueries where they make a query clearer
- Summarise data with built-in functions and GROUP BY
- Insert, update, delete and merge data safely
Agenda
Day 1: Read data
- T-SQL basics
- SELECT
- Sorting and filtering
- JOINs
Ludwik's add-on
Your own reporting questions rewritten as queries.
Prerequisites
- No SQL experience required
- Comfortable with tables in Excel
- A laptop with SQL Server Management Studio or VS Code with the MSSQL extension
Format
- Live online, 09:00–17:00 CET/CEST
- Max 8 participants
- Hands-on labs on your own environment
- Deck and lab files to keep
- 30 days of follow-up Q&A by email
Public classes are not recorded: eight people from different companies, hands-on labs, real questions about real systems. You get the deck, lab files and 30 days of email Q&A. Private runs can be recorded on request for internal use only.
Upcoming public classes
Dates for this course
First public dates are being set.
Tell me which course and I'll notify you first, or request a private run.
Three ways to work with me
Pick the format that fits the problem.
Half-day executive briefing
For leadership€1,900
€1,900 flat (net)
- 3 hours, remote
- Up to 10 leaders
Custom enterprise program
Quoted per program
- Private run of any course
- Custom courseware for your stack
Six or more? A private run is usually the better deal.
Your trainer
Ludwik C. Siadlak
- years as MCT
- 19
- professionals trained
- 10 000+
- countries
- 8+
Related courses
DP-300T00Condensed 2-day
DP-300 Essentials: Implement scalable database solutions using Azure SQL
2 days · Intermediate
€1,090 per seat
See the courseT-SQL performance for developers
2 days · Advanced
€1,090 per seat
See the courseFAQ
Questions buyers ask before they book.
You receive a VAT invoice from a Polish company, payable by bank transfer in EUR or PLN. Public seats: Invoice on confirmation, 14-day payment terms. Pro-forma on request. Enterprise: milestone invoicing on request.
Yes. Send the PO number with the request and it appears on the invoice. Vendor onboarding forms: I fill them, you send them.
Prices are net. Polish companies: +23% VAT. EU companies with a valid VAT ID: reverse charge — no Polish VAT on the invoice, you self-account in your country. Outside the EU: no Polish VAT.
Substitute a colleague any time, free. Cancel 14+ days before: full refund or credit. Under 14 days: credit toward any date within 12 months. No-show: no refund. If I cancel or move a date: full refund plus first pick of the next date.
Public classes are not recorded: eight people from different companies, hands-on labs, real questions about real systems. You get the deck, lab files and 30 days of email Q&A. Private runs can be recorded on request for internal use only.
3 or more seats: 10% off. Six or more: ask for a private-run quote and I show you both numbers.
English or Polish. Materials in English (official Microsoft courseware), delivery in either language.
Courses map to Microsoft exams (e.g. DP-600 → Fabric Analytics Engineer Associate). Exam vouchers are not included. I tell you honestly whether the exam is worth your team's time. Essentials editions cover the exam-relevant core of the official 4-day outline in 2 intensive days; I say which modules I trim.
Request