- Oracle Database 12c New and Enhanced Features
- Objectives
- Challenges
- Oracle Database in 11g Release
- High Performance Systems
- Home
- Mindmajix Technologies
- Courses
- Oracle DBA Training in Bangalore
Oracle DBA Training in Bangalore
Learn the administrative concepts required to manage and monitor multiple Oracle databases, functionalities, and architecture.
Online
Quick facts
particular | details | ||
---|---|---|---|
Medium of instructions
English
|
Mode of learning
Self study, Virtual Classroom
|
Mode of Delivery
Video and Text Based
|
Frequency of Classes
Weekdays, Weekends
|
Course overview
MindMajix Technologies offers the Oracle DBA Training in Bangalore online certification for professionals looking for opportunities to gain knowledge of both fundamental and core concepts of database management. The Oracle DBA Training in Bangalore online classes are designed with two distinct learning methods that cater to two distinct audiences with distinct learning preferences.
Oracle DBA Training in Bangalore online course by MindMajix Technologies is taught by specialists that strive to convey all of the fundamentals required for beginners and advanced levels in real-time. This course covers DBA concepts such as multi-tenant architecture, container naming, pluggable databases, PDB structures, cloning PDBs, and changing PDB modes. Applicants will collaborate with professionals on two real-world projects to get practical expertise with local temporary tablespaces, local schemas, revoking roles, generating non-shared objects, partial PDB backup, Flashback CDB, heat map, and archiving solutions.
The highlights
- Certificate of completion
- Certification oriented curriculum
- Lifetime self-paced video access
- Flexible schedule
- Project use cases
- 50 hours session
- 30 hours of labs
- Quizzes & Mocks
- Free demo on request
- One-on-one doubt resolution
- 100% money-back guarantee
- 24/7 lifetime assistance
Program offerings
- Certificate of completion
- Certification oriented curriculum
- Lifetime self-paced video access
- Flexible schedule
- Project use cases
- 50 hours session
- 20 hours of labs
- Quizzes & mocks
- Free demo on request
- One-on-one doubt resolution
Course and certificate fees
certificate availability
certificate providing authority
What you will learn
After completing the Oracle DBA Training in Bangalore certification course, applicants will be acquainted with the fundamentals of Oracle Database Administrator. Applicants will learn the principles of multi-container databases and pluggable databases, as well as how to create and manage them. Applicants will gain knowledge of automatic data optimization, heat maps, and managing tablespaces and users in CDB and PDB. Applicants will also learn about audits, auditing types, and security, as well as the Oracle data pump, SQL*loader, and recovery manager.
Who it is for
The syllabus
Introduction of Oracle Database Administrator
Basics of Multi Container Database and Pluggable Databases
- New Multitenant Architecture: Benefits
- Other Benefits of Multitenant Architecture
- Multitenant Container Database
- Separating SYSTEM and User Data
- Naming the Containers
- Provisioning a Pluggable Database
- Basics of Multitenant Container Database and Pluggable Databases
- Interacting Within Multitenant Container Database
- Exploring CDB Architecture and Structures
Creating a Multi Container Database and Pluggable Databases
- Steps to Create a Multitenant Container Database
- Creating a Multitenant Container Database Using SQL*Plus
- Exploring CDB and PDB Structures
- Create New PDB from PDB$SEED
- With FILE_NAME_CONVERT
- Without FILE_NAME_CONVERT
- Cloning PDB within the Same CDB
- Plugging a Non-CDB into a CDB
- Dropping a PDB (optional)
- Plug Unplugged PDB in to CDB
Managing Multi Container Databases and Pluggable Databases
- Starting Up a CDB Instance
- Mounting a CDB
- Opening a CDB
- Opening a PDB
- Closing a PDB
- Shutting Down a CDB Instance
- Creating after Startup Trigger to Open All PDBs
- Changing PDB Mode
- Changing PDB Mode with SQL Developer
- Instance Parameter Changes and its Impact on PDBs
Managing Tablespaces and Users in CDB and PDBs
- Creating Permanent Tablespaces in a CDB
- Assigning Default Tablespaces
- Creating Local Temporary Tablespaces
- Assigning Default Temporary Tablespaces
- Users, Roles, and Privileges
- Local Users, Roles, and Privileges
- Creating a Local User
- Common Users
- Creating a Common User
- Common and Local Schemas / Users
- Common and Local Privileges
- Granting and Revoking Privileges
- Creating Common and Local Roles
- Granting Common or Local Privileges / Roles to Roles
- Granting Common and Local Roles to Users
- Granting and Revoking Roles
- Creating Shared and Non-Shared Objects
Backup, Recovery, Flashback CDB and PDBs
- Whole CDB Backup
- User-Managed Hot CDB Backup
- Partial CDB Backup
- Whole PDB Backup
- Partial PDB Backup
- SQL PDB Hot Backup (optional)
- SQL Control File Backup (optional)
Activities
- 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
- Media Failure: PITR
Flashback CDB
Special Situations
Creating a control file backup script
Heat Map, Automatic Data Optimization and Online Datafile Move
- Enabling Heat Map.
- Automatic Data Optimization – Creating a TIER Policy
- Automatic Data Optimization – Creating a COMPRESS Policy
- Cleanup ADO Policies and Heat Map Statistics
- Moving Data File Online
- In-Database Archiving and Temporal Validity
- Archiving Challenges
- Archiving Solutions
- In-Database Archiving: HCC
- Archiving Challenges and Solutions
- In-Database Archiving
- ORA_ARCHIVE_STATE column
- Session Visibility Control
- Disable Row-Archival
- PERIOD FOR Clause Concept
- Filtering on Valid-Time Columns
- DBMS_FLASHBACK_ARCHIVE
Auditing
- Types of Auditing
- Audit Trail Implementation
- Oracle Database 12c Auditing
- Enabling Unified Auditing
- Auditing Data Pump Export
- Auditing RMAN Backups
- Unified Audit Implementation
- Security Roles
- Security SYS Auditing 9-21
- Simplicity Audit Policy 9-22
- Creating the Audit Policy
- Creating the Audit Policy with Object-Specific Actions
- DBMS_FLASHBACK_ARCHIVE
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 Data Pump, SQL*Loader, and External Tables
- 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
- SQL*Loader and External Table Enhancements
Recovery Manager New Features
- Backing Up and Restoring Very Large Files
- RMAN Duplication Enhancements
- Duplicating an Active Database
- What Is New?
- The NOOPEN Option
- Duplicating Pluggable Databases
- Recovering Databases with Third-Party Snapshots
- Transporting Data across Platforms
- Data Transport
- Transporting Database Process Steps
- Transporting Tablespace Process Steps
- Table Recovery
- Recovering Tables from Backups
- Specifying the Recovery Point-in-Time
- Process Steps of Table Recovery
Practice Test & Interview Questions
Instructors
Ms Ashwini
Instructor
Mindmajix Technologies