Advanced SQL + Performance workshop

2017-09-11 09:00 to2017-09-12 17:00(Europe/Tallinn)


Ticket Type End of Subscription Price Quantity

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


    Narva mnt 120b
        Hotel Oru


    From '2017-09-11 09:00
    To '2017-09-12 17:00


    Lukas Eder

    Social Stream

    Participate on Twitter

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

    Use this tag: #LukasEder