Data Analysis Using SQL
- Offered byCoursera
Data Analysis Using SQL at Coursera Overview
Duration | 18 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Official Website | Explore Free Course  |
Credential | Certificate |
Data Analysis Using SQL at Coursera Highlights
- Earn a certificate from
Fractal Analytics - Add to your LinkedIn profile
- September 2023
- 11 quizzes
Data Analysis Using SQL at Coursera Course details
- What you'll learn
- Extract relevant data from the database in a time efficient manner
- Build powerful SQL queries to derive insights
- Analyse and manage large datasets, and derive inferences from complex relational database
- Enable students to create and modify databases for relevant business problems
- In this comprehensive course, you will embark on a transformative journey to master the art of analyzing data through SQL.
- SQL is a powerful tool used for managing and manipulating data in relational databases. Throughout this course, you will acquire the essential skills to efficiently extract relevant data from databases, empowering you to navigate through vast amounts of information with ease.
- With a focus on practical application, you will delve into the world of data analysis, discovering how to derive meaningful insights from large datasets housed within complex relational databases. By the end of this course, you will
- Gain skills to create and modify databases, equipping you with the ability to solve real-world business problems.
- Learn to filter and clean datasets, ensuring the accuracy and reliability of your analysis.
- Whether you aspire to be a data analyst, a business intelligence professional, or a decision-maker relying on data-driven insights, this course will provide you with the necessary tools and knowledge to succeed.
Data Analysis Using SQL at Coursera Curriculum
Introduction to Data Analysis using SQL
Program Introduction
Gateway to the Course
Database and Why Relational Database?
Choosing the Right RDBMS
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
Syllabus - Data Analysis using SQL
History of Databases and Introduction to NoSQL Database
Installation of the software (Windows, Linux, and Mac)
Code Glossary - Week 1
Ungraded Quiz: Check your Understanding
Ungraded Quiz: Check your Understanding
Graded Assignment
Meet and Greet
Optional: Mysql Ungraded Lab
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
Ungraded Assignment - Check Your Understanding
End of Week Graded Assignment
Factors Affecting Revenue
Mysql Ungraded Lab
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
Ungraded - Check Your Understanding
Graded Assignment: Analysing the Food Habits of Customers Based on Meal Of The Day
Insights based on Average Delivery Time
Optional: Mysql Ungraded Lab
Analyzing Multiple Tables in SQL
A Sneak Peek into the Module
Combine Information from Different Tables Using Joins
Analysing the Food Preferences of Customers
Finding Restaurants With No Items Ordered!
Joins in SQL - Additional Reading
Code Glossary - Week 4
Ungraded Assignment - Check Your Understanding
End of week Graded Assignment - Managing Multiple Tables using SQL
Optional: Mysql Ungraded Lab
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
Introduction to the Global Problem Statement
Basic Querying of Data
Product Based Analysis of Sales
Impact of Campaign on Sales of Products
How to Remove Data from Tables
Code Glossary - Week 5 Lesson 1
Code Glossary - Week 5 Lesson 2
Ungraded Quiz: Check your Understanding
End of Week Assessment
MySQL Ungraded Lab
Data Analysis Using SQL at Coursera Admission Process
Important Dates
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?