SQL and Data Processing 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 learn the advanced data processing and analysis tool from scratch, which has been a market standard for years.

• You will create and configure your own database. You will learn what it can be used for in practice.
• You will learn to create advanced reports, where you will search, sum, filter, and process data according to your needs.
• You will learn the language of programmers, concepts, and principles of working with data. You will also learn to communicate with other programmers.
• The knowledge you acquire can be easily transferred and used with other popular tools, such as MS Access, Oracle DB. You will be prepared for Microsoft certification 70-461 MCSA SQL.

1. MODULE 1: INTRODUCTION TO RELATIONAL DATABASES
    • database engines
    • creating a new database
    • division into DQL, DML, DDL, DCL
    • tools and accessories

2. MODULE 2: BASICS OF DATABASE PROGRAMMING
    • selecting queries – DQL (Data Query Language)
    • application of operators and criteria in queries
    • functions and expressions in SQL:
     – string operations
     – concatenating and splitting text strings
     – mathematical functions
     – date/time functions
     – creating your own functions

3. MODULE 3: BASICS OF SQL QUERIES
    • aggregate queries (GROUP BY, COUNT, MIN, MAX, SUM, AVG)
    • conditions in aggregated results (WHERE, HAVING)
    • combining query results (UNION, INTERSECT, EXCEPT/MINUS)
    • nested queries
    • modifying queries – DML (Data Manipulation Language): UPDATE, INSERT, DELETE, SELECT INTO

4. MODULE 4: TABLES AND OBJECTS IN SQL
    • operations on joined tables (INNER JOIN, RIGHT/LEFT/FULL OUTER JOIN, CROSS JOIN)
    • creating and modifying SQL objects – DDL (Data Definition Language): CREATE, ALTER, ALTER TABLE, DROP

5. MODULE 5: ADVANCED FUNCTIONS IN SQL SERVER
    • OVER, ROW_NUMBER, RANK, DENSE_RANK, PARTITION BY, NTILE – usage
    • common table expression
    • stored procedures in SQL and T-SQL programming (introduction)
    • SQL cursors
    • event handling using triggers (TRIGGER)

6. MODULE 6: MICROSOFT SQL SERVER AND BASICS OF ADMINISTRATION
    • communication with Microsoft SQL Server – data import and export
    • basics of administration and introduction to access management

45 h/6 days