A software design pattern is defined in Wikipedia as "a general, reusable solution to a commonly occurring problem within a given context".

In this session we'll see design patterns for various common problems in SQL and PL/SQL, like how to implement some data model requirements, how to write SQL queries for specific types of questions, and how to use PL/SQL for solving some challenging tasks.

Design patterns are popular in C++ and Java, but the concept of general reusable solutions to commonly occurring problems can (and should) be applied in SQL and PL/SQL as well.

The concept of this session is based on a demo application that is built from scratch during the presentation, where every development requirement is a concrete example of a general common task, that is solved using some design pattern.