SQL उजळणी, मुलाखत आणि तुलना Cards (Ravi Sir's Cards, मराठी)
सोप्या मराठीत SQL cards: 16 उजळणी, 16 मुलाखत आणि 16 तुलना. प्रत्येक card स्वतंत्र. PNG save करा; QR पूर्ण lesson उघडतो.
Chapters
- What Is SQL and Why Analysts Need It (3 cards)
- Install SQLite and DB Browser (Windows and Mac) (3 cards)
- SELECT Basics: Read Rows Without Changing Data (3 cards)
- WHERE: Keep Only the Rows You Need (3 cards)
- ORDER BY, DISTINCT and Top-N Results (3 cards)
- Analysts ना रोज भेटणारे SQL Data Types (3 cards)
- NULL Values: Missing Data Done Right (3 cards)
- CASE WHEN: If-Then Logic in SQL (3 cards)
- Analysts साठी Date आणि Time queries (3 cards)
- Analysts रोज वापरतात ती Text Functions (3 cards)
- Aggregate Functions: SUM, COUNT आणि AVG aggregates MIN MAX (3 cards)
- GROUP BY: One Row Per Group (3 cards)
- HAVING: Aggregate नंतर groups filter करा (3 cards)
- Tables join का होतात: Keys आणि Relationships (3 cards)
- INNER JOIN आणि LEFT JOIN (आधी लागणारे दोन joins) (3 cards)
- SQL for Excel Users (Term Map + Side-by-Side) (3 cards)