Course Outline
Module 1: Introduction to databasesThis module provides an overview of key database concepts in the context of SQL Server 2016.Lessons
- Overview of relational databases
- Other database types
- Data analysis
- Database languages in SQL Server
Module 2: Data ModellingThis module explores data modeling techniques.Lessons
- Data modeling
- ANSI/SPARC database model
- Entity relationship modeling
Module 3: NormalizationThis module covers normalization and denormalization techniques.Lessons
- Normalization fundamentals
- Normal forms
- Denormalization
Module 4: RelationshipsThis module examines relationship types and their implications in database design.Lessons
- Introduction to relationships
- Planning for referential integrity
Module 5: PerformanceThis module highlights how database design influences performance.Lessons
- Indexing
- Query performance
- Concurrency
Module 6: Database ObjectsThis module introduces frequently used database objects.Lessons
- Tables
- Views
- Stored procedures, triggers, and functions
Testimonials (3)
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.
James - Shawnee Mission School District
Course - Administering in Microsoft SQL Server
Being human and talking to us as understandable possible
Sorin
Course - Database Administration Fundamentals for MS SQL Server
Lot of content and exactly the requested one.
