Scroll to top button

Oracle Database 12c: SQL Fundamentals

ISBN : 9781616913465
Gain hands-on expertise to pass Oracle SQL Database 12c 1Z0-061 certification with Oracle Database 12c: SQL Fundamentals course. It offers complete coverage of the 1Z0-061 exam objectives and provides expertise on the topics such as SQL, group functions, single-row functions, joins and subqueries, data manipulation, table and constraints creation, 12c RDBMS Database, and more. The course goes beyond traditional Oracle exam preparation to strengthen your knowledge in all aspects of a relational database.
5 average from 2 customer rating

The Oracle Database 12c Fundamentals exam comes under the category of 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
Lessons
8+
Exercises
128+
Quizzes
135+
Flashcards
43+
Glossary of terms
43+
TestPrep
Pre Assessment Questions
10+
Full Length Tests
4+
Post Assessment Questions
48+
LiveLab (Add-on Component)
livelab
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.

Video Lessons
Videos
44+
Hours
15:29+
  • 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 (LiveLab)

Customer Testimonials

Tejas Thakur
excellent
I found uCertify Oracle OCA 12c course very helpful, and complete. The course provided an abundance of information about the curriculum and was well organized. It is just an exceptional tool that helped me study for a course in which I was interested. I looked forward to the quizzes at the end of each topic, because at that moment I could always test to see how much I have learned and can always revisit the topic; should I need. The course is to the point, I have read the course is very informative and can help to understand the detailed aspect of Oracle RDBMS concepts, and totally align with the exam structure.
Rakshit Goyal
excellent
Oracle Database 12c: SQL Fundamentals by uCertify is one of the most user-friendly courses having images to understand the logical model (ERP), videos with transcripts to read throughout the video. They have text material as well if you like to read rather than watching videos and these texts are as rich-featured as Oracle 12c. I highly recommend this course to all those who have experience with SQL.
×