MOC 10985 - Introduction to SQL Databases

Customized Onsite Training

3
Days
  • Customized Content
  • For Groups of 5+
  • Online or On-location
  • Expert Instructors

Live Online Training

$1,425.00
or 3 vouchers
  • Live Online Training
  • Expert Instructors
  • Guaranteed to Run
  • 100% Free Re-take Option
  • 1-minute Video

Upcoming Classes

  • See More Classes

Please select a class.
Overview

This Introduction to SQL Databases training class 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.

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

Goals
  1. Learn to describe key database concepts in the context of SQL Server 2016.
  2. Learn to describe database languages used in SQL Server 2016.
  3. Learn to describe data modelling techniques.
  4. Learn to describe normalization and denormalization techniques.
  5. Learn to describe relationship types and effects in database design.
  6. Learn to describe the effects of database design on performance.
  7. Learn to describe commonly used database objects.
Outline
  1. Introduction to databases
    1. Introduction to relational databases
    2. Other types of database
    3. Data analysis
    4. Database languages
    5. Lab: Querying SQL Server
  2. Data Modelling
    1. Data modelling
    2. ANSI/SPARC database model
    3. Entity relationship modelling
    4. Lab: Entity relationship modelling. After completing this module, you will be able to:
      1. Understand the common data modelling techniques
      2. Describe the ANSI/SPARC database model
      3. Describe entity relationship modelling
  3. Normalization
    1. Why normalize data?
    2. Normalization terms
    3. Levels of normalization
    4. Denormalization
    5. Lab: Normalizing raw data
  4. Relationships
    1. Schema mapping
    2. Referential integrity
    3. Lab: Designing relationships
  5. Performance
    1. Indexing
    2. Query performance
    3. Concurrency
    4. Lab: Query performance
  6. Database Objects
    1. Tables
    2. Views
    3. Stored procedures
    4. Other database objects
    5. Lab: Using SQL Server in a hybrid cloud
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this SQL Server class:

  • This is a foundation level course and therefore only requires general computer literacy.
Preparing for Class

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

74,839

Students who have taken Live Online Training

15,233

Organizations who trust Webucator for their training needs

100%

Satisfaction guarantee and retake option

9.41

Students rated our trainers 9.41 out of 10 based on 5,189 reviews

Contact Us or call 1-877-932-8228