Course Outline
Module 1: Introduction to databases
This module explores key database concepts within the context of SQL Server 2016.Lessons
- Overview of relational databases
- Alternative database types
- Principles of data analysis
- Database languages in SQL Server
Module 2: Data Modelling
This module examines techniques for effective data modelling.Lessons
- Core concepts of data modelling
- The ANSI/SPARC database model
- Entity-relationship modelling
Module 3: Normalization
This module covers the techniques of normalization and denormalization.Lessons
- The fundamentals of normalization
- Understanding normal forms
- Application of denormalization
Module 4: Relationships
This module details the types of relationships and their effects on database design.Lessons
- Introduction to database relationships
- Planning for referential integrity
Module 5: Performance
This module analyzes how database design impacts system performance.Lessons
- Implementation of indexing
- Optimizing query performance
- Managing concurrency
Module 6: Database Objects
This module introduces the commonly used objects in a database environment.Lessons
- Structure of tables
- Creation and use of 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.
