Course Code: 19217

55315 - Introduction to SQL Databases

Class Dates:
7/11/2022
Length:
3 Days
Cost:
$1495.00
Class Time:
Technology:
Database
Delivery:

Overview

  • Course Overview
  • 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. This course updates and replaces course 10985C previously published under the same title.
  • Audience
  • The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material.

    At Course Completion
    Describe key database concepts in the context of SQL Server
    Describe database languages used in SQL Server
    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

Prerequisites

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

Course Details

  • Module 1: Introduction to databases
  • Introduction to Relational Databases
  • Other Databases and Storage
  • Data Analysis
  • SQL Server Database Languages
  • Lab 1: Exploring SQL Server Databases and Tables
  • Explore SQL Server
  • Query Databases and Tables
  • Module 2: Data Modeling
  • Data Modelling
  • Designing a Database
  • Relationship Modeling
  • Lab 1: Identify Components in Relationship Modeling
  • Modeling a database
  • Module 3: Normalization
  • Fundamentals of Normalization
  • Normal Form
  • Denormalization
  • Lab 1: Normalizing Data
  • Normalizing Tables
  • Module 4: Relationships
  • Introduction to Relationships
  • Planning Referential Integrity
  • Lab 1: Planning and Implementing Referential Integrity
  • Implementing Referential Integrity
  • Module 5: Performance
  • Indexing
  • Query Performance
  • Concurrency
  • Lab 1: Performance Issues
  • Using Indexes
  • Module 6: Database Objects
  • Tables
  • Views
  • Stored Procedures, Triggers and Functions
  • Lab 1: Using SQL Server Objects
  • Using Tables
  • Using Views
  • Using Stored Procedures