The Complete SQL Bootcamp 2022: Go from Zero to Hero

Why Attend

This is a course that puts you in control, and have you set up and restore databases right at the start of the course, instead of watching someone else code. Every section comes with fresh challenge questions and tasks, modeled after real-world tasks and situations.

Overview

Course Outline

Schedule & Fees

Course Methodology

Instructor-led training that uses interactive learning methods, including class discussion, small group activities, and role-playing

Course Objectives

Get started with PostgreSQL and PgAdmin.; Learn the basics of SQL syntax; Analyzing data using aggregate functions with GROUP BY commands; Running advanced queries with string operations and comparison operations; Learn to use logical operators to add logic flow to your SQL queries; Learn common SQL JOIN commands; Learn to create tables and databases with constraints on data entries; Learn to use Python to further advance your SQL skills

Target Audience

SQL is one of the most in-demand skills for: Business analysts; Data scientists; Anyone who finds themselves working with data.

Target Competencies

n/a

Introduction to SQL

Windows Installation – PostGreSQL and PgAdmin with Database setup
MacOS Installation - PostgreSQL and PgAdmin with First Query

SQL Statements Fundamentals

SQL Statement Fundamentals
SELECT Statement
Challenge: SELECT
SELECT DISTINCT
Challenge: SELECT DISTINCT
COUNT
SELECT WHERE - Part One
SELECT WHERE - Part Two
ORDER BY
LIMIT
Challenge: ORDER BY
BETWEEN
IN
LIKE and ILIKE

Group By Statements

Introduction to GROUP BY
Aggregation Functions
GROUP BY - Part One
GROUP BY - Part Two
GROUP BY - Challenge
HAVING

JOINS

Introduction to JOINs
AS Statement
Inner Joins
Full Outer Joins
Left Outer Join
Right Joins
UNION

Advanced SQL Commands

Timestamps and Extract
Quick Note on TO_CHAR
Mathematical Functions and Operators
String Functions and Operators
SubQuery
Self-Join

Creating Databases and Tables

Introduction to Section
Data Types
Primary Keys and Foreign Keys
Constraints
CREATE Table
INSERT
UPDATE
DELETE
ALTER Table
DROP Table
CHECK Constraint

Conditional Expressions and Procedures

Conditional Expressions and Procedures Introduction
CASE
COALESCE
CAST
NULLIF
Views
Import and Export

PostGreSQL with Python

Overview of Python and PostgreSQL
Psycopg2 Example Usage

$3875

Cairo

Country: Egypt

Duration: One week

Date: 13–17 Oct 2025

$1375

Dar Es Salaam

The Complete SQL Bootcamp 2022: Go from Zero to Hero

Overview

Course Outline

Schedule & Fees

Course Methodology

Course Objectives

Target Audience

Target Competencies

$3875

Country: Egypt

Duration: One week

Date: 13–17 Oct 2025

$1375

Country: Tanzania

Duration: One week

Date: 06–10 Apr 2026