Description

This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs.

Consists off

  • 3 months access to e-learning materials
  • 3 months access to training labs

Prerequisites

This is a foundation level course and therefore only requires general computer literacy.

Course outcome

After completing this course, students will be able to:
  • Describe key database concepts in the context of SQL Server 2016
  • Describe database languages used in SQL Server 2016
  • Describe data modelling techniques
  • Describe normalization and denormalization techniques
  • Describe relationship types and effects in database design
  • Describe the effects of database design on performance
  • Describe commonly used database objects

Who should attend

The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies.

Module overview

  • Module 1: Introduction to databases
    • Lab : Exploring and querying SQL Server databases
  • Module 2: Data Modelling
    • Lab : Identify components in entity relationship modelling
  • Module 3: Normalization
    • Lab : Normalizing data
  • Module 4: Relationships
    • Lab : Planning and implementing referential integrity
  • Module 5: Performance
    • Lab : Performance issues
  • Module 6: Database Objects
    • Lab : Using SQL server

OD10985CC

 398,00
Offerte aanvragen