DokuWiki

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