Skip to content

Ravindra BagaleCourses & study guides

SQLSQLite · analyst path AWS Cloud18 chapters Microsoft AzureBeginner path DevOps46 chapters Power BI35 chapters Excel31 chapters Data Science24+ chapters Data EngineeringBeginner path Cyber Security50 chapters Generative AI52 chapters

Guides About Enquiry

Track your progress

Menu

Home
SQL
AWS Cloud
Power BI
Excel
Data Science
Data Engineering
Generative AI
Guides
Enquiry
About

Datasets
Ravi Sir's Cards
What Is SQL and Why Analysts Need It
Install SQLite and DB Browser (Windows and Mac)
SELECT Basics: Read Rows Without Changing Data
WHERE: Keep Only the Rows You Need
ORDER BY, DISTINCT and Top-N Results
SQL Data Types Analysts Actually Meet
NULL Values: Missing Data Done Right
CASE WHEN: If-Then Logic in SQL
Date and Time Queries for Analysts
Text Functions Analysts Use Daily
Aggregate Functions: SUM, COUNT आणि AVG aggregates MIN MAX
GROUP BY: One Row Per Group
HAVING: Filter Groups After Aggregates
Why Tables Join: Keys and Relationships
INNER JOIN and LEFT JOIN (The Two You Need First)
SQL for Excel Users (Term Map + Side-by-Side)

Home
SQL
Ravi Sir's Cards

CASE vs WHERE

CASE vs WHERE. WHERE decides which rows appear in the result. CASE adds a label or a new value to the rows you keep. — Download PNG · Open lesson

Live batch madhe shikaycha aahe? Online / offline training with Ravindra Bagale – AWS, Azure, DevOps, Data Analytics, Power BI, Cyber Security, SQL.

Enquire now → Chat on WhatsApp

Share:

Ravindra Bagale · Trainer

LinkedIn: linkedin.com/in/ravindra-bagale · Instagram: @ravindrabagale · Enquiry

About · Contact · Privacy Policy · Terms and Disclaimer · Editorial Policy