Curriculum
- 1 Section
- 7 Lessons
- 3 Days
Expand all sectionsCollapse all sections
- Topics7
- 1.1Module 1: Introduction to databases This module introduces key database concepts in the context of SQL Server. Lessons • Introduction to Relational Databases • Other Databases and Storage • Data Analysis • SQL Server Database Languages
- 1.2Module 2: Data Modeling This module describes data modelling techniques. Lessons • Data Modelling • Designing a Database • Relationship Modeling
- 1.3Module 3: Normalization This module describes normalization and denormalization techniques. Lessons • Fundamentals of Normalization • Normal Form • Denormalization
- 1.4Module 4: Relationships This module describes relationship types and effects in database design. Lessons • Introduction to Relationships • Planning Referential Integrity
- 1.5Module 5: Performance This module introduces the effects of database design on performance. Lessons • Indexing • Query Performance • Concurrency
- 1.6Module 6: Database Objects This module introduces commonly used database objects. Lessons • Tables • Views • Stored Procedures, Triggers and Functions
- 1.7Classroom Live Labs Lab: Exploring SQL Server Databases and Tables • Explore SQL Server • Query Databases and Tables Lab: Identify Components in Relationship Modeling • Modeling a database Lab: Normalizing Data • Normalizing Tables Lab: Planning and Implementing Referential Integrity • Implementing Referential Integrity Lab: Performance Issues • Using Indexes Lab: Using SQL Server Objects • Using Tables • Using Views • Using Stored Procedures
Module 2: Data Modeling This module describes data modelling techniques. Lessons • Data Modelling • Designing a Database • Relationship Modeling
Prev
Module 4: Relationships This module describes relationship types and effects in database design. Lessons • Introduction to Relationships • Planning Referential Integrity
Next