18 - 22 May 2025
Cairo (Egypt)
Hotel : Holiday Inn & Suites Cairo Maadi, an IHG Hotel
Cost : 3575 € Euro
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.
The Complete SQL Bootcamp 2022: Go from Zero to Hero will allow participants how to read and write complex queries to a database using one of the most in-demand skills - PostgreSQL. These skills are also applicable to any other major SQL database, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and much more.
Learning SQL is one of the fastest ways to improve your career prospects as it is one of the most in-demand tech skills! In this course, you'll learn quickly and receive challenges and tests along the way to improve your understanding!
At the end of this training program, participants will learn:
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
SQL is one of the most in-demand skills for:
Business analysts
Data scientists
Anyone who finds themselves working with data.
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