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.
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.
This is a foundation level course and therefore only requires general computer literacy.
Introduction to Relational Databases
Other Databases and Storage
Data Analysis
SQL Server Database Languages
Data Modelling
Designing a Database
Relationship Modeling
Fundamentals of Normalization
Normal Form
Denormalization
Introduction to Relationships
Planning Referential Integrity
Indexing
Query Performance
Concurrency
Tables
Views
Stored Procedures, Triggers and Functions
This course is intended for IT professionals who need to learn how to use SSIS to build, deploy, maintain, and secure Integration Services projects and packages, and to use SSIS to extract, transform, and load data to and from SQL Server. This course is similar to the retired ...