Day 1 SQL Demo | GMBA 612

📋 Available Tables (8 total)

Customers

91 records

Categories

8 records

Employees

10 records

OrderDetails

518 records

Orders

196 records

Products

77 records

Shippers

3 records

Suppliers

29 records

Your First Query

SELECT *

💼 BUSINESS QUESTION

"Show me all our customers."

SELECT * FROM Customers;

🎓 KEY TAKEAWAY

The asterisk (*) means "everything." This is how you explore a table you've never seen before. 91 customers appear — you just pulled data from a database!

Pick What You Need

SELECT columns

💼 BUSINESS QUESTION

"I just need customer names and their cities for a mailing list."

SELECT CustomerName, City FROM Customers;

🎓 KEY TAKEAWAY

You don't always need everything. Selecting specific columns is faster and cleaner — especially when tables have 50+ columns.

Filter Your Data

WHERE

💼 BUSINESS QUESTION

"We're expanding in Germany. Who are our German customers?"

SELECT CustomerName, City FROM Customers WHERE Country = 'Germany';

🎓 KEY TAKEAWAY

WHERE filters rows. Only 11 German customers appear. Notice the single quotes around 'Germany' — text values need quotes.

🧪 STUDENT CHALLENGE

Find all customers in the USA. (Give them 1 minute to try.)

Filter by Numbers

WHERE + comparison

💼 BUSINESS QUESTION

"Which products cost more than $50? We need to review our premium pricing."

SELECT ProductName, Price FROM Products WHERE Price > 50;

🎓 KEY TAKEAWAY

Numbers don't need quotes. You can use > < >= <= = and <> (not equal). Only 7 premium products here.

🧪 STUDENT CHALLENGE

Find products under $20. How many are there?

Sort Results

ORDER BY

💼 BUSINESS QUESTION

"What are our most expensive products? Show me the top-priced items first."

SELECT ProductName, Price FROM Products ORDER BY Price DESC;

🎓 KEY TAKEAWAY

ORDER BY sorts results. DESC = descending (highest first), ASC = ascending (lowest first, this is the default). "Côte de Blaye" at $263.50 is the priciest!

Combine Conditions

AND / OR

💼 BUSINESS QUESTION

"Find affordable beverages — drinks under $20."

SELECT ProductName, Price FROM Products WHERE CategoryID = 1 AND Price < 20;

🎓 KEY TAKEAWAY

AND means both conditions must be true. OR means either condition works. CategoryID 1 = Beverages (we'll learn JOINs later to see the actual category name).

Count Things

COUNT()

💼 BUSINESS QUESTION

"How many orders did we process?"

SELECT COUNT(*) FROM Orders;

🎓 KEY TAKEAWAY

COUNT() is your first "aggregate function" — it summarizes data. Result: 196 orders. We'll learn more functions like SUM, AVG, MAX, MIN soon.

Sneak Peek: Connecting Tables

JOIN (preview)

💼 BUSINESS QUESTION

"Show me orders with customer names — not just IDs."

SELECT Top 10 Orders.OrderID, Customers.CustomerName, Orders.OrderDate FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;

🎓 KEY TAKEAWAY

This is a JOIN — connecting two tables through a shared column (CustomerID). This is where SQL gets powerful. We'll master this in Week 4. For now, just see that it's possible!

✓

What You Just Learned

SELECT -- Pick columns FROM -- Choose table WHERE -- Filter rows ORDER BY -- Sort results

🎯 KEY TAKEAWAY

You just asked a database 8 business questions and got instant answers. This is what data analysts do every day. By Week 5, you'll be writing queries twice this complex without thinking twice.

🚀 Day 1 SQL Demo

📋 Available Tables (8 total)