1
Introduction to SQL

CERTIFICATION OBJECTIVES

1.01 The Exam: An Overview

1.02 Define and Understand the Basics of the RDBMS

1.03 Define and Understand the Basics of SQL

1.04 Understand the Oracle RDBMS and Oracle SQL

1.05 Understand the Unique Role of SQL in Modern Software Systems

1.06 Confirm Appropriate Materials for Study

Two-Minute Drill

Q&A Self Test

Oracle Corporation’s implementation of the Structured Query Language, or SQL, is arguably the most powerful and most significant computer language used in the world of government and business today. This chapter begins the process of preparing you to successfully take and pass the Oracle 1Z0-047 exam, titled “Oracle Database SQL Expert”. First we’ll discuss a few particulars about the exam itself, how it’s different from other Oracle certification tests, and what you can expect when you take it. Then we’ll begin to address the SQL language; we’ll introduce some background information and prepare you to go through a comprehensive analysis and review of the language in order to successfully study for the test. We will explore the background ....