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

   If you are interested in-house training's, please let me know pille@devtraining.ee.

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
    Wednesday
    January 16, 2019
    Start - 9:00 AM
    Thursday
    January 17, 2019
    End - 5:00 PM Europe/Tallinn
    Location

    DevTraining

    DevTraining
    Riga
    Latvia
    +372 56476512
    pille@devtraining.ee
    Get the direction
    Organizer

    Lukas Eder

    --Lukas Eder--
    SHARE

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