Foundations of Programming Databases

09/2015
3:11 hours

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