10985: Introduction to SQL Databases

Databases
  • Retail Price: $1,995.00
  • Sale Price: $1,695.00 (Vendor Credits or Vouchers Accepted)
  • 3 Days
  • Databases
Schedules
  09/05/17 - 9-5pm PST Glendale - CA
  09/18/17 - 9-5pm PST Glendale - CA
  10/02/17 - 9-5pm PST Glendale - CA
  10/16/17 - 9-5pm PST Glendale - CA
  10/30/17 - 9-5pm PST Glendale - CA
  11/13/17 - 9-5pm PST Glendale - CA
  11/27/17 - 9-5pm PST Glendale - CA
  12/11/17 - 9-5pm PST Glendale - CA
  12/26/17 - 9-5pm PST Glendale - CA
Delivery Type (Must Select One)
  Instructor-Led
  Online Live Instructor-Led
Optional
  Microsoft Test Voucher ($155.00)
  Microsoft Practice Exam ($70.00)
  LearnITAnytime Online Subscription (1 Year Subscription - $195.00)
  IT Online Library (1 Year Subscription - $1595.00)
  Private Mentoring 3 Hours ($225)
Quantity
If quantity is more than 1, Please add all Attendees' Names /Voucher #/ Learning Credit below separated with a comma. If not specified, we will contact you prior to the class start date. Special Instructions

This three-day instructor-led course 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.

 

Module 1: Introduction to databases
This module introduces key database concepts in the context of SQL Server 2016.
Lessons

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

Lab : Querying SQL Server

After completing this module, you will be able to:

  • Describe what a database is
  • Understand basic relational aspects
  • Describe database languages used in SQL Server 2016
  • Describe data analytics
  • Describe database languages used in SQL Server 2016

Module 2: Data Modelling
This module describes data modelling techniques.
Lessons

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

Lab : Entity relationship modellingAfter completing this module, you will be able to:

  • Understand the common data modelling techniques
  • Describe the ANSI/SPARC database model
  • Describe entity relationship modelling

Module 3: Normalization
This module describes normalization and denormalization techniques.
Lessons

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

Lab : Normalizing raw data

After completing this module, you will be able to:
• Describe normalization benefits and notation
• Describe important normalization terms
• Describe the normalization levels
• Describe the role of denormalization

Module 4: Relationships
This module describes relationship types and effects in database design.
Lessons

  • Schema mapping
  • Referential integrity

Lab : Designing relationships

After completing this module, you will be able to:

  • Describe relationship types
  • Describe the use, types, and effects of referential integrity

Module 5: Performance
This module introduces the effects of database design on performance.
Lessons

  • Indexing
  • Query performance
  • Concurrency

Lab : Query performance

After completing this module, you will be able to:

  • Discuss the performance effects of indexing
  • Describe the performance effects of join and search types
  • Describe the performance effects of concurrency

Module 6: Database Objects
This module introduces commonly used database objects.
Lessons

  • Tables
  • Views
  • Stored procedures
  • Other database objects

Lab : Using SQL Server in a hybrid cloud

After completing this module, you will be able to:

  • Describe the use of tables in SQL Server 2016
  • Describe the use of views in SQL Server 2016
  • Describe the use of stored procedures in SQL Server 2016
  • Describe other database objects commonly used in SQL Server 2016

After completing this course, students will be able to:
• Describe key database concepts in the context of SQL Server 2016
• Describe database languages used in SQL Server 2016
• Describe data modelling techniques
• Describe normalization and denormalization techniques
• Describe relationship types and effects in database design
• Describe the effects of database design on performance
• Describe commonly used database objects

.

 

The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies.

.

 

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

.

 

You may cancel this class 10 or more business days prior to the start date of the class for a full refund. No shows or cancellations made within 10 days will forfeit all fees paid.