Course Outline
Module 1: Database FundamentalsThis module establishes key database concepts within the SQL Server 2016 environment.Lessons
- Relational databases: An introduction
- Alternative database types
- Data analysis
- SQL Server database languages
Module 2: Data ModellingThis module outlines techniques for effective data modelling.Lessons
- Concepts of data modelling
- The ANSI/SPARC database model
- Entity-relationship modelling
Module 3: NormalizationThis module examines techniques for both normalization and denormalization.Lessons
- Normalization basics
- Normal forms
- Denormalization
Module 4: RelationshipsThis module details the types of relationships and their effects on database design.Lessons
- Understanding relationships
- Implementing referential integrity
Module 5: PerformanceThis module explores how database design impacts system performance.Lessons
- Indexing strategies
- Optimizing query performance
- Concurrency management
Module 6: Database ObjectsThis module presents an overview of commonly used database objects.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
