AI & Data

SQL and Data Processing Training

SQL is everywhere data storage and processing are involved — from machine learning engineers, through finance professionals, web developers, to data visualization experts and even journalists.

Duration
6h
Ask about the program → See all
Who it's for

Ideal for teams that…

1 For those who want to learn SQL and data processing methods, and gain practical knowledge enabling them to work with them.
2 For those who want to learn advanced tools for data processing and analytics that will significantly speed up their work.
3 For anyone who wants, during the course, to set up and use their own database in practice.
Outcomes after the program

Hands-on AI and data analytics workshops — built around your team's real cases.

✓

You will create and configure your own database; you’ll learn what practical applications it can serve.

✓

You will learn to build advanced reports, where you will search, sum up, filter, and process data as needed.

✓

You will discover programming-related language, concepts, principles, and best practices in working with data. You will also learn how to communicate with other developers.

✓

You will acquire knowledge that’s portable to other popular tools, such as MS Access or Oracle DB.

✓

You will be prepared for Microsoft certification 70-461 MCSA SQL.

✓

You will learn advanced tools for data processing and analysis, which for years have been market standards.

Program · 6 modules

What we actually do

M01
Module 1: Introduction to Relational Databases
  • · Database engines
  • · Creating a new database
  • · Distinctions between DQL, DML, DDL, DCL
  • · Tools and accessories
M02
Module 2: Fundamentals of Database Programming
  • · SELECT queries — DQL (Data Query Language)
  • · Application of operators and criteria in queries
  • · SQL functions and expressions: text/string operations, concatenation & splitting string fields, mathematical functions, date/time functions
  • · Creating your own functions
M03
Module 3: Basics of SQL Queries
  • · Aggregating queries (GROUP BY, COUNT, MIN, MAX, SUM, AVG)
  • · Conditions in aggregated queries (WHERE, HAVING)
  • · Combining query results (UNION, INTERSECT, EXCEPT/MINUS)
  • · Nested queries
  • · Data Manipulation Language (DML): UPDATE, INSERT, DELETE, SELECT INTO
M04
Module 4: Tables and SQL Objects
  • · Operations on joined tables: INNER JOIN, RIGHT/LEFT/FULL OUTER JOIN, CROSS JOIN
  • · Creation and modification of SQL objects: CREATE, ALTER, ALTER TABLE, DROP
M05
Module 5: Advanced Functions in SQL Server
  • · Window functions: OVER, ROW_NUMBER, RANK, DENSE_RANK, PARTITION BY, NTILE
  • · Common table expressions (CTEs)
  • · Introduction to stored procedures and T-SQL programming
  • · Cursors in SQL
  • · Event handling using triggers
M06
Module 6: Microsoft SQL Server and Basic Administration
  • · Communication with Microsoft SQL Server — data import and export
  • · Basic administration and introduction to access management
Every module is adapted to your stack and context. The above is a starting point — not a fixed agenda.
How we work

From brief to retro in 30 days.

01

Brief & diagnosis

A call with the team lead + a short survey for participants. We define goals, gap and context.

02

Program customization

We adapt modules, case studies and code examples to your stack. Approval in 5 days.

03

Workshop

Trainer-led sessions, hands-on, code review. Mentor available between sessions too.

04

Retro + report

Outcome report for the team and lead. 30 days of consulting included.

Inquiry

Send a brief. We'll reply within 1 day.

After a short brief we'll prepare a program and a quote. No obligations — it's just a starting point.

✓Quote within 48h of the brief
✓First session within 30 days
✓Pilot before the full decision
✓VAT invoice, payment in instalments possible

Ochrona antyspamowa (Cloudflare Turnstile) zostanie aktywowana po wpięciu klucza.

Other programs for teams

See all →
AI & Data

Active Directory Training

Hands-on AI and data analytics workshops — built around your team's real cases.

AI & Data →
AI & Data

Advanced Power BI Training

Hands-on AI and data analytics workshops — built around your team's real cases.

AI & Data →
AI & Data

Advanced RPA Developer Training

Hands-on AI and data analytics workshops — built around your team's real cases.

AI & Data →