Oracle Database 12c: SQL Fundamentals
Get complete knowledge about the Oracle SQL Database 12c fundamentals with 1Z0-061 Oracle Database SQL Fundamentals course. The course offers complete coverage of the 1Z0-061 exam objectives and provides expertise in the topics such as SQL, group functions, single-row functions, joins and subqueries, data manipulation, table and constraints creation, 12c RDBMS Database, and many more. The Oracle Database 12c Fundamentals exam comes under the category of OCA/OCP certification. The study guide goes beyond traditional Oracle exam preparation to strengthen your knowledge in the exact areas. You can access structured, multimedia self-study courses and have industry experienced in this course.
Here's what you will get
The Oracle 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+
Exercises
138+
Quizzes
125+
Flashcards
43+
Glossary of terms
43+
Pre-assessment Questions
10+
Full Length Tests
4+
Post-Assessment Questions
48+
live lab
68+
Videos and How To..
uCertify course includes videos to help understand concepts. It also includes How Tos that help learners with how to accomplish certain tasks.
Videos
44+
Hours
15:29+
|
Exam FAQs
| |
|---|---|
| What is the exam registration fee? | USD 120 |
| Where do I take the exam? | Pearson VUE |
| What is the format of the exam? | The exam consists 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. |
| Which certification covers this exam? | |
Here's what you will learn
- 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)
1Z0-061
uCertify provides courses, simulator, labs, test prep kits for IT certifications including Microsoft, Oracle, Cisco, CompTIA, CIW, PMI, ISC2, Linux, Zend, IC3, Adobe, and many more.
© 2002-2019 uCertify.
All Rights Reserved
Know Us
- About us
- Careers
- Partners
- Sitemap
- Contact us
- Terms & Conditions
- Privacy Statement