Author: Ben Brumm

Ben Brumm is a software consultant with over 10 years experience in the IT industry. He is also the founder of, a website that teaches database developers how to improve their skills and their career.

Difference Between Inline and Out-of-Line Constraints

Constraints, Database development

Constraints on tables and columns allow you to enforce the data quality. In SQL, there are two...
Read More

Example of Improving Query Performance with Indexes

Database administration, Database development, Indexes, Oracle, Performance Tuning

In this article, we’ll look at how an index can improve the query performance. Indexes in Oracle and other databases are objects that...
Read More

5 Ways to Update Data with a Subquery in Oracle SQL

Database administration, Work with data

A subquery is a powerful way to find the data you want to use for another query. They are often used in SELECT and UPDATE statements to...
Read More