Oracle 12c SQL Fundamentals Exam Prep - 1Z0-061

Share this page:

Exam Details

Duration:	120 minutes
Number of Questions:	75
Passing Score:	65% View passing score policy
Validated Against:	This exam has been validated against Oracle Database 12.1.0.1.0.
Format:	Multiple Choice
Exam Price:	Rs 8084 More on exam pricing

Course Content / Exam(s)

1. Introduction

Appendixes and Practices Used in the Course.
Oracle Database 12c: Focus Areas.
Oracle Database 12c.
Relational and Object Relational Database Management Systems
Data Storage on Different Media
Relational Database Concept.
Definition of a Relational Database.
Data Models.
Entity Relationship Model.
Entity Relationship Modelling Conventions.
Relating Multiple Tables.
Relational Database Terminology.
Human Resources (HR) application.
Tables Used in This Course.
Tables Used in the Course.
Using SQL to Query Your Database.
How SQL Works.
SQL Statements Used in the Course.
Development Environments for SQL.
Introduction to Oracle Live.
Oracle Database Documentation.

2.Retrieving Data Using the SQL SELECT Statement

3.Restricting and Sorting Data

Limiting Rows by Using a Selection
Limiting Rows That Are Selected
Using the WHERE Clause
Character Strings and Dates
Comparison Operators
Using Comparison Operators
Range Conditions Using the BETWEEN Operator
Using the IN Operator
Pattern Matching Using the LIKE Operator
Combining Wildcard Symbols
Using NULL Conditions
Defining Conditions Using Logical Operators
Using the AND Operator
Using the OR Operator
Using the NOT Operator
Rules of Precedence
Using the ORDER BY Clause
Sorting
SQL Row Limiting Clause
Using SQL Row Limiting Clause in a Query
SQL Row Limiting Clause: Example
Substitution Variables
Using the Single-Ampersand Substitution Variable
Character and Date Values with Substitution Variables
Specifying Column Names, Expressions, and Text
Using the Double-Ampersand Substitution Variable
Using the Ampersand Substitution Variable in SQL*Plus
Using the DEFINE Command
Using the VERIFY Command

4.Using Single-Row Functions to Customize Output

Objectives
HR Application Scenario
SQL Functions
Two Types of SQL Functions
Single-Row Functions
Character Functions
Case-Conversion Functions
Using Case-Conversion Functions
Character-Manipulation Functions
Using Character-Manipulation Functions
Nesting Functions
Nesting Functions: Example
Numeric Functions
Using the ROUND Function
Using the TRUNC Function
Using the MOD Function
Working with Dates
RR Date Format
Using the SYSDATE Function
Using the CURRENT_DATE and CURRENT_TIMESTAMP Functions
Arithmetic with Dates
Using Arithmetic Operators with Dates
Date-Manipulation Functions
Using Date Functions
Using ROUND and TRUNC Functions with Dates

5.Using Conversion Functions and Conditional Expressions

Conversion Functions
Implicit Data Type Conversion of Strings
Implicit Data Type Conversion to Strings
Explicit Data Type Conversion
Using the TO_CHAR Function with Dates
Elements of the Date Format Model
Using the TO_CHAR Function with Dates
Using the TO_CHAR Function with Numbers
Using the TO_NUMBER and TO_DATE Functions
Using TO_CHAR and TO_DATE Functions with the RR Date Format
General Functions
NVL Function
Using the NVL Function
Using the NVL2 Function
Using the NULLIF Function
Using the COALESCE Function
Conditional Expressions
CASE Expression
Using the CASE Expression
Searched CASE Expression
DECODE Function
Using the DECODE Function

6.Reporting Aggregated Data Using the Group Functions

Group Functions
Types of Group Functions
Group Functions: Syntax
Using the AVG and SUM Functions
Using the MIN and MAX Functions
Using the COUNT Function
Using the DISTINCT Keyword
Group Functions and Null Values
Creating Groups of Data
Creating Groups of Data: GROUP BY Clause Syntax
Using the GROUP BY Clause
Grouping by More Than One Column
Using the GROUP BY Clause on Multiple Columns
Illegal Queries Using Group Functions
Restricting Group Results
Restricting Group Results with the HAVING Clause
Using the HAVING Clause
Nesting Group Functions

7.Displaying Data from Multiple Tables Using Joins

Why Join?
Obtaining Data from Multiple Tables
Types of Joins
Joining Tables Using SQL:1999 Syntax
Creating Natural Joins
Retrieving Records with Natural Joins
Creating Joins with the USING Clause
Joining Column Names
Retrieving Records with the USING Clause
Qualifying Ambiguous Column Names
Using Table Aliases with the USING Clause
Creating Joins with the ON Clause
Retrieving Records with the ON Clause
Creating Three-Way Joins
Applying Additional Conditions to a Join
Joining a Table to Itself
Self-Joins Using the ON Clause
Nonequijoins
Retrieving Records with Nonequijoins
Returning Records with No Direct Match Using OUTER Joins
INNER Versus OUTER Joins
LEFT OUTER JOIN
RIGHT OUTER JOIN
FULL OUTER JOIN
Cartesian Products
Generating a Cartesian Product
Creating Cross Joins

