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