$2,650
- 3-day instructor-led training course
- Microsoft Certified training
- SATV eligible
- One-on-one after course instructor coaching
- Pay later by invoice -OR- at the time of checkout by credit card
Introduction to SQL Databases Training (10985)
Course 8426
- Sandbox: Yes
- Language: English
- Level:
This official Microsoft Introduction to SQL Databases 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.
- This is a foundation level course and therefore only requires general computer literacy
- Knowledge to the level of course 2107: SQL Server introduction
- This course is eligible for Microsoft Software Assurance Training Voucher (SATV) redemption.
- Want to learn more about Microsoft SATVs? Click to view our SATVs infographic.
Introduction to SQL Databases Training (10985) Delivery Methods
- Microsoft Official Course (MOC) content
- After-course instructor coaching benefit
- Eligible to use with your Microsoft Software Assurance Training Vouchers (SATVs)
Introduction to SQL Databases Training (10985) Course Benefits
- Describe key database concepts in the context of SQL Server 2017
- Describe database languages used in SQL Server 2017
- 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
Introduction to SQL Databases Course Outline
This module introduces key database concepts in the context of SQL Server 2017.
Lessons
- Introduction to relational databases
- Other types of database
- Data analysis
- Database languages in SQL Server
Lab: Exploring and querying SQL Server databases
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
- Describe data analytics
This module describes data modelling techniques.
Lessons
- Data modelling
- ANSI/SPARC database model
- Entity relationship modelling
Lab: Identify components in entity relationship modelling
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
This module describes normalization and denormalization techniques.
Lessons
- Fundamentals of Normalization
- Normal form
- Denormalization
Lab: Normalizing data
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
This module describes relationship types and effects in database design.
Lessons
- Introduction to relationships
- Planning referential integrity
Lab: Planning and implementing referential integrity
After completing this module, you will be able to:
- Describe relationship types
- Describe the use, types, and effects of referential integrity
This module introduces the effects of database design on performance.
Lessons
- Indexing
- Query performance
- Concurrency
Lab: Performance Issues
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
This module introduces commonly used database objects.
Lessons
- Tables
- Views
- Stored procedures, triggers, and functions
Lab: Using SQL Server
After completing this module, you will be able to:
- Describe the use of tables in SQL Server
- Describe the use of views in SQL Server
- Describe the use of stored procedures in SQL Server
- Describe other database objects commonly used in SQL Server
Need Help Finding The Right Training Solution?
Our training advisors are here for you.
