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:

    $

Introduction to SQL Databases (M10985)

Learn fundamental database concepts for Microsoft SQL Server 2016.

GK# 4393 Vendor# M10985

$1245 - $2295 CAD

Enroll Request Group Training

Course Overview

TOP

This course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs. Note:

  • Redeem three SATVs* for a Classroom, Virtual Classroom, or Virtual Classroom Fit session
  • Redeem three SATVs for an individual GK Digital Learning course plus digital Microsoft Official Courseware (dMOC)
  • Redeem two SATVs for an individual GK Digital Learning course

 

*For more information on Microsoft SATVs, click here.

 
This course is also available in the On-Demand delivery format with digital Microsoft Official Courseware (dMOC). Click here to purchase.

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:

Classroom Live Outline

1. Introduction to Databases

  • Relational databases
  • Other types of databases
  • Data analysis
  • Database languages in SQL Server

2. Data Modeling

  • Data modeling
  • ANSI/SPARC database model
  • Entity relationship modeling

3. Normalization

  • Fundamentals of Normalization
  • Normal from
  • 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:

Classroom Live Labs

Lab 1: Exploring and querying SQL Server databases
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
  • Individuals 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:

  • Redeem five SATVs for a Classroom Live or Virtual Classroom Live session
  • Redeem five SATVs for an individual On-Demand course plus digital Microsoft Official Courseware (dMOC)
  • Redeem two SATVs for an individual On-Demand course

For more information on Microsoft SATVs, click here.

Follow-On Courses

TOP
Training Exclusives

This course comes with 12 months access to the following benefits:

  • Practice Labs
  • 24x7 Mentoring
  • Indexed Class Recordings
  • Unlimited Retakes
  • Digital Courseware
Find out more
Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 3 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 3 day

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