Autoryzowane szkolenia MicrosoftMS 55352
Introduction to SQL Databases

ATTENTION! Training withdrawn from the offer.

To get updated information about trainings, please contact our consultant: szkolenia@dagma.pl or 800 080 322.

About this course


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.

Audience profile:

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

Skills gained:

  • Describe key database concepts in the context of SQL Server
  • Describe database languages used in SQL Server
  • 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

Prerequisites:

  • This is a foundation level course and therefore only requires general computer literacy.Experience working from a command prompt

Course Outline

Module 1: Introduction to databases

  • Introduction to relational databases
  • Other types of database
  • Data analysis
  • Database languages

Lab 1: Querying SQL Servers

Module 2: Data Modelling

  • Data modelling
  • ANSI/SPARC database model
  • Entity relationship modelling

Lab 1: Entity relationship modelling

Module 3: Normalization

  • Why normalize data?
  • Normalization terms
  • Levels of normalization
  • Denormalization

Lab 1: Normalizing raw data

Module 4: Relationships

  • Schema mapping
  • Referential integrity

Lab 1: Designing relationships

Module 5: Performance

  • Indexing
  • Query performance
  • Concurrency

Lab 1: Query performance

Module 6: Database Objects

  • Tables
  • Views
  • Stored procedures
  • Other database objects

Lab 1: Using SQL Server in a hybrid cloud

CLOSEST DATES:

Call Us: +48 800 080 322

TRAINING DURATION

3 d x 8 h (Total 24 h)

Do you have any questions?
Do you need more information?
Do you want to pre-book the place?

Call Us!
+48 32 259 11 80