This course will be available soon

SQL for Data Analysis — Managing and Analyzing

This course takes you beyond the basics of SQL into the world of data analysis and reporting. You will learn ... Show more

Instructor

opensigma training hub

0 reviews

Description
Curriculum
Reviews
Grade

SQL for Data Analysis ,in blue background.jpg

This course takes you beyond the basics of SQL into the world of data analysis and reporting. You will learn how to manage, manipulate, and analyze large datasets using SQL queries, subqueries, joins, and window functions. By the end, you’ll be able to extract meaningful insights from raw data and prepare it for business intelligence tools like Power BI or Excel.

Module 1: Working with Multiple Tables

1

Understanding relational joins

Video lesson
2

Types of joins: INNER, LEFT, RIGHT, FULL

Video lesson
3

Combining multiple tables in one query

Video lesson
4

Real-world example: Joining sales, customers, and product tables

Video lesson
5

Assisgnment

Assignment

Module 2: Grouping and Aggregation

6

Using GROUP BY and HAVING

Video lesson
7

Aggregate functions: SUM, AVG, COUNT, MAX, MIN

Video lesson
8

Creating summary tables and reports

Video lesson
9

Filtering groups and computed results

Video lesson
10

Practical Exercise

Assignment

Module 3: Subqueries and Common Table Expressions (CTEs)

11

Writing subqueries in SELECT, FROM, and WHERE

Video lesson
12

Using correlated subqueries

Video lesson
13

Simplifying complex logic with CTEs

Video lesson
14

Improving readability and performance

Video lesson
15

Activity

Assignment

Module 4: Data Cleaning and Transformation

16

Detecting and removing duplicates

Video lesson
17

Handling nulls and missing data

Video lesson
18

Changing data types

Video lesson
19

Creating calculated and derived columns

Video lesson
20

Converting messy data into structured tables

Video lesson
21

Mini Project: Clean and prepare a messy dataset for analysis.

Assignment

Module 6: Final Project — Real Data Analysis

22

Final Project

Assignment

Please, login to leave a review

Course:

Student:

Enrollment date:

Course completion date:

Grade:

Grade Points

Grade Range

Regenerate Grades

Exams:

Add to wishlist

Coming soon

Course details

Lectures 17

Assignments 5

Level Intermediate

Course requirements

Completion of SQL for Beginners or equivalent foundational knowledge.
Familiarity with relational databases and basic SELECT, WHERE, and JOIN operations.
Access to a SQL environment (MySQL, PostgreSQL, or SQLite).