Skill Topic · Cinematic

📘 SQL Quick Reference - SQL Ka Complete Cheat Sheet

Saare important SQL commands ek jagah! Jab bhi bhoolein, yahaan dekh lein! 📋

Overview

📘 SQL Quick Reference - SQL Ka Complete Cheat Sheet — Quick Facts

📌

Function: Kaam

🎯

`COUNT(*)`: Rows count

⚡

`SUM(col)`: Total

🔑

`AVG(col)`: Average

Topic 1

📌 Database Commands

📚 `sql -- Database Create: CREATE DATABASE mydb; -- Database Delete: DROP DATABASE mydb; --…

Topic 2

📌 Table Commands

💡 `sql -- Table Create: CREATE TABLE Users ( ID INT PRIMARY KEY AUTO_INCREMENT, -- MySQL…

Topic 3

📌 SELECT Queries

🎯 `sql -- Basic: SELECT * FROM Users; SELECT Name, Email FROM Users; -- Distinct (unique…

Topic 4

📌 WHERE Clause

⭐ `sql -- Comparison: SELECT FROM Users WHERE Age = 25; SELECT FROM Users WHERE Age >…

Topic 5

📌 ORDER BY & GROUP BY

🔑 `sql -- Order (Sort): SELECT FROM Users ORDER BY Name ASC; -- A to Z SELECT FROM…

Topic 6

📌 INSERT / UPDATE / DELETE

✨ `sql -- INSERT: INSERT INTO Users (Name, Email, Age, City) VALUES ('Rahul',…

Topic 7

📌 JOINs

🌟 ` INNER JOIN: LEFT JOIN: ┌────┐ ┌────┐ ┌────┐ ┌────┐ │ ┌─┼──┼─┐ │ │████┼──┼─┐ │ │ │█│ │█│…

Topic 8

📌 Subqueries

🚀 `sql -- Subquery in WHERE: SELECT * FROM Users WHERE City IN (SELECT City FROM Users…

Topic 9

📌 Set Operations

📚 `sql -- UNION (unique rows): SELECT City FROM Users UNION SELECT City FROM Suppliers; --…

Topic 10

📌 Constraints Quick Reference

💡 ` ┌────────────────────────────────────────────────────────────┐ │ CONSTRAINTS SUMMARY │…

Topic 11

📌 Views

🎯 `sql -- Create View: CREATE VIEW ActiveUsers AS SELECT Name, Email, City FROM Users WHERE…

Topic 12

📌 CASE Expression

⭐ `sql SELECT Name, Age, CASE WHEN Age < 13 THEN 'Child' WHEN Age < 18 THEN 'Teenager' WHEN…

Topic 13

📌 Aggregate Functions

🔑 | Function | Kaam | Example | |----------|------|---------| | COUNT() | Rows count |…

Topic 14

📌 String Functions Comparison

✨ | Kaam | MySQL | SQL Server | |------|-------|-----------| | Length | LENGTH(s) | LEN(s)…

Topic 15

📌 Date Functions Comparison

🌟 | Kaam | MySQL | SQL Server | |------|-------|-----------| | Current date | CURDATE() |…

Topic 16

📌 NULL Handling

🚀 `sql -- Check NULL: WHERE col IS NULL WHERE col IS NOT NULL -- Replace NULL: IFNULL(col,…

Topic 17

📌 Stored Procedures

📚 `sql -- MySQL: DELIMITER // CREATE PROCEDURE GetUsersByCity(IN cityName VARCHAR(50))…

Topic 18

📌 SQL Execution Order

💡 ` Query likhte hain: Execute hota hai: ┌──────────────┐ ┌──────────────┐ │ 1. SELECT │ │…

Topic 19

📌 SQL Injection Prevention

🎯 `sql -- ❌ GALAT (Injectable): query = "SELECT * FROM Users WHERE Name = '" + userInput +…

Topic 20

📌 Data Types Quick Ref

⭐ Numbers: | Type | Range | Bytes | |------|-------|-------| | TINYINT | -128 to 127 | 1 |…

Topic 21

📌 Wildcards Quick Ref

🔑 | Pattern | Meaning | Example | |---------|---------|---------| | % | Zero or more chars…

Topic 22

📌 Common Operators

✨ | Category | Operators | |----------|-----------| | Comparison | = != <> > < >= <= | |…

Topic 23

✅ Summary

🌟 KEY POINTS: - Yeh Quick Reference hai — jab bhi koi SQL syntax bhoolein, yahaan dekh…

Topic 24

🎉 SQL Course Complete!

🚀 ` ╔══════════════════════════════════════════════════════════════╗ ║ ║ ║ 🎓…

Comparison

📌 String Functions Comparison

⚖️

Length: LENGTH(s)

⚖️

Lowercase: LOWER(s)

⚖️

Uppercase: UPPER(s)

Comparison

📌 Date Functions Comparison

⚖️

Current date: CURDATE()

⚖️

Current time: CURTIME()

⚖️

Now: NOW()

Quick Quiz

Quiz — Question 1

📘 SQL Quick Reference - SQL Ka Complete Cheat Sheet ka sabse sahi definition kya hai?

Quick Quiz

Quiz — Question 2

📘 SQL Quick Reference - SQL Ka Complete Cheat Sheet ka 'COUNT(*)' kya hai?

Complete! 🎉

📘 SQL Quick Reference - SQL Ka Complete Cheat Sheet Complete!

Aliens School · HIEN · Cinematic Knowledge

✅