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

1Z0-061
1Z0-061
Oracle Database 12c: SQL Fundamentals
ISBN : 978-1-61691-346-5
The Oracle Certified Associate (OCA) credential is the first step toward achieving the Oracle Certified Professional (OCP) certification. OCA shows that you have the fundamental knowledge and skills to support an Oracle Database 12c database.

Lessons

uCertify uses content from well known publishers, instructors, and subject matter experts. They have a minimum of 15 years of experience in their fields. uCertify brings these textbooks to life. It is full of interactive activities that keeps the learner engaged. uCertify brings all available learning resources for a topic in one place so that the learner can efficiently learn without going to multiple places. Challenge questions are also embedded in the chapters so learners can attempt those while they are learning about that particular topic. This helps them grasp the concepts better because they can go over it again right away which improves learning. Learners can do Flashcards, Exercises, Quizzes and Labs related to each chapter. At the end of every lesson, uCertify courses guide the learners on the path they should follow.

uCertify platform supports 50+ different types of interactive activities, connect the idea, or try it yourself lab activities embedded throughout its course. These interactive activities keeps learners engaged and makes learning fun.

Here's What You Get

Exercises Flashcards Quizzes Glossary

Each lesson comes with Exercises, Flashcards & Quizzes. There is no limit to the number of times learners can attempt these. Exercises come with detailed remediation, which ensures that learners are confident on the topic before proceeding. Flashcards help master the key concepts. Glossary defines the key terms.

Exercise Questions
128+
Quizzes
125+
Flashcards
43+
Glossary of terms
43+
Lessons
8+
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.

Videos
44+
Hours
15:29+

Test Prep & Practice Questions

uCertify provides full length practice tests. These tests closely follow the exam objectives and are designed to simulate real exam conditions. Each course has a number of test sets consisting of hundreds of items to ensure that learners are prepared for the certification exam.

Here's What You Get

Pre-assessments Questions
10+
Full Length Tests
2+
Post-Assessments Questions
48+

Features

Full Remediation

Each question comes with detailed remediation explaining not only why an answer option is correct but also why the incorrect answer options are incorrect.

Unlimited Practice

Each test can be taken unlimited number of times until the learner feels they are prepared. Learner can review the test and read detailed remediation. Detailed test history is also available.

Learn, Test and Review Mode

Each test set comes with learn, test and review modes. In learn mode, learners will attempt a question and will get immediate feedback and complete remediation as they move on to the next question. In test mode, learners can take a timed test simulating the actual exam conditions. In review mode, learners can read through one item at a time without attempting it.

Mentoring

Our Mentors are available 24/7 to provide you an expert support via online chating. They are subject matter experts and ready to provide answer to your questions.

Exam Information

Certification is proof of your knowledge and shows that you have the skills required to support Oracle core products. The Oracle certification program can help a company identify proven performers who have demonstrated their skills and who can support the company's investment in Oracle technology. It demonstrates that you have a solid understanding of your job role and the Oracle products used in that role.

Career Prospects
  • Database Administrator
  • Oracle Programmer
  • DBA
Exam FAQs
What is the exam registration fee?
USD 125

Pricing and taxes may vary from country to country. Click here for more information on exam pricing.

Where do I take the exam?
The 1Z0-061 exam is administered by Pearson VUE at the testing centers worldwide. Click here to find a testing center near you.
What is the format of the exam?
The exam consists scenario-based multiple choice questions.
What are the pre-requisites of the exam?
While there are no official prerequisites to take the Oracle Database 12c Administrator Certified Associate certification, both Oracle and uCertify strongly recommend that the candidates have a good understanding of SQL.
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%

Click here for more information.

What is the exam's retake policy?

Retake Policy for Oracle 1Z0-061 exam is:

  • Candidates must wait 14 days before retaking a failed proctored exam. (Registration will be allowed on the 14th day)
  • Candidates may retake an online non-proctored exam at any time.
  • Candidates may not retake a passed exam at any time.
  • Candidates may not retake a beta exam at any time.
What is the validity of the certification?
Oracle certifications have no expiration. The certification holder is certified for life unless Oracle changes its policy. Click here for more information.
Where can I find more information about this exam?
To know more about the 1Z0-061, click here.

Table of Content

Here's What you will Learn

Lesson 1: Introducing Oracle Database 12c RDBMS Oracle Database 12c:

  • Relational Database Management Systems
  • The Oracle Database 12c
  • Becoming Familiar with SQL*Plus
  • Summary
  • Exam Essentials

Lesson 2: Introducing SQL

  • SQL Fundamentals
  • Writing Simple Queries
  • Accepting Values at Runtime
  • Summary
  • Exam Essentials

Lesson 3: Using Single-Row Functions

  • 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

Lesson 4: Using Group Functions

  • Group Function Fundamentals
  • Utilizing Aggregate Functions
  • Summary
  • Exam Essentials

Lesson 5: Using Joins and Subqueries

  • Writing Multiple-Table Queries
  • Using Set Operators
  • Using Subqueries
  • Summary
  • Exam Essentials

Lesson 6: Manipulating Data

  • Using DML Statements
  • Understanding Transaction Control
  • Summary
  • Exam Essentials

Lesson 7: Creating Tables and Constraints

  • Database Objects Overview
  • Built-in Datatypes
  • Creating Tables
  • Modifying Tables
  • Managing Constraints
  • Summary
  • Exam Essentials

Lesson 8: Video Tutorials

  • 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

Copyright © 2002-2017 uCertify / All Rights Reserved.