Introduction
Welcome
What you need to know

1. Understanding Databases
What are databases?
Exploring databases and database management systems

2. 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)

3. Database Modeling: Tables
Introduction to database modeling
Planning your database
Identifying columns and selecting data types
Choosing primary keys
Using composite keys

4. 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

5. Database Modeling: Optimization
Understanding normalization
First normal form
Second normal form
Third normal form
Database denormalization

6. 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

7. Database Modeling: Indexing and Optimization
Understanding indexes
Understanding write conflicts
Understanding stored procedures and injection attacks

8. Database Options
Desktop databases
Relational database management systems
Object-based and XML-based databases
NoSQL databases

Conclusion
Final thoughts