SQL Server 2016 /2017: Introduction aux bases de données

Langue : FRRéférence : 10985Durée : 3 jours
Lieu : Esch/AlzettePrix : 1 350.00 € (Euro)
Nos Dates :

  Cliquez sur une date pour vous pré-inscrire

Objectifs :

After completing this course, students will be able to:
• 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

Contenu :

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.

Course Outline:

Module 1: Introduction to databases
This module introduces key database concepts in the context of SQL Server 2016.

After completing this module, you will be able to:
• Describe what a database is
• Understand basic relational aspects
• Describe database languages used in SQL Server 2016
• Describe data analytics
• Describe database languages used in SQL Server 2016

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

After completing this module, you will be able to:
• Understand the common data modelling techniques
• Describe the ANSI/SPARC database model
• Describe entity relationship modelling

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

After completing this module, you will be able to:
• Describe normalization benefits and notation
• Describe important normalization terms
• Describe the normalization levels
• Describe the role of denormalization

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

After completing this module, you will be able to:
• Describe relationship types
• Describe the use, types, and effects of referential integrity

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

After completing this module, you will be able to:
• Discuss the performance effects of indexing
• Describe the performance effects of join and search types
• Describe the performance effects of concurrency

Module 6: Database Objects
This module introduces commonly used database objects.

After completing this module, you will be able to:
• Describe the use of tables in SQL Server 2016
• Describe the use of views in SQL Server 2016
• Describe the use of stored procedures in SQL Server 2016
• Describe other database objects commonly used in SQL Server 2016

Pré-requis :

Prerequisites:

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

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.

Telindus Training Institute utilise des cookies pour améliorer l'expérience client et l'utilisation de son site. En continuant à surfer sur training.telindus.lu, vous acceptez les conditions d’utilisation de ces cookies.