The SQL Query Coach
@SQLQueryCoach
Followers
22
Following
25
Media
9
Statuses
63
SQL & Database Enthusiast 💻 | Simplifying data, one query at a time | Tutorials, tips & backend logic | #SQL #Database #Coding
Kampala
Joined September 2022
👋 Hi, I’m The SQL Query Coach! I make databases simple & powerful — sharing easy SQL, database design & backend tutorials. 🎥 Watch & subscribe: https://t.co/PpCPDY6JY3 Let’s make data work smarter — one query at a time ⚙️💡 #SQL #Database #CodingJourney #Tech
0
0
0
If your query feels long, break it into CTEs. Readable > fancy. #CTE #SQLStyle #DataEngineering #TheSQLQueryCoach
youtube.com
SQL for beginners
0
0
0
Beginner developers ask: Which language should I learn? Experienced developers ask: What problem am I solving? Most 'hate' around languages comes from using them outside their strengths. Longevity in tech isn't about hype it's about understanding fundamentals and context.
0
0
0
There are no 'hated' programming languages only misunderstood ones. Every language that still exists does so because it solves real problems at scale. PHP powers the web. Java runs banks. COBOL runs governments. The real skill isn't picking trendy tools it's choosing the right
0
0
0
@Tawakkalah13_10 The word 'Hated is' often just shorthand for 'misused' or 'judged out of context.' Every language on this list exists because it solves real problems at scale. The issue isn’t the language it's choosing the wrong tool for the job or maintaining it poorly. Mature languages
1
1
0
Normalize your data, but not too much. Balance matters. Good databases are practical, not perfect. #DatabaseDesign #SQLArchitecture #TheSQLQueryCoach
youtube.com
SQL for beginners
0
0
0
@SQLQueryCoach @ezekiel_aleke You nailed it 🤝. With python you can do alot in data analytics.
1
1
1
@webdeveloper_NG 🤣 This brings back memories! I was actually the first guy in my class to write a completely bogus HTML page everyone laughed, smiled and got interested and then spent the rest of the course looking for me whenever they got stuck. We all start somewhere, and that’s what makes the
0
1
1
@ezekiel_aleke A solid progression, but worth remembering the best tool is the one that helps you understand the data, not just use it. Excel builds intuition, SQL builds structure, BI tools build storytelling, and Python scales everything up. The real skill is knowing when to use each not just
1
1
4
COUNT(*) tells you how many rows exist. COUNT(column) tells you how many values are NOT null. Simple but important. #SQLTips #DataQuality #TheSQLQueryCoach
youtube.com
SQL for beginners
1
0
0
A good SQL query answers a business question, not just returns rows. Think beyond code. Think value. #BusinessIntelligence #SQLThinking #TheSQLQueryCoach
youtube.com
SQL for beginners
0
0
0
@fidexcode In my opinion, backend is easier to learn not because it's ‘easy’, but because it’s more consistent. Frontend changes every month, new frameworks, new build tools, new styling approaches, browser quirks, responsive issues, accessibility rules, component patterns, UX expectations
1
1
1
The correct query is B. SELECT Date, SUM(Amount) OVER (ORDER BY Date) FROM Sales; Let me give a breakdown of why (B) works: SUM(Amount), specifies the aggregation function to use. OVER (ORDER BY Date), is the window function clause. It tells the database engine to perform the
Do you really know SQL? 😊 Day 20/30 Which query returns the running total of sales by date? A. SELECT Date, SUM(Amount) FROM Sales GROUP BY Date; B. SELECT Date, SUM(Amount) OVER (ORDER BY Date) FROM Sales; C. SELECT Date, RUNNING(Amount) FROM Sales;
0
0
0
If you want to become a world-class software engineer (in 2026), read these 12 books... 🧵
38
205
1K
System Design 2026: Master the 25 Case Studies That Get You Hired. Get all 25+ System Design Case Studies here; https://t.co/uAYxZoqceH
15
10
107
Always write readable SQL. Future-you will thank past-you. Indent. Space. Comment. #CleanCode #SQLBestPractices #TheSQLQueryCoach
https://t.co/D9H9HLk5y4
youtube.com
SQL for beginners
0
0
0
🚨 SQL Challenge (No1) If you run this query, it will definitely throw an error 👇 🤔 What error message do you think this will print? Drop your answers below! ⬇️
0
0
0
SQL is the gateway to Data Science. If you can extract clean data, models become easier. #DataScienceJourney #SQLPower #TheSQLQueryCoach
youtube.com
SQL for beginners
0
0
0
Every data analyst should learn: • SELECT • GROUP BY • HAVING • JOIN • SUM() • COUNT() These 6 make you unstoppable. #Analytics #SQLFundamentals #DataSkills #TheSQLQueryCoach
youtube.com
SQL for beginners
0
0
0