Data Analyst, Freelancer, Varanasi
Product Introducer at Hoben Infotech
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
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.
Data Analyst
I had previously done a course on PostgreSQL from another platform, but many SQL concepts were still unclear. After completing this course on MySQL from Codebasics, I feel much more confident in SQL. The course will take you through all the important concepts of SQL right from the basics to the advanced level. The course has been put together in such an interesting manner, you will feel like you are watching a movie. I have been following Codebasics on Youtube since the beginning of my journey of becoming a data analyst, and I have learned so much from it. I want to especially thank Dhaval Sir & Hemanand Sir, for their efforts in providing high-quality education at such an affordable price. Looking forward to exploring other awesome courses at Codebasics.
Aspiring Data Analyst
The course is designed for beginners and even for data professionals and covers all the important concepts, from the basics of SQL to advanced topics in a clear and concise manner. Mr. Dhaval does an excellent job of breaking down complex topics like window functions and triggers and explaining them in an easy-to-understand way. The practical examples used throughout the course help reinforce the concepts and give you a hands-on experience with SQL. The quizzes at the end of each section are also a great way to test your understanding and solidify the information. Overall, I highly recommend this course to anyone looking to improve their SQL skills and become a better data professional.
Apart from that, I would recommend going through the SQL questions on HackerRank and DataLemur, which will eventually give you more confidence in your SQL skills.
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.
Senior process executive
79 Lectures | 11:12
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 course is for absolute beginners hence you do not need any specific skills other than basic familiarity with computers.
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 business world problem-solving. This course is rather an experience in which you will learn SQL by solving real-life use cases in an imaginary company called AtliQ Hardware. The tutorials are very easy to understand and also have a lot of fun elements into them so that you don’t get bored! 😊
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 course are free so watch them to get an idea of the quality of teaching. Dhaval Patel (the course instructor) runs a popular data science YouTube channel called Codebasics. Over 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. But for advanced concepts, we used a dataset crafted to mimic the real business world by consolidating our years of experience and the FMCG industry. That dataset contains more than 1 million records.
We have an active Discord server where you can post your question, and you will get an answer in a reasonable time frame.
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 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 the resume ad you work on end-to-end implementation. Total beginners, as well as people familiar with Python, will benefit from this course.
A practical beginner’s course that will prepare you for the data analyst, business analyst, or Power BI developer job market through a true end-to-end Power BI project carefully curated to provide you with real organizational experience & business context.