Advanced SQL + Performance workshop

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

Tallinn,Estonia

Ticket TypeEnd of SubscriptionPriceQuantity


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

    Where

    Narva mnt 120b
        Hotel Oru
        Tallinn
        Estonia

    When

    From2018-04-05 09:00
    To2018-04-06 17:00

    Trainer

    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