SQL Basic Query Statements | JT's School

Autoplay
Autocomplete

Previous Lesson Complete and Continue

JRM Data Advanced (2026)

Real-world Test Simulation (07/01/2026)

SQL Real Test (132:42)
Case Study: Range Optimization for Cleaning Sprays (138:07)
RFM Analysis Using SQL (111:03)
Case Study: Financial Analysis of Business Categories (60:42)
Recursion and Association Rules (89:35)
Case Study: Data-Driven Strategy for Competing with Netflix (113:16)
Cohort Analytics With Python (64:45)
Case Study: Customer Insights (54:59)
Machine Learning with Python (Part 1) (125:08)

PYTHON (10/02/2026)

Overview and Basic Syntax in Python (122:53)
Loops and Conditionals in Python (97:20)
Working with Files & Data Connections (101:10)
Fundamentals of Data Analysis & AI (112:45)
Project: Analyze Animal Shelter (112:30)
Data Visualization With Python (110:01)
Practice Test with Python
APIs and Web Scraping with Python

TABLEAU (13/01/2026)

Introduction To Tableau (106:08)
Prepare Data & Clean Data (108:13)
Visualization in Tableau (124:19)
Data Analysis Techniques – Part 1 (122:36)
Data Analysis Techniques – Part 2 (109:14)
Dashboards in Tableau (117:49)
Storytelling in Tableau (115:22)
Tableau Final Project (75:57)

Projects & Workshops (25/11/2025)

Hospital Clinics Report (156:38)
Coffee Sales Report (271:30)
Tableau Project (277:14)
Forage Project (92:21)
HackerRank Test (110:37)

Microsoft Fabric (06/11/2025)

Getting Started with Microsoft Fabric (120:21)
Data Factory & Data Warehouse (104:02)
Data Engineering (87:48)
Mini Project 1 (153:11)
Mini Project 2 (97:55)

Payroll Project (30/10/2025)

Payroll Transformation using SQL (82:14)
Payroll Power BI Visualization (60:35)

Data Cloud With Snowflake

Snowflake Introduction (105:41)
Data Loading & Data Unloading (117:45)
Data Transformation & External tools (60:31)
Data Protection, Zero-Copy Cloning & Data Sharing (129:50)
Account, Security & Performance Concepts (102:30)

SQL & Advanced Analysis

SQL Overview (114:17)
SQL Basic Query Statements (88:18)
JOIN and UNION in SQL (53:09)
Data Processing Functions (79:09)
Subquery, CTE, Temp Table & View (109:14)
Pivot Table & Window Functions (101:43)
Stored Procedure & UDF (66:17)
Test Solving (119:44)
SQL Real Test (125:43)
RFM Analysis Using SQL (88:58)
Recursion and Association Rules (81:26)
Cohort Analytics (118:55)
Machine Learning with Python (Part 1) (129:23)
Machine Learning with Python (Part 2) (137:19)

FORAGE PROJECT

PwC Job Simulation Program (107:14)
Data Science At Standard Bank (115:49)

CRM - ERP - PROJECT MANAGEMENT

Introduce CRM - ERP (128:44)
Introduce Software & Demo (129:59)
Project Management (87:40)

Teach online with

SQL Basic Query Statements

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock