Course Outline
Module 1: Database FundamentalsThis module presents core database concepts specific to SQL Server 2016.Lessons
- Overview of relational databases
- Alternative database types
- Data analysis principles
- Database languages in the SQL Server environment
Module 2: Data ModellingThis module details various data modelling approaches.Lessons
- Principles of data modelling
- The ANSI/SPARC database model
- Entity-relationship modelling
Module 3: NormalizationThis module examines techniques for normalization and denormalization.Lessons
- Basic principles of Normalization
- Normal forms
- Concepts of Denormalization
Module 4: RelationshipsThis module explores relationship types and their influence on database architecture.Lessons
- Understanding relationships in databases
- Ensuring referential integrity in planning
Module 5: PerformanceThis module investigates how database design impacts system performance.Lessons
- Indexing strategies
- Optimizing query performance
- Handling concurrency
Module 6: Database ObjectsThis module introduces the common objects used within database systems.Lessons
- Working with Tables
- Utilizing Views
- Managing 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.
