AI & Machine LearningBeginnerFREENQF Qualification

Data and SQL Fundamentals

Learn how data works, from spreadsheets to relational databases. Master SQL for querying and manipulating data, then build complete data pipelines in Python -- scraping, cleaning, storing, and visualising. Essential foundations for any AI or software development career.

3 hours

26 lessons

Certificate included

Instructor

JP Instructor

Already have an account? Sign in

This course includes:

3 hours of comprehensive lessons
Hands-on coding exercises and challenges
Code examples with syntax highlighting
Certificate of completion
Lifetime access to all content
Mobile-friendly, works offline

Course Curriculum

Module 1: Data Concepts

Understand what data is, how to measure its quality, and the legal requirements for handling it in South Africa.

6 lessons

What Is Data?

Preview

4 minutes

Preview Lesson

Data Analysis Approaches

3 minutes

Data Quality and Governance

3 minutes

Data Capturing Systems

3 minutes

Data Security

4 minutes

Module 1 Quiz: Data Concepts

15 minutes

Module 2: Spreadsheet Analysis

Master spreadsheet skills for data analysis -- formulas, pivot tables, charts, and data wrangling techniques.

6 lessons

Spreadsheet Fundamentals

3 minutes

Sourcing, Cleaning and Refining Data

4 minutes

Data Wrangling

4 minutes

Pivot Tables, Charts and Dashboards

4 minutes

Data Mining and AI Visualisation

3 minutes

Module 2 Quiz: Spreadsheet Analysis

15 minutes

Module 3: SQL and Databases

Learn relational database concepts and write SQL to create, query, and manage data.

7 lessons

Relational Database Concepts

3 minutes

Database Access and Design

3 minutes

SQL Fundamentals: CREATE, INSERT, UPDATE, DELETE

3 minutes

SELECT Queries and Filtering

3 minutes

JOINs, Subqueries and Aggregation

3 minutes

Normalisation, Indexes and Database Security

4 minutes

Module 3 Quiz: SQL and Databases

15 minutes

Module 4: Python Data Pipeline

Build complete data pipelines in Python -- scrape data from the web, clean it, store it in SQL, and create visualisations.

6 lessons

Web Scraping with Python

3 minutes

Data Cleaning and Wrangling in Python

3 minutes

Loading Scraped Data to SQL

3 minutes

Data Visualisation with Matplotlib and Seaborn

3 minutes

End-to-End Data Pipeline Project

3 minutes

Module 4 Assessment: Data Pipelines

45 minutes

Module 5: Capstone Project: Student Database

Build a complete student database query tool from scratch using pure Python. This multi-step project brings together everything you have learned about data structures, filtering, aggregation, and reporting to simulate SQL-style database operations.

1 lessons

Build a Student Database Query Tool

120 minutes

Ready to Start Learning?

Join thousands of students mastering AI & Machine Learning with HardCoded