10985 Introduction to SQL Databases2021-10-22T12:31:03-04:00

Summary

10985 Introduction to SQL Databases

This course is being retired by Microsoft on December 31, 2021.

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.

  • Dates: May 18, 2022- May 19, 2022- May 20, 2022
  • Times: 9:00 am - 5:00 pm (EST)
  • Location: Virtual
  • Seats: 10
  • Price: $1785

Introduction

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

Course Objectives
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

Outline

  • 1 - Introduction to databases

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

    • Data modelling
    • ANSI/SPARC database model
    • Entity relationship modelling
  • 3 - Normalization

    • Why normalize data?
    • Normalization terms
    • Levels of normalization
    • Denormalization
  • 4 - Relationships

    • Schema mapping
    • Referential integrity
  • 5 - Performance

    • Indexing
    • Query performance
    • Concurrency
  • 6 - Database Objects

    • Tables
    • Views
    • Stored procedures
    • Other database objects