- Duration: 2 days
Course overview
This 5-day course is designed to give participants a firm foundation in basic administration of Oracle Database 11g. In this class, students learn how to install and maintain Oracle Database 11g. Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices.
Course Learning Outcomes
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.
Course content
1. 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
5. EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE PROCESSES
• INSTANCE BACKGROUND PROCESSES
• SQL EXECUTION PROCESSES
6. CREATING AN ORACLE DATABASE
7. MANAGING THE DATABASE INSTANCE
8. MANAGE DATABASE STORAGE STRUCTURES: TABLESPACES
9. MANAGE DATABASE STORAGE STRUCTURES: ADVANCED TABLESPACES
10. MANAGE DATABASE STORAGE STRUCTURES
11. MANAGING UNDO DATA
12. NETWORK ENVIRONMENT: ORACLE SHARED SERVERS
13. SECURITY: IMPLEMENTING DATABASE SECURITY
14. SECURITY: ADMINISTERING USER SECURITY
15. MOVING DATA: SQL LOADER
16. MOVING DATA: EXPORT & IMPORT
17. DATABASE MAINTENANCE & PERFORMANCE MANAGEMENT
18. MANAGING CONCURRENCY & LOCKS
19. BACKUP & RECOVERY CONCEPTS & CONFIGURATION
Target audience
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.
Training Methodology
State-of-the-art business facilitation methods are transferred by means of short, focused presentations which are followed by experiential learning workshop sessions. In these sessions, the knowledge gained is applied to real-world examples and case studies. Rapid learning of the methods and techniques is achieved by means of group work, individual work, participant discussion, facilitator interaction and constructive feedback.
WHY STUDY WITH US?
Diamond Training Institute give you the opportunity to further your education and acquire the knowledge and skills that are relevant in the workplace.
ON-TRACK FOR GROWTH
The individual leaves this course with a Personal Action Plan to encourage immediate transfer of training to the job.
EVALUATION TO ENSURE CONSISTENT QUALITY
All our courses are evaluated at Kirkpatrick’s Reaction and Learning levels as part of our quality control process.
Download Course Outline Here
