New Launch: AI Toolkit for Professionals is now LIVE!
New Launch: The Ultimate Gen AI and Data Science Bootcamp is LIVE with a subsidised benefit!
AI Upgrade Alert! Data Analyst Bootcamp 4.0 has an optional AI upgrade at a subsidised price.
SQL Beginner to Advanced For Data Professionals
Beginners to Advanced SQL course for those preparing for a data career (Data Analyst, Data Scientist, or Data Engineer). This course is carefully curated to simulate real-time organizational experience to prepare you for the current job market and at the same time provides you with an ultimate learning experience through a storytelling mode that you would see in movies.
4.9
(1244 Verified ratings)
Last Updated: Jul 23, 2024 6:33 AM
|English
Free Lifetime Access
No Experience
Needed
Start from scratch
and build up
Flexible
Schedule
Learn at your
own pace
Get
Job-Ready
Acquire essential
job skills
/308538/Updated%20Courses%20Thumbnails/SQL-Thumbnail_1000.webp)
Created by:
This course includes:
- 11h:15m:16s on-demand video
- 84 Lectures
- 12 Exercises
- 9 Quizzes
- Access on any Device
- Certificate of completion
Free Lifetime Access
No Experience Needed
Start from scratch
and build up
Flexible Schedule
Learn at your
own pace
Get Job-Ready
Acquire essential
job skills
What you'll learn in our SQL course?
-
SQL Basics (SELECT, WHERE, BETWEEN, GROUP BY, ORDER BY, etc.)
-
Joins (LEFT, RIGHT, INNER, FULL, CROSS)
-
Subqueries, CTEs, Views, Temporary Tables
-
Fundamentals of ETL, Data Warehouse, OLAP, OLTP
-
User Defined Functions, Stored Procedures
-
Window Functions (Over, ROW_NUMBER, RANK, DENSE_RANK, etc.)
-
Data Engineer-Specific Topis: Indexes, Triggers, Events, User Accounts & Privileges
-
Kanban Project Management
-
Real dataset with >1 million records with industry-style project-based learning
-
Exercises, Quizzes, and Certificate Upon Course Completion
Course Curriculum
84 Lectures | 11h:15m:16s
4:
SQL Basics: Data Retrieval - Single Table
15 Lectures
-
4.1: Install MySQL: Windows
Free -
4.2: Install MySQL: Linux, Mac
Free -
4.3: Import Movies Dataset in MySQL
Free -
4.4: Retrieve Data Using Text Query (SELECT, WHERE, DISTINCT, LIKE)
Free -
4.5: Exercise - Retrieve Data Using Text Query (SELECT, WHERE, DISTINCT, LIKE)
Free -
4.6: Retrieve Data Using Numeric Query (BETWEEN, IN, ORDER BY, LIMIT, OFFSET)
Free -
4.7: Exercise - Retrieve Data Using Numeric Query (BETWEEN, IN, ORDER BY, LIMIT, OFFSET)
Free -
4.8: Summary Analytics (MIN, MAX, AVG, GROUP BY)
Free -
4.9: Exercise - Summary Analytics (MIN, MAX, AVG, GROUP BY)
Free -
4.10: HAVING Clause
Free -
4.11: Calculated Columns (IF, CASE, YEAR, CURYEAR)
Free -
4.12: Exercise - Calculated Columns (IF, CASE, YEAR, CURYEAR)
Free -
4.13: The Data God’s Blessing
Free -
4.14: Quiz
-
4.15: Chapter Summary
7:
SQL Basics: Database Creation & Updates
18 Lectures
-
7.1: Database Normalization and Data Integrity
-
7.2: Entity Relationship Diagram (ERD)
-
7.3: Mentor Talk: Art of Googling
-
7.4: Data Types: Numeric (INT, DECIMAL, FLOAT, DOUBLE)
-
7.5: Data Types: String (VARCHAR, CHAR, ENUM)
-
7.6: Data Types: Date, Time (DATETIME, DATE, TIME, YEAR, TIMESTAMP)
-
7.7: Data Types: JSON, Spatial (JSON, GEOMETRY)
-
7.8: Luck Favors the LinkedIn Post
-
7.9: Primary key
-
7.10: Foreign Key
-
7.11: Create a Database From an Entity Relationship Diagram - ERD
-
7.12: Import Data From a CSV File Into a Database
-
7.13: Insert Statement
-
7.14: Update and Delete
-
7.15: I Need a Favour
-
7.16: Expect the Unexpected: The Intermission Scene
-
7.17: Quiz
-
7.18: Chapter Summary
8:
AtliQ Hardware & Problem Statement
9 Lectures
-
8.1: The Rise of Databases at AtliQ
Free -
8.2: Relational vs No-SQL Database
-
8.3: AtliQ Hardware’s Business Model
-
8.4: Profit & Loss Statement
-
8.5: ETL, Data Warehouse, OLAP vs OLTP, Data Catalog
-
8.6: Fact vs Dimension Table, Star vs Snowflake Schema, Data Import
-
8.7: Simplified: What is Kanban?
-
8.8: Quiz
-
8.9: Chapter Summary
9:
SQL Advanced: Finance Analytics
10 Lectures
-
9.1: Backlog Grooming Meeting: Gross Sales Report
-
9.2: User-Defined SQL Functions
-
9.3: Exercise: User-Defined SQL Functions
-
9.4: Gross Sales Report: Monthly Product Transactions
-
9.5: Gross Sales Report: Total Sales Amount
-
9.6: Exercise: Yearly Sales Report
-
9.7: Stored Procedures: Monthly Gross Sales Report
-
9.8: Stored Procedure: Market Badge
-
9.9: Benefits of Stored Procedures
-
9.10: Quiz
10:
SQL Advanced: Top Customers, Products, Markets
16 Lectures
-
10.1: Problem Statement and Pre-Invoice Discount Report
-
10.2: Performance Improvement # 1
-
10.3: Performance Improvement # 2
-
10.4: Database Views: Introduction
-
10.5: Database Views: Post Invoice Discount, Net Sales
-
10.6: Exercise: Database Views
-
10.7: Top Markets and Customers
-
10.8: Exercise: Top Products
-
10.9: The Two Most Important Skills for the Data Analyst
-
10.10: Window Functions: OVER Clause
-
10.11: Window Functions: Using it in a Task
-
10.12: Exercise: Window Functions: OVER Clause
-
10.13: Window Functions: ROW_NUMBER, RANK, DENSE_RANK
-
10.14: Exercise: Window Functions: ROW_NUMBER, RANK, DENSE_RANK
-
10.15: 5 Ways SQL is Used in the Industry
-
10.16: Quiz
11:
SQL Advanced: Supply Chain Analytics
14 Lectures
-
11.1: Supply Chain Basics : Simplified
-
11.2: Problem Statement
-
11.3: Create a Helper Table
-
11.4: Database Triggers
-
11.5: Database Events
-
11.6: Temporary Tables & Forecast Accuracy Report
-
11.7: Exercise: CTE, Temporary Tables
-
11.8: Subquery vs CTE vs Views vs Temporary Table
-
11.9: User Accounts and Privileges
-
11.10: Database Indexes: Overview
-
11.11: Database Indexes: Composite Index
-
11.12: Database Indexes: Index Types
-
11.13: Peter Pandey's Order: I Have Completed the Course - Now What?
-
11.14: Quiz
What our learners experience
Our content is rated 4.9/5 from 8590+ Learners
Professional expert in energy planning
Data scientist
/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/uploads/testimonials/94250/thumbnail/6454e1920b712img-0421.jpeg)
Data Scientist
Data Analyst, Freelancer, Varanasi
Product Introducer at Hoben Infotech
Being from a non-tech background and I know only economics and statistics, I feel happy because these industry experts made our life so easy. From the bottom of my heart, I congratulate Mr Dhaval Patel for introducing this fantastic course.
/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/uploads/testimonials/103097/thumbnail/64d0e750c08febharathphoto.jpg)
Assistant Manager at Zuari FarmHub Limited
Landed a Job
To be honest, this is the first ever course in my life that I completed 100%(bcuz of quality and the interest that Dhaval Patel brings up through out the course). I brought many courses in Udemy but I never crossed 50% in any of them.
I am currently working as a Data Analyst in top Logistics organization, and this course have gave me much needed and valuable knowledge on SQL. I already recommended [codebasics.io](http://codebasics.io/) (SQL course) to many people who reached out to me when I was half way through this course and will continue to highly recommend this unique master piece.
/fit-in/100x100/filters:format(webp)/fit-in/100x100/uploads/images/img-20201223-010103-546.jpg)
Data Analyst
Amazing course, I was always afraid of writing a query, especially in joins before this course. Now I feel very confident in sql queries. Learned a lot in a very organized way and the simulation of Peter Panday and the way you taught us really is decent in this price.
Thank You Sir...
/fit-in/100x100/filters:format(webp)/fit-in/100x100/uploads/testimonials/124467/thumbnail/649a85b947c8cwhatsapp-image-2023-06-27-at-121547.jpeg)
Backend Developer
Excellent course for learning SQL from basics to advanced for Data professionals.
I recently took this course and it was one of the best decisions I've made. The course was well-structured and took me through the basics of SQL to advanced topics. I appreciated the hands-on approach, which gave me practical experience in working with real-world data.
The dhaval patel sir aka peter pandey was great at is work. He explained each concept in a clear and concise manner. The course content was also very comprehensive, covering topics such as Etl, cte, user defined functions, Window functions, querying, joins, and subqueries...tec.
Overall, I highly recommend this course to anyone who wants to learn SQL. Whether you're a beginner or an experienced programmer, this course will give you the skills and knowledge you need to work with databases and manipulate data with ease. Thanks to this course, I feel more confident in my SQL abilities and look forward to applying them in Code basics Resume projects.
No course gave me this much confidence.
Thank you dhaval sir
The course covers almost all aspects of what Data Analysts and Data Scientists need's to work with Data in wild. The unique feature is, it stays true to its name and emphasise only on what Data Professionals needs to know and discard other non relevant topics. The skills are also easily transferrable to working with Platforms such as BigQuery (Which I use daily as part of my Job)
/fit-in/100x100/uploads/testimonials/14800/thumbnail/64492c73b1162education-cubed-5-12-22-05-12-22-154-lo-res-online.jpg)
Junior Data Analyst
System Requirements
- Any computer with 4GB or more RAM
- OS: Windows, Mac, or Linux
Course Instructors/Creators

