Introduction to SQL Databases (10985CC) Certificate for Mateusz Dytry
Certificate ID:
649375
Authentication Code:
84321
Certified Person Name:
Mateusz Dytry
Trainer Name:
Paweł Skrzypiec
Duration Days:
3
Duration Hours:
21
Course Name:
Introduction to SQL Databases (10985CC)
Course Date:
20 September 2021 09:00 to 22 September 2021 16:00
Venue:
Lubliniec
Course Outline:
Module 1: Introduction to databasesThis module introduces key database concepts in the context of SQL Server 2016.Lessons
- Introduction to relational databases
- Other types of database
- Data analysis
- Database languages in SQL Server
Module 2: Data ModellingThis module describes data modelling techniques.Lessons
- Data modelling
- ANSI/SPARC database model
- Entity relationship modelling
Module 3: NormalizationThis module describes normalization and denormalization techniques.Lessons
- Fundamentals of Normalization
- Normal form
- Denormalization
Module 4: RelationshipsThis module describes relationship types and effects in database design.Lessons
- Introduction to relationships
- Planning referential integrity
Module 5: PerformanceThis module introduces the effects of database design on performance.Lessons
- Indexing
- Query performance
- Concurrency
Module 6: Database ObjectsThis module introduces commonly used database objects.Lessons
- Tables
- Views
- Stored procedures, triggers and functions