OCA: Oracle Database 12c Administrator Certified Associate

The process of becoming Oracle Database certified broadens your knowledge and skills by exposing you to a wide array of important database features, functions and tasks. This training course, offered by our accredited school partners, teaches you how to master the skills associated with becoming Oracle (OCA) Certified. You’ll become more valuable to your current and/or future potential employer. Earning this in demand certification will expand your job opportunities, support job stability and speed up your career. The Oracle Database 12c Administrator Certification ensures that as database professionals you have a strong foundation and expertise in the industry’s most advanced database management system, Oracle 12c.

This training course prepares you for Oracle’s certification exams, 1Z0-071 and 1Z0-062. Your training will include topics such as how to install and maintain an Oracle database, cloud computing, how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques.

Course outline:
Module 1: Fundamentals of Relational Database Management Systems, SQL, single row functions
Module 2: Architectural components of the Oracle Database and how to manipulate data
Module 3: How to create an Oracle Database and how to manage storage and space
Module 4: How to implement security and auditing functions, and manage database performance
Module 5: How to use the back-up recovery system, how to perform an upgrade, and how to configure grid infrastructure

Students will learn skills required for working with SQL, including how to use the advanced features of SQL in order to query and manipulate data within the database, control privileges at the object and system level, and use advanced querying and reporting techniques. Enroll through one of our accredited university or college partners today!

Module 1-SQL and DDL Statements
• Identify the Connection Between an ERD and a Relational Database
• Relationship Between a Database and SQL
• Purpose of DDL
• Purpose of DML
• SELECT Statement
• Categorize the Main Database Objects
• Create a Simple Table
• Review the Table Structure

Module 2-Manipulating Data
• Truncate Data
• Insert Rows into a Table
• Update Rows in a Table
• Delete Rows from a Table
• Control Transactions
• Restricting and Sorting Data
• SQL Row Limiting

Module 3-Single-Row Functions and Conversion Functions
• Character and Number Functions
• Date Functions
• DUAL Table
• Conversion Functions
• Analytical Functions
• Nesting Functions
• SELECT Statements

Module 4-Aggregated Data – Group Functions and Multiple Tables
• Describe the Use of Group Functions
• Group Data by Using the GROUP BY Clause
• Displaying Data from Multiple Tables
• Different Types of Joins and Their Features
• Join a Table to Itself by Using a Self-Join
• Inner Joins and National Joins
• USING

Module 5-Subqueries and Schema Objects
• Define Subqueries
• Types of Subqueries
• Update and Delete Rows Using Correlated Subqueries
• EXISTS and NOT EXISTS Operators
• Write Single-Row and Multiple-Row Subqueries
• How Schema Objects Work
• Create Simple and Complex Views with Visible/Invisible Columns
• Create, Maintain, and Use Sequences
• Perform Flashback Operations

Module 6-Set Operators and Data Dictionary Views
• Describe Set Operators
• Control the Order of Rows Returned
• ORDER BY – By Position
• ORDER BY – By Reference
• Query Various Data Dictionary Views
• Dynamic Performance Views

Module 7-Manipulating Large Data Sets and Controlling User Access
• Features of Multitable INSERTS
• Merge Rows into a Table
• System Privileges from Object Privileges
• Grant Privileges on Tables and on a User
• Distinguish Between Privileges and Roles

Module 8-Exploring the Oracle Database Architecture
• Install the Oracle Database Software
• User Accounts
• OUI Inventory
• Generate Database Creation Scripts by Using DBCA
• Configure Database Options by Using DBCA
• Memory Structures
• Background Processes
• Physical Database Structures
• Logical Database Structures

Module 9-Managing and Configuring
• Use Database Management Tools
• Understand Initialization Parameter Files
• Alert Logs and Dynamic Performance Views
• Configure Oracle Net Services
• Configure Client-Side Network
• Configure Communication Between Databases
• Describe Storage of Table Row Data in Blocks
• Create and Manage Tablespaces

Module 10-Managing Space and User Security
• Save Space by Using Compression
• Segment Advisor
• Manage Resumable Space Allocation
• Create and Manage Database User Accounts
• Grant and Revoke Privileges
• Create and Manage Roles and Profiles
• DML and Undo Data Generation
• Monitor and Administer Undo Data

Module 11-Auditing and Maintenance
• Shared and Exclusive Locks
• Automatic and Manual Locking
• Monitor and Resolve Locking Conflicts
• DBA Responsibilities for Security and Auditing
• Enable Standard Database Auditing and Unified Auditing
• Manage the Automatic Workload Repository (AWR)
• Describe and Use the Advisory Framework
• Set Alert Thresholds
• Automated Tasks

Module 12-Performance and Resources
• Use Automatic Memory Management
• Use the Memory Advisor to Size Memory Buffers
• Manage Optimizer Statistics
• Use the SQL Tuning Advisor
• Use the SQL Access Advisor to Tune Workload
• Configuring the Database Resource Manager
• Access and Create Resource Plans

Module 13-Automating Tasks, Backup, and Recovery
• Job Chains to Perform a Series of Tasks
• Use Scheduler Jobs on Remote Systems
• Moving Data
• Create and Use Directory Objects
• SQL*Loader
• Oracle Data Pump
• Back and Recovery: Configuration
• Configure Fast Recovery Area
• Automate Database Backups
• Manage Backups

Module 14-Restart and Upgrades
• Configure Storage for Oracle Automatic Storage Management
• Standalone Server
• Using Oracle Restart to Manage Components
• Upgrade Methods
• Migration Methods
• Upgrade Process
• Upgrade Requirements
• Migrate to Unified Auditing

