No history yet

Introduction to SQL

What is SQL?

Imagine a massive library filled with millions of books. If you needed to find every book on ancient Rome written in the last 20 years, you wouldn't just wander the aisles. You'd go to the librarian and ask a very specific question. The librarian understands your request and retrieves exactly what you need.

In the world of data, a database is that library, and SQL is the language you use to speak to the librarian. It's how you ask questions, update information, and organize everything stored inside.

SQL

noun

Stands for Structured Query Language. It is the standard programming language used to manage, manipulate, and query data stored in a relational database.

SQL works with a specific kind of database called a relational database. This might sound complex, but the idea is simple. Data is organized into tables, which look a lot like spreadsheets. Each table has columns (the categories of information, like 'Name' or 'Price') and rows (the individual records, like a specific customer or product).

Think of it this way:

  • Table: A spreadsheet (e.g., 'Customers')
  • Column: A header on the spreadsheet (e.g., 'Email')
  • Row: A single line of data in that spreadsheet (e.g., 'jane.doe@email.com')

The "relational" part means these tables can be linked together. For instance, you could have one table for customer information and another for their orders. By linking them, you can easily find all the orders placed by a specific customer without duplicating information.

Setting Up Your Workspace

To start writing SQL, you need two things: a database management system (the software that manages the database) and a way to interact with it. There are many great options, but we'll focus on PostgreSQL, a powerful and popular open-source system.

First, you'll need to install it. The process varies slightly by operating system, but the official PostgreSQL website has clear download instructions and installers for Windows, macOS, and Linux. During installation, you'll be asked to set a password for the default user, postgres. Remember this password!

Once installed, you can interact with your database using a command-line tool. For PostgreSQL, this is called psql. Opening it connects you to the database server so you can start running commands.

Basic SQL Syntax

SQL commands are called queries or statements. They are like sentences, built with specific keywords that tell the database what to do. The most common keywords you'll start with are SELECT and FROM.

  • SELECT specifies the columns you want to retrieve.
  • FROM specifies the table where the data lives.

Every SQL statement must end with a semicolon (;). This tells the database that your command is complete and ready to be executed.

-- This is a comment in SQL

-- The basic structure of a query:
SELECT column_name1, column_name2
FROM table_name;

The core logic is always the same: SELECT what you want FROM where it is.

This simple structure is the foundation of everything you'll do in SQL. By mastering this basic pattern, you'll be ready to start pulling meaningful insights from data.

Quiz Questions 1/5

What is the primary purpose of SQL (Structured Query Language)?

Quiz Questions 2/5

In a relational database, the 'relational' aspect means that different tables can be linked together.