FB

Oracle Database

Oracle Database is one of the most popular databases in the world. It’s targeted at large organisations, and has many features to allow administrators manage the database and for developers to improve their query performance.

The latest version of Oracle is 20c. A free version of Oracle is available, called Oracle Express, and their Standard and Enterprise versions are licensed products.

Getting Started

A range of articles and other resources to get you started with Oracle SQL.

I

Course: Introduction to Oracle SQL

Learn Oracle SQL by watching my YouTube video series.

Read More

e

59 Best Resources for Learning SQL

Here’s a list of 59 different places you can learn SQL.

Read More

SQL Roadmap

Understand the topics to learn for SQL and databases, from the very beginning to advanced topics.

Read More

p

How to Resolve Oracle Connection Issues

Learn what some of the common issues are and how to resolve them in this article.

Read More

How to Install Oracle on a Mac

Installing Oracle Database on a Mac is possible. Learn how to do it in this article.

Read More

PL/SQL Tutorial

Get started with Oracle’s procedural language, PL/SQL, and learn how to create your own stored procedures and functions.

Read More

19 Best Database Books

Here’s my list of 19 of the best database-related books.

Read More

How to Create a Connection and Set Up Data

Here are the steps on how to set up a connection in Oracle.

Read More

i

SQL Functions

A full list of all functions available in Oracle SQL.

Read More

d

Oracle SQL Code List

See a list of all SQL Code values used by the SQLCODE function.

Read More

r

Oracle Error Messages

See a list of many of the more common Oracle SQL error messages, and their solutions.

Read More

SQL Keywords

A list of definitive guides on many of the SQL keywords.

:

SELECT

Read data from the database

Read More

;

INSERT

Add new data into a table.

Read More

=

UPDATE

Modify data already in a table.

Read More

<

DELETE

Delete data from a table.

Read More

L

CREATE TABLE

Create a new table on the database.

Read More

/

ALTER TABLE

Modify an existing table.

Read More

K

DROP TABLE

Delete a table.

Read More

O

TRUNCATE

Remove all data from a table.

Read More

U

WHERE Clause

Filter your query based on criteria.

Read More

*

ORDER BY

Sort the results of your query.

Read More

.

GROUP BY and HAVING

Group your results and filter them.

Read More

f

WHERE vs HAVING

The difference between WHERE and HAVING.

Read More

/

JOINs

Connect two tables together in a query.

Read More

a

DISTINCT

Eliminate duplicate results from your query.

Read More

Operators

Perform calculations and operations on data.

Read More

>

Set Operators

Combine results from two queries into one.

Read More

1

CASE

Use conditional logic in a query.

Read More

k

MERGE

Update or insert data into a table based on a condition.

Read More

PIVOT and UNPIVOT

Translate rows to columns and vice-versa.

Read More

Further Learning: Functions

All about functions in Oracle database.

9

Aggregate Functions

Functions that aggregate data into one or more rows.

Read More

o

Regular Expression Functions

A guide to regular expression functions.

Read More

}

Oracle Timezone Functions

A list and explanation of all timezone functions in Oracle SQL.

Read More

T

Analytic Functions

Functions that let you analyse data across multiple rows.

Read More

g

Oracle Interval Functions

A list of all interval functions in Oracle SQL.

Read More

Partition By

An explanation of the Partition By keyword.

Read More

Oracle Date Functions

A list and explanation of all date functions in Oracle SQL.

Read More

Further Learning: Objects

Learn all about the different objects available in Oracle database.

E

Triggers

A piece of PL/SQL code that runs on certain events.

Read More

&

Synonyms

A guide to Synonyms: an object that refers to another object.

Read More

Keys

A guide to database keys (surrogate, natural, composite & more).

Read More

b

Database Schema

An explanation of what a database schema is.

Read More

Indexes

A guide to indexes in SQL.

Read More

P

Sequences

A guide to sequences: objects that generate a unique number.

Read More

l

Stored Procedures

A guide to stored procedures in SQL.

Read More

o

Temp Tables

