Data Analysis with SQL

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

Course Information

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. A laptop can be provided for the duration of the course if needed.

Various funding options are available for this course, including government support schemes and non-profit organisation programmes. Get in touch with our consultant for more detailed information.

Learn about support options →

Target group:

This course is for you if you:

are a beginning data analyst and want to master SQL as a core analysis tool;
work with data (marketing, finance, product) and would like to build your own queries and reports;
are a manager or product analyst and need to get data without relying on developers;
are a developer and are interested in working confidently with databases in your tasks;
are a QA engineer or tester and need to validate data and write SQL queries for tests;
are a specialist from another field and plan to retrain as a data analyst;
are a student of an economics or technical discipline and would like to gain practical SQL skills;
are an entrepreneur or business owner and need to analyse data from your own systems.

What you'll learn on this course:

Write queries in SQL

Work with the MySQL database

Understand relational databases

Requirements for students:

Confident PC user
Preferably with your own laptop (Windows / Mac, 8 GB RAM, screen size > 13.3"); a laptop can be provided for the duration of the course if needed.

Learning Outcomes:

Those who complete this course:

Understand the fundamentals of relational database theory
Be able to write SQL queries according to work tasks
Be able to filter and aggregate data
Apply mathematical and statistical operations for the initial processing of data
Use SQL to work with time series
Understand the principles of creating user-defined functions and stored procedures

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)

Course program

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

Course Details

Course Schedule:

10.09.2026 - 02.10.2026
21.09.2026 - 13.10.2026

Apply →We'll reply within 1 business day

Course length:

3 weeks

Format and Location:

Address: Tartu mnt. 18, Tallinn.
Gamma Intelligence Training Centre
The course is held in a classroom format, in a modern computer lab. Group size from 6 to 10 people.

Language of Instruction: English

Price: 1024.80 EUR (VAT 24% included)

Total Course Volume: 42 acad. hrs
Includes:

Classroom sessions: 28 acad. hrs (including 8 practical hrs and 2 seminars – 8 acad. hrs)
Independent work: 14 acad. hrs

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