This 3-week intensive in the centre of Tallinn gives you SQL as a working analysis tool — from your first queries to JOINs, window functions and time-series analysis, so you can get the data you need without waiting for a developer.

Data Analysis with SQL

Name: Data Analysis with SQL — Course in Tallinn, Estonia
Price: 1024.80 EUR

Time of conduct:
19.10.2026 - 18.11.2026
16.11.2026 - 04.12.2026

Apply → We'll reply within 1 business day

Target group — this course is for you if you are:

A beginning data analystyou want to master SQL as a core analysis tool

Working with datamarketing, finance or product — you would like to build your own queries and reports

A manager or product analystyou need to get data without relying on developers

A developeryou want to work confidently with databases in your tasks

A QA engineer or testeryou need to validate data and write SQL queries for tests

A specialist from another fieldyou plan to retrain as a data analyst

An economics or technical studentyou would like to gain practical SQL skills

An entrepreneur or business owneryou need to analyse data from your own systems

Our classroom at Tartu mnt. 18, Tallinn

A laptop can be provided for the duration of the course if needed

We advise on the job market

Course objective

To learn the fundamentals of working with relational databases and the structured query language SQL, and to use SQL for the initial analysis of data.

Learning outcome — those who complete this course:

Know the theoryunderstand the fundamentals of relational database theory

Write SQL queriesaccording to real work tasks

Filter and aggregatebe able to filter and aggregate data

Apply statisticsmathematical and statistical operations for the initial processing of data

Handle time seriesuse SQL to work with time series

Build reusable objectsprinciples of user-defined functions and stored procedures

Technologies you will learn during the course:

Write queries in SQL

Work with the MySQL database

Understand relational databases

Course modules:

Module	Main topics	Volume
1. Introduction to SQL and database fundamentals	Core concepts: databases, tables, rows and columns. Introduction to SQL: basic commands (SELECT, FROM, WHERE). Filtering data with WHERE and logical operators (AND, OR, NOT). Sorting data with ORDER BY.	4 acad. hrs
2. Aggregation and grouping of data	Using aggregate functions: SUM(), AVG(), COUNT(), MIN(), MAX(). Grouping data with GROUP BY. Filtering aggregated data with HAVING. Combining grouping and sorting.	4 acad. hrs
3. Working with multiple tables and joining data	Types of relationships between tables: one-to-one, one-to-many, many-to-many. Introduction to JOIN: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN. Using UNION and UNION ALL to combine data from different tables. Examples of complex queries with table joins.	4 acad. hrs
4. Working with time series and dates	Storing dates and times in databases. Date functions: NOW(), CURRENT_DATE, DATEPART(), DATEDIFF(). Grouping data by time periods. Time-series analysis in SQL.	4 acad. hrs
5. Window functions and analytical queries	Introduction to window functions and how they differ from aggregate functions. Using ROW_NUMBER(), RANK(), DENSE_RANK() for working with row numbers. Data analysis with LAG(), LEAD(). Walkthrough of practical cases.	4 acad. hrs
6. Creating temporary tables and views	Creating temporary tables (TEMP TABLE). Using views (VIEW) for convenient data analysis. Optimising queries with views.	4 acad. hrs
7. Final project	Walkthrough of a typical data-analysis task. Defining the task and formulating queries. Performing the analysis and presenting the results. Wrap-up and recommendations for further study of SQL.	4 acad. hrs

3-week intensiveshort and focused

Groups of 6–10personal attention

Modern computer labclassroom format in central Tallinn

Lecture recordingscatch up or revise

Flexible payment & state supportpayment options and support programmes are available — ask our consultant

Requirements for students

confident PC user

Learning methods

Total course volume: 42 academic hours, of which 28 academic hours take place in the classroom (including 8 hours of practical work and 2 seminars totalling 8 academic hours).

Assessment criteria

Learning outcomes are assessed on the basis of independently completed practical work.

Assessment methods

Upon successful completion, practical and homework assignments receive a "pass" grade.

Course completion conditions

To successfully complete the course and receive a certificate, at least 75% of the homework assignments must be passed.

Additional information

Curriculum group: 0612 - Database and network design and administration (0612 - Andmebaaside ja võrgu disaini ning halduse õppekavarühm)
General rules for organising studies (in Estonian)
Rules for ensuring study quality (in Estonian)

Ready to start? The next groups begin:

19.10.2026 - 18.11.2026
16.11.2026 - 04.12.2026

Apply → We'll reply within 1 business day

Price: 1024.80 EUR (VAT 24% included)

Total course volume: 42 acad. hrs
Includes classroom sessions 28 acad. hrs (of which 8 practical hrs and 2 seminars, 8 acad. hrs) and independent work 14 acad. hrs. The course is held in a classroom format, in a modern computer lab; group size from 6 to 10 people.

Instructors

Maksim Kolodijev

Qualification: Over 15 years in software development. Over 8 years of experience in software testing.

Specialisation: Software development process, software testing, test automation, data analysis

Teaching experience: Over 5 years of teaching and consulting experience

Education: TalTech, Master's degree (2007)

View CV

Roman Kutselepa

Qualification: Over 5 years in software development.

Specialisation: web design, JavaScript development, effective use of software products in a company

Teaching experience: Over 5 years of experience in teaching and staff training

Education: Anglia Ruskin University, 2010 (England)

View CV