Course Content
Getting Started
0/4
Introduction
02:52
Getting started on Windows, macOS, and Linux
01:30
How to ask great questions
01:32
FAQ’s
01:24
Introduction to PostgreSQL
0/3
What is PostgreSQL
03:13
Why Choose PostgreSQL? Futures and Benefits
04:42
Understanding the PostgreSQL Ecosystem
02:31
Setting up PostgreSQL Server Environment
0/3
Installation and setup (Windows)
14:59
Installation steps for macOS and Linux
06:14
Exploring pgAdmin and Command-Line Tools
10:05
PostgreSQL Fundamentals
0/4
Relational Database Concepts
06:04
Data Types and Schemas
05:00
Creating and Managing Databases
06:59
Quick reference notes – Cheat sheet on SQL
Database Tables
0/4
CREATE a table using pgAdmin
12:48
ALTER a table (modification)
08:06
DELETE a table
04:24
CREATE a table using SQL
09:22
SQL Commands (CRUD functionality) Queries
0/4
CREATE operation (Insert Data)
05:15
READ operation (Select Data)
04:08
UPDATE operation (Modify Data)
04:34
DELETE operation (Remove Data)
02:42
Mastering the Basics of SQL
0/4
SQL statement basics
03:08
SELECT statement
02:44
Eliminating Duplicates with SELECT DISTINCT
04:41
COUNT() Column AS statement for Dashboards
02:51
Data Management: Data Row Filtering Techniques
0/5
SELECT and WHERE Clause
03:02
SELECT and WHERE: Filtering Data in SQL
06:49
Sorting Data with the ORDER BY Clause
04:06
Efficient Data Selection with the LIMIT Clause
02:51
Using LIMIT with an Offset
02:16
Data Management: Aggregate Functions in SQL
0/8
Using SUM() in SQL: Calculating Total Values
07:19
Calculating Averages with the AVG() Function in SQL
03:21
Finding the Minimum Value with the MIN() Function in SQL
02:48
Extracting the Maximum Value with the MAX() Function in SQL
02:21
Concatenating Values with STRING_AGG() in SQL
05:37
Analyzing Data Variance with the VARIANCE() Function in SQL
05:45
Calculating Standard Deviation with the STDDEV() Function in SQL
04:42
Counting Unique Values with COUNT(DISTINCT) in SQL
04:46
Data Management: Advanced Aggregate Functions in SQL
0/2
Grouping Data Efficiently with the GROUP BY Clause
10:57
Advanced Data Filtering Leveraging the HAVING Clause in SQL
03:15
Data Management: JOINS in SQL – Combining Data Across Tables
0/7
Introduction to JOINS in SQL: Combining Data Across Tables
03:15
Writing INNER JOIN: Retrieving Data from Multiple Tables
16:14
Using LEFT JOIN: Retrieving All Records from Left Table
02:07
Right JOIN in SQL: Retrieving Data from the Right Table
01:33
Using FULL OUTER JOIN: Combining Results from Both Tables
01:42
Self JOIN in SQL: Joining a Table to Itself
05:46
Cross Join in SQL: Producing Cartesian Products
10:10
Data Management: Mastering SQL Constraints for Data Integrity
0/7
Enforcing Non-Null Values with the NOT NULL Constraint
11:39
Ensuring Unique Data with the UNIQUE Constraint
08:48
Uniquely Identifying Records with the PRIMARY KEY Constraint
07:49
Maintaining Referential Integrity with the FOREIGN KEY Constraint
11:59
Validating Data with the CHECK Constraint
09:34
Providing Default Values with the DEFAULT Constraint
04:29
Optimizing Queries with the INDEX Constraint
09:02
Database Management: Advanced SQL Techniques for Data Mastery
0/5
Mastering Timestamps: Working with Date and Time in SQL
06:29
Mathematical Functions in PostgreSQL: Beyond Basic Arithmetic
04:07
String Manipulation Made Easy: Transform and Analyze Text Data
03:29
Unlocking the Power of Subqueries in PostgreSQL
03:20
Conditional Logic in SQL: Using CASE for Advanced Filtering
02:56
Database Management: Ensuring Data Security with Backup and Restore
0/2
Mastering Database Backups: Ensuring Data Integrity
06:43
Restoring Databases: Ensuring Business Continuity
05:04
Database Management: Capstone Project
0/10
Create a Database
01:37
Design the Schema -Company Management System
05:00
Insert Sample Data
02:09
Querying the Data
02:42
Optimizing the Database – Indexing
01:40
Optimizing the Database – Query Analysis
01:43
Optimizing the Database – Vacuum and Analyze
01:07
Optimizing the Database – Partitioning (for Large Data)
01:03
Backup and Restore – Backup the Database
01:34
Backup and Restore – Restore the Database
03:01
Database – Data Management: Managing Users and Roles
0/1
Login Group / Roles setup
03:54
The Complete SQL Masterclass From Basics to Advanced
Previous
Next
0% Complete