|
|
|
ora11g201-ver2
Oracle Database 11g R2: Administration I (5 days)
DescriptionThis Oracle 11g textbook will allow the student to gain the skills necessary for day-to-day administration of an Oracle database. Administration of the Oracle database management system (DBMS) software environment and of the server systems on which the DBMS runs is one of the primary tasks required of database administrators. While it is true that the hardware and software platforms on which the DBMS runs have become increasingly complex, as has the database software itself, the capabilities provided by the Oracle database have correspondingly become more sophisticated.
This textbook can be used for advanced self-study, or for instructor-led training in both in-class or virtual-class environments. Textbooks can also be used for ongoing reference long after the course is completed.
AudienceThe primary audiences for this course are:
• Database administrators
• Web server administrators
• System administrators
• Implementation specialists
• Data center support engineers
• Senior application designers and developers
Prerequisites
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 these Sideris titles:
• ORACLE DATABASE 11g R2: INTRODUCTION TO SQL – COMPLETE LIBRARY
• ORACLE DATABASE 11g R2: PROGRAM WITH PL/SQL – COMPLETE LIBRARY
Suggested Next CoursesThis course should be considered the first part of the Sideris integrated database administrator curriculum. Therefore, in the not-too-distant future one should proceed to the follow-up course
• ORACLE DATABASE 11g R2: ADMINISTRATION II.
Instructor ResourcesInstructor resources from the Sideris Training Portal combined with Sideris custom print courseware make distance-learning and virtual training more effective than ever! Available for download when you purchase this title. Please turn on your audio, make sure you have the latest version of Adobe Reader and then watch the demo to see how these new instructor resources improve your instructor’s presentations!
ObjectivesThe overall objective of this training course is to allow the student to gain the skills necessary for day-to-day administration of an Oracle database. These training materials are the starting point for Oracle database administrators and sets the foundation for advanced administrator training and certification. Major tasks to be considered within this course are:
• Configuration of the Linux and MS Windows operating systems in anticipation of a database installation
• Server Class installation of the Oracle 11g R2 Enterprise Edition database
• Verification of a valid database installation
• Database administrator interface options, including the use of Enterprise Manager, command-line SQL*Plus, and terminal console SSH
• Database deinstallation
• Online software patching
• Startup and shutdown of database services and related software components
• Super administrator authentication options
• 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.
 Download PDF outline here!
|
|
|
|
|
|
|
