Intermediate levelData and IT
SQL for analysts
From SELECT to window functions: joins, grouping, subqueries, CTEs and queries for reports.
- Hours
- 40
- Length
- 8 weeks
- Group
- up to 18 people
- Format
- In class, Live online
- Taught in
- AZ, RU
Next groups
A group is certain to run once six people enrol. Enrolment closes at 18:00 the day before the first lesson.
| Dates | Days and time | Language | Format | Seats | Enrol in this group |
|---|---|---|---|---|---|
| Tue 3 Nov – Thu 24 Dec16 lessons | Days and timeTue, Thu 19:00–21:30 | LanguageIn Russian | FormatLive online | Seats9 seats leftGroup confirmed | Enrol in this group |
| Mon 23 Nov – Wed 13 Jan16 lessons | Days and timeMon, Wed 19:00–21:30 | LanguageIn Azerbaijani | FormatIn class | Seats7 seats leftGroup confirmed | Enrol in this group |
| Tue 15 Dec – Tue 9 Feb16 lessons | Days and timeTue, Thu 19:00–21:30 | LanguageIn Russian | FormatLive online | Seats2 seats leftGroup confirmed | Enrol in this group |
| Mon 4 Jan – Wed 24 Feb16 lessons | Days and timeMon, Wed 19:00–21:30 | LanguageIn Azerbaijani | FormatIn class | Seats18 seats left | Enrol in this group |
| Tue 26 Jan – Thu 18 Mar16 lessons | Days and timeTue, Thu 19:00–21:30 | LanguageIn Russian | FormatLive online | Seats4 seats leftGroup confirmed | Enrol in this group |
| Mon 15 Feb – Mon 19 Apr16 lessons | Days and timeMon, Wed 19:00–21:30 | LanguageIn Azerbaijani | FormatIn class | Seats4 seats leftGroup confirmed | Enrol in this group |
Programme
- Tables, rows, keys; SELECT and WHERE6 h
- Types of JOIN and joining tables without duplicates8 h
- GROUP BY, HAVING and report aggregates8 h
- Subqueries and CTEs8 h
- Window functions: ranking, running totals, period comparisons10 h
- Total40 h
After the course you will be able to
- Pull the data a report needs from the database yourself
- Spot and fix a join that inflates the numbers
- Work out monthly trends and rankings in one query
What you need first
Confident Excel; no programming needed.
Tools
- PostgreSQL
- DBeaver
Final project and certificate
Fifteen questions answered on a retail sales database: the queries and a short note on the results.
The certificate goes to those who attend 80% of the lessons and score above 60 on the final project. It is the academy’s own certificate, not a state document; its number can be checked on this site.
Check a certificateCertificate
Awarded to
Name Surname
«SQL for analysts» for completing the course
Length: 40 hours · Final project: 91/100
No. PS-2026-···· · verify at pilleakademiya.az/certificates
Instructors
Farid Aliyev
Power BI and SQL
Data team lead at a telecom operator, 12 years in the trade
Profile and a free consultation
Before and after this course
All courses in the field: Data and ITQuestions
We use Oracle or MS SQL at work; will PostgreSQL help?
Yes. Nine queries in ten are the same in all of them; we show the differences (date functions, TOP versus LIMIT) in a separate table.
Can I get my money back if I change my mind?
Until the first lesson you get back everything you paid. After the start, the lessons not yet held are refunded, to the card within 10 working days. Cancel on the “Your enrolment” page with the number and your phone.
Can I move to another group?
Yes, once and free, until 3 days before the start: choose another group of the same course on the “Your enrolment” page.
This course for your team
We can run the course at your office or online for your staff only, with examples from your company’s own data.