SQL Fundamentals Training Course

This training programme equips learners with the essential skills needed to extract, analyse data from any database system, and generate comprehensive reports. Participants will acquire knowledge on:

Constructing effective SQL queries
The concept of relational databases and their practical applications
Understanding relationships and how to establish them
Data structures
Key distinctions among SQL dialects (Oracle, T-SQL, ANSI)
Hands-on techniques for writing queries

This course focuses on standard ANSI SQL, which is applicable across various database systems including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL, and other relational databases.

This course is available as onsite live training in Kenya or online live training.

Thank you for sending your enquiry! One of our team members will contact you shortly.

Thank you for sending your booking! One of our team members will contact you shortly.

Course Outline

Relational Database Management Systems (RDBMS)

Relational Operators

SQL as a Declarative Language

SQL Syntax Fundamentals

SQL Sublanguages: DQL, DML, DDL, and DCL

In-Depth Look at DQL (Data Query Language)

SELECT clause
Column aliases
Table aliases
Date types and Date functions
Aggregate functions
Joining tables
JOIN clause
UNION operator
Nested queries
Correlated subqueries

Overview of DML (Data Manipulation Language)

Inserting records (INSERT)
Inserting records via subquery
Updating records (UPDATE)
Deleting records (DELETE)

Overview of DDL (Data Definition Language)

Creating, altering, and dropping objects (CREATE, ALTER, DROP)
Creating tables from queries (CREATE TABLE ... AS SELECT...)

Constraints Overview

NULL and NOT NULL
CONSTRAINT clause
ENUM data type
SET data type
PRIMARY KEY
UNIQUE constraint
FOREIGN KEY
DEFAULT value clause

Transactions Overview

COMMIT operations
ROLLBACK procedures
SAVEPOINT management
Implicit and explicit commits and rollbacks

SQL Dialects Overview

MySQL
Microsoft Access and SQL Server
Oracle and PostgreSQL

Requirements

Foundational computer literacy.

14 Hours

Need help picking the right course?
southafrica@nobleprog.co.za or +27 (0)10 005 5793

Testimonials (7)

It was very interactive and it kept us interested.

Raluca Alexandra PUNGA

Course - SQL Fundamentals

The way in which it was organized on virtual machines, easily accessed by the trainer

Alexandru Tudorache

Course - SQL Fundamentals

Providing information and knowledge of the training topic

Patryk Pietrzyk - Nacomi Group

Course - SQL Fundamentals

Learned new things and advanced myself with knowledge

Todor - MYPOS TECHNOLOGIES

Course - SQL Fundamentals

I like this training because it was interactive

Amalia - Banca Transilvania

Course - SQL Fundamentals

style, knowledge

Cristina - Banca Transilvania

Course - SQL Fundamentals

He had a lot of patience with all the students.

SQL Fundamentals Training Course

Course Outline