Training SQL database for functional

Thise IT training is mainly aimed at functional people who need to manipulate data from SQL databases. Starting from scratch, it provides the essential tools to understand how a database works and to be able to query, filter, cross-reference, group data and more, without any prior technical knowledge required.

SQL DATABASE TRAINING: AUDIENCE AND PREREQUISITES

• Anyone who manipulates databases with the SQL language
• Know how to classify, organize documents
• Know how to structure a reflection and describe each step

SQL DATABASE TRAINING: GOALS

Know how to manipulate a database with the SQL language to visualize, test
or extract data (postgresql, sql server, oracle, …)

SQL DATABASE TRAINING: THE PROGRAM

Introduction

• Why SQL: history, standard and language
• Structure (Schema, Table, View) and analogy with reality
• Set concept
• Index concept

Manipulate table data

• Filter data
• Select useful information
• Format data: CASE WHEN and some functions
• Order the results

Cross data from several tables (join)

• INNER JOIN
• LEFT OUTER JOIN
• FULL OUTER JOIN
• CROSS-JOIN

Group results (aggregate)

• COUNT
• MAX
• MIN
• RANK

Intermediate processing for complex queries

• Using subqueries
• Creating Temporary Tables
• Common table expressions
• Combine multiple results: UNION

Presentation of performance issues

At the end of the training, evaluation of the knowledge acquired during the training and delivery of the training follow-up certificate.

SQL DATABASE TRAINING: THE DURATION 

Two day training

Practical information : Our computer training courses are maintained from one participant and they can be carried out with us or with you.

To discover our other courses, click here