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

lun24apr(apr 24)09:00mer26(apr 26)17:00VirtuelVirtual Etiquettes de session55315AC

lun24apr(apr 24)09:00mer26(apr 26)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de session55315AC

lun29may(may 29)09:00mer31(may 31)17:00VirtuelVirtual Etiquettes de session55315AC

lun29may(may 29)09:00mer31(may 31)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de session55315AC

lun03jul(jul 3)09:00mer05(jul 5)17:00VirtuelVirtual Etiquettes de session55315AC

lun03jul(jul 3)09:00mer05(jul 5)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de session55315AC

lun07aug(aug 7)09:00mer09(aug 9)17:00VirtuelVirtual Etiquettes de session55315AC

lun07aug(aug 7)09:00mer09(aug 9)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de session55315AC

lun11sep(sep 11)09:00mer13(sep 13)17:00VirtuelVirtual Etiquettes de session55315AC

lun11sep(sep 11)09:00mer13(sep 13)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de session55315AC

lun16oct(oct 16)09:00mer18(oct 18)17:00VirtuelVirtual Etiquettes de session55315AC

lun16oct(oct 16)09:00mer18(oct 18)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de session55315AC

lun20nov(nov 20)09:00mer22(nov 22)17:00VirtuelVirtual Etiquettes de session55315AC

lun20nov(nov 20)09:00mer22(nov 22)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de session55315AC

mer27dec(dec 27)09:00ven29(dec 29)17:00VirtuelVirtual Etiquettes de session55315AC

mer27dec(dec 27)09:00ven29(dec 29)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