SQL Masterclass

Kesto: 3 pv , Opetuskieli: englanti, Materiaalikieli: englanti, Materiaali: online
SQL Masterclass, no exam
1 Kpl
SQL Masterclass (3 pv), 15.04.2020
1 Kpl
SQL Masterclass Materiaali, online
990 €
+ alv.. 24%.


After completing the course: You will be able to read and write advanced SQL effectively.

This workshop enables developers to use SQL as a first-­class language in their applications.

Due to the historic divide between database and programming skills the majority of SQL written by developers suffers from at least one of the following problems:

  • It is overly complex and could be greatly simplified via refactoring
  • It has poor performance, due to insufficient knowledge of DB internals
  • It does not leverage modern and/or vendor specific SQL functions

All of these issues can be fixed by encouraging developers to treat SQL with as much respect as their normal code, educating them about performance implications and informing them about new features available in commercial and open source databases. This masterclass achieves these three goals.

Target audience: experienced with SQL and programming in general. Specific PostgreSQL or Oracle knowledge is not required.

Prerequisites: This is a 3-day day workshop delivered using the DB2 LuW, MySQL 8.0+, Oracle, PostgreSQL, or SQL Server databases. Delegates should be experienced at writing SQL queries. Delegates should bring their own laptop, in which case setup instructions will be provided.

Learning methods: Practical exercise, independent work.

Assesment methods: Execution of independent work.

Assesment form: Independent practical tasks on relevant topics.

Price includes coffee breaks and lunch in restaurant Lusikas.



Outline Day 1 – SQL Database Design

  • Review of the relational model and normalisation principles
  • Common migration patterns when evolving a database schema
  • Common pitfalls and antipatterns in database design
  • OO first vs. relational first, when using ORMs
  • Schema-on-read (“schemaless”) vs. schema-on-write (“schemaful”)

Outline Day 2 – SQL Functionality

  • Introduction to the course databases and review of core SQL constructs
  • Advanced constructs, such as row value expressions and hierarchical SQL
  • 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 3 – SQL Performance

  • The cost based optimiser (CBO)
  • The inner workings of an index
  • Writing performant predicates
  • Constraints, or why metadata matters
  • Faster writes / data manipulation (DML)
  • Antipatterns, myths, and best practices

If you can not participate this course, you can send someone else instead of you. If cancellation is done less than 14 days before the course start, we will charge 50% of the price. In case of no show without any cancellation, we will charge the whole price. Cancellation fee will also be charged in case of illness.

Oma koulutus tai tapahtuma Oppia.fi:hin?

Ota yhteyttä!