Advanced SQL + Performance workshop

Registrations are closed

This training has already taken place. Next training will take place April 5-6, 2018. This  course can also be delivered in-house. Please contact us for more information 

Contact us

Advanced SQL workshop

Participants will be able to read and write advanced SQL effectively after this course.

Trainer Lukas Eder  

    Outline Day 1 – SQL Functionality
    • Introduction to the course databases and revision of core SQL constructs
    • Advanced constructs, such as row value expressions and hierarchical SQL A
    • Applying window functions for complex calculations within the database
    • Modern use of DML (e.g. using MERGE instead of INSERT and UPDATE)
    • Using esoteric data types (json, hstore, arrays, composite types, ranges etc…)
    Outline Day 2 – SQL Performance

    • The inner workings of an index
    • The cost-based optimizer
    • Why constraints are so important for performance
    • Writing performant predicates
    • Faster DML
    • Antipatterns, myths, and best practices
    Prerequisites and Logistics
    Participants need to bring their own machines and perform pre-course setup. Setup instructions will be available.

    Delegates should bring laptops with PostgreSQL installed, but this training will now support any of these ( if someone prefers not to work with PostgreSQL):

    • DB2 LUW
    • MySQL 8.0
    • Oracle
    • PostgreSQL
    • SQL Server

    Participants should be experienced at writing SQL queries
    Date & Time
    September 11, 2017
    Start - 9:00 AM
    September 12, 2017
    End - 5:00 PM Europe/Tallinn

    Hotel Oru, Hotel Oru

    Narva mnt 120b
    Hotel Oru
    --Hotel Oru, Hotel Oru--

    Lukas Eder

    --Lukas Eder--

    Find out what people see and say about this event, and join the conversation.