Programming Foundations Databases

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