Friday 11th September, 2015
8:30am to 5:30pm
You can learn the basics of SQL in three days but it’ll take you 10 years to become good at it.
In this full training day we will take a look at a range of common design and coding mistakes to get an idea of the patterns and practices that absolutely do not work well for optimum performance, scale and design.
Anti-patterns are a way of naming these common design mistakes in order to make them easier to identify and remember (and correct!). Sooner or later as the demands on your database performance increase, so will the need to identify and resolve your anti-patterns.
During the day we will grow acquainted with anti-patterns on a physical level, a logical level, a SQL Query and application level, and spice it them up with some seriously foolish errors made by both myself, my colleagues and the industry at large!
Examples of SQL Anti patterns that we will address during the day will include:
Null is evil
…and many more!
There will be lots of interaction with the audience in an attempt to uncover the worst database design war stories as well as hearing about my numerous mistakes and experiences over the years!
You can expect to leave the class with a big bag of tricks of BAD database design ideas, illustrated with many examples from real projects in order that you can make a bad database good!
CEO of Effektor
Sign in to add slides, notes or videos to this session