Data Scientist
Data Analyst, Freelancer, Varanasi
Product Introducer at Hoben Infotech
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
5 star Rating is not enough for you. It's beyond the Limit. Your method of Teaching is so good Sir. It didn't distract us and it kept engaging while learning SQL. If I can , everyone can. Keep Teaching and we will always be ready to learn the quality content... Peter Pandey always rockzzz in Data Analyst career...
It was an amazing SQL course. The teaching was very clear and understandable. The movie style approach made the course so much interesting and every time there was an excitement to know what's next. The course covered all the important topics relevant to the industry by working on real-time business analytical requirements. I would strongly recommend this course to all .
Thank you Mr. Dhaval Patel and CodeBasics for this enriching content and outstanding learning experience.
A Great Job Dhaval Patel Sir,
This course is an absolute gem! The creator has crafted a superb learning experience, and the instructor's teaching is top-notch. Their ability to explain complex topics with clear, relatable examples is outstanding. The course structure flows seamlessly, ensuring a comprehensive understanding. It's a 5-star masterpiece, blending informative content and engaging instruction. Highly recommended!
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
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.