get app

    Oracle DBA Training in Bangalore

    BY
    Mindmajix Technologies

    Learn the administrative concepts required to manage and monitor multiple Oracle databases, functionalities, and architecture.

    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

    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
    • Quizzes & mocks
    • Free demo on request
    • One-on-one doubt resolution
    • 30 hours of labs

    Course and certificate fees

    certificate availability

    Yes

    certificate providing authority

    Mindmajix Technologies

    What you will learn

    Knowledge of computer networking

    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.

    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
    • 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

    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