Overview
This 3-day instructor-led 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.
Prerequisites
Those who wish to take up this course should meet the following prerequisites:
- This is a foundation level course and therefore only requires general computer literacy.
Who Should Attend?
This course is recommended for people who are moving into a database role, or whose role has expanded to include database technologies.
Course Outline
- Introduction to relational databases
- Other types of database
- Data analysis
- Database languages in SQL Server
Lab: Exploring and querying SQL Server databases
- Data modelling
- ANSI/SPARC database model
- Entity relationship modelling
Lab: Identity components in entity relationship modelling
- Fundamentals of Normalization
- Normal form
- Denormalization
Lab: Normalizing data
- Introduction to relationships
- Planning referential integrity
Lab: Planning and implementing referential integrity
- Indexing
- Query performance
- Concurrency
Lab: Performance issues
- Tables
- Views
- Stored procedures, triggers and functions
Lab: Using SQL Server
