APEX Educational Institute

Free Data + AI Tutorials

Data Analytics, Data Engineering and Data Science, each with AI.

  1. 1SQL Joins Explained with Examples (INNER, LEFT, RIGHT, FULL)Learn SQL joins with two small tables and clear result sets: INNER, LEFT, RIGHT, FULL OUTER and SELF joins, plus finding unmatched rows and the most common join mistakes.Beginner | 4 min read
  2. 2Data Cleaning with Python pandas: A Practical TutorialClean a messy real-world dataset with pandas step by step: inspect data, fix column names and types, handle missing values and duplicates, standardise text and treat outliers.Beginner | 3 min read
  3. 3ETL vs ELT: Data Pipeline Basics for BeginnersUnderstand what a data pipeline is, the difference between ETL and ELT, batch vs streaming, data warehouse vs data lake, and build a tiny ETL job in Python.Beginner | 3 min read

Go deeper with a live online course

Data + AI

Data Science + AI

Python, statistics, machine learning and Generative AI for data.

22 weeks Beginner to Advanced
Online LiveRecorded Course