Data Analytics Module 2

The Basic Structured Queried Language (SQL)

Learning Outcomes: Data helps us make decisions in everyday life and in business. In this first part of the course, you’ll learn how data analysts use data analytics and the tools of their trade to inform those decisions.

Program Description and course syllabus
Introduction to the course
Helpful resources to get started
What is Data Ecosystem
How Data Informs better decisions

SQL Joins

Learning Outcomes: In this part of the course, you’ll learn to Create Joins, Use Primary and Foreign Keys, Integrate Aliases, Evaluate Various Join Types, and Integrate Filters with Joins.

Introduction to Joins
Primary and Foreign Keys
Alias
Left and Right Joins
Other Joins types
Joins and Filtering

SQL Aggregation

Learning Outcomes: The combination of JOINs and Aggregations is one of the reasons SQL is such a powerful tool. In this lesson, we will deal with NULL values, and also create aggregations in our SQL queries including COUNT, SUM, MIN & MAX etc.

Introduction to Aggregation
NULLs and Aggregation
COUNT and NULLs
SUM
MIN & MAX
AVG
GROUP BY
DISTINCT
HAVING
DATE FUNCTION
CASE STATEMENT

SQL Subqueries and Temporary Tables

Learning Outcomes: In this part of the course, we will cover subqueries, a fundamental advanced SQL topic. The lesson will focus on Creating subqueries to solve real-world problems, differentiating between Subqueries and Joins, considering the tradeoffs to using subqueries, and implementing the best subquery Strategy.

Introduction to Subqueries
Subqueries in Real-world application
Subqueries Vs Joins
Subquery Basics
Subquery Placement
Subquery Formatting
Subquery Dependencies
SQL Views
Subquery Mania
Subquery Tradeoff
Subquery Strategy

SQL Data Cleaning

Learning Outcomes: In this part of the course, you’ll learn how to clean and re-structure messy data, convert columns to different data types, manipulate NULLs with some handy tricks.

Introduction to SQL Data Cleaning
Data Cleaning Real-world Application
Data Cleaning Strategy
Commonly Used Data Functions
Advanced Cleaning Functions

Tools Required

Microsoft excel or Google sheet
MySQL
Power BI

Requirements

Ability to use the computer
Availability of internet

Course Details

N200,000

AGE

ADULT

DELIVERY

ONLINE

MODE

INSTRUCTOR-LED

DURATION

6 WEEEKS

Our Popular Courses

Browse our popular courses.

ONLINE

UI/UX Beginner Module

Students will be introduced to UI/UX design, design workspace setup, Typography and color theory and create a rapid UI/UX prototype using Figma software tool.

ONLINE

Python Programming

Students will learn Python programming using Visual Studio Code or Pycharm. Operators and Expressions, Selection control structure in python, List, Tuple, Dictionary, Number and string etc.

ONLINE

Web Development - Full Stack

Students will be able to design a functional website after learning web design concepts including HTML and CSS coding for front end and back end web development and test hosting server will be provided.