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.

Ready to start but need to ask a few questions?

Click here to contact us and we will give you a call and answer all your questions,explain and then guide you, through the simple enrolment process and payment options.

From $395.00

Study Mode:

Online

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.

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-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.

Start date:

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

How many units and what are the modules I will learn

  • 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

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 do I book the Certification exam?

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 bookings@certhub.com.au to seek exam-booking advice. This service is included for free when you enroll for this course.

PO Box 245 Neutral Bay NSW 2089 Australia

02 8279 6900

Email: bookings@certhub.com.au

Subscribe Us

Get Your IT Certification and land the job you want!