Course Outline
Module 1: Foundations of DatabasesThis module explores key database concepts through the lens of SQL Server 2016.Lessons
- Overview of relational databases
- Exploring other database types
- Essentials of data analysis
- Database languages in SQL Server
Module 2: Data ModellingThis module covers essential data modelling techniques.Lessons
- Principles of data modelling
- The ANSI/SPARC database architecture
- Entity-relationship modelling
Module 3: Normalization StrategiesThis module delves into normalization and denormalization approaches.Lessons
- Core principles of Normalization
- Understanding normal forms
- Strategies for Denormalization
Module 4: Managing RelationshipsThis module explains the types of relationships and their effects in database design.Lessons
- \r
- Introduction to database relationships
- Planning for referential integrity
Module 5: Performance OptimizationThis module examines how database design influences performance.Lessons
- Indexing strategies
- Optimizing query performance
- Managing concurrency
Module 6: Database ObjectsThis module introduces frequently used 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.
