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.
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.
Administration provider and located in Australia. Powered by Skillsoft content
- 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.
None are required for this course.
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-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.
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
- 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 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.