Please note: for Attend from Anywhere customers an additional screen is required. The additional screen must have a minimum screen size of 19 inch and minimum resolution of 1280x1024, with the vertical resolution (1024) being the most critical.
After completing this course, students will be able to:
- Describe key database concepts in the context of SQL Server 2016
- Describe database languages used in SQL Server 2016
- Describe data modelling techniques
- Describe normalization and denormalization techniques
- Describe relationship types and effects in database design
- Describe the effects of database design on performance
- Describe commonly used database objects
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
Lab : Querying SQL Server
Module 2: Data Modelling
This module describes data modelling techniques.
- Data modelling
- ANSI/SPARC database model
- Entity relationship modelling
Lab : Entity relationship modelling
Module 3: Normalization
This module describes normalization and denormalization techniques.
- Why normalize data?
- Normalization terms
- Levels of normalization
Lab : Normalizing raw data
Module 4: Relationships
This module describes relationship types and effects in database design.
- Schema mapping
- Referential integrity
Lab : Designing relationships
Module 5: Performance
This module introduces the effects of database design on performance.
- Query performance
Lab : Query performance
Module 6: Database Objects
This module introduces commonly used database objects.
- Stored procedures
- Other database objects
Lab : Using SQL Server in a hybrid cloud
Students attending this course should ideally have some working knowledge of SQL databases (for example Microsoft SQL Server, Oracle, MySQL, DB2 etc.), including writing simple queries.