Course Outline
Module 1: Introduction to databasesThis module introduces key database concepts in the context of SQL Server 2016.Lessons
- Introduction to relational databases
- Other types of database
- Data analysis
- Database languages in SQL Server
Module 2: Data ModellingThis module describes data modelling techniques.Lessons
- Data modelling
- ANSI/SPARC database model
- Entity relationship modelling
Module 3: NormalizationThis module describes normalization and denormalization techniques.Lessons
- Fundamentals of Normalization
- Normal form
- Denormalization
Module 4: RelationshipsThis module describes relationship types and effects in database design.Lessons
- Introduction to relationships
- Planning referential integrity
Module 5: PerformanceThis module introduces the effects of database design on performance.Lessons
- Indexing
- Query performance
- Concurrency
Module 6: Database ObjectsThis module introduces commonly 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.
