Duration: One Day
The one-day instructor-led course is an introductory class for anyone learning to design and create databases. The material will be helpful for new database administrators or any IT professionals who will have a part in designing and maintaining databases. Students will learn to create databases using SQL Server or Azure SQL databases and learn basic Transact-SQL skills for creating, altering, and updating database objects.
Audience Profile
The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. IT personnel involved in database design and management will find the exercises useful.
At course completion
- Describe data modelling techniques
- Describe normalization and denormalization techniques
- Describe relationship types and effects in database design
- Describe commonly used methods for protecting data integrity
Course Details
- Module 1: Introduction to Data Modelling
- Module 2: Designing A Database (Normalization)
- Module 3: Table Relationships