Skip to content

AJ's Techie & Wacky World

  • ✨ AI Helper
  • 🎓 Courses
  • Excel & Office
    • Charts & Dashboards
    • Excel 365 & Dynamic Arrays
    • Excel for Finance
    • Excel for India
    • Excel Formulas
    • Excel Functions A–Z
    • Excel VBA
    • Formula Combos
    • Power BI & DAX
    • Power Query & Pivots
    • Python in Excel
    • Google Workspace
    • Outlook
    • PowerPoint
    • Word
  • Coding
    • Cloud & Servers
    • Dev Tools
    • Java
    • JavaScript
    • PowerShell
    • Python
    • R
    • Rust
    • SQL
    • VBA to Python Migration
  • Automation
    • AutoHotkey
    • Automation Basics
    • Office Scripts
    • Power Automate
    • Python Automation
    • SAP GUI Scripting
  • AI & ML
    • AI Agents & RAG
    • AI Agents & Workflows
    • AI Tools
    • Build Your Own LLM
    • Deep Learning
    • LLMs
    • Machine Learning
    • Prompt Engineering
    • Vibe Coding
  • ERP
    • Essbase
    • Oracle EPM Cloud
    • Oracle Smart View
    • SAP
    • Tally & Busy
    • Tax & Compliance
  • Tech Tips
    • Internet & Browser
    • Phone
    • Security & Privacy
    • Windows
    • Work Smarter
  • Wacky World
    • Fun Facts
    • History
    • Science
    • All Wacky Facts
  • Tools
    • Formula Lab
    • VBA Playground
    • Macro Recorder
    • VBA Challenges
    • SQL Playground
    • Shortcut Trainer
    • Date & Workday Calculator
    • EMI & SIP Calculator
    • Income Tax: Old vs New
    • GST Calculator
    • Regex Tester
  • About
    • Projects
    • Contact
  • 📲 Get App
AutoHotkey Lesson 1: Install AutoHotkey v2 and Your First Hotkey

11 Sep 2023 · AutoHotkey · 1 min read

AutoHotkey Lesson 1: Install AutoHotkey v2 and Your First Hotkey

Install AutoHotkey v2, create and run a script, write your first hotkeys with modifier symbols, reload and exit scripts, and start scripts with Windows.

Read article →
STDEVA Function in Excel: Sample SD Counting Text and TRUE/FALSE

6 Sep 2023 · Excel Functions A–Z · 1 min read

STDEVA Function in Excel: Sample SD Counting Text and TRUE/FALSE

STDEVA is STDEV.S that also counts text as 0 and TRUE as 1; STDEV.S ignores them.

Read article →
SQL Intermediate Lesson 10: Project – Customer RFM and Outstanding Payments

4 Sep 2023 · SQL · 2 min read

SQL Intermediate Lesson 10: Project – Customer RFM and Outstanding Payments

Final project: recency, frequency and monetary scores with NTILE, customer segments, outstanding receivables per customer and average collection days by payment mode.

Read article →
SQL Intermediate Lesson 9: Indexes and Query Plans

3 Sep 2023 · SQL · 2 min read

SQL Intermediate Lesson 9: Indexes and Query Plans

Read EXPLAIN QUERY PLAN, see SCAN turn into SEARCH with an index, build covering indexes, and learn why functions on columns stop indexes working.

Read article →
SQL Intermediate Lesson 8: Pivot Reports With CASE

2 Sep 2023 · SQL · 2 min read

SQL Intermediate Lesson 8: Pivot Reports With CASE

Turn rows into columns with conditional aggregation: sales by status per region, orders per quarter, payment-mode mix and actual vs target with % achieved.

Read article →
SQL Intermediate Lesson 7: Recursive CTEs – Org Charts and Date Series

1 Sep 2023 · SQL · 2 min read

SQL Intermediate Lesson 7: Recursive CTEs – Org Charts and Date Series

Walk a manager hierarchy, build reporting paths, total a team's salary cost and generate a calendar to find days with no orders, using WITH RECURSIVE.

Read article →
SQL Intermediate Lesson 6: UNION, INTERSECT and EXCEPT

31 Aug 2023 · SQL · 2 min read

SQL Intermediate Lesson 6: UNION, INTERSECT and EXCEPT

Combine and compare result sets: one list from two tables, customers who bought both products, customers who never bought one, and activity timelines with UNION ALL.

Read article →
SQL Intermediate Lesson 5: Joins in Depth – Anti-Joins, Self-Joins, Cross Joins

30 Aug 2023 · SQL · 2 min read

SQL Intermediate Lesson 5: Joins in Depth – Anti-Joins, Self-Joins, Cross Joins

Find unpaid orders with LEFT JOIN ... IS NULL and NOT EXISTS, list employees with their managers via a self-join, and fill zero months with CROSS JOIN.

Read article →
SQL Intermediate Lesson 4: LAG and LEAD – Month-on-Month Growth

29 Aug 2023 · SQL · 2 min read

SQL Intermediate Lesson 4: LAG and LEAD – Month-on-Month Growth

Compare each row with the previous or next one: month-on-month growth %, days between a customer's orders and the next order date with LAG and LEAD.

Read article →
SQL Intermediate Lesson 3: Running Totals and Moving Averages

28 Aug 2023 · SQL · 2 min read

SQL Intermediate Lesson 3: Running Totals and Moving Averages

Running totals, year-to-date by region, 3-month moving averages and share of total with SUM() OVER and window frames (ROWS BETWEEN).

Read article →
SQL Intermediate Lesson 2: Window Functions – ROW_NUMBER, RANK, DENSE_RANK

27 Aug 2023 · SQL · 2 min read

SQL Intermediate Lesson 2: Window Functions – ROW_NUMBER, RANK, DENSE_RANK

Rank customers, find the top customer in each region and each customer's latest order with ROW_NUMBER, RANK, DENSE_RANK and PARTITION BY.

Read article →
SQL Intermediate Lesson 1: Common Table Expressions (WITH)

26 Aug 2023 · SQL · 2 min read

SQL Intermediate Lesson 1: Common Table Expressions (WITH)

Write readable SQL with CTEs: name a subquery once, chain several steps, compare each customer with the average and compute category shares.

Read article →
Older posts
Newer posts
← Previous Page1 … Page61 Page62 Page63 … Page107 Next →

AJ's Techie & Wacky World

Curated by Atul Vij • © 2026 • All Rights Reserved

About Courses Free Tools Templates Privacy Policy Contact GitHub
Did you know?

Why? →