55315: Introduction to SQL Databases
In this course you will describe key database concepts in the context of SQL Server, characterize database languages used in SQL Server, describe data modeling techniques, discuss normalization and denormalization techniques, distinguish relationship types and effects in database design, describe the effects of database design on performance, and define commonly used database objects.
Description
The 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 course updates and replaces course 10985C previously published under the same title.
Course Content
Module 1: Introduction to databases
- Introduction to Relational Databases
- Other Databases and Storage
- Data Analysis
- SQL Server Database Languages
Module 2: Data Modeling
- Data Modelling
- Designing a Database
- Relationship Modeling
Module 3: Normalization
- Fundamentals of Normalization
- Normal Form
- Denormalization
Module 4: Relationships
- Introduction to Relationships
- Planning Referential Integrity
Module 5: Performance
- Indexing
- Query Performance
- Concurrency
Module 6: Database Objects
- Tables
- Views
- Stored Procedures, Triggers and Functions
Prerequisites
This is a foundation level course and therefore only requires general computer literacy.