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.
10985 Introduction to SQL Databases
10985 Introduction to SQL Databases
Overview
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.
CURRICULUM
10985 Introduction to SQL Databases
- 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