SQL Master Class

SQL Master Class

Training

Get the most out of SQL

arrow-down

SQL has come a long way since SQL:92

  • 1
    MUltiple database support
    The SQL Master Class is designed for Oracle, SQL Server, PostgreSQL and MySQL.
  • 2
    PRACTICAL EXAMPLES
    All SQL examples are inspired by real-life scenarios. All code is on GitHub, and you will have exclusive access to the source repository and benefit from future updates.
  • 3
    Present-Day SQL
    SQL has come a long way since SQL:92. This training teaches you many useful features like Window Functions, Lateral Joins, Recursive Common Table Expressions, that will help you write better queries to address complex data access requirements.
arrow-down

Curriculum

The SQL Master Class training is aimed to level up your team's SQL and database skills, covering the top most used database systems, such as Oracle, SQL Server, PostgreSQL, and MySQL.

Day 1

Introduction

Duration: 1h 45m

  • Beyond SQL:92
  • SQL Parsing
  • SQL Operation Order
  • UPSERT and MERGE
  • Execution Plans

Subqueries

Duration: 1h 45m

  • EXISTS and NOT EXISTS
  • IN and NOT IN
  • ANY and ALL
  • INSERT with subqueries
  • Aggregation with subqueries

Joins

Duration: 1h 45m

  • CROSS JOIN
  • INNER and LEFT/RIGHT OUTER JOIN
  • FULL OUTER JOIN
  • NATURAL JOIN
  • LATERAL JOIN and CROSS APPLY

Window Functions

Duration: 1h 45m

  • Analytics queries and window frame processing
  • ROW_NUMBER, RANK, and DENSE_RANK
  • FIRST_VALUE, LAST_VALUE, LEAD and LAG
  • CUME_DIST and PERCENT_RANK
  • PERCENTILE_DISC and PERCENTILE_CONT

Day 2

PIVOT

Duration: 1h 45m

  • CASE Expressions
  • PostgreSQL FILTER Expressions
  • PIVOT
  • UNPIVOT

Query pagination

Duration: 1h 45m

  • TOP-N queries
  • OFFSET pagination
  • Keyset Pagination

Derived Tables and CTE

Duration: 1h 45m

  • Derived Tables
  • CTE (Common Table Expressions)
  • Recursive CTE
  • Hierarchic queries

JSON processing

Duration: 1h 45m

  • Schemaless data structures and JSON
  • JSON queries
  • EAV Model

Fit to your needs

There is no limit of students that can enroll in this training. If you have multiple teams that need to attend it, the cheaper it gets per person.

The full training spans 2 days, but it can be adapted to a 1-day workshop as well. We can arrange the agenda so that we cover exactly what you need.

All source code is in a GitHub repository which you set up during the training and later use it whenever you need.


arrow-down



Contact me

Let me teach you how to run your data access layer at high speeds!


If you want to book an on-site training session, you should email me at vlad@vladmihalcea.com

and discuss it in more detail.