Advanced SQL + Performance workshop

2019-01-16 09:00 to2019-01-17 17:00(Europe/Tallinn)

Tallinn,Estonia

Ticket TypeEnd of SubscriptionPriceQuantity
Normal Price
01/15/2019 990.00 €990.0EUR
Group Price ( if register 2 or more, price per person)
12/31/2018 940.00 €940.0EUR
Team discount (5 and more members, price per person)
12/17/2018 800.00 €800.0EUR


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

    Where

    DevTraining
        Aia 7, II floor
        Tallinn
        Estonia
    +372 56476512
    pille@devtraining.ee

    When

    From2019-01-16 09:00
    To2019-01-17 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