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.
Data Scientist
Data Analyst, Freelancer, Varanasi
.jpg)
Product Introducer at Hoben Infotech
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!
Placement Student
Hands down, the most effective SQL course I found with practical application of SQL codes.
For all you non-tech people who aspire to transition their journey into Data Analytics, do not be afraid to code, please.
I myself came out of this phobia.
Special mention to the mentor Mr.Patel, he has been absolutely tremendous in giving us this course.
Data Analyst-Fresher
The SQL course by code basics was an incredible learning journey that thoroughly equipped me with the essential skills of an SQL data analyst. From the engaging lectures to the hands-on exercises, every aspect of the course contributed to my growth in the field. The journey of Peter Pandey added a relatable and enjoyable element, making the learning experience unique.
I want to express my gratitude to Dhaval sir, Hemanand sir, and the entire code basics team for curating such a comprehensive course. The practical exercises were particularly beneficial in reinforcing the concepts taught in the lectures.
For anyone looking to become a competent data analyst, I highly recommend this course. Overall, a big thank you to codebasics for this fantastic learning experience!
Aspiring Data Analyst
I must say this is the best course I ever took. So many courses are available online but the way of teaching by Dhaval Sir is unique and easy understand the concept. I must recommend this course anyone, who aspire to be made career in the data field. Thank you once again for this quality content.
Consultant
When I started my data science journey by enrolling in a master's in data science at the University of New Haven, I had a challenge. As a part of the course, I had to do some projects on SQL, and I also had a 70% weightage in my data engineering subject final exam for SQL. I don't have much knowledge of SQL, so I started searching for resources. I went through different course curriculums and introductions on YouTube and websites, and finally, I found this course. When I go through the intro of this course, the next minute I purchase it because of the way they deliver the content and practically implement it by creating the character Pandey. After going through a couple of videos, I felt that I was in the right place, and this content is beyond my exceptions.
Thanks to the Code Basics team for this wonderful course.
Graduate student at University of New Haven
84 Lectures | 11hr : 12min
14 Lectures
Install MySQL: Windows
Install MySQL: Linux, Mac
Import Movies Dataset in MySQL
Retrieve Data Using Text Query (SELECT, WHERE, DISTINCT, LIKE)
Exercise - Retrieve Data Using Text Query (SELECT, WHERE, DISTINCT, LIKE)
Retrieve Data Using Numeric Query (BETWEEN, IN, ORDER BY, LIMIT, OFFSET)
Exercise - Retrieve Data Using Numeric Query (BETWEEN, IN, ORDER BY, LIMIT, OFFSET)
Summary Analytics (MIN, MAX, AVG, GROUP BY)
Exercise - Summary Analytics (MIN, MAX, AVG, GROUP BY)
HAVING Clause
Calculated Columns (IF, CASE, YEAR, CURYEAR)
Exercise - Calculated Columns (IF, CASE, YEAR, CURYEAR)
The Data God’s Blessing
Quiz
17 Lectures
Database Normalization and Data Integrity
Entity Relationship Diagram (ERD)
Mentor Talk: Art of Googling
Data Types: Numeric (INT, DECIMAL, FLOAT, DOUBLE)
Data Types: String (VARCHAR, CHAR, ENUM)
Data Types: Date, Time (DATETIME, DATE, TIME, YEAR, TIMESTAMP)
Data Types: JSON, Spatial (JSON, GEOMETRY)
Luck Favors the LinkedIn Post
Primary key
Foreign Key
Create a Database From an Entity Relationship Diagram - ERD
Import Data From a CSV File Into a Database
Insert Statement
Update and Delete
I Need a Favour
Expect the Unexpected: The Intermission Scene
Quiz
10 Lectures
Backlog Grooming Meeting: Gross Sales Report
User-Defined SQL Functions
Exercise: User-Defined SQL Functions
Gross Sales Report: Monthly Product Transactions
Gross Sales Report: Total Sales Amount
Exercise: Yearly Sales Report
Stored Procedures: Monthly Gross Sales Report
Stored Procedure: Market Badge
Benefits of Stored Procedures
Quiz
16 Lectures
Problem Statement and Pre-Invoice Discount Report
Performance Improvement # 1
Performance Improvement # 2
Database Views: Introduction
Database Views: Post Invoice Discount, Net Sales
Exercise: Database Views
Top Markets and Customers
Exercise: Top Products
The Two Most Important Skills for the Data Analyst
Window Functions: OVER Clause
Window Functions: Using it in a Task
Exercise: Window Functions: OVER Clause
Window Functions: ROW_NUMBER, RANK, DENSE_RANK
Exercise: Window Functions: ROW_NUMBER, RANK, DENSE_RANK
5 Ways SQL is Used in the Industry
Quiz
14 Lectures
Supply Chain Basics : Simplified
Problem Statement
Create a Helper Table
Database Triggers
Database Events
Temporary Tables & Forecast Accuracy Report
Exercise: CTE, Temporary Tables
Subquery vs CTE vs Views vs Temporary Table
User Accounts and Privileges
Database Indexes: Overview
Database Indexes: Composite Index
Database Indexes: Index Types
Peter Pandey's Order: I Have Completed the Course - Now What?
Quiz
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.
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.
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.
Yes. Absolutely you can mention the AtliQ Hardware project experience in your resume with the relevant skills that you will learn from this course.
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.
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.
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.
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.
The SQL course consists of 11 hours and 12 minutes of on-demand video content.
Our SQL course is priced at Rs. 900. This investment provides you with comprehensive knowledge of SQL, equipping you with skills valued in many industries.
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
This course uses a project-based learning approach to teach you Python using two real-life projects (1) Hospitality domain data analysis and (2) Medical data extraction. Learning Python programming through projects helps you understand real-life applications of this awesome programming language. You will also have two solid projects that you can add to your resume and you work on end-to-end implementation. Total beginners, as well as people familiar with the language, will benefit from this Python course.
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.
/images/1.1.419/courses/thumbnails/sql-beginner-to-advanced-for-data-professionals.webp)
11hr : 12min on-demand video
84 Lectures
6 Practice Business Scenarios with Solution
9 Quizzes
Access on any Device
Certificate of completion
Free Lifetime Access
Learning knows no limits. Here’s to your journey of seamless learning. Pick your preferred course from the list of paid & free resources.
Quick Link
Help & Support
/images/1.1.419/courses/thumbnails/python-for-beginner-and-intermediate-learners.webp)
Log in with Google
Log in with Linkedin