- Introduction - [[Welcome]] - [[What you need to know]] - [[Understanding Databases]] - [[What are databases?]] - [[Exploring databases and database management systems]] - Database Fundamentals - [[The features of a relational database]] - [[Exploring unique values and primary keys]] - [[Defining table relationships]] - [[Describing many-to-many relationships]] - [[Transactions and the ACID test]] - [[Introduction to Structured Query Language (SQL)]] - Database Modeling: Tables - [[Introduction to database modeling]] - [[Planning your database]] - [[Identifying columns and selecting data types]] - [[Choosing primary keys]] - [[Using composite keys]] - Database Modeling: Relationships - [[Creating relationships]] - [[Defining one-to-many relationships]] - [[Exploring one-to-one relationships]] - [[Exploring many-to-many relationships]] - [[Understanding relationship rules and referential integrity]] - Database Modeling: Optimization - [[Understanding normalization]] - [[First normal form]] - [[Second normal form]] - [[Third normal form]] - [[Database denormalization]] - Database Modeling: Querying - [[Creating SQL queries]] - [[Structuring the WHERE clause]] - [[Sorting query results]] - [[Using aggregate functions]] - [[Joining tables]] - [[Inserting, updating, and deleting]] - [[The data definition language]] - Database Modeling: Indexing and Optimization - [[Understanding indexes]] - [[Understanding write conflicts]] - [[Understanding stored procedures and injection attacks]] - Database Options - [[Desktop databases]] - [[Relational database management systems]] - [[Object-based and XML-based databases]] - [[NoSQL databases]] - Conclusion - [[Final thoughts]]