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,206

Students who have taken Live Online Training

15,320

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

I cannot imagine anyone being more knowledgeable than my instructor on this class...it was like she had written the very programs that she was instructing me on! I feel like I got an entire college semester of education in just two days.

Shelby Coleman, Fresno County Federal Credit Union
Fresno CA

Thanks to Webucator I obtained a lot of knowledge on how to install and configure Project Server that will help me in the coming months. This course has made me feel more confident in my new role as an Administrator.

Andrew Logan, LCEC
North Fort Myers FL

Our instructor was exteremely knowledgeable and personable and made the experience most enjoyable.

John Hickey, Harte Hanks
San Diego CA

At the end of the course I felt as if I could immediately use the knowledge gained in a real world application and be successful.

Roseann Tracy, RJT Advantage, LLC
Ann Arbor MI

Contact Us or call 1-877-932-8228