Course Outline
Module 1: Introduction to databases
This section establishes the core database concepts specifically within the SQL Server 2016 framework.Lessons
- Foundations of relational databases
- Alternative database models
- Data analysis approaches
- Database languages in the SQL Server environment
Module 2: Data Modelling
Here, we explore the various techniques involved in data modelling.Lessons
- Core data modelling practices
- The ANSI/SPARC database model
- Entity relationship modelling
Module 3: Normalization
This part of the course details the methods for normalization and denormalization.Lessons
- Basic principles of normalization
- Understanding normal forms
- Concepts of denormalization
Module 4: Relationships
We examine the different types of relationships and their specific impacts on database design.Lessons
- Overview of database relationships
- Establishing referential integrity
Module 5: Performance
This module highlights how design choices directly affect system performance.Lessons
- Indexing strategies
- Optimizing query performance
- Managing concurrency
Module 6: Database Objects
Finally, we introduce the most frequently encountered database objects.Lessons
- Working with tables
- Utilizing views
- Stored procedures, triggers, and functions
Testimonials (4)
data was personalised to our organisations
Vincent Long - ASSMANG PTY LTD
Course - T-SQL Fundamentals with SQL Server Training Course
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training was well structured and interactive
kgotla Moncho - Martin Engineering Africa
Course - MS 20761 : Querying Data with Transact SQL
The instructor brought his A game again as he superbly took my staff through the customized training with expert timing, knowledge, support, and rapport with my staff.
