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