Dhaval Patel
Data Entrepreneur (12+ Years),
YouTuber,
Ex - Bloomberg, NVIDIA
I have 17 years of experience in Programming and Data Science working for big tech companies like NVIDIA and Bloomberg. I also run a famous YouTube channel called Codebasics where I pursue my passion for teaching.
Hemanand Vadivel
Ex- Data Analytics Manager, 8+ Years in Europe, Microsoft Certified, Certified Supply Chain Professional
I’m a Mechanical Engineer who transitioned to a full-time Data & Analytics Manager in the UK & Germany. I have delivered 30+ analytics projects over 15+ countries and trained professionals at different levels to equip them with valuable analytics skills.

Get Certified
When You Complete This Course
You receive a ‘Certificate of Completion’ signed and addressed personally by me, your guide and mentor. – Dhaval Patel
Add and share this certificate with your Resume/CV or on your LinkedIn profile.
Frequently Asked Questions


Q.1
What is different in this course compared to hundreds of courses on the internet and free tutorials on YouTube
Most of the courses available on the internet teach you how to build x & y without any business context and do not prepare you for real-world problem-solving. However, our SQL course offers a unique experience in which you will learn SQL by solving real-life use cases in an imaginary company called AtliQ Hardware. The tutorials are easy to understand, featuring elements of fun to keep the learning process engaging.
Q.2
What dataset is used in this course? Is it some toy dataset or something that mimics a real-world problem
For the initial basics, we used a toy dataset of movies. However, for advanced concepts in this SQL course, we've crafted a dataset designed to mimic real business world scenarios, informed by our years of experience in the FMCG industry. This dataset contains more than 1 million records.
Q.3
How does this online SQL course make SQL easy to learn?
This course makes SQL easy to learn by utilizing a real dataset for practical, project-based learning. With engaging storytelling, simple explanations, and regular quizzes, you can master SQL in a hands-on, accessible manner. A certificate upon completion further validates your learning journey.
Q.4
What is the duration of this SQL course?
The SQL course consists of 11 hours and 12 minutes of on-demand video content.
Q.1
I have never done programming and belong to a non-technical background. Can I take this SQL Beginners to Advanced course?
Yes, this is the perfect course for anyone who has never done coding and wants to build a career in the IT/Data Analytics industry or just wants to perform better in their current job or business using data.
Q.2
What are the things I need to know before starting this course? Also, will it help me learn SQL from scratch?
This SQL Beginner to Advanced course, is designed for absolute beginners, so you don't need any specific skills other than basic familiarity with computers. It's the perfect starting point for anyone looking to embark on an SQL course.
Q.2
How can I get help if I have a doubt and need support?
We have an active Discord server where you can post your questions as you learn SQL online. You can expect to receive a response in a reasonable timeframe.
Q.1
Can I add this course to my resume
Yes. Absolutely you can mention the AtliQ Hardware project experience in your resume with the relevant skills that you will learn from this course.
Q.2
I’m not sure if this SQL course is good enough for me to invest some money. What can I do?
Don't worry. Many videos in this SQL course are free, allowing you to gauge the quality of teaching before making an investment. Dhaval Patel, the course instructor, runs a popular data science YouTube channel called Codebasics. There, you can watch his videos and read comments to get an idea of his teaching style.
More Courses
Python: Beginner to Advanced For Data Professionals
This project-based learning course will teach Python through hands-on experience with two real-world projects: (1) Data analysis in the hospitality domain and (2) Building an expense tracking system. It is designed for both complete beginners with no prior coding experience and those with some Python knowledge looking to enhance their skills. The course is taught by an industry expert with over 14 years of experience at leading tech companies such as Nvidia and Bloomberg.
Get Job Ready: Power BI Data Analytics for All Levels 3.0
This practical beginner’s course lets you learn Power BI from scratch, preparing you for the Data Analyst, Business Analyst, or Power BI Developer job market. The course provides an end-to-end Power BI project, carefully curated to offer you real organizational experience and business context.
Excel: Mother of Business Intelligence
Beginners to Advanced Excel course for those who are preparing for a data career (especially Data Analysts). This course is carefully curated by industry experts to mimic real-world scenarios to prepare you to become a market fit. You will also get practical exercises to practice and get a simulated experience of a data analyst using Excel to solve problems.
/308538/Updated%20Courses%20Thumbnails/SQL-Thumbnail_1000.webp)
This course includes:
- 11h:15m:16s on-demand videos
- 84 Lectures
- 12 Exercises
- 9 Quizzes
- Access on any Device
- Certificate of completion
Course Preview
/p>
© 2025 Codebasics.io. All Rights
Reserved | Product of LearnerX EdTech Private Limited
Our technology partner: AtliQ Technologies