Course Outline
Module 1: Introduction to databasesThis module presents essential database concepts within the context of SQL Server 2016.Lessons
- Overview of relational databases
- Alternative database types
- Data analysis fundamentals
- Database languages within SQL Server
Module 2: Data ModellingThis module covers various data modelling techniques.Lessons
- Principles of data modelling
- The ANSI/SPARC database model
- Entity-relationship modelling
Module 3: NormalizationThis module examines normalization and denormalization methods.Lessons
- Basics of Normalization
- Normal forms
- Denormalization practices
Module 4: RelationshipsThis module details relationship types and their consequences in database design.Lessons
- Understanding relationships
- Establishing referential integrity
Module 5: PerformanceThis module highlights the impact of database design on overall performance.Lessons
- Indexing strategies
- Optimizing query performance
- Managing concurrency
Module 6: Database ObjectsThis module introduces frequently used database objects.Lessons
- Managing tables
- Working with 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
