What are certification prep paths?

Certification prep paths guide you through the steps you’ll need to prepare for and earn top industry certifications. These paths give you helpful resources and practice so you can feel confident taking a certification test and receiving your industry certification through a third-party provider. [Learn more about certification prep](https://help.codecademy.com/hc/en-us/articles/30914116566427-Certification-Prep-skill-paths-FAQ).

How can I take certification prep paths?

Get access to certification prep paths with a [Codecademy Pro or Plus membership](https://www.codecademy.com/pricing). **Please note:** These paths are for preparation and practice. You’ll schedule and take the actual industry exam directly with a third-party provider, not with Codecademy.

How do I receive my industry certification?

Each industry certification is granted by a third-party provider after passing their certification exam. First, take a certification prep path on Codecademy to learn the content and practice for the industry exam. Then, you'll see links to schedule the industry exam directly with a third-party provider. Once you have passed the industry exam, you will receive that industry certification.

Will I have to pay for an industry certification exam?

Yes. Since the industry exam is scheduled and conducted by a third-party provider, it isn’t already included in your Codecademy Pro or Plus membership. An industry exam will be an additional fee paid to the third-party provider.

Certification path

1Z0-071: Oracle Database 12c SQL

Study for 1Z0-071 Oracle Database 12c SQL certification exam covering SQL queries, database management, functions and advanced SQL techniques.

To start this Certification Path, upgrade your plan.

Start

Exam delivered by Oracle

This path is preparation for an industry certification. The certification exam will be scheduled and delivered through a third-party provider. Learn more about certification prep.

Skill level
Beginner
Time to complete
Approx. 18 hours
Certification exam
Delivered by Oracle

About this certification path

The 1Z0-071: Oracle Database 12c SQL exam is designed for individuals who wish to demonstrate their ability to use SQL to interact with an Oracle Database. This certification exam is ideal for database administrators, developers, or anyone looking to prove their proficiency in working with Oracle 12c SQL to manage, query, and manipulate data in relational databases. The 1Z0-071 journey covers foundational SQL knowledge and practical skills in areas such as querying tables, using SQL functions, creating and managing database objects, and applying various advanced SQL techniques. After completing this journey, participants will be ready to take the 1Z0-071 exam.

Skills you'll gain

Data Manipulation
Database Management
Database Development

Syllabus

7 units • 17 courses

5
Take the Practice Exam
Practice exams are designed to help you prepare for the exam and perform on exam day. Study at your own pace, whenever you want, and wherever you are most comfortable. Practice with exam-like questions.
6
Schedule your Exam
After completing your studies, schedule your exam with the third-party provider.
7
Upload Certification
After you receive notification that you’ve been certified, upload your certification to achieve completion.

Start

Certification path