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 username- The user's full nameemail- The user's email addressage- The user's agecity- The city where they livecreated_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.
التالي · الدرس 2 من 27
Selecting All Columns
قراءة 1 دقيقة
أنهيت 1 من 27 درسًا

اسأل Byte عن هذا الدرس
محادثة خاصة حول هذا الدرس. قرأ Byte الدرس كاملًا، ويجيب خلال ثوانٍ، ويُظهر القسم الذي تأتي منه كل إجابة. يمكنك السؤال بأي لغة.
الأسئلة والأجوبة
أسئلة عامة حول هذا الدرس. يجيب AI Tutor فورًا بلغتك، ويراجع فريق FreeAcademy الإجابات، ويمكن لكل المتعلمين قراءتها.

