Available 24/7
Professional Instruction
Free Training Materials
Course Details
The Introduction to SQL Databases - 10985 course is a 3-day course that is designed to prepare students to move into a database professional role or for those whose job role is expanding to encompass database elements. The course discusses fundamental database concepts such as database types, database languages, and database designs.
Topics covered in the course include:
- Describing key database concepts in the context of SQL Server 2016
- Describing database languages used in SQL Server 2016
- Describing data modelling techniques
- Describing normalization and denormalization techniques
- Describing relationship types and effects in database design
- Describing the effects of database design on performance
- Describing commonly used database objects
Target Student:This course is designed for students that are moving into a database role, or whose role has expanded to include database technologies.
Section 1: Introduction to databases
This section covers key database concepts in the context of SQL Server 2016.
Topics
Introduction to relational databases
Other types of database
Data analysis
Database languages
Lab : Querying SQ Server
Section 2: Data Modelling
This section discusses data modelling techniques.
Topics
Data modelling
ANSI/SPARC database model
Entity relationship modelling
Lab : Entity relationship modelling
Section 3: Normalization
This section discusses normalization and denormalization techniques.
Topics
Why normalize data?
Normalization terms
Levels of normalization
Denormalization
Lab : Normalizing raw data
Section 4: Relationships
This section discusses relationship types and effects in database design.
Topics
Schema mapping
Referential integrity
Lab : Designing relationships
Section 5: Performance
This section discusses the effects of database design on performance.
Topics
Indexing
Query performance
Concurrency
Lab : Query performance
Section 6: Database Objects
This section introduces commonly used database objects.
Topics
Tables
Views
Stored procedures
Other database objects
Lab : Using SQL Server in a hybrid cloud
Please check the course description to find prerequisite information.
MOC On-Demand: 10985-Introduction to SQL Databases
On-Demand Training Course
90/month licence
- 24/7 Access
- Hands-On Practice Exercises
- Free Repeats
- Professional Instruction
Testimonials
This was the class I needed.
The instructor Jeff took his time and made sure we understood each topic before moving to the next. He answered all of our questions, and I don't know about the rest of the students, but was very pleased with this experience.
I finally understand how to use Excel.
-Amanda T (Yale New Haven Hospital).
Great class!
We were able to cover a lot of information in one day without getting overwhelmed.
-Maria R (Microsoft).
Free Repeats
Learn At Your Pace
No Travel
Professional Instruction
Affordable Pricing
Group Discounts
