Advanced SQL + Performance workshop

2018-04-05 09:00 to2018-04-06 17:00(Europe/Tallinn)


Ticket Type End of Subscription Price Quantity

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


    Narva mnt 120b
        Hotel Oru


    From '2018-04-05 09:00
    To '2018-04-06 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