Oracle Database 12c Administrator (OCA) Training Course Online Course

Oracle Database 12c Administrator (OCA) Training Course

All levels
English

Course Description

Oracle Database technology is used by the world's leading companies to manage critical business functions, systems, and processes. Oracle Database is the number one database in the world. Over 305,000 top companies trust their critical systems to Oracle Database. Oracle Database is the number one embedded database technology. In fact, 97% of Global Fortune 500 companies use Oracle software. Well-trained, highly-skilled database professionals who can manage critical systems are in high demand. 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. Oracle Database certification teaches you how to perform complex, hands-on activities through labs, study, and practice. Additionally, Oracle certification exams validate your capabilities using real-world, scenario-based questions that assess and challenge your ability to think and perform.

See more less

What you’ll learn

Live Class Practical Oriented Training
Timely Doubt Resolution
Dedicated Student Success Mentor
Certification & Job Assistance
Free Access to Workshop & Webinar
No Cost EMI Option
Managing components with Oracle Restart. Configuring and managing the Network Environment.
Using the Oracle Support Workbench and My Oracle Support for updating Oracle Database software.
Acquiring an understanding of the Oracle Database Cloud Service.
Creating container databases and provisioning pluggable databases.
Upgrading existing versions of Oracle Database to the latest Oracle Database 12c. Creating and managing Storage Structur...
Learning basic backup and recovery techniques. Installing Oracle Grid Infrastructure for Standalone Servers.
Monitoring & troubleshooting the database while ensuring performance. Optimize the performance effectively & efficiently...

Covering Topics

Part-1 Oracle Database SQL Fundamental: 1Z0-071

Part-2 Oracle Database 12c Administration 1Z0-062

Curriculum

  Part-1 Oracle Database SQL Fundamental: 1Z0-071
Live Lectures - 1 to 14 
This Oracle Database: SQL and PL/SQL Fundamentals training delivers the fundamentals of SQL and PL/SQL along with the benefits of the programming languages using Oracle Database technology. You'll explore the concepts of relational databases.


Lecture-1-2 Introduction and Retrieving Data
Live Lecture 
·      Overview of Oracle Database 12c and Related Products

·      Overview of relational database management concepts and terminologies

·      Introduction to SQL and its development environments

·      What is the Oracle SQL Developer?

·      Starting SQL*Plus from Oracle SQL Developer

·      The Human Resource (HR) Schema

·      Tables used in the Course

·      Capabilities of the SELECT statement

·      Arithmetic expressions and NULL values in the SELECT statement

·      Column aliases

·      Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword

·      Use of the DESCRIBE command

·      Overview of relational database management concepts and terminologies

·      Practical Exercise


Lecture-3 Restricting and Sorting Data
Live Lecture 
·      Limiting the Rows

·      Rules of precedence for the operators in an expression

·      Substitution Variables

·      Using the DEFINE and VERIFY command

·      Practical Exercise


Lecture-4 Using Single-Row Functions to Customize Output
Live Lecture 
·      Describe implicit and explicit data type conversion

·      Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions

·      Nest multiple functions

·      Apply the NVL, NULLIF, and COALESCE functions to data

·      Use conditional IF THEN ELSE logic in a SELECT statement

·      Practical Exercise


Lecture-5 Using Conversion Functions & Conditional Expressions
Live Lecture 
·      Describe implicit and explicit data type conversion

·      Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions

·      Nest multiple functions

·      Apply the NVL, NULLIF, and COALESCE functions to data

·      Use conditional IF THEN ELSE logic in a SELECT statement

·      Practical Exercise


Lecture-6 Reporting Aggregated Data Using the Group Functions
Live Lecture 
·      Group Functions

·      Creating Groups of Data

·      Restricting Group Results

·      Practical Exercise


Lecture-7 Displaying Data from Multiple Tables Using Joins
Live Lecture 
·      Introduction to JOINS

·      Types of Joins

·      Natural join

·      Self-join

·      Non equijoins

·      OUTER join

·      Practical Exercise


Lecture-8 Using Subqueries to Solve Queries
Live Lecture 
·      Introduction to Subqueries

·      Single Row Subqueries

·      Multiple Row Subqueries

·      Practical Exercise


Lecture-9 Using the SET Operators
Live Lecture 
·      Set Operators

·      UNION and UNION ALL operator

·      INTERSECT operator

·      MINUS operator

·      Matching the SELECT statements

·      Using ORDER BY clause in set operations

·      Practical Exercise


Lecture-10 Managing Tables using DML statements
Live Lecture 
·      Data Manipulation Language

·      Database Transactions

·      Practical Exercise


Lecture-11 Introduction to Data Definition Language
Live Lecture 
·      Data Definition Language

·      Practical Exercise


Lecture-12 Introduction to Data Dictionary Views
Live Lecture 
·      Introduction to Data Dictionary

·      Describe the Data Dictionary Structure

·      Using the Data Dictionary views

·      Querying the Data Dictionary Views

·      Practical Exercise


Lecture-13 Creating Sequences, Synonyms, Indexes, Views
Live Lecture 
·      Overview of sequences

·      Overview of synonyms

·      Overview of indexes

·      Overview of views

·      Practical Exercise


Lecture 14-20 Views, Objects & Data
Live Lecture 
·      Lecture-14 Creating Views

·      Lecture-15 Managing Schema Objects

·      Lecture-16 Retrieving Data by Using Subqueries

·      Lecture-17 Manipulating Data by Using Subqueries

