Payroll Analysis using SQL | JT's School

Autoplay
Autocomplete

Previous Lesson Complete and Continue

JRM Data Advanced (2025)

Microsoft Fabric

Getting Started with MS Fabric (124:42)
Data Factory & Data Warehouses (124:21)
Data Engineering (140:24)
Data Science & Data Activate (102:32)
Real-Time Analytics (122:06)

Tableau

Introduction to Tableau (94:04)
Preparing and Cleaning Data (122:00)
Visualizations in Tableau (174:45)
Data Analysis Techniques – Part 1 (145:32)
Data Analysis Techniques – Part 2 (142:12)
Dashboards in Tableau (136:08)
Storytelling in Tableau (110:17)
Tableau Final Project (107:55)

Projects & Workshops

Hospital Clinics Report (229:03)
Coffee Sales Report (255:32)
PwC Job Simulation Program on Forage (142:45)
Project Management, CRM & ERP (144:36)
SQL Practice (115:40)

Payroll Project

Payroll Analysis using SQL (111:11)
Payroll Power BI Visualization (123:56)

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

DATA CLOUD WITH SNOWFLAKE

Introduce To Snowflake (124:06)
Loading Data & Copy Options (109:24)
Loading Data From Cloud Provider (AWS, Azure, GCP) (127:38)
Snowpipe, Time Travel & Fail Safe (103:34)
Types Of Table, Data Sampling & Data Sharing (69:12)

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)

PYTHON

Introduce to Python & Basic syntax (112:44)
Loop and Condition Python (115:28)
Data Type and Data Frame in Python (123:59)
Simple Data Analyst With Python (122:29)
Intermediate Data Analysis with Python (159:44)
Understand Data and Visualization with Python (107:51)
Data Analysis Practice (146:45)
APIs and Demo Project Data Analysis with Python (117:22)

Projects & Workshops

Coffee Sales Report (261:20)
Hospital Clinics Report (287:06)
Tableau Dashboard Part 1 (131:21)
Tableau Dashboard Part 2 (118:44)
Forage Tata Group Visualization Project (124:38)
SQL HackerRank Cert (146:26)

Teach online with

Payroll Analysis using SQL

Lesson content locked

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

Enroll in Course to Unlock