get app

    Oracle DBA Training

    BY
    Mindmajix Technologies

    Equip yourself with the core concepts and skills of Oracle Database Administrator (12c or 19c).

    Brochure Enquire
    Mode

    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

    Oracle DBA Training course is designed to train the students on the Oracle Database Administration. The online training by Mindmajix will explore all the gamut of aspects related to the Oracle database versions 12c or 19c including data warehousing, high availability, security, development, management, and the like. The programme will enable the students to update their skills and knowledge of Oracle DBA and to become successful Oracle Database Administrators. 

    The learners who have the plan of joining the Oracle DBA Training online course are required to have basic knowledge of databases. The course could be taken by the students through three options of enrolment; corporate training, self-study with pre-recorded classes, and virtual live sessions via Google meet or Zoom. In the course of Oracle DBA Training certification, the learners will be assigned many projects to deepen their practical exposure; Database tuning, School student management system, and DBA Production Use Cases. Mindmajix will also render the learners assistance for the job, mock interview, career guidance season, etc after the completion of the programme. 

    The highlights

    • 100 %  online course
    • Offered by Mindmajix
    • FREE Demo on Request
    • Flexible Schedule
    • Online Live and Self-paced Training Options
    • 24/7 Lifetime Support
    • Life-Time Self-Paced Videos Access
    • One-on-One Doubt Clearing
    • Certification Oriented Curriculum

    Program offerings

    • One-on-one doubt clearing sessions
    • Certification oriented curriculum
    • Real-time project use cases
    • 20 hours of labs
    • Free demo on request
    • 24/7 lifetime support
    • 50 hours of sessions
    • Online live and self-paced training options

    Course and certificate fees

    certificate availability

    Yes

    certificate providing authority

    Mindmajix Technologies

    What you will learn

    Database management

    Through the Oracle DBA Training online certification, the candidates will be able to make a detailed knowledge of Oracle Database Architecture, Oracle database parameters, installation of Oracle database/client binaries, Users/Schemas, and profiles. Plus, the students will learn SQL and PL/SQL concepts, Database Administrator Functionalities, major concepts of databases, the configuration of the Oracle Network, cloud and storage management, and whatnot. 

    The syllabus

    Introduction of Oracle Database Administrator

    • Oracle Database 12c New and Enhanced Features
    • Objectives 
    • Challenges 
    • Oracle Database in 11g Release 
    • High Performance Systems

    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

    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

    Trending Courses

    Digital Marketing Courses Fashion Design Courses Data Science Courses Interior Design Courses Graphic Designing Courses Cyber Security Courses Nursing Courses Tally Courses Data Analysis Courses Web Designing Courses Artificial Intelligence Courses Ethical Hacking Courses Free Digital Marketing Courses And certifications Free Artificial Intelligence Courses And Certifications Free Data Analysis Courses And Certifications Free Cyber Security Courses And Certifications Free Data Science Courses And Certifications Free Cloud Computing Courses And Certifications Free Python Courses And Certifications Free Fashion And Textiles Courses And Certifications Free Graphic Designing Courses And Certifications Free Web Designing Courses And Certifications

    Popular Courses

    General Management Courses Public Health Courses Teaching and Education Courses Financial Management Courses Web Development Courses Mathematics Courses Data Science Courses Cyber Security Courses Programming Courses Digital Marketing Courses Law Courses Leadership Courses Explore all courses

    Popular Platforms

    upGrad Courses Udemy Courses Edx Courses Swayam Courses Coursera Courses Futurelearn Courses Mindmajix Technologies Courses Vskills Courses IIT Kharagpur Courses Emeritus Courses IIT Kanpur Courses NPTEL Courses Explore all platforms

    Learn more about the Courses

    10 Reasons to Enrol Yourself in a Digital Marketing Course 8 Must-Have Skills for AWS Cloud Architects Planning to Upskill Yourself? Enrol for a Program in Data Science 25+ Tips for Improving Your Graphic Design Skills Top Universities in India Offering Cyber Security Courses 15+ Courses for Learning Data Mining How to Make a Career in the Field of Artificial Intelligence Top 10 Benefits Of Holding A Certification In Business Intelligence Which are the best certification courses for Photography in India A Beginner's Guide to Pursue Python Programming Want to Pursue a Career in Blockchain Technology? Here is all that you need to Know How Entrepreneurs Can Use Machine Learning to Make their Business Successful? The Scope of Artificial Intelligence in India Top 10 Online Courses for Travel Lovers 10 Best Certification Courses After Hospital and Healthcare Management
    Providers
    Close

    Download the Careers360 App on your Android phone

    Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

    Careers360 App
    150M+ Students
    30,000+ Colleges
    500+ Exams
    1500+ E-books