Oracle

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

(1Z0-061) / ISBN : 978-1-61691-346-5
Lessons
Lab (Add-on)
TestPrep
130 Reviews
Get A Free Trial

Skills You’ll 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.
Download Course Outline

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
2

Introducing SQL

  • SQL Fundamentals
  • Writing Simple Queries
  • Accepting Values at Runtime
  • Summary
  • Exam Essentials
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
4

Using Group Functions

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

Using Joins and Subqueries

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

Manipulating Data

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

Creating Tables and Constraints

  • Database Objects Overview
  • Built-in Datatypes
  • Creating Tables
  • Modifying Tables
  • Managing Constraints
  • Summary
  • Exam Essentials
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

1

Introducing Oracle Database 12c RDBMS Oracle Database 12c

  • Connecting to a Database
  • Saving the SQL Buffer
  • Clearing the SQL Buffer
2

Introducing SQL

  • 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
3

Using Single-Row Functions

  • 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
4

Using Group Functions

  • Retrieving Unique Columns
  • Using the average Function
  • Using the MIN Function
  • Using the MEDIAN Function
  • Using the LISTAGG Function
5

Using Joins and Subqueries

  • 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
6

Manipulating Data

  • Updating a Table
  • Deleting Rows from a Table
  • Deleting Data from a Table
  • Using the MERGE Statement
  • Locking a Table
7

Creating Tables and Constraints

  • 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

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

USD 125

Pearson VUE

Scenario-based multiple choice questions

The exam contains 75 questions.

120 minutes

65%

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)

Oracle certifications have no expiration unless Oracle changes its policy.

Know more about the 1Z0-061

Related Courses

All Courses