Oracle Live SQL Tutorial: Learn SQL Basics, No Setup Required!

We use SQL (Structured Query Language) to communicate with the data that drives the modern world. SQL is a necessary first step if you want to develop apps, examine business performance, or work as a data scientist. But it can be frustrating to get started. Before you can write your first line of code, you are frequently instructed to download database software, configure servers, and create user accounts.

Ignore all of that! Oracle Live SQL, a free browser-based environment that requires no installation, is what we’re learning with today. With pre-loaded tables for practice, it provides you with immediate access to an actual, functional Oracle database. This means you can skip the setup headaches and dive straight into querying. By the end of this tutorial, you’ll be able to log in, navigate the interface, and write your first fundamental SQL queries using the core commands: SELECT, FROM, and WHERE.

Section 1: Accessing the Live SQL Environment

Getting started takes just a minute.

1. Go to the URL: Navigate directly to the Oracle Live SQL website.
2. Sign In: You will need a free Oracle account to use the tool. If you don’t have one, the sign-up process is quick. Once logged in, you’ll land on a dashboard.
3. Find Your Workspace: Search for the “SQL Worksheet” link or tab. This is your command center, where all of your code will be written and run. To launch your first clean editor, click it.

Section 2: Getting Familiar with the Interface

The Live SQL environment is split into three main, user-friendly areas:

1. The Editor (Input): This large text area is where you type your SQL statements. Think of it as your notepad for talking to the database. (If you eventually move to a dedicated desktop tool, you might be interested in a guide on how to use a robust application like MySQL Workbench.)
2. The Run Button (Execution): usually a play icon or a “Run” or “Execute” button. Your code is sent to the database for processing when you press this button.
3. The Results Tab (Output): When you press ‘Run,’ this section shows up beneath the editor. The resultant data table will appear here if your query is successful. The error message will appear in its place if there is a problem.

The Beginner’s Crucial Shortcut: Sample Schemas

The availability of Sample Schemas (such as SCOTT and HR for Human Resources) is a potent feature of Oracle Live SQL. These are pre-loaded sets of dummy data-filled tables (e.g., departments, employees). This is revolutionary! You can begin querying actual, structured data right away without having to spend time creating tables. For all of our examples, the employees table from the HR schema will be used.

Section 3: The Foundation of SQL: SELECT and FROM

These two commands must appear at the beginning of every SQL query. They make up the fundamental framework of data retrieval, known as Data Query Language (DQL)..

1. The SELECT Command (What You Want)

The SELECT command tells the database which columns (data fields) you want to retrieve.

Syntax 1: Selecting All Columns (SELECT *) The asterisk (*) is a wildcard that means “return every column in the table.” This is great for exploration.

-- Select all columns from a table
SELECT * 

Syntax 2: Selecting Specific Columns To be more precise and efficient, you list the column names you want, separated by commas.

-- Select specific columns from a table
SELECT first_name, last_name, salary

2. The FROM Command (Where It Lives)

The FROM command tells the database which table contains the data you want.

Example: If we want data from the employees table:

-- Specify the table to select data from
FROM employees;

Putting It Together: Your First Query

There are always two clauses in a complete query: SELECT and FROM. The semicolon (;), which marks the conclusion of your SQL statement, is crucial.

Live Example 1: View everything in the table

-- Select all columns from the employees table
SELECT * 
FROM employees;

(Try typing this into the Live SQL editor and clicking ‘Run’.)

Live Example 2: View only specific employee details

-- Select specific columns from the employees table
SELECT employee_id, last_name, salary, hire_date
FROM employees;

This query is much cleaner and faster because it only retrieves the necessary columns.

Section 4: Refining Your Results: The WHERE Clause

A table’s rows are all returned by the SELECT and FROM clauses. You hardly ever need every row in real-world analysis. The WHERE clause is used to filter the results.

The WHERE Command (The Condition)

WHERE clause allows you to specify a condition that must be met for a row to be included in the results. It always follows the FROM clause.

Common Operators & Examples

SQL uses standard comparison operators to define filtering rules:

1. Filtering by Numbers (Equality and Inequality)

Here, we find all employees who work in Department 50:

-- Select last_name and department_id for department 50
SELECT last_name, department_id
FROM employees
WHERE department_id = 50;

And here, we find employees who earn a higher salary than $10,000:

-- Select last_name and salary for employees earning more than 10000
SELECT last_name, salary
FROM employees
WHERE salary > 10000;

2. Filtering by Text (String Matching)

When comparing text values (strings), you must enclose the text in single quotes (‘ ‘).

-- Select first_name and job_id for employees with job_id 'IT_PROG'
SELECT first_name, job_id
FROM employees
WHERE job_id = 'IT_PROG';

3. Compound Conditions (AND and OR)

You can combine multiple conditions using the logical operators AND and OR to create highly specific filters.

• AND: Both conditions must be true.
• OR: At least one condition must be true.

This query finds employees in department 80 AND who also earn less than $10,000:

-- Select all columns for employees in department 80 with salary less than 10000
SELECT *
FROM employees
WHERE department_id = 80 AND salary < 10000;

Conclusion & Next Steps

Well done! You quickly learned how to use a professional database tool and became proficient in the three most basic SQL commands: SELECT (what you want to see), FROM (where the data is), and WHERE (how to filter it). Officially, you are making a database query!

Now that you have the basic building blocks, the real fun begins. Here is your learning path for continuing your SQL journey in Oracle Live SQL:

1. Sorting: Learn the ORDER BY clause to organize your result set, for example, listing salaries from highest to lowest.
2. Grouping: Discover how to use GROUP BY to perform calculations like finding the average salary for each department.
3. Joining: This is the most critical next step, learning how to combine data from two or more related tables (like linking the employees table to the departments table) using various types of JOIN clauses.

If you are ready to manipulate data, the next logical step is Data Manipulation Language (DML) commands like INSERT, DELETE, and UPDATE. If you want to move beyond the sample data, you will need to learn Data Definition Language (DDL) to structure your own tables. Get started here with creating SQL tables.

Return to your SQL worksheet and attempt to use a different operator to filter the employees table. For example, find all employees who are not in department 50 (department_id <> 50). Doing is the best way to learn SQL!

FAQs