Advanced Databases for Beginners - Dave Cross
Wednesday, The Camel Room, 1400, 180 mins

Everyone knows how to use databases right? You just create a few tables and bung some data in them. Later on you can select the data back again or update it.

Well, that's only really half the picture. And many people only see that half of the picture. Which is why so many database designs are so bad.

In this tutorial, we'll look at the bits of database design that most people seem to forget about. We'll learn some techniques that can make your databases more robust, easier to use and perhaps even faster.

Amongst the topics we'll cover are:

  • Normalisation
  • Data types
  • Constraints
  • Indexes
  • Relationships
  • Triggers

All of the examples will be based on MySQL 5 but the principles will be application to most database systems.