Oracle Database SQL

classroom technology

NATIONAL CERTIFICATION: Oracle Database 11g Administrator Certified Associate

Learn the fundamentals of SQL using Oracle Database Technology.  Trained and certified Oracle Certified Associates can gain employment as an entry-level database administrator, or build on the OCA to earn the next level in Oracle’s database certification track, the Oracle Certified Professional (OCP).

Certification

Students who complete Oracle Database SQL 12c and Oracle Database 11g: Administration will be prepared for the national exams. Once exams 1Z0-071 and 1Z0-052 are passed, you will become an Oracle Certified Associate.

DPR 880: Oracle Database SQL 12c 2.4 CEUs

 In this course you will learn the fundamentals of SQL using Oracle Database Technology. The course will provides knowledge and skills in the areas such as manipulating, restricting, and sorting data; using single, group and conversions functions; using set operators; using subqueries; controlling user access; Managing Schema Objects; and many more. This course will prepare you for the Oracle Database SQL 1Z0-071exam. Passing this exam will give you the status as an Oracle Database SQL Certified Associate, and it is a requirement for those certifications:Oracle Database 11g Administrator Certified Associate/ Oracle Database 12c Administrator Certified Associate /Oracle PL/SQL Developer Certified Associate. Textbook: Database Systems Using Oracle, 2nd edition, by Nilesh Shah.   8 sessions, $336 * (includes a $100 lab fee)

37579 9/10 - 10/29 6:30 PM - 9:30 PM M Laurel College Center

DPR 881: Oracle Database 11g: Administration 1 1.8 CEUs

This course provides knowledge and skills on how to set up database environments and secure Oracle instances in any network environment, understanding database backup and recovery, Oracle Database Architecture, as well as configuration of security instances. This course will prepare you for the Oracle Database 11g: Administration I 1Z0-052 exam. This is the final class needed to become an Oracle Certified Associate (OCA) 6 sessions, $270 * (includes a $95 lab fee)

37580 11/5 - 12/10 6:30 PM - 9:30 PM M Laurel College Center