The Complete SQL from Scratch: Bootcamp |
Course Introduction |
|
Introduction |
|
00:04:00 |
|
Course Curriculum overview |
|
00:04:00 |
|
Overview of Databases |
|
00:08:00 |
SQL Environment Setup |
|
PostgreSQL Installation |
|
00:13:00 |
|
Connecting to PostgreSQL using psql |
|
00:04:00 |
|
Connecting to PostgreSQL using PgAdmin |
|
00:07:00 |
Creating Database and Tables |
|
Basic of Database and Tables |
|
00:06:00 |
|
Data Types |
|
00:07:00 |
|
Primary Keys and Foreign Keys |
|
00:04:00 |
|
Create Table in SQL Script |
|
00:17:00 |
|
Insert |
|
00:05:00 |
|
Update |
|
00:05:00 |
|
Delete |
|
00:03:00 |
|
Alter Table |
|
00:05:00 |
|
Drop Table |
|
00:02:00 |
|
Check Constraint |
|
00:12:00 |
|
NOT NULL Constraint |
|
00:04:00 |
|
UNIQUE Constraint |
|
00:06:00 |
SQL Statement Basics |
|
Overview of Challenges |
|
00:04:00 |
|
SQL Statement Basic |
|
00:07:00 |
|
SELECT Statement |
|
00:12:00 |
|
SELECT DISTINCT |
|
00:10:00 |
|
Column AS Statement |
|
00:07:00 |
|
COUNT |
|
00:07:00 |
|
SELECT WHERE Clause – One |
|
00:06:00 |
|
SELECT WHERE Clause – Two |
|
00:11:00 |
|
ORDER |
|
00:05:00 |
|
LIMIT |
|
00:04:00 |
|
BETWEEN keyword usage on real time |
|
00:08:00 |
|
IN Operator |
|
00:06:00 |
|
LIKE and ILIKE |
|
00:10:00 |
GROUP BY Statements |
|
Overview of GROUP BY |
|
00:03:00 |
|
Aggregation Function |
|
00:12:00 |
|
GROUP BY – One |
|
00:05:00 |
|
GROUP BY – Two |
|
00:06:00 |
|
HAVING on SQL Statement |
|
00:04:00 |
JOINS |
|
Overview of JOINS |
|
00:07:00 |
|
Introduction to JOINS |
|
00:06:00 |
|
AS Statement table |
|
00:05:00 |
|
INNER Joins |
|
00:14:00 |
|
Full Outer Joins |
|
00:04:00 |
|
Left Outer join |
|
00:03:00 |
|
Right Outer Join |
|
00:05:00 |
|
Union |
|
00:05:00 |
Advanced SQL Commands |
|
Basic of Advanced SQL Commands |
|
00:04:00 |
|
Timestamps |
|
00:17:00 |
|
Extract from Timestamp |
|
00:05:00 |
|
Mathematical Functions |
|
00:06:00 |
|
String Functions |
|
00:16:00 |
|
SubQuery |
|
00:08:00 |
Databases and Tables |
|
Overview of Databases and Tables |
|
00:02:00 |
|
Creating a Database backup |
|
00:03:00 |
|
Restoring a Database from backup |
|
00:04:00 |
Assessment Test |
|
Overview Assessment Test |
|
00:02:00 |
Mock Exam |
|
Mock Exam – The Complete SQL from Scratch: Bootcamp |
|
00:20:00 |
Final Exam |
|
Final Exam – The Complete SQL from Scratch: Bootcamp |
|
00:20:00 |