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 design
Address
Training @ any New Horizons Training Centers View mapCourse 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 de-normalization techniques
- Describe relationship types and effects in database design
- Describe the effects of database design on performance
- Describe commonly used database objects
Target Student and Prerequisites
The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies.
Course Content
- Introduction to relational databases
- Other types of database
- Data analysis
- Database languages
- Lab : Querying SQ Server
- Data modelling
- ANSI/SPARC database model
- Entity relationship modelling
- Lab : Entity relationship modelling
3 – NORMALIZATION
- Why normalize data?
- Normalization terms
- Levels of normalization
- De-normalization
- Lab : Normalizing raw data
4 – RELATIONSHIPS
- Schema mapping
- Referential integrity
- Lab : Designing relationships
5 – PERFORMANCE
- Indexing
- Query performance
- Concurrency
- Lab : Query performance
6 – DATABASE OBJECTS
- Tables
- Views
- Stored Procedures, Triggers and Functions
- Lab : Using SQL Server
- Data modelling
- ANSI/SPARC database model
- Entity relationship modelling
- Lab : Entity relationship modelling
- Why normalize data?
- Normalization terms
- Levels of normalization
- De-normalization
- Lab : Normalizing raw data
- Schema mapping
- Referential integrity
- Lab : Designing relationships
- Indexing
- Query performance
- Concurrency
- Lab : Query performance
- Tables
- Views
- Stored Procedures, Triggers and Functions
- Lab : Using SQL Server
