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

13:52 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

13:38 Database administation, Database development, Indexes, Perfomance Tuning

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

5 Ways to Update Data with a Subquery in Oracle SQL

10:37 Database administation, 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