Overview
-
Learn the fundamentals of database programming. Find out how to build a database, define relationships, and write queries.
Syllabus
-
Introduction
- Why use a database?
- What you should know
- Understanding databases: Benefits of spreadsheets
- Understanding databases: Benefits of structured data
- Relational databases
- Keys and unique values
- Relationships
- ACID and transactions
- Basic SQL
- Modeling and planning a database
- Naming tables
- Columns and data types
- Numbers and other types
- Primary and foreign keys
- Creating relationships
- One-to-many relationships
- Many-to-many relationships
- One-to-one relationships
- Relationship rules and referential integrity
- Normalization
- First normal form
- Second normal form
- Third normal form
- Denormalization
- Creating a database
- Creating tables
- Writing SQL queries
- Narrowing query results
- Sorting results
- Aggregate functions
- Joining tables
- Modifying data
- Indexes, transactions, and stored procedures
- Access control, compliance, and injection
- Software options
- Next steps
