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)
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).
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).
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
- Choose question
Oracle Certified Professional (OCP)
An Oracle Certified Professional is skilled in Oracle technologies. This level of certification validates advanced understanding of Oracle concepts and skills as well as experience applying these in real-world scenarios. An Oracle Certified Professional (OCP) is an individual that has successfully completed certification programs offered by Oracle. In the five tiers of Oracle certification, an Oracle Certified Professional is the second level, above an Oracle Certified Associate (OCA), but below an Oracle Certified Master (OCM).The average Oracle Certified Associate salary in the United States is $97,282 as of October 29, 2021, but the salary range typically falls between $85,493 and $106,953.
- Choose question