SQL for Analysts 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.

Enhance your data analysis skills using advanced SQL capabilities. Learn to write more efficient queries, work with large datasets, and optimize your daily analytical tasks.

• For data analysts who know the basics of SQL and want to advance to a higher level.
• For BI specialists working with large datasets in their daily work.
• For those preparing reports, analyses, and summaries from databases.
• logo infoshare
• For those who want to increase the efficiency of their queries and data work.

• Analyze data using advanced techniques for sorting and comparing records.
• Group and aggregate data in various ways to create clear and complex reports.
• Join and compare datasets and use subqueries in a more flexible manner.
• Create temporary structures, automate queries, and efficiently import and export data.

1. WINDOW FUNCTIONS
    • ROW_NUMBER()
    • RANK()
    • DENSE_RANK()
    • LAG()
    • LEAD()

2. DATA GROUPING
    • ROLLUP
    • CUBE
    • GROUPING SETS

3. SETS AND DATA COLLECTIONS
    • UNION / UNION ALL
    • EXCEPT
    • INTERSECT
    • correlated subqueries

4. BUILT-IN FUNCTIONS
    • text
    • date and time
    • mathematical
    • converting

5. TEMPORARY DATA STRUCTURES
    • CTE
    • views
    • temporary tables

6. WORK OPTIMIZATION
    • functions and procedures
    • dynamic SQL
    • importing/exporting data
    • BULK import

16 h/2 days