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:
Course Topics:
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
Identifying the features of the Universal Installer Defining the Optimal Flexible Architecture Creating a database during installation Creating a new database
Enterprise Manager
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 manually
Using the data dictionary to retrieve information about the database
Listing the contents of the control file Multiplexing the control file Managing control file with Oracle Managed Files (OMF) Obtaining control file information
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
Creating a tablespace when using OMF Obtaining tablespace and datafile information
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
Obtaining table information
Creating b-tree and bitmap indexes Maintaining Indexes
|
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