Why SELECT is the most important command in SQL - See It in Action

Why SELECT is the most important command

📖 Scenario: You are working as a data assistant in a small bookstore. The store keeps track of books and their details in a database. You need to learn how to get information from this database to help customers find books.

🎯 Goal: Build a simple database query project that shows how to use the SELECT command to get information from a books table.

📋 What You'll Learn

Create a table called books with columns id, title, and author

Insert three specific books into the books table

Write a SELECT query to get all columns from the books table

Write a SELECT query to get only the title column from the books table

💡 Why This Matters

🌍 Real World

Bookstores, libraries, and many businesses use SELECT to find and show data they need quickly.

💼 Career

Knowing how to use SELECT is essential for database jobs, data analysis, and any role that works with data.

1

Create the books table

Write a SQL command to create a table called books with three columns: id as an integer primary key, title as text, and author as text.

SQL

-- Write the CREATE TABLE command for books
-- Your code here

Need a hint?

Use CREATE TABLE books and define the columns with their types.

2

Insert three books into the books table

Write three SQL INSERT INTO books commands to add these books exactly: (1, 'The Hobbit', 'J.R.R. Tolkien'), (2, '1984', 'George Orwell'), and (3, 'To Kill a Mockingbird', 'Harper Lee').

SQL

CREATE TABLE books (
  id INTEGER PRIMARY KEY,
  title TEXT,
  author TEXT
);
-- Insert the three books below
-- Your code here

Need a hint?

Use INSERT INTO books (id, title, author) VALUES (...) for each book.

3

Select all columns from the books table

Write a SQL SELECT query to get all columns from the books table.

SQL

CREATE TABLE books (
  id INTEGER PRIMARY KEY,
  title TEXT,
  author TEXT
);
INSERT INTO books (id, title, author) VALUES (1, 'The Hobbit', 'J.R.R. Tolkien');
INSERT INTO books (id, title, author) VALUES (2, '1984', 'George Orwell');
INSERT INTO books (id, title, author) VALUES (3, 'To Kill a Mockingbird', 'Harper Lee');
-- Write a SELECT query to get all columns from books
-- Your code here

Need a hint?

Use SELECT * FROM books; to get all columns.

4

Select only the title column from the books table

Write a SQL SELECT query to get only the title column from the books table.

SQL

CREATE TABLE books (
  id INTEGER PRIMARY KEY,
  title TEXT,
  author TEXT
);
INSERT INTO books (id, title, author) VALUES (1, 'The Hobbit', 'J.R.R. Tolkien');
INSERT INTO books (id, title, author) VALUES (2, '1984', 'George Orwell');
INSERT INTO books (id, title, author) VALUES (3, 'To Kill a Mockingbird', 'Harper Lee');
SELECT * FROM books;
-- Write a SELECT query to get only the title column
-- Your code here

Need a hint?

Use SELECT title FROM books; to get only the titles.