8. Using Subqueries to Solve Queries

Using a Subquery to Solve a Problem
Subquery Syntax
Using a Subquery
Rules and Guidelines for Using Subqueries
Types of Subqueries
Single-Row Subqueries
Executing Single-Row Subqueries
Using Group Functions in a Subquery
HAVING Clause with Subqueries
What Is Wrong with This Statement?
No Rows Returned by the Inner Query
Multiple-Row Subqueries
Using the ANY Operator in Multiple-Row Subqueries
Using the ALL Operator in Multiple-Row Subqueries
Multiple-Column Subqueries
Multiple-Column Subquery: Example
Null Values in a Subquery

9.Using Set Operators

Set Operators
Set Operator Rules
Oracle Server and Set Operators
Tables Used in This Lesson
UNION Operator
Using the UNION Operator
UNION ALL Operator
Using the UNION ALL Operator
INTERSECT Operator
Using the INTERSECT Operator
MINUS Operator
Using the MINUS Operator
Matching SELECT Statements
Matching the SELECT Statement: Example
Using the ORDER BY Clause in Set Operations

10. Managing Tables Using DML Statements

HR Application Scenario
Data Manipulation Language
Adding a New Row to a Table
INSERT Statement Syntax
Inserting New Rows
Inserting Rows with Null Values
Inserting Special Values
Inserting Specific Date and Time Values
Creating a Script
Copying Rows from Another Table
Changing Data in a Table
UPDATE Statement Syntax
Updating Rows in a Table
Updating Two Columns with a Subquery
Updating Rows Based on Another Table
Removing a Row from a Table
DELETE Statement
Deleting Rows from a Table
Deleting Rows Based on Another Table
TRUNCATE Statement
Database Transactions
Database Transactions: Start and End
Advantages of COMMIT and ROLLBACK Statements
Explicit Transaction Control Statements
Rolling Back Changes to a Marker
Implicit Transaction Processing
State of Data Before COMMIT or ROLLBACK
State of Data After COMMIT
Committing Data
State of Data After ROLLBACK
State of Data After ROLLBACK: Example
Statement-Level Rollback
Read Consistency
Implementing Read Consistency
FOR UPDATE Clause in a SELECT Statement
FOR UPDATE Clause: Examples
LOCK TABLE Statement

11. Introduction to Data Definition Language

12. Oracle Cloud Overview

Introduction to Oracle Cloud
Oracle Cloud Services
Cloud Deployment Models
Evolving from On-premises to Exadata Express
What is in Exadata Express?
Exadata Express for Users
Exadata Express for Developers
Getting Started with Exadata Express
Oracle Exadata Express Cloud Service
Getting Started with Exadata Express
Managing Exadata
Service Console
Web Access through Service Console
Client Access Configuration through Service Console
Database Administration through Service Console
SQL Workshop
Connecting through Database Clients
Enabling SQL*Net Access for Client Applications
Downloading Client Credentials
Connecting Oracle SQL Developer
Connecting Oracle SQLcl

D. Commonly Used SQL Commands

Basic SELECT Statement
SELECT Statement
WHERE Clause
ORDER BY Clause
GROUP BY Clause
Data Definition Language
CREATE TABLE Statement
ALTER TABLE Statement
DROP TABLE Statement
GRANT Statement
Privilege Types
REVOKE Statement
TRUNCATE TABLE Statement
Data Manipulation Language
INSERT Statement
UPDATE Statement Syntax
DELETE Statement
Transaction Control Statements
COMMIT Statement
ROLLBACK Statement
SAVEPOINT Statement
Joins
Types of Joins
Qualifying Ambiguous Column Names
Natural Join
Equijoins
Retrieving Records with Equijoins
Additional Search Conditions Using the AND and WHERE Operators
Retrieving Records with Nonequijoins
Retrieving Records by Using the USING Clause
Retrieving Records by Using the ON Clause
Left Outer Join
Right Outer Join
Full Outer Join
Self-Join: Example
Cross Join

Schedule for Oracle Database 12c: SQL Fundamentals (Oracle Training in Nagpur, Pune And Bangalore)
Course Contents	Exam #	Regular Track (days)	Fast Track (days)
Oracle Database 12c: SQL Fundamentals	1Z0-061	40	5
Balance Days for arrival, exam(s) and practice		5	3
Total duration		45	8

Benefits of Learning From Unisoft Technologies
Authorized Oracle Official Curriculum - Ekits (PDF's)
Award of Completion Certificate (AOC) - Directly from Oracle for Course Completion.
25% Discount Voucher on Each Individual Oracle Exam.
Get Trained By Qualified and Certified Faculties.
Mock Test for Exam Preparations.

FAQ's

How would a certificate from Unisoft Technologies help me?

In today’s era where technologies and best practices are changing rapidly, and demand for qualified candidates is significantly increasing, a certification from Oracle is the key to your success and a valuable add-on in your resume. Our training courses are designed and updated by Oracle University renowned industry experts, and more than 40 global organizations have recognized us as an official provider of certification training.

Who are the trainers?

All our trainers are certified and are highly qualified, with multiple years of experience in working with front-end development technology.

What are the prerequisites for SQL training course?

There are no prerequisites for this SQL Training course.