Introduction

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!

Training Objectives

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

Target Audience

SQL is one of the most in-demand skills for:

• Business analysts

• Data scientists

• Anyone who finds themselves working with data.

Course Outlines

Day 1: SQL Fundamentals & Setup

Introduction to SQL
Windows Installation – PostgreSQL and PgAdmin with Database Setup
MacOS Installation – PostgreSQL and PgAdmin with First Query
SQL Statements Fundamentals
SELECT Statement
SELECT DISTINCT
COUNT
SELECT WHERE (Part 1 & Part 2)
ORDER BY
LIMIT

Day 2: Filtering & Grouping Data

BETWEEN
IN
LIKE and ILIKE
GROUP BY Introduction
Aggregation Functions
GROUP BY (Part 1 & Part 2)
HAVING
GROUP BY Challenge
ORDER BY Challenge

Day 3: Joins & Set Operations

Introduction to JOINs
AS Statement (Aliases)
Inner Joins
Left Outer Join
Right Join
Full Outer Join
UNION
Self Join

Day 4: Advanced SQL Concepts

Timestamps and Extract
TO_CHAR Function
Mathematical Functions and Operators
String Functions and Operators
Subqueries
Advanced SQL Commands Overview

Day 5: Database Design & PostgreSQL with Python

Creating Databases and Tables Introduction
Data Types
Primary and Foreign Keys
Constraints (CHECK included)
CREATE, INSERT, UPDATE, DELETE
ALTER and DROP Tables
Conditional Expressions (CASE, COALESCE, CAST, NULLIF)
Views
Import and Export Data
PostgreSQL with Python Overview
Psycopg2 Usage Example