SQL Master Class

For way too many application developers, SQL equates that SQL-92 they learned in college. However, SQL has seen many additions over the past 25 years.

Even if the NoSQL movement stormed onto the development scene 10 years ago, it never got to overthrown relational database systems, which have a huge market share.

Vlad Mihalcea

@vlad_mihalcea

CEO at Hypersistence

Vlad Mihalcea is the CEO of Hypersistence, and he also works as a Developer Advocate for the Hibernate project. He is passionate about enterprise systems, data access frameworks, and distributed systems.

He wrote hundreds of articles about Hibernate on vladmihalcea.com, and he has a gold badge for the Hibernate, Java, and JPA tags on StackOverflow. He’s also the author of High-Performance Java Persistence.

What the attendees will learn

We are going to go through various SQL constructs that will help you build better and faster queries like:

  • Window functions
  • Derived tables and WITH queries
  • Hierarchical queries using Recursive CTE
  • Pivot and Unpivot
  • Upsert and Merge
  • Lateral Join, Cross Apply, Disjunctive Union queries
  • Subqueries with EXISTS, ANY, ALL
  • JSON processing

What’s great about this training is that it covers all the major relational database systems: Oracle, SQL Server, PostgreSQL, and MySQL.

Requirements 

To run the SQL examples, the attendees need to bring their own notebooks with the following programs installed:
- Java 1.8 or newer
- Maven
- IntelliJ IDEA
- Any of the following database systems: Oracle, SQL Server, PostgreSQL, and MySQL

Workshop plan

1.-  Introduction. 1 hour
    - Beyond SQL:92
    - SQL Parsing
    - SQL Operation Order
    - TOP-N queries
    - OFFSET pagination
    - Keyset Pagination

2. Subqueries - 1h 15m
    - EXISTS and NOT EXISTS
    - IN and NOT IN
    - ANY and ALL
    - INSERT with subqueries
    - Aggregation with subqueries
   
3. Joins - 1h 15m
    - CROSS JOIN
    - INNER and LEFT/RIGHT OUTER JOIN
    - FULL OUTER JOIN
    - NATURAL JOIN
    - LATERAL JOIN and CROSS APPLY

4. Window Functions - 1h 30m
    - 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

5. Derived Tables and CTE - 1h 15m
    - Derived Tables
    - CTE (Common Table Expressions)
    - Recursive CTE
    - Hierarchic queries
   
6. PIVOT and UPSERT - 1h
    - CASE Expressions
    - PostgreSQL FILTER Expressions
    - PIVOT
    - UNPIVOT
    - MERGE and UPSERT statements

SQL Master Class


Date and time:

Wednesday 13th

From 9:00 to 17:00

Topics:

Databases, SQL, Queries.

Target audience roles:

The workshop is intended for any developer that has previously worked with SQL and has some basic knowledge of it.

It's best if the dev is familiar with Java as we will use it to run code examples.

Attendees:

20

Included:

Coffee, tea and lunch included


Venue


13th May
Polo de Contenidos Digitales Málaga
Av de Sor Teresa Prat, 15, 29003 Málaga
14th-15th May
FYCMA - Palacio de Ferias y Congresos de Málaga
Av. de José Ortega y Gasset, 201, 29006 Málaga
13TH - 15TH MAY 2020

Take a look at previous editions