55315: Introduction to SQL Databases
E-Learning
Description
This course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management. Students will learn fundamental database concepts through demonstrations and hands-on labs on a SQL Server instance. This material updates and replaces course Microsoft course 10985 which was previously published under the same title.
This course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management. Students will learn fundamental database concepts through demonstrations and hands-on labs on a SQL Server instance.
This material updates and replaces course Microsoft course 10985 which was previously published under the same title.
After completing this course, you will be able to:
Describe key database concepts in the context of SQL Server
Describe database languages used in SQL Server
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
The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material.
| Lesson Id | Title | Description |
|---|---|---|
| 1 | Module 1: Introduction to databases |
Introduction to Relational Databases Other Databases and Storage Data Analysis SQL Server Database Languages |
| 2 | Module 2: Data Modeling |
Data Modelling Designing a Database Relationship Modeling |
| 3 | Module 3: Normalization |
Fundamentals of Normalization Normal Form Denormalization |
| 4 | Module 4: Relationships |
Introduction to Relationships Planning Referential Integrity |
| 5 | Module 5: Performance |
Indexing Query Performance Concurrency |
| 6 | Module 6: Database Objects |
Tables Views Stored Procedures, Triggers and Functions |
Self-Paced
Free
This course includes: :
Full lifetime access