Introduction To SQL Databases Training 10985C - Canada

Introduction to SQL Databases Training 10985C Course Outline

Module 1: Introduction to Databases

• Introduction to Relational Databases
• Retrieve Data from a Relational Database by using SQL

Lab 1: Use the SELECT Statement to Retrieve Data from a Database

• Use the SELECT Statement to Retrieve Data from a Database

Module 2: Database Tables

• Identify and use Microsoft SQL Server Data Types
• Create Tables with SQL
• Altering and Dropping a Table
• Collect Information from Multiple Tables by using Joins and Views

Lab 1: Create and Alter a Table in Microsoft SQL Server

• Create and Alter a Table in Microsoft SQL Server
• Create and Retrieve a View that Uses the JOIN Statement in Microsoft SQL Server

Lab 2: Create and Alter a Table in Microsoft SQL Server

• Create and Alter a Table in Microsoft SQL Server

Lab 3: Create and Retrieve a View that Uses the JOIN Statement in Microsoft SQL Server

• Create and Retrieve a View that Uses the JOIN Statement in Microsoft SQL Server

Module 3: Add and Update Data

• Insert, Update, and Delete Information

Lab 1: Add and Change Data in SQL Server

• Add and Change Data in SQL Server

Lab 2: Create and use Stored Procedures in Microsoft SQL Server

• Create and use Stored Procedures in Microsoft SQL Server

Module 4: Entity Relationships

• Model Entity Relationships
• Design for Referential Integrity What is Referential Integrity?

Lab 1: Create an Entity Relationship Diagram in Microsoft SQL Server Management Studio

• Create an Entity Relationship Diagram in Microsoft SQL Server Management Studio

Module 5: Normalisation and Denormalisation

• Normalisation
• Denormalisation

Lab 1: Denormalise a Table by Adding a Redundant Column of Computed Data

• Denormalise a Table by Adding a Redundant Column of Computed Data

Module 6: Query Performance and Safety

• Indexes
• Write Performant SQL Code
• Concurrency

Lab 1: Create Indexes and Consult Execution Plans in Microsoft SQL Server Management Studio

• Create Indexes and Consult Execution Plans in Microsoft SQL Server Management Studio

Who should attend this Introduction to SQL Databases Training 10985C Course?

This Introduction to SQL Databases Training 10985C Course is designed for individuals who want to develop a foundational understanding of working with SQL databases and querying data. This training course is beneficial for the following professionals:

• Administrative Assistants
• Database Administrators
• Data Analysts
• IT Professionals
• Clerical Staff
• Web Developers
• Researchers

Prerequisites of the Introduction to SQL Databases Training 10985C Course

There are no formal prerequisites for this Introduction to SQL Databases Training 10985C Course.

Introduction to SQL Databases Training 10985C Course Overview

The Introduction to SQL Databases Training 10985C Course provides a comprehensive foundation in SQL databases, a critical component for managing and querying data in today's data-driven world. This one-day training is designed to equip delegates with essential skills to understand and utilise SQL databases effectively, ensuring they can handle data efficiently and accurately.

Proficiency in SQL databases is crucial for Data Analysts, Database Administrators, and IT Professionals. Mastering SQL ensures that professionals can efficiently retrieve and manipulate data, which is essential for decision-making and strategic planning. This course is particularly beneficial for those aiming to advance their careers in data management and analysis.

This 3-day training will empower delegates with hands-on experience in SQL databases. Delegates will learn through practical exercises, enabling them to apply SQL commands and manage data effectively. The course is structured to provide a thorough understanding of SQL fundamentals, ensuring delegates gain the skills needed to work confidently with databases.

Course Objectives

• To understand the basics of relational databases
• To learn the SQL language and its practical applications
• To execute data queries to retrieve specific information
• To perform data manipulation, including inserting, updating, and deleting records
• To create and manage database tables and schemas
• To understand and implement data integrity and constraints

After completing the course, delegates will receive a certification, validating their SQL database skills and enhancing their professional credentials. This certification will open up new opportunities in data management and analysis fields.

What’s included in this Introduction to SQL Databases Training 10985C Training Course?

• World-Class Training Sessions from Experienced Instructors
• Introduction to SQL Databases Training 10985C Certificate
• Digital Delegate Pack

You’ll also get access to the MyTKA Training Portal, which will be your go to hub for all your training.
Hands-On Labs: Included as part of our online instructor-led delivery, these labs provide real-world exercises in a simulated environment guided by expert instructors to enhance your practical skills.