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 |
Membership renews after 12 months. You can cancel anytime from your account.