Introduction to SQL Databases (55315)

Module 1: Introduction to databases

This module introduces key database concepts in the context of SQL Server.

Lessons

• Introduction to Relational Databases
• Other Databases and Storage
• Data Analysis
• SQL Server Database Languages

Module 2: Data Modeling

This module describes data modelling techniques.

Lessons

• Data Modelling
• Designing a Database
• Relationship Modeling

Module 3: Normalization

This module describes normalization and denormalization techniques.

Lessons

• Fundamentals of Normalization
• Normal Form
• Denormalization

Module 4: Relationships

This module describes relationship types and effects in database design.

Lessons

• Introduction to Relationships
• Planning Referential Integrity

Module 5: Performance

This module introduces the effects of database design on performance.

Lessons

• Indexing
• Query Performance
• Concurrency

Module 6: Database Objects

This module introduces commonly used database objects.

Lessons

• Tables
• Views
• Stored Procedures, Triggers and Functions