Training: SQL – Fundamentals and Queries

Ref. SQL-01
Duration:
3
 days
Exam:
Not certifying
Level:
Fundamental

Description

Do you need to master the SQL language to communicate with databases? How to use efficiently the data from your databases? Whether you are a beginner or want to improve your skills and finally master the language of relational databases, this course will quickly teach you how to execute SQL queries and take advantage of the available data.

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

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.
Prix de l'inscription
CHF 2'150.-
Inclus dans ce cours
  • Training provided by an industry expert
  • Digital documentation and materials
  • Achievement Badge

lun08juil(juil 8)09:00mer10(juil 10)17:00VirtuelVirtual Etiquettes de sessionSQL-01

lun08juil(juil 8)09:00mer10(juil 10)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionSQL-01

lun12Aoû(Aoû 12)09:00mer14(Aoû 14)17:00VirtuelVirtual Etiquettes de sessionSQL-01

lun12Aoû(Aoû 12)09:00mer14(Aoû 14)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionSQL-01

lun16Sep(Sep 16)09:00mer18(Sep 18)17:00VirtuelVirtual Etiquettes de sessionSQL-01

lun16Sep(Sep 16)09:00mer18(Sep 18)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionSQL-01

lun21Oct(Oct 21)09:00mer23(Oct 23)17:00VirtuelVirtual Etiquettes de sessionSQL-01

lun21Oct(Oct 21)09:00mer23(Oct 23)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionSQL-01

lun25Nov(Nov 25)09:00mer27(Nov 27)17:00VirtuelVirtual Etiquettes de sessionSQL-01

lun25Nov(Nov 25)09:00mer27(Nov 27)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionSQL-01

Horaires d’ouverture

Du lundi au vendredi, de 8:30 à 18:00.

Contactez-nous

Votre demande

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request

X
X
X
X