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

Oracle Database 12c: SQL Fundamentals
ISBN : 9781616918163
Includes:
44+ Videos
123+ Test Prepkits
176+ Flash Cards
Rating :
(16)
Gain hands-on expertise in 1Z0-061 exam with Oracle Database 12c: SQL Fundamentals course and live lab. This course and live lab provides complete coverage of 1Z0-061 exam and includes topics such as SQL fundamentals, single row functions, group functions, joins and subqueries, manipulating data and much more. Oracle Database 12c: SQL Fundamentals live lab is a real computer equipment, networked together and conveniently accessible over the Internet using virtualization. It is automatic, objective-oriented and has equipment such as a computer, server, switch or router in it that a user is free to configure.

Here's what you will get

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. Oracle Database 12c: SQL Fundamentals exam is designed to certify the competency of Database professionals to manage, develop, or implement enterprise-wide databases, middleware, or applications.

Lessons
Lessons
8+
Exercises
96+
Quizzes
123+
Flashcards
176+
Glossary of terms
45+
Test prep
Pre-assessment Questions
40+
Full Length Tests
5+
Post-Assessment Questions
70+
Live Lab (Add-on Component)
live lab
68+

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
16:08+
Exam FAQs
What is the exam registration fee? USD 125
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 WGU-1Z0-061, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?
  • Database Administrator
  • Oracle Programmer
  • DBA

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

Hands on Activities (Live Labs)