Analytics on Tables

Dhaval Patel

Data Entrepreneur | 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. Codebasics is one of the top channels on YouTube when it comes to data science, machine learning, data structures, etc. I firmly believe that “Anyone can code” and I use analogies, simple explanations, and step-by-step storytelling to explain difficult concepts in such a way that even a high school student can understand them easily.

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 by teaching myself Power BI, excel & anything else that was required to solve the problem. I have worked with complex data across Supply Chain, Sales, Marketing, Revenue Management, Finance and HR functions over the last 8 years to deliver effective solutions. To me, Analytics is an extra sensory organ that anyone can develop to become a superhuman at work. I have conducted several workshops and internal training to help non-technical people to become superhuman at work and now, really excited for this opportunity to share all that knowledge with you in this course.

Analytics on Tables

Lecture Content Locked

Get Notified for Next Cohort →

Contents

1.1: How much SQL is Needed for Data Scientist / AI Engineer?

2.1: Join Discord

3.1: Install MySQL: Windows

3.2: Install MySQL: Linux, Mac

3.3: Import Movies Dataset in MySQL

3.4: Retrieve Data Using Text Query (SELECT, WHERE, DISTINCT, LIKE)

3.5: Exercise - Retrieve Data Using Text Query (SELECT, WHERE, DISTINCT, LIKE)

3.6: Retrieve Data Using Numeric Query (BETWEEN, IN, ORDER BY, LIMIT, OFFSET)

3.7: Exercise - Retrieve Data Using Numeric Query (BETWEEN, IN, ORDER BY, LIMIT, OFFSET)

3.8: Summary Analytics (MIN, MAX, AVG, GROUP BY)

3.9: Exercise - Summary Analytics (MIN, MAX, AVG, GROUP BY)

3.10: HAVING Clause

3.11: Calculated Columns (IF, CASE, YEAR, CURYEAR)

3.12: Exercise - Calculated Columns (IF, CASE, YEAR, CURYEAR)

3.13: The Data God’s Blessing

3.14: Quiz

4.1: Why do We Need Multiple Tables?

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

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

4.4: Cross Join

4.5: Analytics on Tables

4.6: Join More Than Two Tables

4.7: Exercise - Join More Than Two Tables

4.8: Quiz

5.1: SQL Final Quiz

6.1: Transition to Maths and Stats

Analytics on Tables

Lecture Content Locked

Contents

1: Welcome to The SQL Experience

1.1: How much SQL is Needed for Data Scientist / AI Engineer?

2: Enhance your Learning Experience

2.1: Join Discord

3: SQL Basics: Data Retrieval - Single Table

3.1: Install MySQL: Windows

3.2: Install MySQL: Linux, Mac

3.3: Import Movies Dataset in MySQL

3.4: Retrieve Data Using Text Query (SELECT, WHERE, DISTINCT, LIKE)

3.5: Exercise - Retrieve Data Using Text Query (SELECT, WHERE, DISTINCT, LIKE)

3.6: Retrieve Data Using Numeric Query (BETWEEN, IN, ORDER BY, LIMIT, OFFSET)

3.7: Exercise - Retrieve Data Using Numeric Query (BETWEEN, IN, ORDER BY, LIMIT, OFFSET)

3.8: Summary Analytics (MIN, MAX, AVG, GROUP BY)

3.9: Exercise - Summary Analytics (MIN, MAX, AVG, GROUP BY)

3.10: HAVING Clause

3.11: Calculated Columns (IF, CASE, YEAR, CURYEAR)

3.12: Exercise - Calculated Columns (IF, CASE, YEAR, CURYEAR)

3.13: The Data God’s Blessing

3.14: Quiz

4: SQL Basics: Data Retrieval - Multiple Tables

4.1: Why do We Need Multiple Tables?

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

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

4.4: Cross Join

4.5: Analytics on Tables

4.6: Join More Than Two Tables

4.7: Exercise - Join More Than Two Tables

4.8: Quiz

5: Final Quiz

5.1: SQL Final Quiz

6: What's Next?

6.1: Transition to Maths and Stats

Analytics on Tables

Lecture Content Locked