CareerStart's Oracle DBA career track is a career builder for aspiring database administrators. This course is designed to prepare students to handle the job of an Oracle DBA effectively. The objective of this track is to provide students a strong conceptual knowledge and lots of hands-on exercises to help understand the Oracle Database Architecture and Administration better and to appreciate the best practices used in the industry. The program is very detailed and totally hands-on. The following are just few of the exercises that students actually perform in class as part of their lab exercises:
This is a rigorous program and you must be willing to devote a substantial amount of time and effort to complete it. Your gains will be in direct proportion to the amount of effort you put into it.
Oracle database is the most popular and powerful relational database in the market today. Oracle DBAs are in high demand even in the current economic slowdown. According to a recently published article in San Jose Mercury News, lot of San Jose firms are on the look out for good DBAs. The article further noted that the average salary of an experienced DBA is about $83,000 in the Bay Area.
Since a majority of Oracle databases run on UNIX based operating systems, CareerStart Oracle DBA track has been designed on the UNIX platform. As such, students are expected to have a reasonably good understanding of UNIX operating system and end user skills. The following basic knowledge is assumed of each student:
The CareerStart Oracle DBA training assists students to prepare for Oracle DBA OCP Certification track.
The following modules make up the CareerStart's Oracle 12c Developer career track:
The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide you with a firm foundation in administration of an Oracle Database. In this course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner. This course covers both Database as a Cloud Service and the on-premises Oracle Database.
Benefits to You
You will benefit from this course as you learn detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition you learn how to create users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course.
To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.
In this Oracle Database 12c R2: Backup and Recovery Workshop, students learn how to perform backup and recovery based on the related Oracle Database architecture components. Various backup, failure, restore, and recovery scenarios are provided so that students learn to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. This course includes an interactive workshop, with scenarios that provide participants with opportunities to diagnose and recover from several failure situations.
Benefits to You
The student benefits by gaining a deeper understanding of possibly the most important job of a DBA – backup and recovery. The concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. Students gain knowledge of the Recovery Manager (RMAN) command line interface for various backup, failure, restore, and recovery scenarios, including tape backup and data duplication. (Familiarity with basic database tools and utilities, such as, SQL*Plus, is assumed.)
Extensive hands-on practices and workshop scenarios provide the student with experience in a realistic technical environment. This course includes an interactive workshop that provide participants with opportunities to diagnose and recover from several failure scenarios, based on backup and recovery case studies. After completing this course, students should be able to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures.
During the Oracle Database 12c Administration Workshop, students cover a brief overview of the multitenant container database and its pluggable databases. This course covers all aspects of the multitenant architecture, providing detailed information on the components of an Oracle multitenant container database and its regular and application pluggable databases. You learn why and how to create and manage a multitenant container database and its regular and application pluggable databases, with storage structures appropriate for the business applications. You practice cold and hot cloning, plugging unplugged pluggable databases in multitenant container databases using various methods.
In addition, you learn how to create common and local users and administer database security to meet your business requirements by using encryption, Database Vault and auditing and you will learn how to create a database deployment in the Cloud.
During the Oracle Database 12c Backup and Recovery Workshop, students get an overview of how to backup and recover pluggable databases. This course presents multitenant container database and pluggable databases backup, recovery and flashback procedures.
To provide an acceptable response time to users and manage resources effectively, you learn how to monitor performance and manage resources within the multitenant container database and its pluggable databases, and within each pluggable database.
Another important aspect is the data movement between non-CDBs and pluggable databases, and between pluggable databases.
It is also important to understand the procedures of upgrading an Oracle Database 12.1 multitenant container database to an Oracle Database 12.2 multitenant container database or an Oracle Database 12.1 pluggable database to an Oracle Database 12.2 pluggable database.
Finally, students discover the way multitenant container database and pluggable databases are created and monitored in the Cloud.