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

(1377 Verified ratings)

9401 Enrolled Learners

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

SQL Beginner to Advanced For Data Professionals

US$36

Created by:

Dhaval Patel & Hemanand Vadivel

Enroll Now

This course includes:

11h:39m:30s on-demand video
86 Lectures
12 Exercises
10 Quizzes
Access on any Device
Certificate of completion

Share With Friends

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

Course Curriculum

86 Lectures | 11h:39m:30s

1: Course Overview
3 Lectures

1.1: Who can Enroll in this Course? Any Prerequisites?

Free

1.2: What Type of Computer do I Need for this Course?

Free

1.3: Course Outline

Free

2: Welcome to The SQL Experience
3 Lectures

2.1: How Learning SQL can Help You in Your Career

Free

2.2: Who is Peter Pandey?

Free

2.3: Peter Pandey’s Early Life and SQL

3: Enhance your Learning Experience
2 Lectures

3.1: Setting Video Resolution and Video Speed Globally

Free

3.2: Join Discord

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

5: SQL Basics: Data Retrieval - Multiple Tables
9 Lectures

5.1: Why do We Need Multiple Tables?

Free

5.2: SQL Joins (INNER, LEFT, RIGHT, FULL)

Free

5.3: Exercise - SQL Joins (INNER, LEFT, RIGHT, FULL)

Free

5.4: Cross Join

5.5: Analytics on Tables

5.6: Join More Than Two Tables

5.7: Exercise - Join More Than Two Tables

5.8: Quiz

5.9: Chapter Summary

6: SQL Basics: Complex Queries
10 Lectures

6.1: Subqueries

6.2: ANY, ALL Operators

6.3: Co-Related Subquery

6.4: Exercise: Subqueries

6.5: Common Table Expression (CTE)

6.6: CTE Benefits & Other Applications

6.7: Exercise: CTE

6.8: Peter Pandey Flexes his SQL Skills

6.9: Quiz

6.10: 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

12: Final Quiz
1 Lecture

12.1: Final Quiz

What our learners experience

Our content is rated 4.9/5 from 9401+ Learners

Jorge Daniel Carreon Guzman

Data scientist

Mansi Agrahari

Data Analyst, Freelancer, Varanasi

Asadur Rahman Nafi

Data Scientist

Rishabh Mankar

Product Introducer at Hoben Infotech

Miguel Ángel Hernández

View All

I recently enrolled in the SQL course offered by Code Basics, and I must say, it exceeded my expectations in every aspect. From the comprehensive curriculum to the engaging teaching style, this course truly stands out.

One of the highlights of the course is its structured approach. Each concept is explained in a clear and concise manner, making it easy for beginners to grasp the fundamentals of SQL. The course starts with the basics and gradually progresses to more advanced topics, ensuring that learners build a strong foundation before moving on to complex queries and database management.
Overall, I highly recommend the SQL course on Code Basics to anyone looking to learn SQL from scratch or enhance their existing skills. Thank you, Code Basics, for providing such an enriching learning experience!

kanchan sinha

aspiring data analyst

Landed a Job

The course is great! Easy to understand, even for beginners. It covers everything from basics to advanced topics. The instructor (Dhaval Patei) explains things well, and there are lots of practical examples to help you learn. Highly recommended!

Y Amisha

Database Engineer

Landed a Job

The course not only explains technical stuff but also all the industrial jargon and workflow, which is a huge confidence booster. Thank you codebasics team and Dhaval Patel Sir.

Anirudh Rana

Student

Landed a Job

Fantastic SQL Training!

I just completed the SQL training, and it was fantastic! The instructors were great at explaining things clearly, and the hands-on exercises helped me learn quickly. The course covered everything from basics to advanced topics and gave me a solid foundation in SQL. The support from the team was excellent, and I'd recommend this training to anyone looking to learn SQL. It's a valuable course that will boost your skills!

Cynthia Chinenye Udoye

Placement Student

Landed a Job

The best sql course at affordable price before this I have taken 2 courses but this course is just awesome which explains from basics to advance level with exercises and quizzes, Some special techniques and tricks explained by Dhaval patel with his industry knowledge makes course interesting , I highly recommend this sql course worth more than 5 star.

Ashray Gowda

Senior process executive

View All

System Requirements

Any computer with 4GB or more RAM
OS: Windows, Mac, or Linux

Course Instructors/Creators

Dhaval Patel

Data Entrepreneur (17+ 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.

Hemanand Vadivel, Co-Founder of Codebasics and Course Instructor

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.1 Once purchased, is this course available for lifetime access

Yes

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

US$30

Python: Beginner to Advanced For Data Professionals

4.9 (416)

7958 Enrolled

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.

US$60

Get Job Ready: Power BI Data Analytics for All Levels 3.0

4.9 (903)

7475 Enrolled

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.

US$36

Excel: Mother of Business Intelligence

4.9 (1888)

10226 Enrolled

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.

US$36

Created by:

Dhaval Patel & Hemanand Vadivel

Enroll Now

This course includes:

11h:39m:30s on-demand videos
86 Lectures
12 Exercises
10 Quizzes
Access on any Device
Certificate of completion

Share With Friends

US$36

Enroll Now

SQL Beginner to Advanced For Data Professionals

No Experience Needed

Flexible Schedule

Get Job-Ready

This course includes:

No Experience Needed

Flexible Schedule

Get Job-Ready

Course Curriculum

What our learners experience

System Requirements

Course Instructors/Creators

Dhaval Patel

Hemanand Vadivel

Get Certified

When You Complete This Course

Frequently Asked Questions

Features and Course Content

Eligibility

Support and Access

Others

More Courses

This course includes:

No Experience
Needed

Flexible
Schedule

Get
Job-Ready