Anoka Tech SQL database course

SQL course notes

Week 1

• Purpose of databases
• Relationhips

Week 2

• Relations
• Keys
• Integrity constraints
• Functional dependencies
• Normalization
• Design

Week 3

• Basic commands

Week 4

• Calculated fields
• Aggregate functions
• Creating tables and relationships
• Joins
• Modification and deletion

Week 5

• Joins

Week 6

• Unions
• Views
• Case statements

Week 7

• data modeling
• entity-relational model
• cardinality
• Strong/weak entities