Introduction to SQL Databases

Introduction to databases

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

Topics:

• Introduction to relational databases
• Other types of database
• Data analysis
• Database languages

Data Modelling

This module describes data modelling techniques.

Topics:

• Data modelling
• ANSI/SPARC database model
• Entity relationship modelling

Normalization

This module describes normalization and denormalization techniques.

Topics:

• Why normalize data?
• Normalization terms
• Levels of normalization
• Denormalization

Relationships

This module describes relationship types and effects in database design.

Topics:

• Schema mapping
• Referential integrity

Performance

This module introduces the effects of database design on performance.

Topics:

• Indexing
• Query performance
• Concurrency

Database Objects

This module introduces commonly used database objects.

Topics:

• Tables
• Views
• Stored procedures
• Other database objects