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.
Course: Introduction to Oracle SQL
Learn Oracle SQL by watching my YouTube video series.
59 Best Resources for Learning SQL
Here’s a list of 59 different places you can learn SQL.
SQL Roadmap
Understand the topics to learn for SQL and databases, from the very beginning to advanced topics.
How to Resolve Oracle Connection Issues
Learn what some of the common issues are and how to resolve them in this article.
How to Install Oracle on a Mac
Installing Oracle Database on a Mac is possible. Learn how to do it in this article.
PL/SQL Tutorial
Get started with Oracle’s procedural language, PL/SQL, and learn how to create your own stored procedures and functions.
19 Best Database Books
Here’s my list of 19 of the best database-related books.
How to Create a Connection and Set Up Data
Here are the steps on how to set up a connection in Oracle.
SQL Functions
A full list of all functions available in Oracle SQL.
Oracle SQL Code List
See a list of all SQL Code values used by the SQLCODE function.
Oracle Error Messages
See a list of many of the more common Oracle SQL error messages, and their solutions.
SQL Keywords
A list of definitive guides on many of the SQL keywords.
SELECT
Read data from the database
INSERT
Add new data into a table.
UPDATE
Modify data already in a table.
DELETE
Delete data from a table.
CREATE TABLE
Create a new table on the database.
ALTER TABLE
Modify an existing table.
DROP TABLE
Delete a table.
TRUNCATE
Remove all data from a table.
WHERE Clause
Filter your query based on criteria.
ORDER BY
Sort the results of your query.
GROUP BY and HAVING
Group your results and filter them.
WHERE vs HAVING
The difference between WHERE and HAVING.
JOINs
Connect two tables together in a query.
DISTINCT
Eliminate duplicate results from your query.
Operators
Perform calculations and operations on data.
Set Operators
Combine results from two queries into one.
CASE
Use conditional logic in a query.
MERGE
Update or insert data into a table based on a condition.
PIVOT and UNPIVOT
Translate rows to columns and vice-versa.
Further Learning: Functions
All about functions in Oracle database.
Aggregate Functions
Functions that aggregate data into one or more rows.
Regular Expression Functions
A guide to regular expression functions.
Oracle Timezone Functions
A list and explanation of all timezone functions in Oracle SQL.
Analytic Functions
Functions that let you analyse data across multiple rows.
Oracle Interval Functions
A list of all interval functions in Oracle SQL.
Further Learning: Objects
Learn all about the different objects available in Oracle database.
Triggers
A piece of PL/SQL code that runs on certain events.
Synonyms
A guide to Synonyms: an object that refers to another object.
Keys
A guide to database keys (surrogate, natural, composite & more).
Database Schema
An explanation of what a database schema is.
Indexes
A guide to indexes in SQL.
Sequences
A guide to sequences: objects that generate a unique number.
Stored Procedures
A guide to stored procedures in SQL.
Temp Tables
An explanation of what a temp table is and how to create one.
Further Learning
More features and topics in SQL and Oracle database.
Glossary of Terms
A definition of many terms used in SQL and database development.
Character Sets
An overview of character sets in Oracle.
DDL, DML, and TCL
A list of SQL commands and what DDL, DML, and TCL mean.
Aliases
A guide to column aliases and table aliases in SQL.
CTE (WITH Clause)
A guide to Common Table Expressions (CTEs) aka the WITH clause.
Concatenate
What concatenation is and how to do it in SQL.
NULL
A guide on what NULL is and how to handle them in SQL.
Data Types
A guide to data types in many different databases.
TNSNAMES.ORA
An explanation of TNSNAMES.ORA and what it’s for.
Oracle 12c New Features
All the new features in Oracle 12c for developers.
Subqueries
A guide to subqueries, what they are and many different examples.
Oracle Certified Associate
A guide and FAQ for the Oracle Certified Associate certification (1Z0-071)
Booleans
How SQL handles booleans and how you can implement them.
Data Warehouses
A in-depth guide to data warehouses.
Comments
A guide to comments in SQL and why they can help.
Oracle Data Types
A list and recommendations for Oracle data types.
Interview Questions and Answers
A list of 69 interview questions and answers, plus interview tips.
Oracle 18c Guide
A guide to the changes in Oracle 18c.
Limiting Results
A guide to SQL row limiting and Top-N queries.
Transactions and Isolation Levels
An explanation of transactions in SQL and what isolation levels are.
Wildcards
An explanation of what wildcards are and how to use them.
Database Version Control, CI, and CD
An in-depth guide on database version control, continuous integration, and continuous deployment.
How To
A collection of articles detailing how to do common tasks in SQL queries.
Convert Data Types
How to convert data types in Oracle SQL.
Auto Increment in Oracle
How to create an auto increment column in Oracle.
Escape Single Quotes
How to escape single quotes in SQL.
Select Rows with a Max Value
How to select rows with a maximum value for a column.
Find Row with Max Value
How to find the row with the max value for a column in Oracle.
Remove Duplicate Records
How to remove duplicate records in SQL.
SQL Developer
A range of articles that explain how to do certain things in Oracle SQL Developer.
SQL Developer Resource Guide
A list of articles, videos, and steps on working with SQL Developer.
Export Connections
How to export connections from SQL Developer including passwords.
Export Data and Results
How to export table data and query results.
Autocommit Settings
How to turn on or off the autocommit settings.
Enable DBMS_OUTPUT
How to enable and see DBMS_OUTPUT.
Debug Session
How to start a debug session.
Tools
A list of guides and collations of different tools for database developers and administrators.