SQL – how to work effectively with large datasets

SQL workshops

The goal of this meeting is to present and speak about how poor database schema project can affect on performance of whole application. What are the most common mistakes? How to avoid them and make database faster, easier to maintain and data more reliable.

Speakers

Grzegorz

Agenda

  1. Good and bad database model, SQL antipatterns
  2. Proper usage of SQL data types and indexes
  3. How to tweak SQL queries, good and bad practices
  4. Fight with large dataset – denormalization, partitions
  5. Doctrine features and “features”

Prerequisites:

  • Practical knowledge of SQL queries construction
  • Open mind

Useful reading

  • Learn SQL: codecademy
  • MySQL and/or PostgreSQL official documentation

When:

Thursday, 26 October 2017, 16:00

Length:

~ 3-4 hours

Where:

Espeo Software, Wroniecka 18/5 Poznań