The Complete SQL Masterclass From Basics to Advanced
0% Completed
Getting Started
Introduction to PostgreSQL
Setting up PostgreSQL Server Environment
PostgreSQL Fundamentals
Database Tables
SQL Commands (CRUD functionality) Queries
Mastering the Basics of SQL
Data Management: Data Row Filtering Techniques
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
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
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
Finish Course Early?
You have not completed all required lessons and assessments.
Your Progress
0%