Meet Your SQL Playground

Welcome to Interactive SQL Practice! This course is different from traditional tutorials - here, you'll learn by doing. Every lesson includes a live SQL editor where you can write and run real queries instantly.

Your First Look at the Playground

Below is your SQL playground. It has three main parts:

• Schema Panel (left): Shows you all available tables and their columns
• Editor (top): Where you write your SQL queries
• Results (bottom): Shows the output of your query

Try clicking "Run" or pressing Ctrl+Enter (Cmd+Enter on Mac) to execute the pre-filled query:

Understanding the Schema

The schema panel on the left shows you the database structure. Click on a table name to see its columns. For this first module, we're working with a simple users table that contains:

• id - A unique identifier for each user
• name - The user's full name
• email - The user's email address
• age - The user's age
• city - The city where they live
• created_at - When the account was created

Quick Tips

Before moving forward, here are some tips for using the playground:

• Run queries: Click the "Run" button or press Ctrl+Enter
• Reset database: If you modify data and want to start fresh, click "Reset DB"
• Explore schema: Click on table names in the left panel to see column details
• Case doesn't matter: SQL keywords like SELECT and select work the same way (but UPPERCASE is conventional)

Try It Yourself

Modify the query in the playground above. Try these variations:

-- Get just names and emails
SELECT name, email FROM users;

-- Get users from a specific city
SELECT * FROM users WHERE city = 'New York';

-- Count how many users exist
SELECT COUNT(*) FROM users;

When you're comfortable with the playground, continue to the next lesson where we'll start with proper SELECT exercises.