Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

MOD+DMOC: Introduction to SQL Databases (M10985)

Learn fundamental database concepts for Microsoft SQL Server 2016.

GK# 4941

Course Overview

TOP

In this course, you will learn fundamental database concepts for Microsoft SQL Server 2016, including database types, database languages and database designs.

This course incorporates material from the Official Microsoft Learning Product 10985: Introduction to SQL Databases.

Microsoft Official Course On-Demand (MOD) plus digital Microsoft Official Courseware (dMOC) includes three months, 24x7 access to:

  • HD-quality streaming videos that adapt to your connection speed and device
  • Hands-on live labs with integrated lab steps and ability to save and resume labs
  • Knowledge checks for comprehensive assessments
  • 24x7 mentoring via chat, email, and phone
  • Digital Microsoft Official Courseware (dMOC); forever available in your Skillpipe Library when activated

Redeem three SATVs for an individual On-Demand course plus digital Microsoft Official Courseware (dMOC). For more information on Microsoft SATVs click here.

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP
  • Key database concepts in the context of SQL Server 2016
  • Database languages used in SQL Server 2016
  • Data modeling techniques
  • Normalization and denormalization techniques
  • Relationship types and effects in database design
  • Effects of database design on performance
  • Commonly used database objects

Outline

TOP
Viewing outline for:

On-Demand Outline

1. Introduction to Databases

• Relational databases
• Other types of databases
• Data analysis
• Database languages

2. Data Modeling

• ANSI/SPARC database model
• Entity relationship modeling

3. Normalization

• Normal Form
• Denormalization

4. Relationships

• Introduction to relationships
• Planning referential integrity

5. Performance

• Indexing
• Query performance
• Concurrency

6. Database Objects

• Tables
• Views
• Stored procedures, triggers and functions

Labs

TOP
Viewing labs for:

On-Demand Labs

Lab 1: Querying SQL Server
Lab 2: Identify components in entity relationship modeling
Lab 3: Normalizing data
Lab 4: Planning and implementing referential integrity
Lab 5: Performance issues
Lab 6: Using SQL Server

Prerequisites

TOP

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

Who Should Attend

TOP
  • The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies.

Vendor Credits

TOP

SATV Redemption

Redeeming your Microsoft Software Assurance Training Vouchers:

  • 3 Day SATV for an individual On-Demand course

Follow-On Courses

TOP

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

Training Exclusives

This course comes with three months, 24x7 access to: 

  • HD-quality streaming videos that adapt to your connection speed and device
  • Hands-on live labs with integrated lab steps and ability to save and resume labs
  • Knowledge checks for comprehensive assessments
  • 24x7 mentoring via chat, email and phone
  • Digital Microsoft Official Courseware (dMOC)
Course Delivery

This course is available in the following formats:

On-Demand

Train at your own pace with 24/7 access to courses that help you acquire must-have technology skills.

Duration: 13 hours

Request this course in a different delivery format.
Enroll