Lesson 1

This course is the third of five courses in the Oracle Database Administration Certification Series.

This course focuses on the database structures within an Oracle database. After completing this course, you will be able to

1. Create tables, indexes, and constraints
2. Assign appropriate storage specifications for tables, indexes, and constraints
3. Assign security privileges to all objects within an Oracle database
4. Use security roles to control access to database objects
5. Create and manage stored code within an Oracle database

This course will prepare you for one of the following Oracle certification exams:

1. Exam [1Z0-061, 1Z0-051, 1Z0-047]

This database administration exam is one of five that you must pass in order to earn certification as an Oracle database administrator.
The current Oracle exams for the year 2016 are:

Exam Number: Pass one SQL Exam:

1. Oracle Database 12c: SQL Fundamentals 1Z0-061 or
2. Oracle Database 11g: SQL Fundamentals I 1Z0-051 or
3. Oracle Database SQL Expert 1Z0-047

Exam Product Version: Oracle Database 11g, 12c