Welcome to Comnet Group Inc.

Courses

Introduction to SQL

Course number: CGISQL40

This course is geared toward anyone who is interested in transitioning 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.

What You’ll Learn

  • Key database concepts in the context of SQL Server
  • Database languages used in SQL Server
  • Data modeling techniques
  • Normalization and denormalization techniques
  • Relationship types and effects in database design
  • Effects of database design on performance
  • Commonly used database objects
Prerequisites
  • This is a foundation-level course and therefore only requires general computer literacy.
Target Audience

The primary audience for this course is anyone who is moving into a database role, or whose role has expanded to include database technologies. Developers who deliver content from SQL Server databases will also benefit from this material.

Course Content
Introduction to Databases

This module introduces key database concepts in the context of SQL Server.

Lessons:

  • Introduction to Relational Databases
  • Other Databases and Storage
  • Data Analysis
  • SQL Server Database Languages
Data Modeling

This module describes data modeling techniques.

Lessons:

  • Data Modeling
  • Designing a Database
  • Relationship Modeling
  • Database languages in SQL Server
Normalization

This module describes normalization and denormalization techniques.

Lessons:

  • Fundamentals of Normalization
  • Normal from
  • Denormalization
Relationships

This module describes relationship types and effects in database design.

Lessons:

  • Introduction to relationships
  • Planning referential integrity
Performance

This module introduces the effects of database design on performance.

Lessons:

  • Indexing
  • Query performance
  • Concurrency
Database Objects

This module introduces commonly used database objects.

Lessons:

  • Tables
  • Views
  • Stored procedures, triggers and functions

Available Formats

Live Online
Register