Data Analysis Using SQL

In today's data-centric world, businesses heavily rely on data for decision-making. SQL, or Structured Query Language, is one of the most fundamental tools that help with basic data-related tasks. Our problem-centric approach will help you explore the use of data to make informed decisions for each business problem. This course focuses on:

  1. Efficiently extracting relevant data from relational databases.

  2. Constructing powerful SQL queries to derive valuable insights.

  3. Analyzing and managing large datasets, drawing inferences from complex relational databases.

  4. Creating and modifying databases to address specific business problems effectively.

  5. Navigating vast amounts of information effortlessly enhances your data analysis skills for informed decision-making.

Who Should Enroll:

This course is perfect for professionals aiming to leverage data in decision-making processes, as well as aspiring data analysts. Whether in business, healthcare, finance, or any field that relies on relational data, you'll benefit from mastering SQL. The course is also suitable for beginners seeking a Data Analysis and Data Science career.

Key Takeaways from the “Data Analysis Using SQL” course

  • Extract relevant data from relational databases in a time-efficient manner

  • Build powerful SQL queries to derive insights

  • Analyze and manage large datasets and derive inferences from complex relational databases

  • Create and modify databases for relevant business problems

What do I need to start the “Data Analysis Using SQL” course

  • A reliable laptop/desktop with sufficient processing power

  • Basic understanding of spreadsheets

  • MySQL database software installed for hands-on exercises

Course curriculum

  • 1
    Introduction to Data Analysis using SQL
    • Gateway to the course
    • Syllabus of the Course
    • Database and Why Relational Database?
    • Quiz: Database and its Types
    • History of Databases & 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
    • Quiz
    • Assignment - Write Your First SQL Query
    • Code Glossary
  • 2
    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
    • Quiz
    • Assignment - Data Analysis using SQL on Single Tables.
    • Code Glossary
  • 3
    Advanced functions on Single Tables in SQL
    • Understand Percentage Change in Sales Over Months
    • Understanding Window Functions
    • Quiz
    • Compare Month-On-Month Change in Revenue
    • Insights Based on Delivery Time
    • Assignment : Analysing the Food Habits of Customers Based on Meal of the Day
    • Code Glossary
  • 4
    Analyzing Multiple Tables in SQL
    • A Sneak Peek into the Module
    • Reading - Joins in SQL
    • Combine Information from Different Tables Using Joins
    • Analyzing the Food Preferences of Customers
    • Finding Restaurants With No Items Ordered!
    • Quiz - Check Your Understanding
    • Assignment - Managing Multiple Tables using SQL
    • Code Glossary
  • 5
    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 Food Hunter Revenue
    • Reading - How to Remove Data from Tables
    • Quiz - Check your Understanding
    • Project
    • Code Glossary
    • Share your feedback