Launch Your Global Career with Maersk – Placement Drive 2025 @ ZebLearn | Applications Close In 0d 0h 00h 00s

    ZebLearn Certification Partners – Globally Recognized Credentials!

    ZebLearn partners with leading industry experts to offer genuine, career-focused certifications in SAP training, foreign languages, and professional development courses. Earn internationally recognized credentials, enhance your career prospects, and distinguish yourself with certifications valued by the industry.

    cisco
    apple
    esb
    abode
    Partner
    meta
    pmi
    ic3
    Partner
    Partner
    Partner
    Partner
    communication

    Course content

    About Oracle 11g DBA Training Program

  • Role of a DBA
  • OLTP vs OLAP Databases
  • Database ABC's
  • Undo vs Redo Data
  • Oracle Instance vs Database
  • Quiz Time

  • Process Architecture
  • Database Writer Process
  • Log Writer Process
  • Checkpoint Process
  • SMON Process
  • PMON Process
  • RECO Process
  • Archiver Process

  • Memory Architecture
  • Database Buffer Cache
  • Shared Pool
  • REDO Log Buffer
  • Large Pool
  • Java Pool and Streams Pool
  • Keep Buffer Pool
  • Recycle Buffer Pool
  • nK Buffer Cache
  • Program Global Area (PGA)
  • Dedicated vs Shared Databases
  • PGA in a Shared Environment

  • Software Download
  • Virtual Machine Installation
  • Linux Installation
  • Oracle Software Installation
  • Oracle Parameter Files
  • Database Creation - Manual Method Demo
  • Verify Database Creation
  • Database Creation Using DBCA (Preferred Option)
  • Oracle Startup Steps
  • Oracle Shutdown Methods
  • Oracle 12c Upgrade

  • How Data is Stored in a Database
  • Tablespace Concepts
  • Online and Offline Tablespaces
  • Let's Create a Tablespace
  • Let's Add More Space to the Database
  • Tablespace Demo 1
  • Tablespace Demo 2
  • Tablespaces with Different Block Sizes
  • Temporary Tablespace Management
  • Temporary Tablespace Groups
  • Extent Management

  • UNDO Concepts
  • Read Consistency
  • ORA-01555 Snapshot Too Old Error
  • Automatic Undo Management
  • UNDO Management
  • Configuring Undo Retention Period

  • REDO Concepts
  • REDO Logfile Management Demo1
  • REDO Logfile Management Demo2
  • Archival Concepts
  • Archival Log Mode Demo

  • User Management Concepts
  • User Management Demo 1
  • User Management Demo 2
  • User Creation Exercise
  • Privileges
  • System Privileges Demo
  • Object Privileges Demo
  • Revoking User Privileges
  • Revoking System Privileges
  • Revoking Object Privileges
  • Let's practice what we learnt so far...
  • Role Management Concepts
  • Role Management Demo
  • User Profiles
  • User Profile Demo
  • Managing Passwords using Profiles

  • Networking Concepts
  • Listener Configuration Demo
  • TNSNAMES Configuration Demo
  • Database Link Concepts
  • Public Database Link
  • Private Database Link

  • What is Data Dictionary?
  • Static Data Dictionary Views
  • Dynamic Data Dictionary Views
  • Miscellaneous Data Dictionary Views
  • Data Dictionary Demo

  • What is Diagnostic Data?
  • Automatic Diagnostic Repository (ADR)
  • Manually navigating through the Diagnostic Data
  • Automatic Diagnostic Repository Command Interpreter (ADRCI)
  • Using ADRCI to navigate through Diagnostic Data
  • Creating an Incident Package for Oracle Support

  • Backup and Recovery Concepts 1
  • Backup and Recovery Concepts 2
  • Backup Types
  • Performing a Cold Backup manually
  • Hot Backup Steps
  • Hot Backup Demo
  • Recover a Control file from media failure
  • Recover a System Data file from media failure
  • Recover a non-system data file from media failure

  • RMAN Backup Types
  • Incremental Backup
  • Recovery Manager (RMAN) Terminology
  • Image Copies VS Backup sets
  • Why RMAN?
  • RMAN Commands

  • Materialized Views Introduction
  • Materialized Views creation Options
  • Materialized Views with ON COMMIT option
  • Materialized Views with ON DEMAND option
  • Materialized Views with REFRESH FAST option
  • Timing the refresh
  • Query Rewrite functionality
  • Materialized Views Recap

  • Table Partitioning Introduction
  • Range Partition based on range of values
  • List Partition based on list of values
  • Hash Partition based on the hash key
  • Composite Partitioning by mixing things up!!
  • Interval Partition for automatic partition creation
  • Adding/Droping Partitions
  • Table Partitioning Recap
    • Why Should You Learn Oracle 11g DBA Training?

    The annual salary of an Oracle 11g DBA is $125k.

    Request more information

    What you will get at Zeblearnindia Learning?

    Zeblearnindia Learning is a premier institute offering training in SAP Online Courses, Web Designing, Data Science, Full-Stack Development, Salesforce, Workday, Machine Learning, Software Testing, and Video Editing. With the option to choose between online and offline (classroom) learning, our well-structured courses cater to students, working professionals, business owners, and entrepreneurs. Here’s what you can expect at Zeblearnindia Learning:

    •   Expert-Led Training
    •   Globally Recognized Certifications
    •   100% Job Placement Support
    •   Hands-On Learning
    •   Flexible Learning Options
    •   Affordable Course Fees
    •   Career Growth Opportunities
    View Courses  
    best-seller-min

    () 60 Minutes WEBINAR with CERTIFICATE

    Date Time IST (GMT +5:30) Event Free Sign Up

    Explore Our Courses Across India - Flexible batches

    We are proud to offer our Oracle 11g DBA Training Program services across numerous states nationwide.

    Call Us
    WhatsApp
    Questions? WhatsApp us.
    Placements query?

    We use cookies to improve your experience and personalize our site. cookie policy