In this Instructor-led course, you install the Oracle Database 12c Enterprise Edition software, create new databases, and learn how to administer the database.

You also configure the database to support an application and perform tasks such as creating users, defining storage structures, and setting up security. This course uses a fictional application. However, you perform all the core tasks that are necessary for a real application.

Database administration does not end after you configure your database. You also learn how to protect it by designing a backup and recovery strategy and how to monitor it to ensure that it operates smoothly

Being an Oracle DBA is a very privileged, prestigious and high paying career in the IT industry – $80k – 120+K/yr.

1 Month

After completing this course, you should be able to:

1. The Oracle Architecture
2. Install, create, and administer Oracle Database 11g
3. Configure the database for an application
4. Move data between databases and files
5. Manage an Oracle Database instance.
6. Configure the Oracle Network environment.
7. Create and manage storage structures.
8. Manage and move data.
9. Create and manage users.
10. Monitor the database and manage performance.
11. Create and manage Database as a Cloud Service database deployments.
          Advanced Topics for advanced students:
12. Configure and administer Goldengate
13. Configure and administer Standby Databases & Dataguard
14. Configure and administer RAC An updated and more detailed outline will be given on the first day of Class. 
          Alternate Course Outlines:
    . Detail Course Outline for 11g & 12c here
    . Course Outline per Class Textbook for 12c here
    Check out and compare the price of taking this course at Oracle University for 5 days here

1. A lot of study time ~ 2 hours daily
2. A very powerful laptop with lots of memory and hard drive space. Get nothing less than an i7 laptop with a minimum 12GB RAM, SSD o/s drive, and 1 TB storage hard drive.
3. Custom design Virtual Machines (to be provided in class)
4. The rest of this requirements list shall be provided upon registration

1. Performing installation on a Linux system
2. Navigating the file system to locate key files
3. Running the standard maintenance tools and utilities,
4. Applying patches 
5. Carrying out cloning operations
6. Monitoring
7. Backup and Recovery

1. Database Administrators – 10g & 11g
2. Database Designers
3. Functional Implementer
4. Project Manager
5. Support Engineer
6. Data Warehouse Administrator
7. Anyone willing to work very hard for a career change or a new career.
8. New College graduates with a degree in any field.

1. Introductory to SQL
2. 11g Database Administration

• Among all the IT/computer best jobs in a recent CNN.com Best Jobs in America report, the Database Administrator job has the highest job growth forecast (30% increase) for the next 10 years until 2023. www.cnn.com also published an article recently that Database Administrators stand # 98 out of 100 BEST AMERICA JOBS

  They need you…..

•  New and good paying Career

• To Obtain the OCA & OCP certificates

BereansIT EBS Certificate

OCA certificate if already written the SQL exam.

This course is designed to prepare students to become an Oracle Database 12c Administrator Certified Associate.