1­-855­-778­-7246

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
Online Training

Duration 3 days

Price
  • US$ 1,795
  • SA Voucher: 3
    hardcoded default SA
Classroom Training

Duration 3 days

Price
  • United States: US$ 1,795
  • SA Voucher: 3
    hardcoded default SA
 
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

Currently there are no training dates scheduled for this course.  You can schedule a private, onsite training session or request a public date by emailing info@fastlaneus.com.

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