Advanced SQL + Performance workshop

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

Tallinn,

Ticket TypeEnd of SubscriptionPriceQuantity
Early Bird Price
01/08/2018 569.00 €569.0EUR
Normal Price
04/02/2018 630.00 €630.0EUR
Group Price ( if register 2 or more)
02/08/2018 550.00 €550.0EUR

 This  course can also be delivered in-house. Please contact us for more information 

Contact us

Advanced SQL workshop

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

Trainer Lukas Eder  

    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
    Prerequisites and Logistics
     
    Participants need to bring their own machines and perform pre-course setup. Setup instructions will be available.

    Delegates should bring laptops with PostgreSQL installed, but this training will now support any of these ( if someone prefers not to work with PostgreSQL):

    • DB2 LUW
    • MySQL 8.0
    • Oracle
    • PostgreSQL
    • SQL Server

    Participants should be experienced at writing SQL queries

    Where

    Narva mnt 120b
        Hotel Oru
        Tallinn

    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