1­-855­-778­-7246
> > 10985

Introduction to SQL Databases (10985)

 

Course Content

This three-day instructor-led course is the starting point if you are looking to move into a database professional role or if your job role is expanding to encompass database elements. You will learn fundamental database concepts including database types, database languages, and database designs.

Who should attend

IT Professionals who are moving into a database role, or whose role has expanded to include database technologies.

Prerequisites

This is a foundation level course and only requires general computer literacy.

Course Objectives

  • Learn key database concepts in the context of SQL Server 2016
  • Become familiar with database languages used in SQL Server 2016
  • Describe data modelling techniques
  • Perform normalization and denormalization techniques
  • Describe relationship types and effects in database design
  • Understand the effects of database design on performance
  • Know commonly used database objects

Outline: Introduction to SQL Databases (10985)

Module 1: Introduction to Databases

  • Introduction to relational databases
  • Other types of database
  • Data analysis
  • Database languages

Module 2: Data Modelling

  • Data modelling
  • ANSI/SPARC database model
  • Entity relationship modelling

Module 3: Normalization

  • Why normalize data?
  • Normalization terms
  • Levels of normalization
  • Denormalization

Module 4: Relationships

  • Schema mapping
  • Referential integrity

Module 5: Performance

  • Indexing
  • Query performance
  • Concurrency

Module 6: Database Objects

  • Tables
  • Views
  • Stored procedures
  • Other database objects

Labs

  • Querying SQL Server
  • Entity relationship modelling
  • Normalizing raw data
  • Designing relationships
  • Query performance
  • Using SQL Server in a hybrid cloud
Classroom Training

Duration 3 days

Price
  • United States: US$ 1,795
  • SA Voucher: 3
    hardcoded default SA
Online Training

Duration 3 days

Price
  • United States: US$ 1,795
  • SA Voucher: 3
    hardcoded default SA
E-Learning MOC on Demand

Duration 90 days

Price
  • United States: US$ 995
Buy E-Learning
 
Click City Name To Book Schedule
This is an Instructor-Led Classroom course
This is an Instructor-Led Online (ILO) course. These sessions are conducted via WebEx in a VoIP environment and require an Internet Connection and headset with microphone connected to your computer or laptop.
This is a FLEX course, which is delivered simultaneously in two modalities. Choose to attend the Instructor-Led Online (ILO) virtual session or Instructor-Led Classroom (ILT) session.
  *   This class is delivered by a partner.
United States
Dec 16-18, 2019 This is a FLEX event Live Online Training 08:00 US/Pacific * Enroll
Online Training Time zone: US/Pacific Enroll
Dec 16-18, 2019 Online Training 08:00 US/Pacific * Enroll
Jan 6-8, 2020 This is a FLEX event Live Online Training 06:00 US/Pacific * Enroll
Online Training Time zone: US/Pacific Enroll

Fast Lane Flex™ Classroom If you can't find a suitable date, don't forget to check our world-wide FLEX™ training schedule.

Europe
Germany
Jan 27-29, 2020 Berlin Enroll
Feb 24-26, 2020 Stuttgart Enroll
Mar 23-25, 2020 Hamburg Enroll
Apr 6-8, 2020 Munich Enroll
May 18-20, 2020 Berlin Enroll
Jun 15-17, 2020 Münster Enroll
Jul 13-15, 2020 Düsseldorf Enroll
Aug 17-19, 2020 Berlin Enroll
Sep 28-30, 2020 Stuttgart Enroll
Nov 9-11, 2020 Hamburg Enroll
France
Feb 3-5, 2020 Paris * Enroll
May 18-20, 2020 Paris * Enroll
Nov 16-18, 2020 Paris * Enroll
Italy
Feb 24-26, 2020 Milan Enroll
Apr 20-22, 2020 Rome Enroll
Jun 22-24, 2020 Milan Enroll
Aug 31-Sep 2, 2020 Rome Enroll
Oct 19-21, 2020 Milan Enroll
Dec 14-16, 2020 Rome Enroll
Switzerland
Apr 6-8, 2020 Zurich Enroll
Sep 28-30, 2020 Zurich Enroll
United Kingdom
Dec 16-18, 2019 This is a FLEX event Birmingham * Enroll
Online Training Time zone: Europe/London Enroll
Dec 16-18, 2019 London (Int Hse) * Enroll
Jan 13-15, 2020 Birmingham * Enroll
Jan 15-17, 2020 Leeds * Enroll
Jan 27-29, 2020 London (Int Hse) * Enroll
Feb 5-7, 2020 This is a FLEX event Leeds * Enroll
Online Training Time zone: Europe/London Enroll
Mar 9-11, 2020 London (Int Hse) * Enroll
Mar 11-13, 2020 Birmingham * Enroll
May 18-20, 2020 This is a FLEX event Birmingham * Enroll
Online Training Time zone: Europe/London Enroll
May 26-28, 2020 This is a FLEX event London (Int Hse) * Enroll
Online Training Time zone: Europe/London Enroll
Jul 6-8, 2020 This is a FLEX event London (Int Hse) * Enroll
Online Training Time zone: Europe/London Enroll
Middle East
United Arab Emirates
Mar 15-17, 2020 Dubai Course language: English This course is being delivered by iTLS. Enroll
Sep 6-8, 2020 Dubai Course language: English This course is being delivered by iTLS. Enroll
Africa
Egypt
Jun 7-9, 2020 Cairo Course language: English Enroll
Nov 29-Dec 1, 2020 Cairo Course language: English Enroll
 
...