Full Oracle Database Administration with RAC
Learn Oracle Database Administration, 12C R2 RAC Administration, Oracle Backup and Recovery concepts in this course
4.40 (592 reviews)
5,193
students
21.5 hours
content
Feb 2025
last update
$74.99
regular price
What you will learn
We prepared this course of Oracle Database which includes not only database administration but also RAC (Real Application Clusters).
Creating Tables in Oracle Database Administration
You would be able to install the necessary Oracle Software/Database
Creating and Starting Oracle Database
Creating A New Database User
Database Concepts And Fundamentals
Inserting, Updating and Deleting Data In The Table
Retrieving Data From Table
Retrieving Data From Table
Filtering Result Set in Oracle Database Administration
Using Ampersand Subtition To Make More Dynamic Queries
Single Row Functions
Reporting Aggregated Data
Table Joins
Using Subqueries
Exists And Not Exists
Using Set Operators
To convert RAC database to RAC One Node and administer it
What is Real Application Cluster?
Install Grid Infrastructure, Database Software and Create database
Administer Database Instances and Cluster Databases
While preparing the course, we first covered the basic issues of database management. Then you will find a detailed explanation of Backup and Recovery concepts
Design and Deployment Techniques
Backup and recovery concepts in Oracle
Setting up the laboratory environment
Creating and managing recovery catalog
Using flashback Technologies in Oracle
Data Guard Administration for Oracle 12C R2
Switchover and Failover Operations on Physical Standby Database via both SQLPlus and Data Guard Broker
Configuring Primary and Standby Databases for far sync Instance
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.
Having Oracle SQL skills can add value to many careers. The most obvious is being a database administrator in enterprises that use the Oracle databasemanagement
Business analysts also use Oracle SQL to generate reports that help businesses get to their next stage.
Screenshots
Related Topics
3538844
udemy ID
10/1/2020
course created date
11/7/2020
course indexed date
Bot
course submited by