SQL Training
Level
BeginnerDuration
16h / 2 daysDate
Individually arrangedPrice
Individually arrangedSQL 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. SQL can be used for creating web applications, analyzing data outside of Excel, or in Big Data / Data Science scenarios.
What will you learn?
- 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.
Who is this training for?
For people who want to learn SQL and methods of data processing, and acquire practical knowledge that enables them to work with data.-
For those who would like to discover advanced tools for data processing and analysis that will significantly speed up their work.
-
For anyone who wants to set up and use their own database in practice during the course.
Training Program
-
Relational vs Non-Relational Database Models
- What simple and complex databases are
- How relational databases work (SQL)
- What non-relational (NoSQL) databases are
-
Table Joins
- JOIN / INNER JOIN / FULL JOIN
- CROSS JOIN
-
Set Operations
- UNION
- EXCEPT
- INTERSECT
-
Subqueries
- Correlated subqueries
- Subqueries in FROM
- Subqueries in WHERE / HAVING
- Use of EXISTS
-
Analytic and Aggregate Functions
- SUM
- COUNT
- MIN / MAX / AVG
-
Ranking Functions
- RANK
- DENSE_RANK
- ROW_NUMBER
- NTILE
-
Window Functions
- Using OVER
- PARTITION BY and ORDER BY
- Use of ROWS and GROUPS
-
Basics of Query Optimization
- Data structure
- Data size
- Filtering data
- Data access methods
