CPE Oracle DBA (LOR)
LOR 0005 - Oracle 12c: SQL Workshop 1 (0.5 Credits)
.5 lecture, .5 lab, 1 total contact hours
This course offers an introduction to Oracle Database 12c technology. You will learn the concepts of relational databases and powerful SQL (structured query language) programming. Discover essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. Requires familiarity with data processing concepts and techniques.
LOR 0006 - Oracle Database 12c: Admin Workshop (2 Credits)
1 lecture, 2 lab, 3 total contact hours
Designed to provide a firm foundation in administration of an Oracle Database. Gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner. Covers both Database as a Cloud Service and the on-premises Oracle Database. Learn how to create database storage structures appropriate for the business applications supported by a database. Learn how to create users and administer database security to meet business requirements. Basic information on backup and recovery techniques is presented in this course. Prerequisite: Oracle Database 12c: SQL Workshop I or equivalent experience.
