Programming Foundations: Databases

Learn the fundamentals of database programming. Find out how to build a database, define relationships, and write queries.

Introduction

• Why use a database?
• What you should know
• Understanding databases: Benefits of spreadsheets
• Understanding databases: Benefits of structured data

1. Database Foundations

• Relational databases
• Keys and unique values
• Relationships
• ACID and transactions
• Basic SQL

2. Tables

• Modeling and planning a database
• Naming tables
• Columns and data types
• Numbers and other types
• Primary and foreign keys

3. Relationships

• Creating relationships
• One-to-many relationships
• Many-to-many relationships
• One-to-one relationships
• Relationship rules and referential integrity

4. Database Optimization

• Normalization
• First normal form
• Second normal form
• Third normal form
• Denormalization

5. Querying a Database

• Creating a database
• Creating tables
• Writing SQL queries
• Narrowing query results
• Sorting results
• Aggregate functions
• Joining tables
• Modifying data

6. Further Database Topics

• Indexes, transactions, and stored procedures
• Access control, compliance, and injection
• Software options

Conclusion

• Next steps