SQL Server 2016 /2017: Introduction aux bases de données | ||
| Langue : FR | Référence : 10985 | Durée : 3 jours |
| Lieu : Bertrange | Prix : 1 350.00 € (Euro) | |
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
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
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.