Oracle Certified Associate (OCA) DBA 11g is designed for IT professionals who are beginning to work with Oracle technologies. This OCA certification is appropriate for junior-level database administrators who maintain an Oracle database, or work on a team that administers the DBMS in a business environment. Oracle Certified Associate (OCA) DBA 11g certification validates the fundamental skills needed to install, configure and maintain an Oracle database. Oracle Database 11g Administrator Certified Associates can also configure and manage the Oracle network environment.
- Database Engineer
- Database Support
- Database Administrator
- Oracle Specialist
Global – From the Oracle Academy
Oracle Database 11g Administrator Certified Associate requires only 1 exam
Exam Code: 1Z0-052
Expert Oracle University instructors will reinforce topics with structured hands-on practices that will prepare you for the corresponding Oracle Certified Associate exam. Learn To: Install Oracle Grid Infrastructure. Create and manage users. Install and configure an Oracle Database. Create and manage storage structures. Administer the Oracle Database. Understand the Oracle database architecture and how its components work and interact with one another. Perform backup and recovery.
Online – 100% Flexible Self Study – You study at your own pace, at your own time. You have 24 hours access via your own private study portal.
40-80 hours (depends on the learner, how quickly they pick the skills is up to the student) you have 2 years access to your course material. You have more than enough time to complete this short course).
** Part – time students dedicate on average 5 hours study time per week. This course would approximately take 8-16 weeks to complete at that pace of study.
Within 3 working days payment confirmation and Enrolment form completed or you can pick your own start date!
- Retrieve Data using the SQL SELECT Statement
- Learn to Restrict and Sort Data
- Usage of Single-Row Functions to Customize Output
- Describe the differences between single row and multiple row functions
- Invoke Conversion Functions and Conditional Expressions
- Aggregate Data Using the Group Functions
- Display Data from Multiple Tables Using Joins
- Use Sub-queries to Solve Queries
- Use of DDL Statements to Create and Manage Tables
- Create a simple and complex view
- Retrieve data from views
- Create, maintain, and use sequences
- Management of Schema Objects
- Query External Tables
- Install your Oracle Software
- Backup and Recovery Concepts
- Perform Database Backups
Mentor Support – Free
Support from an official Cisco Certified mentor via email (response within 24 hours), Live chat (typically available in the evenings Australia time) or telephone (typically available in the evenings Australia time).
Practice Exams/ Mock Exams – Free
Test Prep can be taken in either Study or Certification mode.
EBOOKS – Included for Free
E-books for relevant course included for free.
If you like a particular hardcopy (paperback) book,
contact us to find out if you can also purchase a hard copy book (separate cost)
ORACLE – is a globally recognized certification and Cert.Hub will help book the global certification exam as part of the enrolment process. You can choose a date and time once you are close to completing your course or you can contact us via email@example.com to seek exam-booking advice. This service is included for free when you enroll for this course.