Oracle Database 11g Administrator Certified Associate

About this course

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.

Study Mode:

Online Only

Course Fees:

AUD $795 + GST. This does not include the cost of the official Oracle Database 11g Certification exam. We can help guide you on how to book the exam as it is a self booking service.

To Enrol for this course, please contact our Learning Consultants. Click here –  Contact Us 

If you are looking at completing more than one Certification in the next 12 months, it might be worthwhile looking at our Course Subscription option. To find out more Click here – Subscription option. 

Provider:

Administration provider and located in Australia. Powered by Skillsoft content

Career Opportunities:
  • Database Engineer
  • Database Support
  • Database Administrator
  • Oracle Specialist
 
Recognition:

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.

Pre Requisites:

None are required for this course.

Course location:

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.

Course Length:

40-60hours (depends on the learner, how quickly they pick the skills is up to the student) you have 6 months (180 days) 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-12 weeks to complete at that pace of study.

Start date:

Within 3 working days payment confirmation and enrolment form completed or you can pick your own start date!

What will I Learn / Extra Information:

How many units and what are the modules I will learn

  1. Retrieve Data using the SQL SELECT Statement
  2. Learn to Restrict and Sort Data
  3. Usage of Single-Row Functions to Customize Output
  4. Describe the differences between single row and multiple row functions
  5. Invoke Conversion Functions and Conditional Expressions
  6. Aggregate Data Using the Group Functions
  7. Display Data from Multiple Tables Using Joins
  8. Use Sub-queries to Solve Queries
  9. Use of DDL Statements to Create and Manage Tables
  10. Create a simple and complex view
  11. Retrieve data from views
  12. Create, maintain, and use sequences
  13. Management of Schema Objects
  14. Query External Tables
  15. Install your Oracle Software
  16. Backup and Recovery Concepts
  17. Perform Database Backups

Support and how the course is delivered

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)

How to Enrol for this course

For the Subscription option please click below on the Subscribe Here button.

For the Individual course, please contact us via live chat or click below on the Contact CertHub button.