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

76,130

Students who have taken Live Online Training

15,315

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

This course covered all of the important aspects of the CAPM exam and I feel very prepared to take the test!

Jake Rumanek, ASRT
Albuquerque NM

I very much enjoyed my Excel 3 class. I learned a lot, and will recommend this to other members of my company as I thought it was very informative and a much better use of time and money than many live in-person Microsoft Suite classes that I have attended.

Elyse Castillo, Entertainment Cruises
Baltimore MD

Instructor was very knowledgeable in all aspects of the application. It was a pleasure to learn.

Bryan Lerch, State of CT Dept of Children and Families
Hartford CT

I was completely starting from scratch when learning SQL. Great, patient instructor.

Alex Mathew, GuideStone Financial Resources
Wylie TX

Contact Us or call 1-877-932-8228