Advanced SQL + Performance workshop

Registrations are closed

Odoo CMS - a big picture

What In It For Me

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

Trainer Lukas Eder

This SQL class has already TAKEN PLACE , but do not worry, we are planning next class.

If you are interested in, please let us  know, when do you prefer to have a training

Contact us

    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
    Date & Time
    Thursday
    April 5, 2018
    Start - 9:00 AM
    Friday
    April 6, 2018
    End - 5:00 PM Europe/Tallinn
    Location

    Hotel Oru, Hotel Oru

    Narva mnt 120b
    Hotel Oru
    Tallinn
    Estonia
    --Hotel Oru, Hotel Oru--
    Trainer

    Lukas Eder

    --Lukas Eder--
    SHARE

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