Training: Introduction to SQL Databases

Ref. 55315AC
Duration:
3
 days
Exam:
Not certifying
Level:
Fundamental

Description

This 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.

Participant profiles

  • People who are moving into a database role, or whose role has expanded to include database technologies
  • Developers that deliver content from SQL Server databases will also benefit from this material

Objectives

  • 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

  • No prerequisites

Course content

Module 1: Introduction to databases

  • Introduction to Relational Databases
  • Other Databases and Storage
  • Data Analysis
  • SQL Server Database Languages

Module 2: Data Modeling

  • Data Modelling
  • Designing a Database
  • Relationship Modeling

Module 3: Normalization

  • Fundamentals of Normalization
  • Normal Form
  • Denormalization

Module 4: Relationships

  • Introduction to Relationships
  • Planning Referential Integrity

Module 5: Performance

  • Indexing
  • Query Performance
  • Concurrency

Module 6: Database Objects

  • Tables
  • Views
  • Stored Procedures, Triggers and Functions

Documentation

  • Digital courseware included

Lab / Exercises

  • Online Labs

Complementary courses

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.
Prix de l'inscription
CHF 2'350.-
Inclus dans ce cours
  • Training provided by a certified trainer
  • 180 days of access to Microsoft labs
  • Documentation in digital format
  • Achievement badge

lun08Avr(Avr 8)09:00mer10(Avr 10)17:00VirtuelVirtual Etiquettes de session55315AC

lun08Avr(Avr 8)09:00mer10(Avr 10)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de session55315AC

lun13Mai(Mai 13)09:00mer15(Mai 15)17:00VirtuelVirtual Etiquettes de session55315AC

lun13Mai(Mai 13)09:00mer15(Mai 15)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de session55315AC

lun17Juin(Juin 17)09:00mer19(Juin 19)17:00VirtuelVirtual Etiquettes de session55315AC

lun17Juin(Juin 17)09:00mer19(Juin 19)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de session55315AC

lun22juil(juil 22)09:00mer24(juil 24)17:00VirtuelVirtual Etiquettes de session55315AC

lun22juil(juil 22)09:00mer24(juil 24)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de session55315AC

lun26Aoû(Aoû 26)09:00mer28(Aoû 28)17:00VirtuelVirtual Etiquettes de session55315AC

lun26Aoû(Aoû 26)09:00mer28(Aoû 28)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de session55315AC

lun30Sep(Sep 30)09:00mer02Oct(Oct 2)17:00VirtuelVirtual Etiquettes de session55315AC

lun30Sep(Sep 30)09:00mer02Oct(Oct 2)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de session55315AC

lun04Nov(Nov 4)09:00mer06(Nov 6)17:00VirtuelVirtual Etiquettes de session55315AC

lun04Nov(Nov 4)09:00mer06(Nov 6)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de session55315AC

lun09Déc(Déc 9)09:00mer11(Déc 11)17:00VirtuelVirtual Etiquettes de session55315AC

lun09Déc(Déc 9)09:00mer11(Déc 11)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de session55315AC

Horaires d’ouverture

Du lundi au vendredi, de 8:30 à 18:00.

Contactez-nous

Votre demande

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request

X
X
X
X