Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

SQL Bootcamp: Complete SQL Course

Video Introducing this tutorial

Introduction :
Course Intro

Beginner: PostgreSQL Downloading & Installing + Preparing Airlines Database :
SQL PostgreSQL Down and install
PostgreSQL Database creation
SQL Restore

Beginner: Database Airlines Overview :
SQL Database Overview Part 1
SQL Database Overview Part 2
SQL Data Types

Beginner: SQL Basics Part 1 :
Select Statement For all Airlines Database Tables
Distinct

Beginner: SQL Basics Part 2 :
Where Clause
Operators used with Where Clause
Where Clause + AND & Where Clause + OR
Where Clause + LIKE
(Where Clause + BETWEEN & IN) & AS

Beginner: SQL Basics Part 3 :
LIMIT & ORDER BY
FETCH vs LIMIT
NOT IN
ISNULL & IS NOT NULL
CAST

Intermediate: SQL Aggregations :
COUNT( ) Function, CREATE TABLE & INSERT INTO TABLE
SUM( ) Function
MIN( ) , MAX( ) & AVG( ) Functions
GROUP BY & HAVING

Intermediate: SQL Conditional :
CASE Clause in SQL
NULLIF() Function in SQL
COALESCE() Function in SQL

Intermediate: SQL Time Data management :
Overview of Time Functions in PostgreSQL
TIMESTAMP EXTRACT()
DATE_TRUNC() & DATE_PART()
Double Column + DATE IN PostgreSQL & CURRENT_DATE & now( )

Intermediate: SQL Joins :
INNER JOIN
Joins Types Overview
LEFT OUTER JOIN
Deep understanding of LEFT JOIN
RIGHT OUTER JOIN
FULL OUTER JOIN
CROSS JOIN
UNION, UNION ALL, INTERSECT & EXCEPT
SELF JOIN
USING
NATURAL JOIN

Intermediate: Sub-queries & Common Table Expression in SQL :
Sub-queries
SQL Sub-query + EXISTS, ANY OR ALL
Common Table Expression

Advanced: PostgreSQL Math & Window functions. :
Math Functions
Window Functions OVER()
Window Functions RANK() + OVER() & NTILE() + OVER()
Window Functions OVER() + LEAD()
Window Functions OVER() + LAG()

Advanced: PostgreSQL String Functions :
PostgreSQL POSITION Function
STRPOS() & REPLACE() in PostgreSQL
PostgreSQL LEFT(), RIGHT(), BTRIM() & SPLIT_PART() Functions
PostgreSQL CONCAT Function
PostgreSQL LOWER(), UPPER() & INITCAP() Functions

Advanced: Other SQL Functions :
GROUPING SETS(), ROLLUP(), CUBE()
SELECT Statement + INTO & SELECT Statement + INTO + IN
VIEW()

Lots of SQL Challenges :
Challenge(1)
Solution
Challenge(2)
Solution
Challenge(3)
Solution
Challenge(4)
Solution
Challenge(5)
Solution
Challenge(6)
Solution
Challenge(7)
Solution
Challenge(8)
Solution
Challenge(9)
Solution
Challenge(10)
Solution
Challenge(11)
Solution
Challenge(12)
Solution
Challenge(13)
Solution

Final Exam :
Final Exam Quiz 1
Solution
Final Exam Quiz 2
Solution
Final Exam Quiz 3
Solution
Final Exam Quiz 4
Solution
Final Exam Quiz 5
Solution
Final Exam Quiz 6
Solution