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.

Students who can benefit from this course:

Database Administrators

Prerequisites:
Introduction to Oracle9i: SQL

Course Objectives:
  • Manage tablespaces, segments, extents, and blocks
  • Manage users, privileges, and resources
  • Create an operational database 
  • Start up and shut down an Oracle instance and database 
  • Manage Oracle database files
  • Use Globalization Support features 

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
Mapple Edusoft offers 45 Days Training / 6 Weeks Training / Android Training / Android Training in Jaipur  /   Asp.Net Training in Jaipur  /  Asp.Net with C# Training in Jaipur  /   B.Tech Training /  BE Training /  Best Institute Oracle Jaipur / Best Oracle Institute /  Best Oracle Institute in Jaipur / C Training in Jaipur /  C# Training in Jaipur /  C++ Training in Jaipur /  Embedded Systems Training in Jaipur /  Four Weeks Training /  Industrial Training /  Institute for Oracle in Jaipur / IT Training / IT Training Institute / Java Training /  Java Training in Jaipur /  Major Project /  MCA Training /  MCA Training in Jaipur /  Minor Project / Oracle Certification /  Oracle Certification Center in Jaipur /  Oracle Certification Course /  Oracle Certification Course in Jaipur / Oracle Certification in Jaipur /  Oracle Certification Jaipur /  Oracle Classes in Jaipur / Oracle Coaching /  Oracle Coaching Classes / Oracle Coaching Classes in Jaipur / Oracle Coaching in Jaipur / Oracle Coaching Jaipur / Oracle Course /  Oracle Course in Jaipur /  Oracle Course Jaipur /  Oracle in Jaipur / Oracle Jaipur /  Oracle Jaipur Institute / Oracle Training /  Oracle Training Center /  Oracle Training Center in Jaipur / Oracle Training in Jaipur /  Oracle Training Institute /  Oracle Training Institute in Jaipur / Oracle Training Institute Jaipur / Oracle Training Institutes /  Oracle Training Institutes in Jaipur / Oracle Training Jaipur /  PHP Training / PHP Training in Jaipur / Robotics Training in Jaipur / SEO Training in Jaipur /  Six Weeks Training / Software Training / Software Training Institute /  Summer Training /  Summer Training for B.E / Summer Training for B.Tech Students /  Summer Training for MCA /  Summer Training in Jaipur / VLSI Training in Jaipur / .Net Training in Jaipur / 4 Weeks Training