Corporate training · Intermediate SQL

Modern SQL & T-SQL with AI Assistance

A practical program for developers, analysts and engineers who already write basic queries and want reliable results, stronger debugging skills and a safe transition to SQL Server.

30 hours 10 sessions × 3 hours
Maximum 10 participants
PostgreSQL + T-SQL transferable skills
Romanian or English online or on site

Who this is for

For professionals who need to trust the results of their queries

This program is suitable for

  • developers who use SQL in applications and reporting;
  • analysts who work with queries, aggregations and relational datasets;
  • engineers who need to read and debug SQL written by other people;
  • teams transitioning to Microsoft SQL Server and T-SQL.

What to know before you join

  • this is not a complete introduction to databases;
  • this is not a DBA specialization or a SQL Server administration course;
  • AI is not treated as a source of truth for queries;
  • participants should be able to read a simple SELECT statement.

Outcomes

What you will be able to do

Write correct queries

Avoid duplicated rows, incorrect counts and aggregations that produce misleading reports.

Explain and debug

Use CTEs, subqueries, window functions and execution plans to understand what a query is doing.

Transition to T-SQL

Convert common patterns, write simple stored procedures and identify when an index can help.

Indicative curriculum

30 hours built around real-world queries

Part I — Solid SQL designed to hold up

1. Joins and the row-multiplication trap — 3 hours NULL, differences between dialects and diagnosing joins that duplicate data and inflate results.
2. Correct aggregations and counts — 3 hours COUNT, GROUP BY, HAVING, group averages and reports that correctly include zero values.
3. Subqueries, CTEs and step-by-step thinking — 3 hours Breaking down complex queries, EXISTS, IN and choosing a structure that is easy to verify.
4. Advanced joins and finding missing data — 3 hours Self-joins, UNION, INTERSECT, EXCEPT and anti-joins for missing or orphaned records.
5. Window functions in practice — 3 hours Ranking, running totals, moving averages, LAG, LEAD and top-N-per-category scenarios.
6. Safely changing data — 3 hours INSERT, UPDATE, DELETE, transactions, rollbacks and the upsert pattern.
7. Reporting workshop — 3 hours Building and validating complete reports from requirements expressed in natural language.

Part II — T-SQL, SQL Server and performance

8. T-SQL for developers — 3 hours Practical PostgreSQL–SQL Server differences: syntax, types, functions, variables and error handling.
9. Stored procedure fundamentals — 3 hours Parameterized procedures, when to use them, readability and testing.
10. Query performance and indexes — 3 hours Reading an execution plan, choosing an index and measuring the effect before and after optimization.

The curriculum is reviewed before each cohort to keep tools and examples relevant without changing the stated learning outcomes.

What is included

Materials the team can continue using after the program

  • slides and a recording of each session;
  • all SQL scripts used in the workshops;
  • a complete dataset for PostgreSQL and SQL Server;
  • practice exercises and explained solutions;
  • examples tailored to the team context after the discovery call.

Trainer

Practical experience, explained clearly

Rareș Pop

Senior Software Engineer & Architect · Trainer

He has more than 20 years of experience in software engineering, automation and cloud platforms. He works hands-on with SQL and PL/SQL, PostgreSQL, Python, Java and Azure, and has technical-lead experience in distributed teams. He is a Microsoft Certified Azure Developer and holds Microsoft SQL Server and Oracle PL/SQL certifications.

Investment

A proposal tailored after discovery

Corporate program for one team

The proposal is configured after the discovery call, based on the team’s level, the examples used, delivery format and required adaptations.

Proposal after discovery call

  • 30 live hours
  • up to 10 participants
  • changes that affect duration or format are quoted separately
Request a proposal

Frequently asked questions

Before you apply

Can we use company data or examples?

Yes, after a discussion about confidentiality and complexity. We can adapt the scenarios without using sensitive data in the training environment.

Can the program be delivered in English?

Yes. Delivery and learning materials can be in Romanian or English.

Why does the program start with PostgreSQL?

To build SQL skills that transfer between systems. The final sessions make the transition to T-SQL and SQL Server explicit.

Does Copilot generate the queries?

It is used as a pair programmer during workshops, and every result is verified. The course focuses on the subtle errors that a model can reproduce.

Next step

Request a proposal for your team

Tell us about the roles, current skill level and outcomes your team needs. We will follow up with a proposed structure, schedule and delivery format.

We do not request your date of birth or address at this stage. If you continue the enrollment process, any required documents are requested separately.