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 database applications.

Coursework and Certifications

The Oracle Database SQL Certified Associate and the Oracle Database Administration Certified Specialist will give you the full set of skills that 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 database applications.

Summer 2024 Semester

Course Descriptions

The Oracle courses will be taught in a Remote learning environment that happens 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, 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 conversions 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, which is the first step to other Oracle certifications.

$336* (includes $100 lab fee).

09516 | 6/3 - 7/22 | 6:30-9:30 p.m. | Mon | Remote

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, properly managing the various structures effectively, and efficiently using performance monitoring, database security, user management, and backup/recovery techniques.

$336* (includes $100 lab fee).

Classes not offered at this time.

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 completion of 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).