SQL · Beginner
Basic Data Retrieval
The SELECT statement is used to fetch data from a database. This query retrieves two specific columns: first_name and last_name from the employees table.
Open snippet →Code library
Beginner SQL exercises
Read these Beginner SQL snippets line by line — each one comes with a written breakdown of what the code does and why.
SQL · Beginner
Creating a Table
The CREATE TABLE statement is used to create a new table in a database. You must define the name of the columns and their data types.
Open snippet →SQL · Beginner
Sorting Results
The ORDER BY keyword is used to sort the result-set in ascending (ASC) or descending (DESC) order. Here, products are sorted from most expensive to cheapest.
Open snippet →SQL · Beginner
Filtering with WHERE
The WHERE clause is used to filter records. It ensures that only rows meeting a specific condition—in this case, products with a price greater than 100—are returned.
Open snippet →SQL · Beginner
Aggregate Functions: COUNT
The COUNT() function returns the number of rows that matches a specified criterion. Using (*) counts all rows in the orders table.
Open snippet →SQL · Beginner
Updating Existing Data
The UPDATE statement is used to modify the existing records in a table. It is crucial to use a WHERE clause to specify which record(s) should be updated; otherwise, all records in the table will be…
Open snippet →SQL · Beginner
Joining Tables with INNER JOIN
INNER JOIN combines rows from two tables whenever there is a matching value in a common column. This allows you to retrieve data distributed across multiple tables in a single result set.
Open snippet →SQL · Beginner
Using Column Aliases
Aliases are used to give a table or a column in a table a temporary name. They are often used to make column names more readable or descriptive in the output.
Open snippet →SQL · Beginner
Retrieving Unique Values
The DISTINCT keyword is used in a SELECT statement to remove duplicate rows from the result set. It ensures that each returned value is unique.
Open snippet →SQL · Beginner
Deleting Data
The DELETE statement removes rows from a table. Similar to UPDATE, the WHERE clause is vital to prevent accidentally deleting all data in the table.
Open snippet →SQL · Beginner
Ensuring Data Integrity with SQL Transactions
A transaction bundles multiple database modifications into a single unit of work. Using COMMIT saves all operations permanently, ensuring data stays consistent across multiple steps.
Open snippet →SQL · Beginner
Speeding Up Database Searches with Indexes
An index acts like a book index for a table, allowing the database engine to find specific rows much faster without scanning every record.
Open snippet →SQL · Beginner
Enhancing Database Security with Views
A view provides a restricted virtual table that exposes only non-sensitive columns, preventing unauthorized access to confidential fields like passwords or social security numbers.
Open snippet →SQL · Beginner
Optimizing Query Performance by Selecting Specific Columns
Avoiding SELECT * and requesting only necessary columns reduces memory usage and network overhead, significantly improving query performance.
Open snippet →SQL · Beginner
Structuring Complex Logical Filters with Parentheses
Explicitly grouping conditions with parentheses ensures correct logical operator precedence (AND vs. OR), avoiding unexpected filtering bugs.
Open snippet →SQL · Beginner
Defining Unique Identifiers with Primary Keys
A PRIMARY KEY constraint uniquely identifies each record in a database table. Primary keys must contain unique values and cannot contain NULL values.
Open snippet →SQL · Beginner
Summarizing Numeric Data Using Aggregate Functions
Aggregate functions like COUNT and AVG compute a single result value from a set of input values across multiple table rows.
Open snippet →SQL · Beginner
Renaming Result Columns with AS Aliases
Column aliases assigned via the AS keyword temporarily rename output headers in query results to improve readability without altering underlying table columns.
Open snippet →SQL · Beginner
Checking for Missing Data Using IS NULL
Because NULL represents unknown or missing data, equality operators like = cannot compare NULL values; SQL requires using IS NULL instead.
Open snippet →SQL · Beginner
Selecting Fixed and Variable Character Lengths in Tables
When defining text columns, CHAR stores fixed-length text padding short inputs with spaces, while VARCHAR stores variable-length strings efficiently. Choosing the right data type optimizes storage…
Open snippet →SQL · Beginner
Improving Search Performance with Single-Column B-Tree Indexes
Indexes improve data retrieval speed by providing a fast lookup structure on columns frequently filtered in search conditions, reducing the need for full table scans.
Open snippet →SQL · Beginner
Bundling Related Operations in Database Transactions
Transactions group multiple SQL operations into an all-or-nothing unit of work. COMMIT saves all changes permanently, preserving data consistency across multi-step updates.
Open snippet →SQL · Beginner
Standardizing String Casing with UPPER and LOWER Scalar Functions
Scalar functions like LOWER and UPPER transform individual column values into lowercase or uppercase, helping normalize text representation across outputs.
Open snippet →SQL · Beginner
Precision Decimal Storage for Currency Data
The DECIMAL numeric data type stores exact decimal numbers with specified precision and scale. It is preferred for monetary calculations to prevent rounding errors associated with floating-point ty…
Open snippet →SQL · Beginner
Merging Multiple String Columns with CONCAT
The CONCAT scalar function combines multiple string expressions into a single text value. It simplifies formatting text output directly within SQL queries.
Open snippet →SQL · Beginner
Removing Direct Table Modification Rights with REVOKE
The REVOKE command removes specific database permissions from users or roles, enforcing the principle of least privilege for security compliance.
Open snippet →SQL · Beginner
Accelerating Lookup Operations using CREATE INDEX
Creating an index on a frequently searched column builds a supporting data structure that reduces query lookup times from linear table scans to logarithmic searches.
Open snippet →SQL · Beginner
Discarding Uncommitted Changes with ROLLBACK
The ROLLBACK command undoes all modifications performed within the current transaction, returning the database to its state before the transaction began.
Open snippet →SQL · Beginner
Granting Read-Only Privileges with GRANT SELECT
The GRANT statement is used in SQL to provide database permissions to specific users or roles. Giving SELECT privileges allows a user to read table data without giving them permission to modify or…
Open snippet →SQL · Beginner
Persisting Database Changes via COMMIT
Transactions bundle multiple SQL commands into a single unit of work. The COMMIT statement permanently saves all modifications made within the active transaction to the database.
Open snippet →