Introduction to Data Analysis using SQL-Are your spreadsheets too slow?
Gateway to the Course
()
Syllabus - Data Analysis using SQL
Introduction to Data Analysis using SQL-Introduction to Data Analysis using SQL
Database and Why Relational Database?
()
History of Databases and Introduction to NoSQL Database
Choosing the Right RDBMS
()
Installation of the Software (Windows, Linux, and Mac)
Introduction to the UI of MySQL
()
Case Study - FoodHunter || Import Data
()
Writing Your First Code to Explore ORDERS Table - Part 1
()
Writing Your First Code to Explore ORDERS Table - Part 2
()
Code Glossary - Week 1
Data Analysis with SQL on a Single Table-Data Analysis with SQL on a Single Table
Understanding the Monthly Sales
()
Analyzing the Trend In Sales for FoodHunter
()
Various Factors Affecting Revenue - Hypothesis Generation
()
Did Discounts Have Any Impact on Sales
()
Did Day Have Any Impact on Sales
()
Code Glossary - Week 2
Advanced functions on Single Tables in SQL-Advanced functions on Single Tables in SQL
Understand Percentage Change in Sales Over Months
()
Understanding Window Functions
()
Compare Month-On-Month Change in Revenue
()
Insights Based on Delivery Time
()
Midweek Practice Question - Analysing the Food Habits of Customers Based on Meal of the Day
Midweek Practice Question - Solution
Code Glossary - Week 3
Analyzing Multiple Tables in SQL-Analysing Food Preferences and Food Items
A Sneak Peek into the Module
()
Combine Information from Different Tables Using Joins
()
Joins in SQL - Additional Reading
Analysing the Food Preferences of Customers
()
Finding Restaurants With No Items Ordered!
()
Code Glossary - Week 4
CRUD Operations in SQL-CRUD operations in SQL
Complete Recall and A Gist of the Module
()
Converting Raw Data into a Structured Relational Dataset
()
Importing Data using the Table Import Wizard
()
Understanding Percentage Change in Competitor Revenue vs FoodHunter Revenue
()
How to Remove Data from Tables
Code Glossary - Week 5 Lesson 1
CRUD Operations in SQL-Global Problem Statement
Introduction to the Global Problem Statement
()
Basic Querying of Data
()
Product Based Analysis of Sales
()
Impact of Campaign on Sales of Products
()
Code Glossary - Week 5 Lesson 2