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 9i: Database Administration Fundamentals I

    What you will learn:
    Oracle DBAs manage the industries most advanced information systems and command some of the highest salaries. This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database tasks. In this class, you'll learn how to design, create, and maintain an Oracle database.

    Students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner. The lesson topics are reinforced with structured hands-on practices. This course is designed to prepare you for the corresponding Oracle Certified Associate exam: Exam #1Z0-031.

    Why Oracle 9i 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 :
    • Introduction to Oracle9i: SQL

    Course Topics :
    Oracle Architectural Components
    • Defining an Oracle Database, the Oracle server, and the Oracle Instance
    • Establishing a connection and creating a session
    • Understanding the physical structure
    • Understanding the memory structure
    • Understanding the process structure
    • Understanding the logical structure
    • Outlining the stages of an SQL statement
    Getting Started with the Oracle Server
    • Identifying database administrative tools
    • Identifying the features of the Universal Installer
    • Defining the Optimal Flexible Architecture
    • Creating a database during installation
    • Creating a new database
    Identifying database administrative users
    • Understanding operating system and password file authentication SQL*Plus
    • Enterprise Manager
    Managing an Oracle Instance
    • Creating, managing, and using initialization files: PFILE and SPFILE 
    • Identifying the various states of starting an instance
    • Identifying the various options available to shutdown an instance
    • Monitoring Alert and Trace files
    Creating a Database
    • Using the Database Configuration Assistant to create a database
    • Creating a database manually
    Using the Data Dictionary
    • Identifying the uses and contents of the data dictionary
    • Using the data dictionary to retrieve information about the database
    Maintaining the Control File
    • Explaining the uses of the control file
    • Listing the contents of the control file
    • Multiplexing the control file
    • Managing control file with Oracle Managed Files (OMF)
    • Obtaining control file information
    Maintaining Redo Log Files
    • Explaining the purpose of and how online redo log files work
    • Control log switches and checkpoints
    • Maintaining online redo log files
    • Managing online redo log files using OMF
    • Multiplexing and maintaining online redo log files
    • Archiving online redo log files
    • Obtaining online and archived redo log file information
    Managing Tablespaces and Datafiles

    Describing storage hierarchy

    Establishing the difference between SYSTEM & Non-SYSTEM tablespaces
    • Creating and managing tablespaces
    • Creating a tablespace when using OMF
    • Obtaining tablespace and datafile information
    Storage Structures and Relationships
    • Describing the logical structure of the database (segments, extents, blocks)
    • Listing the segment types and their uses
    • Understanding the use of extents and their allocation and deallocation 
    • Understanding the structure of a database block
    • Maintaining storage structures with automatic segment - space management
    • Maintaining storage structures manually
    • Obtaining storage structure information 
    Managing Undo Data

    Understanding difference between automatic undo management & manual undo management

    Creating and maintaining UNDO tablespaces
    • Obtaining undo information 
    Managing Tables
    • Creating and maintaining tables using appropriate storage settings
    • Obtaining table information 
    Managing Indexes
    • Listing the different types of indexes and their uses
    • Creating b-tree and bitmap indexes
    • Maintaining Indexes
    Identifying unused indexes
    • Obtaining index Information


    Certificate From Oracle University :
    Oracle Training in Jaipur - DBA, Developer - OCA -OCP
    Oracle Training in Jaipur - DBA, Developer - OCA -OCP
    Authorized Oracle 9i 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