Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Codecademy

1Z0-071: Oracle Database 12c SQL

via Codecademy Path

Go to class Write review
Scrimba Ad

Free courses from frontend to fullstack and AI

Learn More → Coursera Ad

AI, Data Science & Cloud Certificates from Google, IBM & Meta

Learn More →

Overview

Build a Learning Habit
Download Class Central's free printable study calendar
Download for Free
Study for 1Z0-071 Oracle Database 12c SQL certification exam covering SQL queries, database management, functions and advanced SQL techniques.

Syllabus

  • Relational Databases, SQL SELECT Statements, and Displaying Data
    • <p>In this track you will learn about the Structured Query Language (SQL) as well as SELECT statements, expressions, and how to display data from tables.</p>
  • Set Operators, DDL, and Objects
    • <p>In this track you will explore set operators, learn how to manage objects, as well as go over the data definition language (DDL).</p>
  • Sorting Data, Single-Row Functions, and Aggregated Data Using Group Function
    • <p>This track will covers areas such as restricting and sorting data, single-flow functions, group functions, and subqueries.</p>
  • Schema Objects, User Access, and Advanced Queries
    • <p>In this final track you will learn how to create other schema objects, how to control user access, as well as how to manupulate data with advanced queries.</p>
  • Take the Practice Exam
    • <p>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.</p>
  • Schedule your Exam
    • After completing your studies, schedule your exam with the third-party provider.
  • Upload Certification
    • After you receive notification that you’ve been certified, upload your certification to achieve completion.

Reviews

Start your review of 1Z0-071: Oracle Database 12c SQL

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.