Course Curriculum
- 13 sections
- 26 lectures
- 00:00:00 total length
-
Introduction
00:04:00 -
Course Curriculum overview
00:04:00 -
Overview of Databases
00:08:00
-
PostgreSQL Installation
00:13:00 -
Connecting to PostgreSQL using psql
00:04:00 -
Connecting to PostgreSQL using PgAdmin
00:07:00
-
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
-
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
-
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
-
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
-
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
-
Overview of Databases and Tables
00:02:00 -
Creating a Database backup
00:03:00 -
Restoring a Database from backup
00:04:00
-
Overview Assessment Test
00:02:00
-
Mock Exam – The Complete SQL from Scratch: Bootcamp
00:20:00
-
Final Exam – The Complete SQL from Scratch: Bootcamp
00:20:00
-
Claim Your Certificate
00:00:00