Introduction to Data Analytics with SQL

By Kayode Daniel Categories: Data Analysis
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Explore the world of data analytics through SQL. Learn how to query, aggregate, and interpret data to make informed business decisions. Perfect for beginners aiming to build a career in data analysis.

What Will You Learn?

  • How to write SQL queries for data analysis.
  • Techniques for aggregating and grouping data.
  • Combining datasets using joins and subqueries.
  • Using window functions for advanced analytics.
  • How to clean and export data for reporting.

Course Content

Module 1: Fundamentals of Data Analytics
This module introduces the concepts and processes involved in analyzing data.

  • Lesson1: Introduction to Data Analytics
    00:35
  • Lesson 2: Data Types and Data Sources
    00:22
  • Lesson 3: The Data Analytics Process (Lifecycle)
    00:00
  • Lesson 4: Essential Tools for Data Analytics
    00:00
  • Lesson 5: Basic Data Visualization Techniques
    00:00
  • Final Assessment

Module 2: SQL Basics
Database Concepts SELECT Statements and Filtering Data Sorting and Aliasing

Module 3: Aggregations and Grouping
COUNT, SUM, AVG, MIN, MAX GROUP BY and HAVING Clauses Real-World Use Cases

Module 4: Joins and Subqueries
INNER, LEFT, RIGHT, and FULL Joins Subqueries and Nested Queries Combining Data from Multiple Tables

Module 5: Window Functions and CTEs
Ranking and Partitioning ROW_NUMBER, RANK, DENSE_RANK Common Table Expressions (CTEs)

Module 6: Data Cleaning and Reporting
Handling Nulls and Duplicates Exporting and Visualizing Results Creating Reports for Business Insights

Student Ratings & Reviews

No Review Yet
No Review Yet