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
  21 Hours

Testimonials (8)

Related Courses

Related Categories