Oracle Database 12c: SQL Fundamentals (1Z0-061)
(1Z0-061)
/ ISBN: 9781616913465
This course includes
Lessons
TestPrep
LiveLab (Add-on)
Mentoring (Add-on)
Oracle Database 12c: SQL Fundamentals (1Z0-061)
Pass the Oracle Database certification exam with the Oracle Database 12c: SQL Fundamentals course and lab. The lab comes with a well-organized component library for every task. The Oracle database full 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.
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
Test Preps
-
10+ Pre Assessment Questions
-
48+ Post Assessment Questions
LiveLab (Add-on)
-
68+ LiveLab
Video Lessons
-
44+ Videos
-
15:29+ Hours
- 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
| 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:
|
| 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. |
Tejas Thakur
Rakshit Goyal
Show more
×
