Oracle DBA 12C Course Overview
JOYATRES Online Training Institute provides best Oracle DBA 12c Online Training by our highly professional certified trainers. Database administrators (DBAs) use specialized software to store and organize data. Each database requires at least one database administrator (DBA) to administer it. Because an Oracle database system can be large and can have many users often this is not a one person job. In such cases, there is a group of DBAs who share responsibility. We are delighted to be one of the best leading IT online training with best experienced IT professionals and skilled resources. We have been offering courses to consultants, companies so that they can meet all the challenges in their respective technologies and also we are offering other courses like Oracle SOA 12C.
Highlights of Oracle DBA 12C Online training:-
* Very in depth course material with Real Time Scenarios for each topic with its Solutions for Oracle DBA 12C Online Trainings.
* We Also provide Case studies for Oracle DBA 12C Online Training.
* We do Schedule the sessions based upon your comfort by our Highly Qualified Trainers and Real time Experts.
* We provide you with your recorded session for further Reference.
* We also provide Normal Track, Fast Track and Weekend Batches also for Oracle DBA 12C Online Training.
* We also provide Cost Effective and Flexible Payment Schemes.
What is Oracle DBA?
Oracle DBA is the Relational Database management system. The main aim of Oracle DBA is data storing, managing and retrieve information efficiently and deliver with high performance. It is also called RDBMS.
- Database Administrators
- Security Officers
- Network Administrators
- Application Developers
- Application Administrators
- Database Users
Database Administrators:
Database Administrator (DBAs) use the specialized software package to store and organize information. The role could embrace capability designing, installation, configuration, information style, migration, and performance observation, security, troubleshooting, additionally as backup and information recovery.
Each Database needs a minimum of one database administrator (DBA) to administer it. As a result of changes in Oracle DB system may be massive and might have several users, usually, this can be not a 1 person job. In such cases, there’s a bunch of DBAs Who share responsibility.
What Are The Responsibilities Of A Database Administrator?
As the data center grows with the growth in business, so do the challenges. An administrator is faced with challenges that include:
- Monitoring high levels of performance and availability of applications
- Identifying and resolving problems quickly and effectively
- Enabling IT professionals to use resources effectively, thereby reducing costs
- Aligning IT with business priorities to ensure that businesses are agile enough to meet the changing needs
Why will we learn Oracle DBA?
Oracle has maintained the lead in the industry with a large number of trend-setting products.
Some of the marquee areas in the Oracle Database 12c release are the following:
- Private Database Cloud
- Defense in Depth included Oracle Data Redaction, Real Application Security
- Information Lifecycle Management (ILM), which includes hot/cold data classification, declarative compression and tiering, In-database Archiving and Valid-Time Temporal
- Flex Clusters
What will we learn after completion of Oracle DBA Course?
- Learn to install Oracle database/client binaries
- Create Oracle databases.
- Configure network
- Query data using structured query language and perform DDL, DML and DCL operations
- Configure backups and perform recovery using recovery manager
- Work with a recovery catalog
- Work with Oracle database parameters
- Work with tablespaces, database objects etc.
- Managing Users/Schemas
- Managing profiles, roles, and grants
- Learn how to work with RDBMS to store and retrieve data
What are the Prerequisites for Oracle DBA Training?
Our Experienced trainers will teach from basics, if you have a basic idea of Data warehousing concepts is an added advantage for this course.
Course Finished Certificate:
After finish, the course we provide Oracle DBA course finished certificate of kits technologies looks like
Oracle DBA 12C Course Curriculum
- What is DBA?
- Why a Company needs a DBA?
- Roles & Responsibilities of DBA
- Identify the oracle product
- Oracle Architecture
- Physical and Logical Phase of Database
- System requirements.
- Redhat Linux Installation
- Install software with the Oracle Universal Installer on Linux Platform
- Identify System Requirements
- Optimal Flexible Architecture (OFA)
- Discuss Oracle Base
- Discuss Oracle Home
- Prerequisite Checks and Fixup Utility
- Describe the multitenant architecture
- Describe the root and pluggable database containers
- Differentiate the root from a pluggable database
- Explain pluggable database plugging
- List impacts in various areas
- Initialization Parameter Files
- Starting Up Oracle Databases
- Shutting Down Oracle Databases
- Opening and Closing PDBs
- Working with the Automatic Diagnostic Repository (ADR)
- Querying Dynamic Performance Views
- Methods and Tools to Create PDBs
- Creating PDBs from Seed with SQL*Plus
- Cloning PDBs with SQL*Plus
- Unplugging and Pluggin In PDBs with SQL*Plus
- Dropping PDBs with SQL*Plus
- Configure and create a CDB, Create a PDB from PDB$SEED
- Plug or clone a non-CDB into a CDB
- Clone a local or remote PDB into a CDB
- Unplug and plug a PDB from one CDB to another CDB
- Explore the instance and structure of PDBs
- Migrate a pre-12.1 non-CDB database to CDB
Managing Tablespaces and Users in CDB and PDBs
- How Table Data is Stored
- Creating Tablespaces in SQL*Plus
- Altering and Dropping Tablespaces in SQL*Plus
- Viewing Tablespace Information in SQL*Plus
- Implementing Oracle Managed Files
- Moving and Renaming Online Data Files in SQL*Plus
- Permanent & temporary tablespaces in CDB and PDBs
- Oracle Database Space Management Features
- Block Space Management
- Row Chaining and Migration
- Free Space Management Within Segments
- Types of Segments
- Allocating Extents
- Understanding Deferred Segment Creation
- Space-Saving Features
- Undo Data: Overview
- Transactions and Undo Data
- Storing Undo Information
- Comparing Undo Data and Redo Data
- Managing Undo
- Local Undo Mode Versus Shared Undo Mode
- Configuring Undo Retension
- Categories of Undo
- Creating Users
- Granting Privileges
- Creating and Granting Roles
- Revoking Privileges and Roles
- Creating and Assigning Profiles
- Authenticating Users
- Assigning Quotas to Users
- Applying the Principal of Least Privilege
- Common and local users, roles and privileges
- New Administrative Privileges
- New Administrative Privilege SYSBACKUP
- New Administrative Privilege SYSDG
- New Administrative Privilege SYSKM
- OS Authentication and OS Groups
- Password Authentication for SYSBACKUP
- Password Authentication for SYSDG
- New System Privilege PURGE DBA_RECYCLEBIN 10-19
- Creating Policies Database and Role Analysis
- Creating Policies Context Analysis
- Analyzing and Reporting
- SYSTEM and OBJECT Used Privileges
- Used Privileges Results
- Compare Used and Unused Privileges
- Oracle Net Services
- How Listeners Work
- Configuring Listeners for Dynamic Service Registration
- Configuring Listeners for Static Service Registration
- Configuring Local Naming for Connections
- Testing Oracle Net Connectivity with tnsping
- Configuring Communication Between Databases
- Dedicated Versus Shared Server Configurations
- Moving Data: General Architecture
- Oracle Data Pump: Overview
- Oracle Data Pump: Benefits
- Full Transportable Export/Import Overview
- Full Transportable Export/Import Usage
- Full Transportable Export/Import Example
- Plugging a Non-CDB into CDB Using Data Pump
- Plugging a Non-CDB into CDB Using Replication
- Transporting a Database over the Network Example
- Disabling Logging for Oracle Data Pump Import Overview
- Disabling Logging for Oracle Data Pump Import Usage
- Disabling Logging for Oracle Data Pump Import Command-Line Examples
- Exporting Views as Tables Overview
- Exporting Views as Tables Usage
- Exporting Views as Tables Command-Line Examples
- Specifying the Encryption Password
- Compressing Tables during Import
- DBA Responsibilities
- Categories of Failure
- Understanding Instance Recovery
- Understanding Types of Backups
- Comparing Complete and Incomplete Recovery
- Duplicating a Database ( Database Cloning )
- Use Table Recovery
- Backup and Recovery Concepts
- Perform basic backup and recovery
- Configure and manage RMAN settings, Configure FRA
- Describe the use of the RMAN recovery catalog, Create Catalog
- Register a database in the RMAN recovery catalog
- Perform full and incremental backups
- Configure Block Change tracking, Perform incremental level backups
- Recover an incremental level 0 backup with level 1 incremental
- Perform automated TSPITR, Perform table recovery from backups
- Perform CDB and PDB backups
- Recover CDB and PDB from essential file loss
- Media Failure: CDB or PDB Temp File Recovery
- Media Failure: PDB Temp File Recovery
- Media Failure: Control File Loss
- Media Failure: Redo Log File Loss
- Media Failure: Root SYSTEM or UNDO Data File
- Media Failure: Root SYSAUX Data File
- Media Failure: PDB SYSTEM Data File
- Media Failure: PDB Non-SYSTEM Data File
- Describe Flashback Database architecture
- Understand flashback technologies from various types of errors
- Configure your database to use flashback technologies
- Perform flashback query, version query, transaction backout
- Perform flashback table, recyclebin, flashback data archive
- Database Patch Management Introduction
- Applying Interim and Patch set Patches
- Patch History & Documentation
- SQL Tuning Process
- Oracle Optimizer
- Optimizer Statistics
- SQL Plan Directives
- Adaptive Execution Plans
- SQL Tuning Advisor
- SQL Access Advisor
- SQL Performance Analyzer
- Managing Performance Activities
- Performance Planning Considerations
- Database Maintenance
- Automatic Workload Repository (AWR)
- Automatic Database Diagnostic Monitor
- Performance Monitoring
- Performance Tuning Methodology
- Database Server Statistics and Metrics
Author
SAURA