MOC 10985 - Introduction to SQL Databases

  4.9 out of 5 - Read Testimonials

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 in SQL Server
    5. Lab: Exploring and querying SQL Server databases
  2. Data Modelling
    1. Data modelling
    2. ANSI/SPARC database model
    3. Entity relationship modelling
    4. Lab: Identify components in entity relationship modellingAfter 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. Fundamentals of Normalization
    2. Normal form
    3. Denormalization
    4. Lab: Normalizing data
  4. Relationships
    1. Introduction to relationships
    2. Planning referential integrity
    3. Lab: Planning and implementing referential integrity
  5. Performance
    1. Indexing
    2. Query performance
    3. Concurrency
    4. Lab: Performance issues
  6. Database Objects
    1. Tables
    2. Views
    3. Stored procedures, triggers and functions
    4. Lab: Using SQL server
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

Training for your Team

Length: 3 Days
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors

Training for Yourself

$1,425.00 or 3 vouchers

Upcoming Classes

  • See More Classes

Please select a class.
  • Live Online Training
  • For Individuals
  • Expert Instructors
  • Guaranteed to Run
  • 100% Free Re-take Option
  • 1-minute Video

What people say about our training

I thoroughly enjoyed the Excel class, which is not something one would usually expect to say, or hear, about an Excel class. The class was over before I knew it. It was very informative, perfectly paced, and my instructor was incredibly patient and knowledgeable. With all the options available these days for Excel classes, I wasn't sure about an online class. I can honestly say it was worth every penny, and I will be referring anyone and everyone that is interested in expanding their Excel skills. I will definitely be taking the Advanced class as soon as possible.
Jody Wright
Weatherford International
The XSLT 2 and XPath 2 class was excellent - I'd happily recommend the class to others.
Patrick Quinlan
Citrix Systems
Great refresher course for someone that has not used Excel in many years.
Kathy Rawlings
Edwin JonesCo
A very effective customer service training class! I definitely recommend it.
Mark Stenger
YouDecide.com

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

60,501

Students who have taken Instructor-led Training

11,680

Organizations who trust Webucator for their Instructor-led 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

Contact Us or call 1-877-932-8228