Module 1: Introduction to databases.
This module introduces key database concepts in the context of SQL Server 2016.
• Introduction to relational databases.
• Other types of database.
• Data analysis.
• Database languages in SQL Server.
• Lab: Exploring and querying SQL Server databases.
Module 2: Data Modelling.
This module describes data modelling techniques.
• Data modelling.
• ANSI/SPARC database model.
• Entity relationship modelling.
• Lab: Identify components in entity relationship modelling.
Module 3: Normalization.
This module describes normalization and denormalization techniques.
• Fundamentals of Normalization.
• Normal form.
• Denormalization.
• Lab: Normalizing data.
Module 4: Relationships.
This module describes relationship types and effects in database design.
• Introduction to relationships.
• Planning referential integrity.
• Lab: Planning and implementing referential integrity.
Module 5: Performance.
This module introduces the effects of database design on performance.
• Indexing.
• Query performance.
• Concurrency.
• Lab: Performance issues.
Module 6: Database Objects.
This module introduces commonly used database objects.
• Tables.
• Views.
• Stored procedures, triggers and functions.
• Lab: Using SQL server./