An explanation of what a temp table is and how to create one.

Read More

V

Dual Table

A dummy table in Oracle.

Read More

~

Constraints

A guide to the different types of contraints in Oracle.

Read More

Views and Materialized Views

A guide to views and materialised views in SQL.

Read More

Further Learning

More features and topics in SQL and Oracle database.

i

Glossary of Terms

A definition of many terms used in SQL and database development.

Read More

Character Sets

An overview of character sets in Oracle.

Read More

d

DDL, DML, and TCL

A list of SQL commands and what DDL, DML, and TCL mean.

Read More

|

Aliases

A guide to column aliases and table aliases in SQL.

Read More

CTE (WITH Clause)

A guide to Common Table Expressions (CTEs) aka the WITH clause.

Read More

L

Concatenate

What concatenation is and how to do it in SQL.

Read More

K

NULL

A guide on what NULL is and how to handle them in SQL.

Read More

Data Types

A guide to data types in many different databases.

Read More

h

TNSNAMES.ORA

An explanation of TNSNAMES.ORA and what it’s for.

Read More

h

Oracle 12c New Features

All the new features in Oracle 12c for developers.

Read More

w

Subqueries

A guide to subqueries, what they are and many different examples.

Read More

N

Oracle Certified Associate

A guide and FAQ for the Oracle Certified Associate certification (1Z0-071)

Read More

Z

Booleans

How SQL handles booleans and how you can implement them.

Read More

Data Warehouses

A in-depth guide to data warehouses.

Read More

{

Comments

A guide to comments in SQL and why they can help.

Read More

N

Oracle Data Types

A list and recommendations for Oracle data types.

Read More

u

Interview Questions and Answers

A list of 69 interview questions and answers, plus interview tips.

Read More

h

Oracle 18c Guide

A guide to the changes in Oracle 18c.

Read More

e

Limiting Results

A guide to SQL row limiting and Top-N queries.

Read More

Transactions and Isolation Levels

An explanation of transactions in SQL and what isolation levels are.

Read More

Wildcards

An explanation of what wildcards are and how to use them.

Read More

Database Version Control, CI, and CD

An in-depth guide on database version control, continuous integration, and continuous deployment.

Read More

How To

A collection of articles detailing how to do common tasks in SQL queries.

1

Convert Data Types

How to convert data types in Oracle SQL.

Read More

P

Auto Increment in Oracle

How to create an auto increment column in Oracle.

Read More

`

Escape Single Quotes

How to escape single quotes in SQL.

Read More

e

Select Rows with a Max Value

How to select rows with a maximum value for a column.

Read More

e

Find Row with Max Value

How to find the row with the max value for a column in Oracle.

Read More

a

Remove Duplicate Records

How to remove duplicate records in SQL.

Read More

*

Limit Rows After Ordering

How to limit the number of rows returned after ordering.

Read More

d

List Tables in Database

How to list all the tables in a database or a schema.

Read More

M

Mean, Median, and Mode

How to calculate the mean, median, and mode in Oracle SQL.

Read More

SQL Developer

A range of articles that explain how to do certain things in Oracle SQL Developer.

e

Line Numbers

How to turn on line numbers in your SQL editor.

Read More

Export Connections

How to export connections from SQL Developer including passwords.

Read More

&

Export Data and Results

How to export table data and query results.

Read More

Z

Autocommit Settings

How to turn on or off the autocommit settings.

Read More

b

Enable DBMS_OUTPUT

How to enable and see DBMS_OUTPUT.

Read More

I

Debug Session

How to start a debug session.

Read More

f

Format SQL Options

How to use the Format SQL options to change how your SQL is formatted.

Read More

p

Execution Plan

How to use and run the execution plan.

Read More

Tools

A list of guides and collations of different tools for database developers and administrators.

d

50 SQL IDEs

A list of 5 Oracle SQL IDEs compared.

Read More

d

42 ETL Tools

A list of 42 different ETL tools.

Read More

e

50 Experts Reveal Top Tools

50 different Oracle SQL experts reveal their top SQL tools.

Read More