MOC 10985 - Introduction to SQL Databases (MOC10985)
Course Length: 3 days
Delivery Methods:
Available as private class only
Course Overview
This Introduction to SQL Databases training class is aimed at people looking to move into a database 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 Benefits
- Learn to describe key database concepts in the context of SQL Server 2016.
- Learn to describe database languages used in SQL Server 2016.
- Learn to describe data modelling techniques.
- Learn to describe normalization and denormalization techniques.
- Learn to describe relationship types and effects in database design.
- Learn to describe the effects of database design on performance.
- Learn to describe commonly used database objects.
Microsoft Certified Partner
Webucator is a Microsoft Certified Partner for Learning Solutions (CPLS). This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).
Course Outline
- Introduction to Databases
- Introduction to relational databases
- Other types of database
- Data analysis
- Database languages in SQL Server
- Lab: Exploring and querying SQL Server databases
- Data Modelling
- Data modelling
- ANSI/SPARC database model
- Entity relationship modelling
- Lab: Identify components in entity relationship modellingAfter completing this module, you will be able to:
- • Understand the common data modelling techniques
- • Describe the ANSI/SPARC database model
- • Describe entity relationship modelling
- Normalization
- Fundamentals of Normalization
- Normal form
- Denormalization
- Lab: Normalizing data
- Relationships
- Introduction to relationships
- Planning referential integrity
- Lab: Planning and implementing referential integrity
- Performance
- Indexing
- Query performance
- Concurrency
- Lab: Performance issues
- Database Objects
- Tables
- Views
- Stored procedures, triggers and functions
- Lab: Using SQL server
Class Materials
Each student will receive a comprehensive set of materials, including course notes and all the class examples.
Class Prerequisites
Experience in the following is required for this Microsoft SQL Server class:
- This is a foundation level course and therefore only requires general computer literacy.