SQL Mastery with Generative AI From Beginner to Expert
0% Completed
Getting Started
Introduction to Generative AI – ChatGPT
Introduction to PostgreSQL
Setting up PostgreSQL Server Environment
======Quick Reference Guide for PostgreSQL Database======
SQL Basics – Learn by Doing with AI
SQL AL: 100+ Prompts
PostgreSQL Fundamentals
Database Tables
SQL Commands (CRUD functionality) Queries
Mastering the SQL Basics
Data Reporting: Data Row Filtering
Functions in SQL Data Management: Aggregate
Data Aggregation: Learn by doing Functions with Generative AI
Data Management: Advanced Aggregate Functions in SQL
Data Management: Advanced Functions using AI
Data Modelling: Mastering JOINS using Generative AI
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
Prompt Engineering for SQL using Generative AI – ChatGPT
Database Management: Ensuring Data Security with Backup and Restore
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
Finish Course Early?
You have not completed all required lessons and assessments.
Your Progress
0%