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
  • 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

78,645

Students who have taken Live Online Training

15,450

Organizations who trust Webucator for their training needs

100%

Satisfaction guarantee and retake option

9.90

Students rated our MOC 10985 - Introduction to SQL Databases trainers 9.90 out of 10 based on 11 reviews

Was not expecting to learn much from this. However, the instructor provided tips and examples that we didn't know. I was so glad I took this class.

Gregory Galicia, United States Postal Service (USPS)

Comfortable class pace with a wide range of content that I know I will be applying within my developer role.

Bruce Symanowicz, Union Pacific Railroad

Great class! Learned a lot and had fun!

Lisa Pirone, SSA
Baltimore MD

This training was clear, step by step, easy to manage and understand. Instructor was very good about going back through steps to help me catch up when needed. The materials given were the best I have ever had!!! I feel very comfortable with going back on the job and using what I have learned.

Shanna Zanolini, VCBH QI
Ventura CA

Contact Us or call 1-877-932-8228