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.

15 hours

25 lessons

Certificate included

Instructor

JP Instructor

Already have an account? Sign in

This course includes:

15 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

20 minutes

Preview Lesson

Data Analysis Approaches

15 minutes

Data Quality and Governance

20 minutes

Data Capturing Systems

15 minutes

Data Security

20 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

20 minutes

Sourcing, Cleaning and Refining Data

20 minutes

Data Wrangling

20 minutes

Pivot Tables, Charts and Dashboards

20 minutes

Data Mining and AI Visualisation

15 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

20 minutes

Database Access and Design

15 minutes

SQL Fundamentals: CREATE, INSERT, UPDATE, DELETE

25 minutes

SELECT Queries and Filtering

25 minutes

JOINs, Subqueries and Aggregation

25 minutes

Normalisation, Indexes and Database Security

20 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

25 minutes

Data Cleaning and Wrangling in Python

25 minutes

Loading Scraped Data to SQL

20 minutes

Data Visualisation with Matplotlib and Seaborn

20 minutes

End-to-End Data Pipeline Project

25 minutes

Module 4 Assessment: Data Pipelines

45 minutes

Ready to Start Learning?

Join thousands of students mastering AI & Machine Learning with HardCoded