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 →