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

Bita IT Training Academy Logo

Oracle DBA Training

Are you making the most of your data? Are you retrieving valuable and practical data from IT systems? Then you are at the right place. BITA Academy offers the Best Oracle DBA Training in Chennai that will help DBA handle capacity planning and manage all aspects of DB.

by Bita IT Training Academy [Claim Listing ]
AICPE (All India Council For Professional Excellence) Logo

Certificate In PHP And MySQL

This 2-month part-time skill development course on PHP and MySQL is designed to empower Indian students with the knowledge and practical skills necessary for self-employment and career growth in the field of web development.

by AICPE (All India Council For Professional Excellence) [Claim Listing ]
KCVT (Kamrup College Of Vocational Training) Logo

SQL Server

SQL Server course is offered by KCVT (Kamrup College Of Vocational Training). We provide training on skill development through vocational training to candidates from High School level to Post graduation.

by KCVT (Kamrup College Of Vocational Training) [Claim Listing ]
Simply C Computers without logo

MySQL

MySQL course is offered by Simply C Computers. Simply C believes in providing students quality education with practical application, with a vision of future. The company is preparing its students to have a competitive edge in the global job market.

by Simply C Computers [Claim Listing ]
Radical Technologies Logo

My SQL Developer Training

A MySQL Developer is a professional who specializes in working with MySQL, an open-source relational database management system (RDBMS). MySQL is widely used for developing and maintaining databases for various applications, websites, and software solutions.

by Radical Technologies [Claim Listing ]

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