Oracle Database 18c: Administration Workshop

by Trainocate India Claim Listing

This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to manage your database resources effectively. You learn how to create database storage structures appropriate for the business applications supported by your database.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Trainocate India Logo

img Duration

5 Days

Course Details

This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to manage your database resources effectively. 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. This course provides basic information on backup and recovery techniques. To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.

 

Objectives:

  • Describe Oracle Database architecture
  • Explain Oracle Database Cloud Service (DBCS) architecture and features
  • Create and manage DBCS database deployments
  • Configure the database to support your applications
  • Manage database security and implement auditing
  • Implement basic backup and recovery procedures
  • Move data between databases and files
  • Employ basic monitoring procedures and manage performance

 

Content

  • Module 1: Introduction
  • Sample HR Schema
  • Oracle Cloud Overview
  • Oracle Database Editions, Options, and Management Packs
  • Module 2: Oracle Database Architecture
  • Automatic Storage Management (ASM) Overview
  • Oracle Database Instance Configurations
  • Oracle Database Memory and Process Structures
  • Connecting to the Database Instance
  • Logical and Physical Database Structures
  • Multitenant Architecture
  • Oracle Database Server Architecture
  • Module 3: Introduction to Oracle Database Cloud
  • Automated Database Provisioning
  • Oracle Database Cloud Service Architecture
  • Features and Tooling
  • Module 4: Creating Oracle Database Cloud Service (DBCS) Deployments
  • SSH Key Pairs
  • Database File Storage
  • Input to the Creation Wizard
  • Module 5: Accessing an Oracle Database
  • Oracle Database Cloud Service Tools
  • Database Configuration Assistant (DBCA)
  • Oracle Enterprise Manager Cloud Control
  • Oracle enterprise Manager Database Express
  • SQL Developer
  • SQL*Plus
  • Module 6: Managing DBCS Database Deployments
  • Managing Network Access to DBCS
  • Managing the Compute Node
  • Scaling a Database Deployment
  • Patching a Database Deployment
  • Module 7: Managing Database Instances
  • Starting Up Oracle Database Instances
  • Data Dictionary Views
  • Shutting Down Oracle Database Instances
  • Dynamic Performance Views
  • Automatic Diagnostic Repository (ADR)
  • Alert Log and Trace Files
  • Initialization Parameter Files
  • Module 8: Oracle Net Services
  • Oracle Net Services Administration Tools
  • Configuring Communication Between Database Instances
  • Oracle Net Listener Overview
  • Connecting to an Oracle Database Instance
  • and more.

 

Prerequisites:

  • A working knowledge of SQL and PL/SQL packages is very helpful in the course.
  • Basic knowledge of Linux operating system
     
  • Bangalore Branch

    Royal Barter, 1st Floor No 78/1, Residency Road, Bangalore
  • Chennai Branch

    4th Floor, 4 - 417, Workafella | Nungambakkam No 10, Uthamar Gandhi Salai, Chennai
  • Mumbai Branch

    7th Floor, 7 - 120, WeWork, Zenia Building, Mumbai

Check out more Oracle courses in India

Hi-Tech Academy Logo

SQL Server

SQL Server training teaches developers all the Transact-SQL skills they need to create database objects like Tables, Views, Stored procedures & Functions and triggers in SQL Server.

by Hi-Tech Academy [Claim Listing ]
QuickXpert Infotech Logo

SQL Course

Learn from Basics to Advanced SQL course to become an SQL Expert. Learn right from select queries to database creation with Project. Get Certified from Best SQL Training Institute QuickXpert Infotech known for Quality Training in Reasonable Fees and Placements!

by QuickXpert Infotech [Claim Listing ]
Arth Logo

MySQL Oracle Course

MsAccess / Oracle / MySQL all are the part of RDBMS (Relational Database Management System) software. It aids costumers to handle a massive amount of data with high defined security and low access time.

by Arth [Claim Listing ]
Vikram Genuine Technology Logo

Oracle Training

The database is very important in software development. Oracle training is essential for all the software developer. Oracle is widely used in software development. VGT is the oldest centre for Oracle Training in Kota City.

by Vikram Genuine Technology [Claim Listing ]
Itronix Solutions Logo

Microsoft SQL Server Course

SQL Server, developed by Microsoft, is a relational database management system (RDBMS) used for storing and retrieving data as requested by other software applications. It’s part of the Microsoft SQL Server product suite, which includes various editions catering to different needs.

by Itronix Solutions [Claim Listing ]

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy