Course Catalog  > Microsoft  > SQL Server
55315

Introduction to SQL Databases Training

New to databases? This course is your starting point. This SQL Database course covers the basics, whether you're a programmer suddenly dealing with databases or an IT pro whose role is growing. We'll walk you through core database ideas, and you'll get hands-on practice with SQL Server, both on your own computer and in the cloud.

Request Information
Request On-Site or Customized Course Info
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: Sep 30 - Oct 2, 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.