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

This course is designed to give students a firm foundation in basic administration of Oracle Database 12c. In this class, students learn how to install and maintain Oracle Database 12c. 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.

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

1 Month

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 the requirements 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 and
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.

This course is designed for Oracle RDBMS 11g DBAs.

1. 11g Database Administration
2. Working knowledge of SQL
3. Oracle Database 12c: Introduction to SQL
4. Performance-Based Objectives
5. Describe Oracle Database Architecture
6. Install and configure Oracle Database 12c
7. Configure Oracle Net services
8. Manage the database storage structures
9. Create and administer user accounts
10. Perform basic backup and recovery of a database
11. Manage users and schemas
12. Manage data and concurrency
13. Monitor and administer undo data
14. Backup and recover a database
15. Monitor performance
16. Use the database diagnostic monitor

• Among all the IT/computer best jobs in a recent CNN.com Best Jobs in America report, 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 JOBSThey 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.