Oracle Database SQL Certified Associate and Oracle Certified Associate Database Administrator

The Oracle Certified Associate (OCA) gives you the full set of skills that DBAs need today in the competitive marketplace. With the OCA credential, you can work as a team member or an application developer in junior database management. This professional certification allows you to manage large databases and develop large-scale applications.

Coursework and Certifications

The Oracle Database SQL Certified Associate and the Oracle Database Administration Certified Specialist will give you the full skills DBAs need today in the competitive marketplace. With the SQL Certified Associate, you can work as an application developer, and as an Administration Certified Specialist, you can work as a junior DBA. Those two professional certifications allow you to manage large databases and develop large-scale applications.

Course Descriptions

The Oracle courses will be taught in a Remote learning environment in real-time.

Remote

Learning in real-time

Students who take a remote class will meet online via Zoom in your Canvas course at scheduled times with set deadlines and due dates. Students will also access learning materials and assignments and participate in discussions via Canvas.

TEC-526: Oracle Database SQL 

In this course, you will learn the fundamentals of SQL using Oracle Database Technology. This course also provides knowledge and skills in manipulating, restricting, and sorting data, using single, group, and conversion functions, using set operators, using subqueries, controlling user access, managing schema objects, and many more. This course prepares you for the Oracle Database SQL 1Z0–071 (or current exam) to earn Oracle Database SQL Certified Associate certification, the first step to other Oracle certifications.

$336* (includes $100 lab fee).

Fall 2024 Session

13820 | 9/9 - 10/28 | 6:30-9:30 p.m. | Mon | Remote

Spring 2025 Session

15681 | 1/27- 3/24 | 6:30-9:30 p.m. | Mon | TBA

TEC 534: Oracle Database Administration 19c

This course is designed for entry-level database administrators, data warehouse administrators, support engineers, technical administrators, and database engineers. It provides instruction on Oracle Database administration and prepares students for Certification Exam 1Z0–912 (or current exam) Oracle Database Administration Specialist. Topics include installing and maintaining Oracle Database 19c instances, creating an operational database, and properly managing the various structures effectively and efficiently using performance monitoring, database security, user management, and backup/recovery techniques.

$336* (includes $100 lab fee).

Fall 2024 Session

12194 | 11/4 - 12/9 | 6:30 p.m.-9:30 p.m. | Mon | Remote

Spring 2025 Session

15682 | 1/27 - 3/24 | 6:30 p.m.-9:30 p.m. | Mon | Remote

TEC-533: Fundamentals of Database Management-Oracle Certified Professional

In this course, students will gain a solid foundation in the fundamental concepts of relational database management. Students are introduced to database architecture, data migration and recovery, high availability techniques, database performance tuning, and basic database security tasks. They will learn to install and configure relational database servers and run queries to retrieve data. Upon completing this course, students will be prepared to take Oracle's MySQL Database Professional exam, IZO-888 (or current exam), to become an Oracle Certified Professional. This course is cross-listed with INT 2080. 

$420* (includes a $150 lab fee).

Fall 2024 Sessions

11916 | 10/15 - 12/6 | Online

11917 | 8/26 - 12/11 | 10:00 a.m. - 12:45 | Mon/Wed | Remote

Spring 2025 Session

15447 | 1/21 - 3/17 | 6:00-9:40 p.m. | Mon/Wed | Remote

Contact Information

Phone: 301-546-0873
Email: itcerts@pgcc.edu