Earning the Oracle Database 12c Administrator Certified Associate (OCA) credential demonstrates that you carry the foundational knowledge and skills needed to administer the Oracle Database, and sets the stage for your future progression to Oracle Database 12c Administrator Certified Professional (OCP). With Oracle Database 12c, you will experience the benefits of an Oracle Database that is re-engineered for Cloud computing. Multitenant architecture brings enterprises unprecedented hardware and software efficiencies, performance and manageability benefits, and fast and efficient Cloud provisioning. Oracle Database 12c certifications emphasize the full set of skills that DBAs need in today’s competitive marketplace.

6 Reasons to Complete Your Training With Us

Flexibility

With our programs, you can learn and study at your own pace with access 24/7/365 for the duration of your program. This means you can learn on your own terms and work around your own schedule.

Support

Our online training comes with access to real, live support personnel that will help you through every step from our admissions adviser who will assist you with selecting the right training for you, to our student adviser who will be there with you during your entire training journey.

Relevancy

We have tailored our programs to provide comprehensive training in the technical and soft skills employers are looking for. With direct input and feedback from industry leaders and hiring managers, our program aligns with exactly what you need to successfully enter the workforce.

Certification

Our career training not only gives you the knowledge you need but preparation for the certification exams relevant to your desired career path. If you are pursuing an exciting new career in a field with a national certification, our program will both prepare you to sit for the exam but will often include a voucher for the exam cost.

Simulations and Case Studies

Our training programs have been developed with real learners and professionals in mind, so our programs incorporate real-world case studies and virtual simulations that will provide examples and interactions with real-life situations you may encounter during your career. These allow you to learn by experience with circumstances similar to what will be your daily responsibilities on the job.

Engaging and Interactive

Our training curriculum was developed with you in mind, looking at modern day learners and their needs. Our curriculum contains a mix of formats including reading, listening, watching, and interacting that will immerse you into a fun and engaging learning experience you will not only enjoy but not want to end.

Program Description

FAQ

To request more information, you can contact us via online chat, our website contact form, or toll free at 1-855-201-6910.

Online courses are accessible 24/7/365 and self-paced, allowing you to progress at your own pace on your own schedule. They can be taken from anywhere in the world from the comfort of your own home. Classroom courses have a set schedule of the days and times the courses will be held, and you must attend during those specific times.

Find out if online learning is right for you by contacting our team of registration advisers. Our team is available to answer any of your questions about taking an online course before you commit to enrolling. We will walk you through what to expect to ensure you are making the right decision. You can contact a registration adviser today via online chat, our website contact form, or toll free at 1-855-201-6910.

No, you are not required to have a diploma or higher education degree to enroll in an online course. However, some occupations may require minimum educational thresholds for employment or certification. For more information on your desired career requirements, please contact us via online chat, our website contact form, or toll free at 1-855-201-6910.

To take an online course, you will need to have access to an internet connection and an internet ready device such as a laptop, PC, or tablet. For course specific requirements, please visit the course page or contact a registration adviser today.

Our courses are developed with multiple formats including text, audio, video, and interactivity. Our courses also include multiple resources and tools which can include flashcards, games, activities, and more.

No, you can take the online courses from anywhere in the world.

We participate in several financial assistance options including third party funding, both military and non-military. To request more information on the financial assistance options available and check your eligibility, contact us via online chat, our website contact form, or toll free at 1-855-201-6910.

Duration is the amount of time you will receive access to your course. Durations vary by course and range between 1 month and 12 months. If you complete your course before your duration ends you will continue to have access to your course until the duration period ends.

Many of our career training programs include certification vouchers. This means that at the successful completion of your course, at no additional charge, you will receive an exam voucher for the corresponding industry certification. This voucher will allow you to register and sit for the appropriate certification exam to obtain your industry credential.

Our online courses are open enrollment, so you can start immediately. If you are using any third-party funding to cover your course tuition, your start date may be a future date determined by your funding program.

Once enrolled, you will be assigned a client adviser who will provide you with customer and technical support. Your client adviser will supply you with your course access information, any needed materials, and be available to answer any questions you have during your training experience. They will regularly check-in with you to monitor your progress and assist you with staying on track. You will also be assigned to a course mentor who will provide curriculum support throughout your training. Your mentor is available to answer any questions you have on your course curriculum, will monitor your progress and understanding of the curriculum, and may give assignments or quizzes.

If you experience any trouble accessing your course including technical issues or lost login credentials, please contact your client adviser at Austin Peay State University.

Our goal for students is to successfully complete their training course and achieve their career goals. We understand that extenuating circumstances can interfere with your ability to complete your course in the duration given. Because of this we have free or low-cost extensions available for our courses upon request. To discuss or request an extension please contact your client adviser at Austin Peay State University.

Upon successful completion of your course and fulfillment of any outstanding financial obligations, you will receive your certificate of completion. Certificates are provided to you within 30 days of completion. Your certificate will validate the training course you completed with a stamp of completion.

Students that successfully complete our career training programs are assigned a career development adviser who will coordinate placement at a local externship or hands on opportunity. These opportunities are optional and may vary based on availability and occupation. Your career development adviser will also provide job search services such as: resume building, mock interviews, job opportunity resources, and more. Our professional enrichment courses do not come with a career adviser or career services.

6 Reasons to Complete Your Training With Us

Program Description

FAQ

Any Questions?