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

Aptron Logo

MySQL

Aptron Noida provides Best MySQL training in noida based on current industry standards that helps attendees to secure placements in their dream jobs at MNCs. Aptron Provides Best MySQL Training in Noida.

by Aptron [Claim Listing ]
CITM (Coastal Institute Of Technology And Management) Logo

MS SQL

MS SQL course is offered by CITM (Coastal Institute Of Technology And Management). CITM is a pioneer in the field of Diploma and ITI Courses in Mangalore. The institute is affiliated to ISO Certified (ISO 9001:2015), registered under Govt. of India – Ministry of Corporate Affairs Organization.

by CITM (Coastal Institute Of Technology And Management) [Claim Listing ]
Prayosha Institute Logo

PL/SQL

PL/SQL course is offered by Prayosha Institute. Prayosha is a foremost Institute for career-oriented vocational courses. The students get trained through one-to-one student-mentor interaction, and intense practical training sessions.

by Prayosha Institute [Claim Listing ]
SDLC Training Logo

Data Warehousing Training

In computing, a data warehouse, also known as an enterprise data warehouse, is a system used for reporting and data analysis, and is considered a core component of business intelligence. DWs are central repositories of integrated data from one or more disparate sources.

by SDLC Training [Claim Listing ]
The Earth Logo

SQL

SQL course is offered by The Earth. The Earth is an institute of par excellence. We are committed to quality only. Along with academic we provide campus education. Shake your hand and shape your career with us.

by The Earth [Claim Listing ]
  • Price
  • Start Date
  • Duration

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