top of page

SQL Training Modules

Register to any of our training modules! 

There's much to see here so, take your time, look around and take a moment to drop us a line &

we will get back to you for further scheduling, customization or preferred method.

SQL Introduction & Overview 

Mo - Sat 

8:00 AM - 16:00 PM

4 hrs ​/Virtual or Classroom

50 Eur/ Participant

​

  • SQL introduction & history 

  • SQL role & purpose

  • SQL process

  • SQL commands

  • DDL: data definition language 

  • DML: data manipulation language 

  • DCL: data control language 

  • DQL: data query language 

RDBMS

Concepts 

Mo - Sat 

8:00 AM - 16:30 PM

4 hrs ​/Virtual or Classroom

50 Eur/ Participant

​

  • Relational database introduction 

  • Database schemas

  • Database tables

  • Database rows/ records

  • Database columns

  • Oracle history & features

More

Detailed Concepts

Mo - Sat 

8:00 AM - 16:30 PM

4 hrs ​/Virtual or Classroom

50 Eur/ Participant

​

  • Field introduction 

  • Field definition 

  • Record/ row introduction 

  • record/ row definition 

  • Column introduction 

  • Column definition 

  • Null value role & purpose

  • MySQL introduction, history & features

  • MySQL server introduction, history & features

  • ORACLE history & features

SQL

Constraints

Mo - Sat 

8:00 AM - 16:30 PM

8 hrs ​/Virtual or Classroom

70 Eur/ Participant

​

  • NOT NULL constraint & example 

  • DEFAULT constraint & examples

  • DROP DEFAULT constraint & examples

  • PRIMARY KEY (PK) introduction & definition 

  • FOREIGN KEY introduction & definition 

  • DROP a FK constraint & examples

  • CHECK constraint introduction & definition 

  • INDEX introduction & examples 

  • DROP an INDEX constraint

SQL

Syntax

Mo - Sat 

8:00 AM - 16:30 PM

4 hrs ​/Virtual or Classroom

50 Eur/ Participant

​

  • SELECT statement 

  • DISTINCT clause

  • WHERE clause 

  • IN clause

  • BETWEEN clause

  • LIKE clause

  • COUNT clause

  • DESC clause

  • HAVING clause

  • INSERT INTO clause

  • UPDATE statement

  • DELETE statement 

  • USE statement 

  • COMMIT statement 

  • ROLLBACK statement 

....

SQL Expressions & Syntax (part I)

Mo - Sat 

8:00 AM - 16:00 PM

4 hrs ​/Virtual or Classroom

50 Eur/ Participant

​

  • Boolean date expressions 

  • Numeric expressions 

  • Date expressions 

  • CREATE DATABASE syntax & examples

  • DROP/ DELETE DATABASE syntax & examples

SQL Expressions & Syntax (part II)

Mo - Sat 

8:00 AM - 16:30 PM

4 hrs ​/Virtual or Classroom

50 Eur/ Participant

​

  • CREATE TABLE statement 

  • DROP/ DELTE TABLE statement 

  • TRUNCATE TABLE statement 

  • ALTER TABLE statement 

  • RENAME TABLE statement

SQL Expressions & Syntax (part III)

Mo - Sat 

8:00 AM - 16:30 PM

4 hrs ​/Virtual or Classroom

50 Eur/ Participant

​

  • INSERT query syntax & examples 

  • AND/ OR operator syntax & examples

  • UPDATE query syntax & examples

  • DELETE query syntax & examples

  • TOP clause syntax & examples

  • ORDER BY clause syntax & examples

  • GROUP BY clause syntax & examples

  • DISTINCT keyword

  • SORTING results syntax

SQL Index

Introduction 

Mo - Sat 

8:00 AM - 16:30 PM

8 hrs ​/Virtual or Classroom

70 Eur/ Participant

​

  • Index definition & examples

  • The single-column indexes 

  • The unique indexes

  • The composite indexes

  • The implicit indexes

  • CREATE INDEX 

  • DROP INDEX

  • When should indexes be avoided

SQL

Practice Session

Mo - Sat 

8:00 AM - 16:30 PM

8 hrs ​/Virtual or Classroom

Free of charge/ Participant

​

  • Data access phase & types

  • Data selection 

  • Data drilling down 

  • Data exceptional reporting 

  • Data calculations 

  • Data graphics & visualization 

  • Data entry options 

  • Data customizations 

  • Data web-based reporting 

  • Data broadcasting

bottom of page