Webfire Themes Weebly Templates
    Mapple Jaipur
    info@mapple.ac.in
        mapple.edusoft@gmail.com
    Call us :  8233-25-2525
                          8233-54-5555
    • Home
    • Profile
      • Meet the Team
      • Partner with us
      • Webmail
      • Career >
        • Code of Conduct
    • Services
    • Training
      • Online Registration
      • IT Training >
        • Oracle Training >
          • Oracle 11g Database (DBA) >
            • 11g: Introduction to SQL
            • 11g: Administration Workshop 1
            • 11g: Administration Workshop 2
          • Oracle 10g Database (DBA) >
            • 10g: Introduction to SQL
            • 10g: Administration Workshop 1
            • 10g: Administration Workshop 2
          • Oracle 9i Database (DBA) >
            • 9i: Introduction to SQL
            • 9i: Administration Fundamentals 1
            • 9i: Administration Fundamentals 2
            • 9i: Performance Tuning
        • Big Data >
          • Introduction to Big Data
          • Big Data Essentials
        • Java Training >
          • Java Fundamentals SE6 (OCJA)
          • Java Fundamentals SE7 (OCJA)
          • Java Fundamentals SE8 (OCJA)
          • Java SE6 (OCJP)
          • Java SE7 (OCJP)
          • Java SE8 (OCJP)
          • Java SE 7 New Features
          • Java SE 8 New Features
          • Java EE6 Developing App (OCWCD)
          • Java EE6 Servlets & JSP (OCWCD)
          • Java EE6 EJB TECHNOLOGY (OCBCD)
        • PHP With MySQL >
          • PHP Training & MySQL
          • MySQL for Developers
        • Ethical Hacking
        • SEO Training
      • SSC Training >
        • SSC SYLLABUS TIER-I >
          • QUANTITATIVE APTITUDE
          • GENERAL MENTAL ABILITY
          • ENGLISH
          • COMPUTER AWARENESS
          • GENERAL KNOWLEDGE
    • Certification
    • Online Test
      • Admin
    • Alliances
    • Placement
    • Contact Us
      • Bank Details

    Oracle Database 11g: Administration Workshop 1

    What you will learn:
    This Oracle Database 11g: Administration Workshop I Release 2 course explores the fundamentals of basic database administration. Expert Oracle University instructors will reinforce topics with structured hands-on practices that will prepare you for the corresponding Oracle Certified Associate exam. 

    Why Oracle 11 g training from Mapple Edusoft :
    • Official Course-ware from Oracle University.
    • Authorized Structured Oracle Training in Jaipur.
    • Highly Qualified Java Industry Experts as Trainer.
    • Hands on experience on Oracle Software.
    • Course Completion Certificate From Oracle University.
    • Discount Vouchers for International Exams.
    • 10 Full-length Online Mock Tests (Real-life Oracle® Exam) per Module.

    Prerequisites :
    • Oracle Database 11g: Introduction to SQL 

    Course Topics :
    Exploring the Oracle Database Architecture
    • Oracle Database Architecture Overview
    • Oracle ASM Architecture Overview
    • Process Architecture
    • Memory structrues
    • Logical and physical storage structures
    • ASM storage components
    Installing your Oracle Software
    • Tasks of an Oracle Database Administrator
    • Tools Used to Administer an Oracle Database
    • Installation: System Requirements
    • Oracle Universal Installer (OUI)
    • Installing Oracle Grid Infrastructure
    • Installing Oracle Database Software
    • Silent Install
    Creating an Oracle Database
    • Using the DBCA to Create a Database
    • Password Management
    • Creating a Database Design Template
    • Using the DBCA to Delete a Database
    Managing the Oracle Database Instance
    • Start and stop the Oracle database and components
    • Use Oracle Enterprise Manager
    • Access a database with SQLPlus
    • Modify database installation parameters
    • Describe the stages of database startup
    • Describe database shutdown options
    • View the alert log
    • Access dynamic performance views
    Manage the ASM Instance
    • Set up initialization parameter files for ASM instance
    • Start up and shut down ASM instances
    • Administer ASM disk groups
    Configuring the Oracle Network Environment
    • Use Enterprise Manager to create and configure the Listener
    • Enable Oracle Restart to monitor the listener
    • Use tnsping to test Oracle Net connectivity
    • Identify when to use shared servers and when to use dedicated servers
    Managing Database Storage Structures
    • Storage Structures
    • How Table Data Is Stored
    • Anatomy of a Database Block
    • Space Management in Tablespaces
    • Tablespaces in the Preconfigured Database
    • Actions with Tablespaces
    • Oracle Managed Files (OMF)
    Administering User Security
    • Database User Accounts
    • Predefined Administrative Accounts
    • Benefits of Roles
    • Predefined Roles
    • Implementing Profiles
    Managing Data Concurrency
    • Data Concurrency
    • Enqueue Mechanism
    • Resolving Lock Conflicts
    • Deadlocks
    Managing Undo Data
    • Data Manipulation
    • Transactions and Undo Data
    • Undo Data Versus Redo Data
    • Configuring Undo Retention
    Implementing Oracle Database Auditing
    • Describe DBA responsibilities for security
    • Enable standard database auditing
    • Specify audit options
    • Review audit information
    • Maintain the audit trail
    Database Maintenance
    • Manage optimizer statistics
    • Manage the Automatic Workload Repository (AWR)
    • Use the Automatic Database Diagnostic Monitor (ADDM)
    • Describe and use the advisory framework
    • Set alert thresholds
    • Use server-generated alerts
    • Use automated tasks
    Performance Management
    • Performance Monitoring
    • Managing Memory Components
    • Enabling Automatic Memory Management (AMM)
    • Automatic Shared Memory Advisor
    • Using Memory Advisors
    • Dynamic Performance Statistics
    • Troubleshooting and Tuning Views
    • Invalid and Unusable Objects
    Backup and Recovery Concepts
    • Part of Your Job
    • Statement Failure
    • User Error
    • Understanding Instance Recovery
    • Phases of Instance Recovery
    • Using the MTTR Advisor
    • Media Failure
    • Archive Log Files
    Performing Database Backups
    • Backup Solutions: Overview
    • Oracle Secure Backup
    • User-Managed Backup
    • Terminology
    • Recovery Manager (RMAN)
    • Configuring Backup Settings
    • Backing Up the Control File to a Trace File
    • Monitoring the Flash Recovery Area
    Performing Database Recovery
    • Opening a Database
    • Data Recovery Advisor
    • Loss of a Redo Log File
    • Data Recovery Advisor
    • Data Failures
    • Listing Data Failures
    • Data Recovery Advisor Views
    Moving Data
    • Describe ways to move data
    • Create and use directory objects
    • Use SQL*Loader to move data
    • Use external tables to move data
    • General architecture of Oracle Data Pump
    • Use Data Pump export and import to move data
    Working with Support
    • Use the Enterprise Manager Support Workbench
    • Work with Oracle Support
    • Log service requests (SR)
    • Manage patches

    Certificate From Oracle University :
    Oracle Training in Jaipur - DBA, Developer - OCA -OCP
    Oracle Training in Jaipur - DBA, Developer - OCA -OCP
    Authorized Oracle 11g Training in Jaipur @ Mapple Edusoft

    OUR SERVICES : 

    IT Training & Skill Development
    International Certification
    Earn & Learn
    Software & Website Development
    Business Support Services
    Infrastructure leasing
    Franchise

    Company :

    About Us
    Contact Us
    Terms and Conditions
    Privacy Policy
    Disclaimer of Warranty

    Alliances :

    Oracle - Java - WDP
    EC - Council
    MeritTrac Services Pvt. Ltd
    Aspiring Minds
    Hughes Communication India Ltd.

    Contact US

    • Mapple Edusoft Private Limited
      78, 3rd Avenue, Goms Defence Colony,
      Vaishali Nagar, Jaipur - 302021
      Rajasthan
    • +91-8233-54-5555
      +91-8233-25-5555
    • info@mappleedusoft.com
    • www.mappleedusoft.com

    Back to top