Author Simon Allardice covers key terminology and concepts, such as normalization, "deadly embraces" and "dirty reads," ACID and CRUD, referential integrity, deadlocks, and rollbacks. The course also explores data modeling step by step through hands-on examples to design the best system for your data. Plus, learn to juggle the competing demands of storage, access, performance, and security—management tasks that are critical to your database's success.

Topics include:

• What is a database?
• Why do you need a database?
• Choosing primary keys
• Identifying columns and selecting data types
• Defining relationships: one-to-one, one-to-many, and many-to-many
• Understanding normalization
• Creating queries to create, insert, update, and delete data
• Understanding indexing and stored procedures
• Exploring your database options