·      Lecture-18 Controlling User Access

·      Lecture-19 Manipulating Data

·      Lecture-20 Managing Data in Different Time Zones

  Part-2 Oracle Database 12c Administration 1Z0-062
Live Lectures - 15 to 35 

Lecture-15-16 Exploring and Managing Oracle Database
Live Lecture 
·      List the architectural components of Oracle Database

·      Explain the memory structures

·      Describe the background processes

·      Use database management tools

·      Practical Exercise


Lecture-17 Oracle Database Instance
Live Lecture 
·      Understand initialization parameter files

·      Start up and shut down an Oracle database instance

·      View the alert log and access dynamic performance views

·      Practical Exercise


Lecture-18 Configuring the Oracle Network Environment
Live Lecture 
·      Configure Oracle Net Services

·      Use tools for configuring and managing the Oracle network

·      Configure client-side network

·      Configure communication between databases

·      Practical Exercise


Lecture-19 Administering User Security
Live Lecture 
·      Create and manage database user accounts

·      Grant and revoke privileges

·      Create and manage roles

·      Create and manage profiles

·      Practical Exercise


Lecture-20 Managing Database Storage Structures
Live Lecture 
·      Describe the storage of table row data in blocks

·      Practical Exercise


Lecture-21 Create and manage tablespaces
Live Lecture 
·      Explain how Oracle database server automatically manages space

·      Save space by using compression

·      Use the Segment Advisor

·      Reclaim wasted space from tables and indexes by using the segment shrink functionality

·      Practical Exercise


Lecture-22 Managing Undo Data
Live Lecture 
·      Explain DML and undo data generation

·      Monitor and administer undo data

·      Describe the difference between undo data and redo data

·      Configure undo retention

·      Practical Exercise


Lecture-23 Managing Data Concurrency
Live Lecture 
·      Describe the locking mechanism and how Oracle manages data concurrency

·      Monitor and resolve locking conflicts

·      Practical Exercise


Lecture-24 Implementing Oracle Database Auditing
Live Lecture 
·      Enable standard database auditing and unified auditing

·      Practical Exercise


Lecture-25 Backup and Recovery Concepts
Live Lecture 
·      Identify the importance of checkpoints, redo log files, and archive log files

·      Practical Exercise


Lecture-26 Backup and Recovery Configuration
Live Lecture 
·      Configure the fast recovery area

·      Configure ARCHIVELOG mode

·      Practical Exercise


Lecture-27 Performing Database Backups
Live Lecture 
·      Create consistent database backups

·      Back up your database without shutting it down

·      Create incremental backups

·      Automate database backups

·      Manage backups

·      Practical Exercise


Lecture-28 Performing Database Recovery
Live Lecture 

Lecture-29 Moving Data
Live Lecture 
·      Describe ways to move data

·      Use SQL*Loader to load data from a non-Oracle database

·      Use external tables to move data via platform-independent files

·      Explain the general architecture of Oracle Data Pump

·      Use Data Pump Export and Import to move data between Oracle databases

·      Practical Exercise


Lecture-30 Performing Database Maintenance
Live Lecture 
·      Use server-generated alerts

·      Practical Exercise


Lecture-31 Managing Performance: SQL Tuning
Live Lecture 
·      Use the SQL Tuning advisor

·      Practical Exercise


Lecture-32 Automating Tasks by Using Oracle Scheduler
Live Lecture 
·      Use Oracle Scheduler to simplify management tasks

·      Use job chains to perform a series of related tasks

·      Use Scheduler jobs on remote systems

·      Use advanced Scheduler features to prioritize jobs

·      Practical Exercise


Lecture-33 Creating an Oracle Database Using DBCA
Live Lecture 
·      Generate database creation scripts by using DBCA

·      Manage database design templates by using DBCA

·      Practical Exercise


Lecture-34 Upgrading Oracle Database Software
Live Lecture 
·      Describe data migration methods

·      Describe the upgrade process

·      Practical Exercise


Lecture-35 Introduction to DBAAS
Live Lecture 
·      Recognize the difference between a DBaaS Instance and a Database Instance

·      Navigate with My Services Dashboard

·      User authentication and roles

·      Generate a Secure Shell (SSH) Public/Private Key Pair

·      Practical Exercise

Frequently Asked Questions

Basic understanding of Oracle database.

Ans: The course offers a variety of online training options, including: • Live Virtual Classroom Training: Participate in real-time interactive sessions with instructors and peers. • 1:1 Doubt Resolution Sessions: Get personalized assistance and clarification on course-related queries. • Recorded Live Lectures*: Access recorded sessions for review or to catch up on missed classes. • Flexible Schedule: Enjoy the flexibility to learn at your own pace and according to your schedule.

Ans: Live Virtual Classroom Training allows you to attend instructor-led sessions in real-time through an online platform. You can interact with the instructor, ask questions, participate in discussions, and collaborate with fellow learners, simulating the experience of a traditional classroom setting from the comfort of your own space.

Ans: If you miss a live session, you can access recorded lectures* to review the content covered during the session. This allows you to catch up on any missed material at your own pace and ensures that you don't fall behind in your learning journey.

Ans: The course offers a flexible schedule, allowing you to learn at times that suit you best. Whether you have other commitments or prefer to study during specific hours, the course structure accommodates your needs, enabling you to balance your learning with other responsibilities effectively. *Note: Availability of recorded live lectures may vary depending on the course and training provider.