AI & Data

SQL Training

SQL is everywhere data storage and processing are involved — from machine learning engineers, through financial specialists, web developers, to data visualization experts and even journalists.

Duration
6h
Ask about the program → See all
Who it's for

Ideal for teams that…

1 For people who want to learn SQL and methods of data processing, and acquire practical knowledge that enables them to work with data.
2 For those who would like to discover advanced tools for data processing and analysis that will significantly speed up their work.
3 For anyone who wants to set up and use their own database in practice during the course.
Outcomes after the program

Hands-on AI and data analytics workshops — built around your team's real cases.

✓

You will gain basic knowledge about SQL — the key language for working with databases, essential in many fields.

✓

You will learn the differences between relational (SQL) and non-relational (NoSQL) databases, which will help you choose the right tools for data processing and analysis.

✓

You will master techniques for joining tables, including various types of JOINs, cross joins, and set operations (UNION, EXCEPT, INTERSECT).

✓

You will learn how to use subqueries, including correlated subqueries, and use the EXISTS clause.

✓

You will gain skills in using analytic and ranking functions such as SUM, COUNT, MIN / MAX / AVG, RANK / DENSE_RANK, ROW_NUMBER, NTILE, and window functions using OVER, PARTITION BY, and ORDER BY.

✓

You will learn the basics of SQL query optimization, including how data structure, data size, filtering, and data access impact performance.

Program · 8 modules

What we actually do

M01
Relational vs Non-Relational Database Models
  • · What simple and complex databases are
  • · How relational databases work (SQL)
  • · What non-relational (NoSQL) databases are
M02
Table Joins
  • · JOIN / INNER JOIN / FULL JOIN
  • · CROSS JOIN
M03
Set Operations
  • · UNION
  • · EXCEPT
  • · INTERSECT
M04
Subqueries
  • · Correlated subqueries
  • · Subqueries in FROM
  • · Subqueries in WHERE / HAVING
  • · Use of EXISTS
M05
Analytic and Aggregate Functions
  • · SUM
  • · COUNT
  • · MIN / MAX / AVG
M06
Ranking Functions
  • · RANK
  • · DENSE_RANK
  • · ROW_NUMBER
  • · NTILE
M07
Window Functions
  • · Using OVER
  • · PARTITION BY and ORDER BY
  • · Use of ROWS and GROUPS
M08
Basics of Query Optimization
  • · Data structure
  • · Data size
  • · Filtering data
  • · Data access methods
Every module is adapted to your stack and context. The above is a starting point — not a fixed agenda.
How we work

From brief to retro in 30 days.

01

Brief & diagnosis

A call with the team lead + a short survey for participants. We define goals, gap and context.

02

Program customization

We adapt modules, case studies and code examples to your stack. Approval in 5 days.

03

Workshop

Trainer-led sessions, hands-on, code review. Mentor available between sessions too.

04

Retro + report

Outcome report for the team and lead. 30 days of consulting included.

Inquiry

Send a brief. We'll reply within 1 day.

After a short brief we'll prepare a program and a quote. No obligations — it's just a starting point.

✓Quote within 48h of the brief
✓First session within 30 days
✓Pilot before the full decision
✓VAT invoice, payment in instalments possible

Ochrona antyspamowa (Cloudflare Turnstile) zostanie aktywowana po wpięciu klucza.

Other programs for teams

See all →
AI & Data

Active Directory Training

Hands-on AI and data analytics workshops — built around your team's real cases.

AI & Data →
AI & Data

Advanced Power BI Training

Hands-on AI and data analytics workshops — built around your team's real cases.

AI & Data →
AI & Data

Advanced RPA Developer Training

Hands-on AI and data analytics workshops — built around your team's real cases.

AI & Data →