Full Oracle Database Administration With High Availability

Oracle Database Administration, Oracle DBA, Oracle 12C RAC, Oracle Database 12C R2 Backup and Recovery, Oracle RMAN

Created by: Oak Academy
Web & Mobile Development, IOS, Android, Ethical Hacking, IT

Created by: OAK Academy Team
instructor

What Will I Learn?

• This course is a complete set of Oracle Database Administration with High Availability.
• You will become an expert in subjects like Oracle DBA, Oracle 12C Release 2, Oracle 12C R2 Backup and Recovery ( using RMAN), Oracle Data Guard
• You would be able to install the necessary Oracle Software/Database
• Creating and Starting Oracle Database
• Database Concepts And Fundamentals
• Inserting, Updating and Deleting Data In The Table
• Using Ampersand Subtition To Make More Dynamic Queries
• Backup and recovery concepts in Oracle
• Setting up the laboratory environment
• Creating and managing recovery catalog
• Using flashback Technologies in Oracle
• Managing RMAN backups
• Setting Up Oracle Enterprise Linux
• What is Real Application Cluster?
• Install Grid Infrastructure, Database Software and Create database
• Administer Database Instances and Cluster Databases
• Learn about Oracle RAC One Node
• To convert RAC database to RAC One Node and administer it
• Design and Deployment Techniques
• Data Guard Administration for Oracle 12C R2
• Creating Virtual Machines
• Basic Usage of Data Guard Broker Utility
• Switchover and Failover Operations on Physical Standby Database via both SQLPlus and Data Guard Broker
• Creating Far Sync Instance
• Configuring Primary and Standby Databases for far sync Instance
• Switchover & Failover Operations on Logical Standby Database via both SQLPlus and Data Guard Broker
• Oracle Database is an enterprise database that can handle online transaction processing needs, as well as data warehousing and workloads for ERP
• Oracle DB was designed to be a flexible way to handle large applications and massive amounts of structured data.
• SQL stands for Structured Query Language—the language developers use to interact with databases to create, read, update, and delete database records
• ANSI created the standard for SQL. Many database vendors, like Oracle, expand on this standard to create their version of the language.
• Oracle SQL is compliant with ANSI SQL standards, with features designed specifically for the Oracle database management system.
• Oracle SQL extends the SQL standard with a procedural language PL/SQL and adds the ability to use the Java programming language.
• What careers use Oracle SQL? Having Oracle SQL skills can add value to many careers.
• The most obvious is being a database administrator in enterprises that use the Oracle database management system.

Requirements

• 12 GB memory for Full Oracle Database Administration
• 60 GB of free disk space
• A computer with access to the internet
• Basic Computer Knowledge with (Win7/8/10)
• Desire to learn Oracle
• Desire to learn Oracle Database Administration
• Desire to learn Oracle RAC
• Desire to learn Oracle Rman
• Nothing else! It’s just you, your computer and your ambition to get started today

Target audience

• Anyone who is Oracle Database beginner but wants to become expert
• DBA`s who are looking to sharpen their skills to the expert level
• DBA`s that manage other RDBMS and want to immigrate Oracle
• DBA`s that manage other RDBMS and want to immigrate Oracle
• Anyone who wants to become an Oracle DBA at a big company
• People who want to learn Oracle DBA
• People who want to learn Oracle Database Administration
• People who want to learn Oracle Rman
• People who want to learn Oracle RAC