SQL is one of the most in-demand skills in data, analytics, and software development. This beginner-friendly training is designed to help participants build a solid foundation in relational databases and SQL is one of the world's most powerful open-source database systems.
Through practical examples and hands-on exercises, participants will learn how to create databases, write queries, manipulate data, and work with relationships between tables. By the end of the course, students will be able to confidently build and query databases while applying SQL to real-world business and technical scenarios.

Module 1 — Introduction to Databases
What is a database
SQL vs NoSQL
What is PostgreSQL
Install PostgreSQL
Install pgAdmin
Database terminology
table
row
column
schema
 
Module 2 — Creating Databases & Tables
CREATE DATABASE
CREATE TABLE
PRIMARY KEY
NOT NULL
UNIQUE
 
Module 3 — Basic SQL Queries
SELECT
WHERE
ORDER BY
LIMIT
DISTINCT
Aliases
 
Module 4 — INSERT, UPDATE, DELETE
INSERT INTO
UPDATE
DELETE
RETURNING
 
Module 5 — Data Types
INTEGER
BIGINT
VARCHAR
TEXT
BOOLEAN
DATE
TIMESTAMP
 
Module 6 — Filtering Data
LIKE
ILIKE
IN
BETWEEN
IS NULL
 
Module 7 — SQL Functions
COUNT
SUM
AVG
MIN
MAX
 
Module 8 — Relationships
One-to-One
One-to-Many
Many-to-Many
Foreign Keys
 
Module 9 — Joins Basics
INNER JOIN
LEFT JOIN
 
Practical Exercises
SQL practice
Coding interview problems
 
TRAINING DETAILS
Training format: hybrid
Training duration: 16 hours / 8 days / 2 per lesson
Training fee: