Data Scientist
Data Analyst, Freelancer, Varanasi
Product Introducer at Hoben Infotech
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
This course exceeded my expectations in numerous ways. The content was impeccably organized, allowing for a smooth and engaging learning journey. Practical examples and hands-on exercises were thoughtfully integrated, enhancing my understanding of real-world applications.
The inclusion of insights into Jira tasks and the way meetings are conducted was a brilliant move. It gave me a glimpse of how data projects are managed in real-life scenarios.
Putting theory into practice through these AtliQ Hardware projects helped solidify my knowledge and gave me the confidence to apply SQL to real-world problems. The interactive quizzes and challenges throughout the course were also a great touch, making the learning process engaging and enjoyable.
The combination of solid content, practical insights, interactive learning, and excellent instruction like Dhaval Patel or we can say Peter Pandey makes this course stand out. As I move forward in my data journey, I'm grateful for the knowledge and skills I've gained from this course.
Thank you, CodeBasic, for offering such an enriching learning experience!
The way of teaching of Mr. Dhaval Patel is just outstanding. I didn't have any issue understanding any of the lesson. The most important thing I found is the exercises he provided in the course which helped me the do and understand everything more properly.
Extremely happy with the course contents, If someone wishes to learn intermediate to advance sql concepts, this is the best course available.
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.