Graduate Training 89
- Module 10: REST API Fundamentals
- Module 5: Node.js
- Module 8: Unit Testing Fundamentals
- Module 11: Password Salt + Hash Fundamentals
- Module 9: Feature Toggle Fundamentals
- Module 7: JWT Authentication
- Module 6: Express
- Module 3: Git
- Git Training Program for Graduates
- 07 - Advanced Workflows and Team Collaboration
- Linux Week2 Exam Questions
- Module 2: Linux Commands
- Mac Users: SSH & SCP Hands-On Guide (Week 2)
- Basic Linux Training - 2 Week Intensive
- Basic Linux Training - Course Index
- Week 2: System Administration & Remote Access
- Git Part 2 — Practical Exam (Week 2)
- Git Part 1 — Practical Exam (Week 1)
- Query Cost and EXPLAIN
- Module 1: MySQL
- MySQL 8+ Training Course Index
- Recursive CTEs — Traversing Hierarchies
- Correlated Subqueries — Row-by-Row Subqueries
- Nested Subqueries — Queries Within Queries
- RANK() and DENSE_RANK() — Handling Ties in Rankings
- COALESCE — First Non-NULL Value
- RIGHT JOIN
- Week 1: Linux Fundamentals
- Weeks 3–4: IDE Workflows and Professional Collaboration
- Weeks 1–2: Git Fundamentals and Branching
- 10 - Trainer Guide
- 09 - Student Worksheet (Fill-in + Exercises)
- 08 - Cheat Sheet and Practice Lab
- 06 - Branching and Merging
- 05 - Remote Collaboration
- 04 - Fixing Mistakes
- 03 - vi Quick Guide for Beginners
- 02 - Local Workflow
- 01 - Setup and Basics
- Module 4: HTML + CSS + JavaScript
- Track 3: ReactJS
- Track 5: React Native
- Track 7: Python / Machine Learning
- Track 2: Java
- Track 6: Flutter
- Track 1: C#
- Track 4: AngularJS
- My Progress Tracker
- Transactions — Ensuring Data Integrity
- ROW_NUMBER() — Numbering Rows with Window Functions
- Views — Reusable Query Logic
- Date and Time Functions — Working with Temporal Data
- Multiple Joins — Combining 3+ Tables
- Self Joins — Comparing Rows Within the Same Table
- CASE WHEN — Conditional Logic in SQL
- SUBSTRING — Extract Parts of Text
- String Functions (UPPER, LOWER)
- NULL Handling
- DISTINCT
- LEFT JOIN
- INNER JOIN
- Primary Key and Foreign Key Concepts
- HAVING vs WHERE
- GROUP BY
- Aggregate Functions
- LIMIT
- ORDER BY
- Filtering Data
- SELECT with FROM and WHERE
- DROP TABLE
- ALTER TABLE
- DELETE
- UPDATE
- INSERT
- CREATE TABLE — Building Your Database Structure
- Mini Challenge 11 — Capstone: Complete Business Intelligence Dashboard
- Mini Challenge 10 — Recursive CTEs, Dates, Views
- Mini Challenge 9 — COALESCE, Subqueries
- Mini Challenge 8 — SUBSTRING, CASE, Self Joins, Multiple Joins
- Mini Challenge 7 — NULL Handling, String Functions, and SUBSTRING
- Mini Challenge 6 — LEFT JOIN, RIGHT JOIN, and DISTINCT
- Mini Challenge 5 — HAVING, Keys, and INNER JOIN
- Mini Challenge 4 — LIMIT, Aggregate Functions, GROUP BY
- Mini Challenge 3 — SELECT, Filtering, and ORDER BY
- MySQL 8+ Training Course
- Mini Challenge 2 — ALTER TABLE, DROP TABLE
- Mini Challenge 1 — CREATE TABLE, INSERT, UPDATE, DELETE
- Database Setup: company_db
- Linux Quick Reference - Essential Commands