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 this individual GK Digital Learning 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:

GK Digital Learning 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

• Why normalize data?
• Normalization terms
• Levels of normalization
• Denormalization

4. Relationships

• Schema mapping
• Referential integrity

5. Performance

• Indexing
• Query performance
• Concurrency

6. Database Objects

• Tables
• Views
• Stored procedures
• Other database objects

Labs

TOP
Viewing labs for:

GK Digital Learning Labs

Lab 1: Querying SQL Server
Lab 2: Entity relationship modeling
Lab 3: Normalizing raw data
Lab 4: Designing relationships
Lab 5: Query performance
Lab 6: Using SQL Server in a hybrid cloud

 

Prerequisites

TOP

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

Who Should Attend

TOP
  • Individuals moving into a database role or whose role has expanded to include database technologies

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:

GK Digital Learning

Experience high-quality online learning combined with reliable expert guidance and skills development activities.



Request this course in a different delivery format.
Enroll