Your First Look at a Query
Write your very first SELECT statement, understand FROM and WHERE, and see real query results — no setup needed, just the concept.
Your First Look at a Query is a free SQL Academy lesson on CoddyKit — lesson 3 of 3. You can read the complete lesson below for free — then practise it hands-on in the browser with a built-in code editor and a 24/7 AI tutor. It is part of the SQL Academy learning path, one of 3 lessons in the course, and your progress syncs across the web and the CoddyKit app.
Let's read a query
Time to look at a full query together. Don't worry, we'll go one little piece at a time. 🔍
Here it is
This query asks for the names of users from the users table. Read it like a sentence.
SELECT name FROM users;Part 1: SELECT
SELECT is the verb. It says 'show me'. Right after it, you list the columns you want.
Part 2: the column
Here we wrote 'name', so we only want the name column. Want more? Just separate them with commas.
Part 3: FROM users
FROM users points SQL to the right table. Now it knows exactly where to look.
The semicolon
That little ';' at the end just says 'I'm done.' Like a period at the end of a sentence.
Want everything?
Use a star to grab every column at once. The '*' is a handy shortcut for 'all columns'. ⭐
SELECT * FROM users;Try it for real
Here's a tiny self-contained query you can run. It just picks a friendly greeting. Give it a go!
SELECT 'Hello, SQL!' AS greeting;You can read SQL now
See? A query is just SELECT, some columns, FROM, and a table. You can read it like a sentence.
Amazing work
You went from zero to reading real SQL queries. That's a huge first step. Be proud! 🎉
Quick Check
Last one! In 'SELECT name FROM users;', what does the 'users' part tell SQL?
Frequently asked questions
Is the “Your First Look at a Query” lesson free?
Yes — the full text of “Your First Look at a Query” is free to read here on the web, and the SQL Academy course includes 3 lessons in total. To practise it interactively (a built-in code editor and a 24/7 AI tutor) and unlock the rest of the SQL Academy course, upgrade to CoddyKit PRO.
What will I learn in “Your First Look at a Query”?
Write your very first SELECT statement, understand FROM and WHERE, and see real query results — no setup needed, just the concept. You practise SQL Academy with hands-on code you run directly in the browser, and a 24/7 AI tutor answers your questions as you work through the lesson.
Do I need any experience to start SQL Academy?
No prior experience is required. SQL Academy on CoddyKit is structured for beginners through advanced learners; this is — lesson 3 of 3, so you can start here or from the beginning and move at your own pace.
How long does the “Your First Look at a Query” lesson take?
Most CoddyKit lessons take about 5–10 minutes. Each one is bite-sized and interactive, so you make steady progress and pick up exactly where you left off across the web and the app.
Can I write and run code in this SQL Academy lesson?
Yes. Every SQL Academy lesson includes a built-in code editor, so you write and run real code right in your browser and get instant AI feedback — no local setup required.
All lessons in this course
- What is a Database?
- What is SQL?
- Your First Look at a Query