Introduction to SQL Databases

Enhance your career as a database professional with our Introduction to SQL Databases course, expertly designed to equip you with essential database concepts and SQL Server 2016 skills.

Course Thumbnail

Essential Skills Gained

Checkmark

Describe fundamental database concepts and SQL Server 2016 applications.

Checkmark

Implement data modeling techniques and database languages.

Checkmark

Execute normalization and denormalization processes.

Checkmark

Analyze performance implications of database design.

Format

  • Instructor-led
  • 3 days with lectures and hands-on labs.

Audience

  • Database Administrators
  • Data Analysts
  • IT Professionals
  • Software Developers

Description

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.

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

Module 1: Introduction to databases

  1. Introduction to relational databases

  2. Other types of database

  3. Data analysis

  4. Database languages

Module 2: Data Modelling

  1. Data modelling

  2. ANSI/SPARC database model

  3. Entity relationship modelling

Module 3: Normalization

  1. Why normalize data?

  2. Normalization terms

  3. Levels of normalization

  4. Denormalization

Module 4: Relationships

  1. Schema mapping

  2. Referential integrity

Module 5: Performance

  1. Indexing

  2. Query performance

  3. Concurrency

Module 6: Database Objects

  1. Tables

  2. Views

  3. Stored procedures

  4. Other database objects

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.