Oracle Database 11g: Administration Workshop I
Free
Introduction
This course is designed to give the Database professional a firm foundation in basic database administration. In this class, you’ll learn how to install and maintain an Oracle database. You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. You will also 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
Audience
This course is intended for Database Administrators, Technical Administrators, Support Engineers, Technical Consultants & Java Developers.
At Course Completion
After completing this course, students will be able to:
- Monitor performance
- Describe Oracle Database Architecture
- Install Oracle Grid Infrastructure
- Install and configure Oracle Database 11g
- Configure Oracle Net services
- Monitor and administer undo data
- Manage the database storage structures
- Create and administer user accounts
- Perform basic backup and recovery of a database
- Manage users and schemas
- Manage data concurrency
Prerequisites
Before attending this course, students must have working knowledge of SQL.
Professional Exam(s)
Exam 1Z0-052: Oracle Database 11g: Administration ICertification(s):
OCA – Oracle Certified Associate: Database 11g AdministratorMODULES
- Exploring the Oracle Database Architecture
- Installing your Oracle Software
- Creating an Oracle Database
- Managing the Oracle Database Instance
- Manage the ASM Instance
- Configuring the Oracle Network Environment
- Managing Database Storage Structures
- Administering User Security
- Managing Data Concurrency
- Managing Undo Data
- Implementing Oracle Database Auditing
- Database Maintenance
- Performance Management
- Backup and Recovery Concepts
- Performing Database Backups
- Performing Database Recovery
- Moving Data
- Working with Support
- Nicosia
City
Dates and Times
Duration (Hours)
- 20 Louki Akrita street, 2064 Strovolos
(behind Kykko secondary schools)
Location
- Limassol
City
Dates and Times
Duration (Hours)
- 22 Griva Digeni Avenue, 3106 Agios Nikolaos
(200 m. from the roundabout, near Agios Nikolaos church)
Location
For participants eligible for subsidy by the Human Resource Development Authority:
| Participation * | Course Manual | Exam | |
| Official Course 20486 | Oracle Press | 1Z0-062 | |
| Amount | €550,00 | €191,00 | €212,00 |
| VAT * | €233,70 | €13,30 |
For participants not eligible for subsidy by the Human Resource Development Authority:
| Participation | Course Manual | Exam | |
| Course | Oracle Press | 1Z0-052 | |
| Amount | €875,00 | €70,00 | €212,00 |
| VAT | €166,25 | €13,30 | - |
Take advantage of our special offer by taking this course as part of a bundle of 2 courses leading to the OCA – Oracle Certified Associate: Database 11g Administrator certification:
For participants eligible for subsidy by the Human Resource Development Authority:
| Participation * | Course Manuals | Exams | |
| Courses: Datab. Admin & SQL Fund. | Oracle Press - 2 books | 1Z0-052 & 1Z0-051 | |
| Amount | €950,00 | €130,00 | €321,00 |
| VAT * | €438,90 | €24,70 |
For participants not eligible for subsidy by the Human Resource Development Authority:
| Participation | Course Manuals | Exams | |
| Courses: Datab. Admin & SQL Fund. | Oracle Press - 2 books | 1Z0-052 & 1Z0-051 | |
| Amount | €1,300,00 | €130,00 | €321,00 |
| VAT | €247,00 | €24,70 |
