55315

Introduction to SQL Databases Training

55315A is the equivalent of the retired MOC Course 10985C - Introduction to SQL Databases. The 55315A three-day instructor-led course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management. Students will learn fundamental database concepts through demonstrations and hands-on labs on SQL Server, Azure SQL Server and other cloud-based SQL Server databases.
Course Details

Duration

3 days

Prerequisites

General computer literacy.

Target Audience

  • Individuals who are moving into a database role, or whose role has expanded to include database technologies.
  • Developers that deliver content from SQL Server databases.

Skills Gained

  • 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
Course Outline
  • Introduction to databases
    • Introduction to Relational Databases
    • Other Databases and Storage
    • Data Analysis
    • SQL Server Database Languages
  • Data Modeling
    • Data Modelling
    • Designing a Database
    • Relationship Modeling
  • Normalization
    • Fundamentals of Normalization
    • Normal Form
    • Denormalization
  • Relationships
    • Introduction to Relationships
    • Planning Referential Integrity
  • Performance
    • Indexing
    • Query Performance
    • Concurrency
  • Database Objects
    • Tables
    • Views
    • Stored Procedures, Triggers and Functions
Upcoming Course Dates
USD $2,295
Online Virtual Class
Scheduled
Date: Jul 22 - 24, 2024
Time: 9 AM - 5 PM ET
Partner Registration

The course you are registering for is being delivered by our sister company - ExitCertified. All logistics related to course delivery will be managed by the ExitCertified team. If you have a dedicated Web Age representative, please feel to reach out to them with any questions/concerns you may have.

You'll now be redirected to https://www.exitcertified.com to complete the enrollment process.

USD $2,295
Online Virtual Class
Scheduled
Date: Aug 28 - 30, 2024
Time: 9 AM - 5 PM ET
Partner Registration

The course you are registering for is being delivered by our sister company - ExitCertified. All logistics related to course delivery will be managed by the ExitCertified team. If you have a dedicated Web Age representative, please feel to reach out to them with any questions/concerns you may have.

You'll now be redirected to https://www.exitcertified.com to complete the enrollment process.

USD $2,295
Online Virtual Class
Scheduled
Date: Oct 7 - 9, 2024
Time: 9 AM - 5 PM ET
Partner Registration

The course you are registering for is being delivered by our sister company - ExitCertified. All logistics related to course delivery will be managed by the ExitCertified team. If you have a dedicated Web Age representative, please feel to reach out to them with any questions/concerns you may have.

You'll now be redirected to https://www.exitcertified.com to complete the enrollment process.

USD $2,295
Online Virtual Class
Scheduled
Date: Nov 13 - 15, 2024
Time: 9 AM - 5 PM ET
Partner Registration

The course you are registering for is being delivered by our sister company - ExitCertified. All logistics related to course delivery will be managed by the ExitCertified team. If you have a dedicated Web Age representative, please feel to reach out to them with any questions/concerns you may have.

You'll now be redirected to https://www.exitcertified.com to complete the enrollment process.

USD $2,295
Online Virtual Class
Scheduled
Date: Dec 16 - 18, 2024
Time: 9 AM - 5 PM ET
Partner Registration

The course you are registering for is being delivered by our sister company - ExitCertified. All logistics related to course delivery will be managed by the ExitCertified team. If you have a dedicated Web Age representative, please feel to reach out to them with any questions/concerns you may have.

You'll now be redirected to https://www.exitcertified.com to complete the enrollment process.