Course Content
Getting Started
0/4
Introduction
03:29
Getting started on Windows, Mac or Linux
01:44
How to ask great questions
01:39
FAQ’s
01:42
Introduction to Generative AI – ChatGPT
0/5
What is ChatGPT
03:36
Generative AI (Gen AI) for Developers
06:15
Settingup ChatGPT for SQL Help
03:47
How to use ChatGPT Gen AI
05:34
ChatGPT for your day-to-day tasks (Prompting Basics)
05:16
Introduction to PostgreSQL
0/3
What is PostgreSQL
03:16
Why Choose PostgreSQL? Futures and Benefits
04:45
Understanding the PostgreSQL Ecosystem
02:34
Setting up PostgreSQL Server Environment
0/3
Installation and setup (Windows)
14:28
Installation steps for macOS and Linux
06:17
Exploring pgAdmin and Command-Line Tools
10:04
======Quick Reference Guide for PostgreSQL Database======
0/1
Cheat Sheet Quick Reference Notes on PostgreSQL
SQL Basics – Learn by Doing with AI
0/5
Create Database – Table – AddingSample Data using AI
11:07
Basic SELECT Queries
03:39
Filtering Data with WHERE
06:34
Sorting Data with ORDER BYb
04:22
SQL Using AI Prompts to Explain Syntax
05:40
SQL AL: 100+ Prompts
0/1
100+ SQL AI Prompts Booklet
PostgreSQL Fundamentals
0/3
Relational Database Concepts
06:09
Data Types and Schemas
05:04
Creating and Managing Databases
07:02
Database Tables
0/3
CREATE a table using pgAdmin
12:51
ALTER a table (modification)
08:11
DELETE a table
04:27
SQL Commands (CRUD functionality) Queries
0/4
CREATE operation (Insert Data)
05:18
READ operation (Select Data)
04:11
UPDATE operation (Modify Data)
04:37
DELETE operation (Remove Data)
02:45
Mastering the SQL Basics
0/4
SQL statement basics
03:11
SELECT statement
02:47
Eliminating Duplicates with SELECT DISTINCT
04:44
COUNT() Column AS statement for Dashboards
02:54
Data Reporting: Data Row Filtering
0/5
SELECT and WHERE Clause
03:05
SELECT and WHERE: Filtering Data in SQL
06:52
Sorting Data with the ORDER BY Clause
04:09
Efficient Data Selection with the LIMIT Clause
02:54
Using LIMIT with an Offset
02:18
Functions in SQL Data Management: Aggregate
0/4
Using SUM() in SQL: Calculating Total Values
07:22
Calculating Averages with the AVG() Function in SQL
03:24
Finding the Minimum Value with the MIN() Function in SQL
02:51
Extracting the Maximum Value with the MAX() Function in SQL
02:24
Data Aggregation: Learn by doing Functions with Generative AI
0/3
Using SQL Built-in Functions (Text, Math, Date)
09:11
Aggregate Functions: SUM, AVG
05:59
Aggregate Function: COUNT
03:05
Data Management: Advanced Aggregate Functions in SQL
0/2
Grouping Data Efficiently with the GROUP BY Clause
11:00
Advanced Data Filtering Leveraging the HAVING Clause in SQL
03:18
Data Management: Advanced Functions using AI
0/2
GROUP BY Clause – Organize and Summarize Your Data
05:21
Filtering Groups with HAVING: Go Beyond WHERE
04:42
Data Modelling: Mastering JOINS using Generative AI
0/4
SQL JOINS Explained with AI
07:20
Combining Multiple Tables with AI Guidance
04:38
Writing JOIN Queries Faster with AI Templates
02:53
Debugging JOIN Errors Using Generative AI
03:55
Data Management: JOINS in SQL – Combining Data Across Tables
0/5
Introduction to JOINS in SQL: Combining Data Across Tables
06:18
Writing INNER JOIN: Retrieving Data from Multiple Tables
16:20
Using LEFT JOIN: Retrieving All Records from Left Table
02:10
Right JOIN in SQL: Retrieving Data from the Right Table
01:36
Using FULL OUTER JOIN: Combining Results from Both Tables
01:45
Data Management: Mastering SQL Constraints for Data Integrity
0/4
Enforcing Non-Null Values with the NOT NULL Constraint
11:42
Ensuring Unique Data with the UNIQUE Constraint
08:51
Uniquely Identifying Records with the PRIMARY KEY Constraint
07:52
Maintaining Referential Integrity with the FOREIGN KEY Constraint
11:59
Real-World Projects with AI Support
0/3
E-Commerce Data Analysis Project
06:11
Employee Management System Queries
03:47
Sales & Revenue Dashboard Queries
02:10
Prompt Engineering for SQL using Generative AI – ChatGPT
0/4
How to Write SQL-Specific Prompts
02:53
Best Practices: Using AI Ethically and Efficiently
03:48
Creating a Prompt Library for SQL Productivity
04:05
Challenge: Automate SQL Reporting with AI
04:02
Database Management: Ensuring Data Security with Backup and Restore
0/2
Mastering Database Backups: Ensuring Data Integrity
06:46
Restoring Databases: Ensuring Business Continuity
05:07
Database Management: Capstone Project
0/10
Create a Database
01:40
Design the Schema – Company Management System
02:35
Insert Sample Data
02:12
Querying the Data
02:45
Optimizing the Database – Indexing
01:43
Optimizing the Database – Query Analysis
01:46
Optimizing the Database – Vacuum and Analyze
01:10
Optimizing the Database – Partitioning (for Large Data)
01:06
Backup and Restore – Backup the Database
01:37
Backup and Restore – Restore the Database
03:04
SQL Mastery with Generative AI From Beginner to Expert
Previous
Next
0% Complete