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.

starstarstarstarstar_half

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

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

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

Audience

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.

Language

English

Prerequisites

This is a foundation level course and therefore only requires general computer literacy.

$1,785

Length: 3.0 days (24 hours)

Level:

Not Your Location? Change

Course Schedule:

Schedule select
16
Oct
Monday
8:00 AM PT -
4:00 PM PT
Available
Schedule select
29
Nov
Wednesday
9:00 AM ET -
5:00 PM ET
Available
Schedule select
08
Jan
Monday
9:00 AM ET -
5:00 PM ET
Available
Schedule select
28
Feb
Wednesday
9:00 AM ET -
5:00 PM ET
Available
Schedule select
15
Apr
Monday
8:00 AM PT -
4:00 PM PT
Available
Loading...