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

(1Z0-061) / ISBN: 9781616913465
This course includes
Lessons
TestPrep
LiveLab (Add-on)
Mentoring (Add-on)
Share
$200.99
Try This Course
5 Rating 2 Reviews
Are you an instructor?
Request a free evaluation copy

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

Pass the Oracle Database certification exam with the Oracle Database 12c: SQL Fundamentals (1Z0-061) course and lab. The lab comes with a well-organized component library for every task. The Oracle database course offers complete coverage of the 1Z0-061 exam objectives and provides expertise on topics such as SQL, data manipulation, table and constraints creation; and more. The database online course goes beyond traditional Oracle exam preparation to strengthen your knowledge in all aspects of a relational database.
Here's what you will get

The Oracle Database 12c Fundamentals 1Z0-061 exam comes under the category of the OCA/OCP certification. 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
  • 8+ Lessons
  • 128+ Exercises
  • 135+ Quizzes
  • 43+ Flashcards
  • 43+ Glossary of terms
TestPrep
  • 10+ Pre Assessment Questions
  • 4+ Full Length Tests
  • 48+ Post Assessment Questions
  • 248+ Practice Test Questions
LiveLab (Add-on)
  • 68+ LiveLab
Video Lessons
  • 44+ Videos
  • 15:29+ Hours
Here's what you will learn
Download Course Outline
  • 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)

  • Connecting to a Database
  • Saving the SQL Buffer
  • Clearing the SQL Buffer
  • Creating a Table
  • Inserting Data Into a Table
  • Converting the String to the DATE Data Type
  • Retrieving Data Using the SQL SELECT Statement
  • Using the WHERE Clause
  • Using the IN Operator
  • Using the NULL Values in the SELECT Statement
  • Using the Column Aliases
  • Using the Concatenation Operator
  • Using the DESCRIBE Command
  • Using the DISTINCT Keyword
  • Using the INEQUALITY Operator
  • Using the Less Than Operator
  • Using the Greater Than Operator
  • Using the ANY Operator
  • Using the ALL Operator
  • Using the NOT Operator
  • Using the AND Operator
  • Using the BETWEEN Operator
  • Using the EXISTS Operator
  • Using the FETCH Clause
  • Using the WITH TIES Clause
  • Using the OFFSET-FETCH Clause
  • Using the CASE Statement
  • Using the Runtime Query
  • Using the UPPER Function
  • Using the SUBSTR Function
  • Using the ROUND Function
  • Using the TRUNC Function
  • Using the Single-Row Date Function
  • Using the ASCII Function
  • Using the DECODE Function
  • Retrieving Unique Columns
  • Using the average Function
  • Using the MIN Function
  • Using the MEDIAN Function
  • Using the LISTAGG Function
  • Retrieving data using the INNER JOIN operator
  • Using the Self Join
  • Using the FULL OUTER JOIN
  • Using the MINUS Operator
  • Using the INTERSECT operator
  • Using a Subquery
  • Using the UNION Operator
  • Creating a View
  • Using the WITH Clause
  • Using the GROUP BY Clause
  • Using the HAVING Clause
  • Updating a Table
  • Deleting Rows from a Table
  • Deleting Data from a Table
  • Using the MERGE Statement
  • Locking a Table
  • Creating a Sequence
  • Inserting Data Into a Table Using Sequence
  • Retrieving the Next Value of Sequence
  • Creating an Index
  • Using the CREATE SYNONYM Statement
  • Creating a Table with the INTERVAL Datatype
  • Creating a Table from Another Table
  • Creating a Table with Default Values
  • Creating a Table with an Invisible Column
  • Dropping a Table
  • Renaming a Table
  • Adding a Column
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? 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.
Customer Testimonials
Rakshit Goyal
Oracle Database 12c: SQL Fundamentals by uCertify is one of the most user-friendly courses having images to understand the logical model (ERP), videos with transcripts to read throughout the video. They have text material as well if you like to read rather than watching videos and these texts are as rich-featured as Oracle 12c. I highly recommend this course to all those who have experience with SQL.
Tejas Thakur
I found uCertify Oracle OCA 12c course very helpful, and complete. The course provided an abundance of information about the curriculum and was well organized. It is just an exceptional tool that helped me study for a course in which I was interested. I looked forward to the quizzes at the end of each topic, because at that moment I could always test to see how much I have learned and can always revisit the topic; should I need. The course is to the point, I have read the course is very informative and can help to understand the detailed aspect of Oracle RDBMS concepts, and totally align with the exam structure.

Show more

×