SQL Training

Infoshare is the largest tech community in CEE and the organizer of the leading tech conference in Gdańsk. It connects startups, investors, corporations, and innovation enthusiasts. It promotes entrepreneurship, knowledge sharing, and networking. Through events, competitions, and programs, it supports the development of the tech ecosystem in Poland and the region.

SQL is everywhere where work is related to data storage and processing. From machine learning engineers, through specialists in financial sectors, web developers, to data visualization experts, and even journalists. SQL can be used: in creating web applications, in data analysis outside of Excel, or even in Big Data or Data Science.

• For those who want to learn SQL and ways to process data, and gain practical knowledge that will enable them to work with it.
• For those who want to learn advanced tools for data processing and analysis that will significantly speed up their work.
• For anyone who wants to configure and practically use their own database during the course.

• To gain basic knowledge about SQL, a key language for working with databases, which is essential in many fields, from machine learning engineering to data visualization.
• To learn the basics of SQL query optimization, which includes data structure, data size, data filtering, and data access.

• You will learn to understand the differences between relational databases (SQL) and non-relational databases (NoSQL),
• You will master techniques for joining tables, including various types of JOINs, CROSS JOINs, and set operations (UNION, EXCEPT, INTERSECT).
• You will learn the applications of subqueries, including correlated subqueries, in various parts of SQL queries and the use of EXISTS clauses.
• You will acquire skills in using analytical and ranking functions, such as SUM, COUNT, MIN/MAX/AVG, RANK/DENSE_RANK, ROW_NUMBER, NTILE, and window functions, including OVER, PARTITION BY, and ORDER BY.

1. RELATIONAL DATABASE MODEL – NON-RELATIONAL DATABASE MODEL – LECTURE
    • what simple and complex databases are
    • what a relational database is, how it works (SQL)
    • what non-relational databases are (NoSQL)

2. JOINING TABLES
    • table joins: JOIN / INNER JOIN / FULL JOIN
    • cross joins: CROSS JOIN
    • set operations: UNION / EXCEPT / INTERSECT

3. SUBQUERIES
    • correlated subqueries
    • subqueries in FROM
    • subqueries in WHERE / HAVING
    • use of EXISTS

4. ANALYTICAL FUNCTIONS
    • SUM
    • COUNT
    • MIN / MAX / AVG

5. RANKING FUNCTIONS
    • rankings RANK / DENSE_RANK
    • ROW_NUMBER
    • NTILE partitioning

6. WINDOW FUNCTIONS
    • use of OVER
    • using PARTITION BY and ORDER BY
    • use of ROWS and GROUPS

7. BASICS OF QUERY OPTIMIZATION
    • data structure
    • data size
    • data filtering
    • data access

16 h/2 days