Training: SQL – Fundamentals and Queries

Ref. SQL-01

Download PDF

Duration:

3

days

Exam:

Not certifying

Level:

Fundamental

Funding:

Temptraining

Home > Trainings > IT Pro > Analytics and Data Management > SQL – Fundamentals and Queries

SQL Training

Learn SQL and master it! Revolutionize your data management with our SQL Training. Learn how to execute complex queries and fully leverage your relational databases, whether you’re a beginner or already familiar with the basics.

This hands-on course will guide you from the fundamentals to advanced techniques, covering everything from executing simple queries to exporting data. With our SQL database training, become an expert in record time and turn your skills into a valuable asset for your career.

Participant profiles

Beginner to SQL

Objectives

Exploit the contents of a relational database essentially based on SELECT queries

Prerequisites

No prerequisites

Course content

Module 1 : Introduction to SQL Usage and Terminology

What is SQL and What can SQL Do?
SQL Keyword Command Language and Hierarchy
Introduction and Usage of the Select Clause Statement

Module 2 : Executing A Simple Query

Connect to a SQL Database
Query a Database
Save a Query
Modify and Execute a Saved Query

Module 3 : Performing Queries Using Criteria Conditions

Query Using One or More Conditions
Query for a Range of Values and NULL Values
Query Data Using Wildcard Characters
Applying And/Or Operators
Format Column Headings with Aliases
Format Query Results Data

Module 4 : Summarizing Data with Mathematical Functions

Perform Date Calculations
Summarize Data Using Aggregate Functions
Manipulate Text Results with String Functions

Module 5: Organizing Query Data Results

Sort Data with “Order By” Clause
Group Data with “Group By” Clause
Rank Data Using “Rank” Function
Filter Grouped Data
Summarize Grouped Data
Use PIVOT and UNPIVOT Operators

Module 6 : Retrieving Data from Multiple Tables

Understanding SQL Joins
Retrieve Data by Joining Tables
Combine the Results of Two Queries
Compare the Results of Two Queries
Introduction into Sub-Queries

Module 7 : Exporting Query Results

Export to Excel Workbook
Generate a Text File

Documentation

Digital courseware included

Complementary courses

SQL – Advanced Queries | SQL-02

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.

Additional information

SQL Training: Master the Basics of SQL Language

If you want to learn SQL and understand how to interact with databases, our SQL training is perfect for you. This comprehensive course will guide you step by step through the key concepts of the SQL language and enable you to run complex queries, organize data, and manipulate it effectively.

What is an SQL Database?

An SQL database is a structured system that allows information to be stored and managed in an organized manner. With the SQL language, it is possible to query, modify, and retrieve data quickly and securely. Learning SQL is essential for any professional working with data.

What is SQL and Why Do We Use It?

SQL (Structured Query Language) is a standard language used to communicate with relational databases. It allows you to run queries to add, delete, update, or retrieve data. Whether you work in development, project management, or data analysis, mastering SQL is crucial for handling large and complex datasets.

Is SQL Difficult to Learn?

Learning SQL is often considered accessible even for beginners. Our SQL course is designed to be easy to follow, with practical exercises and clear explanations at every step. With this approach, you will progress quickly, whether or not you have prior programming experience.

How to Create an SQL Database?

Creating an SQL database is a skill you will acquire in the first modules of our training. We will guide you through all the steps, from connecting to a database to creating tables and structuring your data. You will also learn how to query these databases and save your queries for future analysis.

The Four Sub-languages of SQL

SQL is divided into four main sub-languages:

DDL (Data Definition Language): Used to define the structure of databases (creating, modifying tables).
DML (Data Manipulation Language): For interacting with data, i.e., adding, updating, or deleting it.
DQL (Data Query Language): Primarily represented by the SELECT command, it allows you to query and extract data.
DCL (Data Control Language): Manages permissions and access controls to databases.

A Hands-on Program to Master SQL

Our SQL training covers all the basics you need to become proficient with this language. Here’s an overview of what you will learn:

Run simple and complex queries: You will start with the SELECT command and learn how to filter results, use logical operators like AND/OR, and apply criteria to get exactly the data you need.
Manipulate data: The training will help you understand how to manipulate data efficiently using aggregation functions, aliases, or joins to combine multiple tables.
Create and organize your databases: In the first modules, you will learn how to create and organize your databases with the ORDER BY clause to sort results or the GROUP BY clause to group and analyze data intelligently.

Why Learn SQL Today?

SQL is used everywhere there is data to manage. Whether for web applications, data analysis systems, or e-commerce platforms, SQL is the tool that allows you to structure and retrieve information quickly. With the rise of relational databases, learning SQL opens many doors, whether you’re looking for a career change or aiming to enhance your current skills.

Exporting the Results of Your SQL Queries

By the end of our SQL training, you will also be able to export your results in various formats such as Excel files or text files, a valuable skill for sharing and analyzing data in a corporate setting.