MY ACCOUNT

IT Pro

>

MS Office

>

Management

>

Multimedia

>

Development

>

Collaborative tools

>

Soft skills

>

Digital Marketing

>

ALL TRAININGS

Training: Introduction to SQL Databases

Ref. 55315AC

Download PDF

Duration:
3
 days
Exam:
Not certifying
Level:
Fundamental
Funding:
Temptraining

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

lun16Oct(Oct 16)09:00mer18(Oct 18)17:00Virtuel 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:00Virtuel Etiquettes de session55315AC

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

lun25Déc(Déc 25)09:00mer27(Déc 27)17:00Virtuel Etiquettes de session55315AC

lun25Déc(Déc 25)09:00mer27(Déc 27)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de session55315AC

lun29Jan(Jan 29)09:00mer31(Jan 31)17:00Virtuel Etiquettes de session55315AC

lun29Jan(Jan 29)09:00mer31(Jan 31)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de session55315AC

lun04Mar(Mar 4)09:00mer06(Mar 6)17:00Virtuel Etiquettes de session55315AC

lun04Mar(Mar 4)09:00mer06(Mar 6)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de session55315AC

lun08Avr(Avr 8)09:00mer10(Avr 10)17:00Virtuel 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:00Virtuel 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:00Virtuel 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:00Virtuel 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:00Virtuel 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:00Virtuel 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:00Virtuel 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:00Virtuel 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

  • ITTA
    Route des jeunes 33 Bis, Entrée B,
    1227 Carouge, Suisse

Horaires d’ouverture

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

Contactez-nous

  • ITTA
    Route des jeunes 33 Bis, Entrée B,
    1227 Carouge, Suisse

Votre demande

Opening hours

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

Contact us

  • ITTA
    Route des jeunes 33B,
    1227 Carouge, Suisse

Your request

X
X
X
X