About the course
This course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs.
ideal for
The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies.
Objectives
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
Prerequisite Knowledge
This is a foundation level course and therefore only requires general computer literacy.