Data Science & Analytics

Data Analysis with Python & SQL

Learn Python, SQL, data cleaning, analysis, visualization, and business insight communication for analyst roles.

16 weeks DurationPrior experience helpful Learning supportOnline / Hybrid Format

Enroll for this course Ask admissions

Data Analysis with Python & SQL at Loctech

Tuition₦430,000VAT-inclusive where applicable. Instalment plans are available.

What you will learn

Graduate with skills you can demonstrate.

Analyze datasets with Python and SQL

Answer business questions with data

Prepare for data analyst roles

Upcoming classes

Choose a published intake.

Dates shown here come from the Loctech class system.

The next intake is being confirmed.

Admissions will confirm the start date, class time, learning format, and availability before you make a commitment.

Ask for the next class date

Curriculum

A clear path from foundation to project.

17 modules / 16 weeks

01INTRODUCTION

Introduction to Data Analysis

SETTING UP THE ENVIRONMENT

02PYTHON BASICS

PYTHON BASICS

Conditional Statement

03SEQUENCES

SEQUENCES

04ITERATION

The detailed lesson outline for this module is being reviewed by the academic team.

05ITERATION

Loops

06FUNDAMENTALS FOR CODING IN PYTHON

FUNDAMENTALS FOR CODING IN PYTHON

07INTRODUCTION TO NUMPY AND PANDAS

INTRODUCTION TO NUMPY AND PANDAS

08INTRODUCTION TO PANDAS

Introduction to pandas Library

09WORKING WITH TEXT FILES

File input and Output

10WORKING WITH TEXT DATA

WORKING WITH TEXT DATA

11DATA CLEANING AND TRANSFORMATION

CLEANING AND TRANSFORMATION

12EXPLORATORY DATA ANALYSIS (EDA)

EXPLORATORY DATA ANALYSIS

13MEASURES OF CENTRAL

MEASURES OF CENTRAL

14PROBABILITY AND DISTRIBUTIONS

PROBABILITY

DISTRIBUTION

CORRELATION

15DATA VISUALIZATION

MATPLOTLIB

SEABORN

16REGRESSION ANALYSIS

REGRESSION ANALYSIS

17SQL FOR DATA SCIENCE

Introduction to SQL

SQL Query Basics

SQL Joins

Filtering and Sorting

SQL Aggregations

Subqueries and Temp Tables

SQL Data Cleaning and Transformation

Before the first class

Know what you need and where the course can take you.

Prerequisites

Basic mathematics (algebra, statistics)

No prior programming experience required

Analytical mindset

Access to a laptop/computer

Tools you will practise with

Python

SQL

Pandas

Jupyter notebooks

Matplotlib

Project experience

Build work worth showing.

Project 01

A portfolio-ready capstone project

Project 02

Guided practical exercises

Completion credential

Earn a verifiable Loctech certificate.

Verifiable Loctech certificate of completion with an industry-aligned curriculum.

Questions answered

Before you apply.

Do I need prior experience?

Beginner tracks assume no prior experience.

Can I learn online?

Yes — most programs run hybrid and online with live instructor-led classes.

Do I get a certificate?

Yes — a verifiable Loctech certificate on completion.

All programmes