Contents - OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) [Book]

Skip to main content

Get full access to OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) and 60K+ other titles, with a free 10-day trial of O'Reilly.

There are also live events, courses curated by job role, and more.

Start your free trial

Contents

Acknowledgments

1 Introduction to SQL

The Exam: An Overview

“SQL Fundamentals I” Versus “SQL Expert”

Define and Understand the Basics of the RDBMS

Relational Databases and Dr. E.F. Codd

Database Normalization

Database Design Considerations

Define and Understand the Basics of SQL

Understand the Oracle RDBMS and Oracle SQL

Oracle Is the Market Leader

Certification: Oracle SQL Versus ANSI SQL

Certification: Oracle SQL Versus Oracle SQL*Plus

Oracle’s Tools for Working with SQL

Oracle’s Documentation for SQL

Understand the Unique Role of SQL in Modern Software Systems

SQL: Gateway to the RDBMS for All Other Languages

Syntax Isn’t Enough

Confirm Appropriate Materials for Study

Documentation ...

Get OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Don’t leave empty-handed

Get Mark Richards’s Software Architecture Patterns ebook to better understand how to design components—and how they should interact.

It’s yours, free.

Get it now

Cover of Software Architecture Patterns

Check it out now on O’Reilly

Dive in for free with a 10-day trial of the O’Reilly learning platform—then explore all the other resources our members count on to build skills and solve problems every day.

Start your free trial Become a member now