10985 – Introdution to SQL Databases

Braga
01 Out 2018
a 03 Out 2018
Laboral

09h30 - 17h30

Chat

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.

 

Objectives

  • 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

Destinatários

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

Pré-Requisitos

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

Programa

  • Introduction to databases
  • Data Modelling
  • Normalization
  • Relationships
  • Performance
  • Database ObjectsThis module introduces commonly used database objects.

Module 1: Introduction to databases
This 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

Lab : Querying SQL Server

Module 2: Data Modelling
This module describes data modelling techniques.

Lessons

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

Lab : Entity relationship modelling

Module 3: Normalization
This module describes normalization and denormalization techniques.

Lessons

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

Lab : Normalizing raw data

Module 4: Relationships
This module describes relationship types and effects in database design.

Lessons

  • Schema mapping
  • Referential integrity

Lab : Designing relationships

Module 5: Performance
This module introduces the effects of database design on performance.

Lessons

  • Indexing
  • Query performance
  • Concurrency

Lab : Query performance

Module 6: Database Objects

This module introduces commonly used database objects.

Lessons

  • Tables
  • Views
  • Stored procedures
  • Other database objects

Lab : Using SQL Server in a hybrid cloud

Chat

Quero saber mais informações sobre este curso

10985 – Introdution to SQL Databases

Base de Dados | 18h - Laboral: 09h30 - 17h30


Notas

Pretende mais informação sobre este curso?

Preencha o formulário com os seus dados e as suas questões e entraremos em contacto consigo para lhe darmos todas as informações pretendidas.

Obrigado!