Learn SQL in a Weekend: Real-World Business Guide + Practice Dataset

Transform from SQL novice to confident data sleuth in just two days! In this hands-on eBook, you’ll step into the role of a Junior Data Analyst at Bean Town Café—a bustling coffee shop chain in Dubai—and tackle real business problems using SQL. No installations, no complicated setups: everything happens in your browser with SQLiteOnline (or any free online SQL editor).

🔹 What You’ll Learn & Do:

• Day 1 (SQL Basics): Retrieve menu items, filter beverages, and sort by price using SELECT, WHERE, and ORDER BY.
• Day 2 (Intermediate): Add new menu items, update prices, and summarize total sales per product with INSERT, UPDATE, GROUP BY, and SUM.
• Day 3 (Advanced): Join multiple tables to discover which customers bought which items, and create a “Top Customers” view using JOIN and CREATE VIEW.
• What’s Next: Guidance on sourcing real datasets, mastering visualization tools (Power BI, Tableau, Google Data Studio), and exploring advanced SQL topics (window functions, CTEs, stored procedures).

🔹 Why This Book?

• Real-World Context: Follow a proven approach I use as a Senior Data Engineer to solve actual business problems.
• Beginner-Friendly: Written for total newcomers—no prior SQL or database knowledge required. Step-by-step instructions keep you moving, not distracted by jargon.
• Practice-Ready: Includes a comprehensive dataset (products, customers, orders, order details) so you can upload straight into SQLiteOnline and run every example.

🔹 Included with Your Purchase:

1. EBook PDF: Clear explanations, sample queries, and insider tips.
2. Four CSV Files:
   • coffee_menu.csv (20 menu items, categories, prices)
   • customers.csv (100 customer profiles)
   • sales.csv (500 orders with dates)
     Upload these to SQLiteOnline and start querying immediately.

🔹 About the Author:
I’m Haroon Muhammad—a Senior Data Engineer who’s helped teams across industries turn messy data into actionable insights. I’ve designed this guide to mirror exactly how I onboard new analysts on my team: clear, practical, and fully connected to business outcomes.

Ready to level up your data skills?
Download now to start your weekend SQL crash course—and open the door to data-driven decision making, better job opportunities, and stronger business insights. 🚀