This course allows the student to gain the skills necessary for day-today administration of an Oracle database. This course is the starting point for Oracle database administrators and also sets the foundation for advanced administrator training and certification.
The primary target audience for this course is Oracle database administrators. Oracle web server and application server administrators, as well as others who must manage an embedded repository database using Oracle database technology will also find this information useful. This course is also recommended for technical consultants, support engineers, project managers and other technical management and support personnel.
Major tasks to be considered within this course are:
Software installation and the creation of new databases.
An in-depth exploration of the database architecture, including memory, process and data structures, and the management of those structures.
Management of database files.
Specialized facilities intended to maximize performance of enterprise-scale transactional applications, such as the shared SQL and PL/SQL cache, the result cache, the database buffer cache, and other similar components.
Management of security policies and procedures, including administration of user accounts, roles, privileges and profiles.
Utilization of advanced self-tuning and self-management capabilities, including the use of Oracle-Managed Files, database Advisors and other components of the Management Framework.
Performance monitoring, problem troubleshooting, and resolving lock and conflict issues.
Using the Oracle Enterprise Manager and SQL interfaces for administration tasks.
Control over database support services, including the Database Control, Oracle Net and others.
A primer on backup and recovery structures and strategies.
Operating system-specific considerations for various platforms, especially Linux and MS Windows Server.
Many students taking this course have familiarity with system administration and administration of other non-Oracle databases, and this is helpful though not mandatory. Specific course prerequisites for this course are:
Oracle Database 11g: SQL FundamentalsOracle Database 11g: Program with PL/SQL
Outline of Oracle Database 11g: Administration I Training 1. Enterprise edition installation
Identify system requirements
The optimal flexible architecture (ofa)
Configure the installation environment
Enterprise edition installation
2. The administrator interface
Enterprise manager tour
Using em sql worksheet
Duties of a database administrator
Exploring the oracle database architecture: general
3. The oracle enterprise architecture 4. Exploring the oracle database architecture: instance memory
What is an oracle database instance?
More about the system global area (sga)
About the pga
5. Exploring the oracle database architecture: instance processes
If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.
Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.
ITILv3, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O, MoP, MoV courses on this page are offered by QA Affiliate of AXELOS Limited. ITIL, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O,MoP, MoV are registered trademarks of AXELOS Limited. All rights reserved.