Course Outline
Module 1: Introduction to databases This module presents fundamental database concepts within the environment of SQL Server 2016.Lessons
- Overview of relational databases
- Alternative database types
- Data analysis
- Database languages in SQL Server
Module 2: Data Modelling This module examines various data modelling techniques.Lessons
- Data modelling principles
- ANSI/SPARC database model
- Entity relationship modelling
Module 3: Normalization This module covers the principles of normalization and denormalization.Lessons
- Core concepts of Normalization
- Normal form
- Denormalization
Module 4: Relationships This module explores the types of relationships and their specific impacts on database design.Lessons
- Foundations of relationships
- Planning referential integrity
Module 5: Performance This module highlights how database design choices affect overall performance.Lessons
- Indexing
- Query performance
- Concurrency
Module 6: Database Objects This module introduces standard database objects and their applications.Lessons
- Tables
- Views
- Stored procedures, triggers, and functions
Testimonials (4)
The basic structure of Power BI, its main functions, as well as some advanced functions
Alessandro Binaghi - Great Place to Work(R) Institute Italia Srl
Course - PL-300: Microsoft Power BI Data Analyst
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
