1Z0-061 : Oracle Database 12c: SQL Fundamentals

1Z0-061
1Z0-061
Oracle Database 12c: SQL Fundamentals
ISBN : 978-1-61691-346-5
Get complete knowledge about SQL Database fundamentals with 1Z0-061 Oracle Database SQL Fundamentals course. The course offers complete coverage of 1Z0-061 exam objectives and provides expertise in SQL, group functions, single-row functions, joins and subqueries, data manipulation, table and constraints creation, 12c RDBMS Database, and many more. The 1Z0-061 exam comes under the category of OCA/OCP certification.

Here's what you will get

The OCA/OCP certification proves your knowledge and skills required to support Oracle core products. The certification describes the features of Oracle Database 12c, Oracle Cloud 12c, theoretical and physical aspects of a relational database, Oracle server s implementation of RDBMS and object relational database management system (ORDBMS). This exam has been validated against Oracle Database 12.1.0.1.0.

Lessons
Lessons
8+
Exercises
128+
Quizzes
125+
Flashcards
43+
Glossary of terms
43+
TestPrep
Pre-assessment Questions
10+
Full Length Tests
4+
Post-Assessment Questions
48+

Videos and How To..

uCertify course includes videos to help understand concepts. It also includes How Tos that help learners with how to accomplish certain tasks.

Video Lessons
Videos
44+
Hours
15:29+
Exam FAQs
What is the exam registration fee? USD 125
Where do I take the exam? Pearson VUE
What is the format of the exam? The exam consists scenario-based multiple choice questions.
How many questions are asked in the exam? The exam contains 75 questions.
What is the duration of the exam? 120 minutes
What is the passing score? 65%
What is the exam's retake policy?

Here are the retake policies:

  • Candidates may not retake a beta exam at any time.
  • Candidates may not retake a passed exam at any time.
  • Candidates may retake an online non-proctored exam at any time.
  • Candidates are only allowed 4 attempts to pass an exam in a 12-month period.
  • Candidates must resubmit a failed Master Assignment within 30 days of receiving the notification of failing.
  • Candidates must wait 14 days before retaking a failed proctored exam. (Registration will be allowed on the 14th day)
What is the validity of the certification? Oracle certifications have no expiration unless Oracle changes its policy. 
Where can I find more information about this exam? To know more about the 1Z0-061, click here.
Which certification covers this exam?

Here's what you will learn

  • Relational Database Management Systems
  • The Oracle Database 12c
  • Becoming Familiar with SQL*Plus
  • Summary
  • Exam Essentials
  • SQL Fundamentals
  • Writing Simple Queries
  • Accepting Values at Runtime
  • Summary
  • Exam Essentials
  • Single-Row Function Fundamentals
  • Using Single-Row Character Functions
  • Using Single-Row Numeric Functions
  • Using Single-Row Date Functions
  • Using Single-Row Conversion Functions
  • Using Other Single-Row Functions
  • Summary
  • Exam Essentials
  • Group Function Fundamentals
  • Utilizing Aggregate Functions
  • Summary
  • Exam Essentials
  • Writing Multiple-Table Queries
  • Using Set Operators
  • Using Subqueries
  • Summary
  • Exam Essentials
  • Using DML Statements
  • Understanding Transaction Control
  • Summary
  • Exam Essentials
  • Database Objects Overview
  • Built-in Datatypes
  • Creating Tables
  • Modifying Tables
  • Managing Constraints
  • Summary
  • Exam Essentials
  • Introduction
  • Oracle 12c- SQL Fundamentals
  • Basic Select Statements
  • Using the Where Clause
  • The Order By Clause
  • Left And Right Outer Joins
  • Multi-Table Selection Demo
  • SQL Functions
  • Using Group By clause
  • Conversion Functions
  • Subqueries
  • Data Modification
  • Implementing Security
  • Creating Objects In The Database
  • Using Sequences
  • Indexes
  • Views
  • Combining Queries
  • Oracle 12c SQL Fundamentals Review