Mercy ⭐ Data Analyst

Essential SQL Commands & Functions Cheatsheet Here's a quick reference of key SQL operations to know: ➜ SELECT → Retrieve data from a table ➜ WHERE → Filter rows based on condition ➜ GROUP BY → Aggregate rows with same values ➜ HAVING → Filter groups after aggregation ➜ ORDER BY → Sort result by one or more columns ➜ JOIN → Combine rows from multiple tables ➜ UNION → Merge result sets into one ➜ INSERT INTO → Add new data into a table ➜ UPDATE → Modify existing records ➜ DELETE → Remove records ➜ CREATE TABLE → Define a new table ➜ ALTER TABLE → Modify an existing table ➜ DROP TABLE → Delete a table ➜ TRUNCATE TABLE → Remove all records ➜ DISTINCT → Get unique values ➜ LIMIT → Restrict number of results ➜ IN / BETWEEN → Filter by multiple values/ranges ➜ LIKE → Pattern matching ➜ IS NULL → Filter NULL values ➜ COUNT() / SUM() / AVG() → Common aggregate functions Hope this helps you 😊

📊 DATA ANALYST CORE SKILLS 1️⃣ Excel → Data Handling 2️⃣ SQL → Data Extraction 3️⃣ Statistics → Data Interpretation 4️⃣ Power BI → Visualization 5️⃣ Python → Automation 6️⃣ Communication → Present Insights 7️⃣ Business Knowledge → Make Better Decisions