Data Science and Machine Learning
Data Analysis with Python and Pandas
Analyze data like a pro. Use Python, Pandas, and NumPy to clean, transform, and explore datasets and extract meaningful…
USD 39
Data Science and Machine Learning
SQL for Data Analysis
Write clear, correct SQL to filter, join, aggregate and analyse data in relational databases, and turn business questions into reliable answers.
About this course
Query data with confidence. Master SQL joins, aggregations, and subqueries to pull insights from any relational database.
What you will learn
- Explain how relational databases organise data in tables linked by primary and foreign keys.
- Write SELECT queries that filter, sort, limit and calculate new columns, handling NULLs correctly.
- Summarise data with aggregate functions, GROUP BY, HAVING, CASE and date functions.
- Combine tables with the right join type and avoid dropped or duplicated rows.
- Use subqueries, CTEs, window functions and set operations for multi-step analysis.
- Plan, build, validate and speed up analysis queries that answer real business questions.
Curriculum
Module 1SQL Foundations4 lessons
- 1Databases and Tables Explained Free preview
- 2SELECT: Your Core Tool
- 3Filtering with WHERE
- 4Sorting and Limiting Results
- QModule quiz (4 questions)
Module 2Aggregation Power4 lessons
- 5COUNT, SUM, AVG and Friends
- 6GROUP BY and HAVING
- 7CASE WHEN Logic
- 8Working with Dates
- QModule quiz (4 questions)
Module 3Multiple Tables4 lessons
- 9JOINs Explained Visually
- 10Subqueries and CTEs
- 11Window Functions Introduction
- 12Set Operations
- QModule quiz (4 questions)
Module 4Analyst Workflows3 lessons
- 13Building Analysis Queries Step by Step
- 14Query Performance Basics
- 15Course Project: Answer Business Questions in SQL
- QModule quiz (4 questions)
PFinal project: Business Questions Analysis in SQL
Who this course is for
- Analysts and report writers who want to pull their own data instead of waiting for exports.
- Excel users and managers who want to work directly with company databases.
- Beginners preparing for junior data analyst, business intelligence or reporting roles.
Requirements
- A computer able to run a free database such as SQLite (with DB Browser for SQLite) or PostgreSQL.
- Basic comfort with spreadsheets and simple arithmetic; no programming experience is needed.
- Permission to install software, or access to a practice database provided by your workplace.
What is included
Written lessons
15 lessons, each with a practical exercise and key points to remember.
Module quizzes
A short quiz at the end of each module. Pass mark 70%, and you can retake it.
Final project
Business Questions Analysis in SQL. A practical brief with steps and a way to check your own work.
Certificate
A certificate of completion from EMFAD Courses with a unique code anyone can verify.
How the certificate works
Complete every lesson and pass every module quiz with 70% or more. Your certificate then appears in your learner area, ready to print or save as PDF. It shows your name, the course title, the completion date and a unique code. It is a certificate of completion from EMFAD Courses, not an accredited qualification.
More in Data Science and Machine Learning
All →Data Science and Machine Learning
Data Science Fundamentals
Enter the world of data. Learn the data science workflow, tools, and thinking needed to turn raw data into valuable insights.
USD 49
Data Science and Machine Learning
Data Visualization with Tableau
Tell stories with data. Build interactive dashboards and charts in Tableau that make complex information clear and…
USD 39