Training: Introduction to SQL Databases

Ref. 55315AC

Download PDF

Duration:

3

days

Exam:

Not certifying

Level:

Fundamental

Funding:

Temptraining

ITTA | Trainings | IT Pro | Analytics & Data Management | Introduction to SQL Databases

Description

This 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.

Participant profiles

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

Objectives

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

No prerequisites

Course content

Module 1: Introduction to databases

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

Module 2: Data Modeling

Data Modelling
Designing a Database
Relationship Modeling

Module 3: Normalization

Fundamentals of Normalization
Normal Form
Denormalization

Module 4: Relationships

Introduction to Relationships
Planning Referential Integrity

Module 5: Performance

Indexing
Query Performance
Concurrency

Module 6: Database Objects

Tables
Views
Stored Procedures, Triggers and Functions

Documentation

Digital courseware included

Lab / Exercises

Online Labs

Complementary courses

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.