Oracle

Oracle Database 12c: SQL Fundamentals

(WGU-1Z0-061) / ISBN : 978-1-61691-816-3

Lessons

Lab (Add-on)

TestPrep

AI Tutor (Add-on)

336 Reviews

Get A Free Trial

This course includes:

Free pre-assessment and first 2 lessons

8+ Interactive Lessons | 95+ Exercises

44+ Videos | 15:29+ Hours

Accessible on mobile and tablet too

Certificate of completion

$47.00

Buy Now

Are you an instructor?

Access detailed information about the course content, learning objectives, activities, and assessments before adding it to your curriculum.

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

Interactive Lessons

8+ Interactive Lessons | 95+ Exercises | 129+ Quizzes | 176+ Flashcards | 45+ Glossary of terms

Gamified TestPrep

40+ Pre Assessment Questions | 5+ Full Length Tests | 70+ Post Assessment Questions | 360+ Practice Test Questions

Hands-On Labs

68+ LiveLab | 68+ Video tutorials | 00+ Minutes

Video Lessons

44+ Videos | 15:29+ Hours

Download Course Outline

Introducing Oracle Database 12c RDBMS Oracle Database 12c

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

Introducing SQL

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

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

Using Group Functions

Group Function Fundamentals
Utilizing Aggregate Functions
Summary
Exam Essentials

Using Joins and Subqueries

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

Manipulating Data

Using DML Statements
Understanding Transaction Control
Summary
Exam Essentials

Creating Tables and Constraints

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

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

Introducing Oracle Database 12c RDBMS Oracle Database 12c

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

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

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

Using Group Functions

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

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

Manipulating Data

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

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?

USD 125

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

The 1Z0-061 exam is administered by Pearson VUE at the testing centers worldwide. Click here to find a testing center near you.

The exam consists scenario-based multiple choice questions.

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.

The exam contains 75 questions.

120 minutes

65%

Click here for more information.

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.

Oracle certifications have no expiration. The certification holder is certified for life unless Oracle changes its policy. Click here for more information.

Know more about the 1Z0-061