1Z0-061Oracle Database 12c: SQL Fundamentals (OCA)

Candidates for the Oracle Database 12c: SQL Fundamentals (OCA) exam are developers, database administrators, system analysts, and functional implementers with familiarity with data process concepts and techniques, and programming languages. This certification is a prerequisite to Oracle Database 11g Administrator Certified Associate, Oracle PL/SQL Developer Certified Associate, and Oracle Database 12c Administrator Certified Associate. 

This exam measures the following skills*:

  • Retrieving data using the SQL SELECT statement
  • Restricting and sorting data
  • Using single-row functions to customize output
  • Reporting aggregated data using the group functions
  • Displaying data from multiple tables
  • Using subqueries to solve queries
  • Managing tables using DML statements
  • Introduction to Data Definition Language

For more information about the 1Z0-061 exam, visit the Oracle page.

*These exam objectives can change at any time.

1Z0-061 Oracle Database 12c: SQL Fundamentals (OCA) Certification Study Package

Kaplan IT Training Certification Packages are based on Kaplan's proven learning strategy of Prepare, Practice, Perform® and are customizable to fit your preferred study method. Study at your own pace, whenever you want, and wherever you are most comfortable. Choose between our 30-Day Assessment and 180-Day Exam Preparation. Practice with exam-like questions. 

30-Day Assessment (Online only)

  • A single set of focused exam-like questions
  • Custom quiz settings to drill down into specific topics
  • Detailed explanations and references
  • Grade as you go or simulate the exam experience
  • Online access only
  • Upgrade to the 180-Day Exam Preparation for only $40

180-Day Exam Preparation (Online + Download)

  • Multiple unique sets of exam-like questions for additional exam experiences
  • Custom quiz settings to drill down into specific topics
  • Detailed explanations and references
  • Grade as you go or simulate the exam experience
  • Performance Tracker to see how your performance stacks up to others
  • Full set of key concepts flashcards to memorize critical information
  • Online access and downloadable and printable quizzes for offline study
  • Study Calendar to optimize your exam study time
  • Student Discussion Board to share study tips
  • InstructorLink™ to contact our IT experts
  • Pass Guarantee to ensure your success

Build Your Package:

1Z0-061 Oracle Database 12c: SQL Fundamentals (OCA) Practice Lab

The Oracle Database 12c: SQL Fundamentals (OCA) Practice Lab is a live, hands-on lab platform you can access directly from your web browser. Designed to develop and enhance your IT practical skills, Practice Labs provide you with the hardware you need for high-quality, real-life exercises and scenarios, without having to purchase your own equipment and risk your internal systems. Perform with realistic Practice Labs.

Your single user license will give you full online access:

  • Real labs carried out on real hardware, accessed from your web browser
  • Absolutely no simulations
  • Carry out your own configurations, or follow the accompanying lab guides
  • The latest technology available 24/7
  • No extra hardware or licensing costs
  • An affordable, effective way to gain hands-on, real-world experience

Kaplan IT Training Certification Package Grid Image