Download app Download App
tag
Favourite 0
Your cart is empty
Keep shopping  right

    Oracle Database 12c Admin, Install and Upgrade Accelerated Training Course

    Oracle Database technology is used by the world's leading companies to manage critical business functions, systems and processes. Oracle Database is the number one databa...

    ₹ 22000

    ₹ 25000

    12% off

    SHARE
    Baroda Institute of Technology
    ₹22000  ₹ 25000  

    12% off

     
    Buy Now
    This includes following
    •  100 Hours
    •  Completion certificate : Yes
    •  Language : Hinglish 
    Oracle Database technology is used by the world's leading companies to manage critical business functions, systems and processes. Oracle Database is the number one database in the world. Over 305,000 top companies trust their critical systems to Oracle Database. Oracle Database is the number one embedded database technology.In fact, 97% of Global Fortune 500 companies use Oracle software. Well-trained, highly-skilled database professionals who can manage critical systems are in high demand. This Oracle Database 12c: Admin, Install and Upgrade Accelerated course covers practical approach. This course will will teach you about the Oracle Database architecture and you will discover how to effectively manage an Oracle Database instance. You will also be provided key information on how to install and administer Oracle Database 12c.

        Live Class Practical Oriented Training

        Timely Doubt Resolution

        Dedicated Student Success Mentor

        Certification & Job Assistance

        Free Access to Workshop & Webinar

        No Cost EMI Option

        Manage Oracle Database Storage structures. Gain an understand of the Oracle Database Cloud Service.

        Create a container database. Monitor the Database. Manage Database Performance. Implement Database Auditing

        Schedule Jobs to Run Inside or Outside of the Database. Configure Oracle Net Services.

        Configure your Database For Backup and Recovery Operations.

        Install Oracle Database 12c software. Upgrade database to Oracle Database 12c. Create an Oracle Database.

        Configure the Database Instance Such That Resources Are Appropriately Allocated Among Sessions and Tasks.

        Describe Oracle Database Architecture . Manage the Oracle Database Instance

       Lecture-1 Introduction

       Lecture-2 Exploring the Oracle Database Architecture

       Lecture-3 Oracle Software Installation Basics

       Lecture-4 Installing Oracle Database Software

       Lecture-5 Creating an Oracle Database by Using D.B.C.A.

       Lecture-6 Oracle Database Management Tools

       Lecture-7 Managing the Database InstanceV

       Lecture-8 Configuring the Oracle Network Environment

       Lecture-9 Administering User Security

       Lecture-10 Managing Database Storage Structures

       Lecture-11 Managing Space

       Lecture-12 Managing Undo Data

       Lecture-13 Managing Data Concurrency

       Lecture-14 Implementing Oracle Database Auditing

       Lecture-15 Backup and Recovery Concepts

       Lecture-16 Backup and Recovery Configuration

       Lecture-17 Performing Database Backups

       Lecture-18 Performing Database Recovery

       Lecture-19 Moving Data

       Lecture-20 Performing Database Maintenance

       Lecture-21 Managing Performance

       Lecture-22 Oracle Database Cloud Service 

    •   Lecture-1 Introduction
Live Lecture 
·         Overview of Oracle Database 12c

·         Overview of Oracle Cloud

·         Overview of the HR Schema

·         Oracle Database 12c Introduction

·         Practical Exercise
    •   Lecture-2 Exploring the Oracle Database Architecture
Live Lecture 
·           Oracle Database Architecture: Overview

·           Oracle Database Instance Configurations

·           Connecting to the Oracle Database Instance

·           Oracle Database memory Structures (overview)

·           Process Architecture

·           Process Structures

·           Process Start-up Sequence

·           Database Storage Architecture

·           Practical Exercise
    •   Lecture-3 Oracle Software Installation Basics
Live Lecture 
·         Planning Your Installation

·         Configuring Oracle Linux with Oracle RDBMS Pre-Install RPM

·         Operating System Groups and Users

·         Environment Variables

·         Configuring the Oracle Software Owner Environment

·         Using Oracle Universal Installer (OUI)

·         Installation Option: Silent Mode

·         Practical Exercise
    •   Lecture-4 Installing Oracle Database Software
Live Lecture 
·         System Requirements for Oracle Database

·         Creating Operating System Groups and Users

·         Types of Installations

·         Practical Exercise
    •   Lecture-5 Creating an Oracle Database by Using D.B.C.A.
Live Lecture 
·         Planning the Database Storage Structure

·         Types of Databases (based on workload)

·         Choosing the Appropriate Character Set

·         Understanding How Character Sets are Used

·         Setting the NLS_LANG Initialization Parameter

·         Using the Database Configuration Assistant (DBCA)

·         Practical Exercise
    •   Lecture-6 Oracle Database Management Tools
Live Lecture 
·         Introducing Oracle Database Management Tools

·         Using SQL*Plus

·         Using SQL Developer

·         Logging in to Oracle Enterprise Manager Database Express

·         Enterprise Manager Database Express Home Page

·         Enterprise Manager Cloud Control Framework

·         Using Enterprise Manager Cloud Control

·         Practical Exercise
    •   Lecture-7 Managing the Database Instance
Live Lecture 
·         Initialization Parameter Files

·         Starting an Oracle Database Instance

·         Shutting Down an Oracle Database Instance

·         Viewing Log Files

·         Using Trace Files

·         Using the Dynamic Performance Views

·         Data Dictionary

·         Practical Exercise
    •   Lecture-8 Configuring the Oracle Network Environment
Live Lecture 
·         Oracle Net Services Overview

·         Oracle Net Listener Overview

·         Establishing Oracle Network Connections

·         Connecting to a Server

·         Tools for Configuring & Managing the Oracle Network

·         Using the Listener Control Utility

·         Using Oracle Net Configuration Assistant

·         Using Oracle Net Manager

·         Practical Exercise
    •   Lecture-9 Administering User Security
Live Lecture 
·         Database User Accounts (overview)

·         Predefined Administrative Accounts

·         Creating a User

·         Authentication

·         Unlocking a User Account & Resetting the Password

·         Privileges

·         Roles

·         Profiles

·         Practical Exercise
    •   Lecture-10 Managing Database Storage Structures
Live Lecture 
·         Understanding Storage of Data

·         Database Block contents

·         Exploring the Storage Structure

·         Creating a New Table-space

·         Overview of Table-spaces Created by Default

·         Managing Table-spaces

·         Viewing Table-space Information

·         Using Oracle Managed Files

·         Practical Exercise
    •   Lecture-11 Managing Space
Live Lecture 
·         Space Management Overview

·         Block Space Management

·         Row Chaining and Migration

·         Free Space Management Within Segments

·         Types of Segments

·         Allocating Extents

·         Allocating Space

·         Creating Tables Without Segments

·         Practical Exercise
    •   Lecture-12 Managing Undo Data
Live Lecture 
·         Undo Data Overview

·         Transactions and Undo Data

·         Storing Undo Information

·         Comparing Undo Data and Redo Data

·         Managing Undo

·         Configuring Undo Retention

·         Guaranteeing Undo Retention

·         Changing an Undo table-space to a Fixed Size

·         Practical Exercise
    •   Lecture-13 Managing Data Concurrency
Live Lecture 
·         Overview of Locks

·         Locking Mechanism

·         Data Concurrency

·         DML Locks

·         Enqueue Mechanism

·         Lock Conflicts

·         Practical Exercise
    •   Lecture-14 Implementing Oracle Database Auditing
Live Lecture 
·         Separation of Responsibilities

·         Database Security

·         Monitoring for Compliance

·         Standard Database Auditing

·         Unified Audit Data Trail

·         Separation for Duties for Audit Administration

·         Configuring the Audit Trail

·         Specifying Audit Options
    •   Lecture-15 Backup and Recovery Concepts
Live Lecture 
·         Categories of Failures

·         Flashback Technology

·         Understanding Instance Recovery

·         Phases of Instance Recovery

·         Tuning Instance Recovery

·         Using the MTTR Advisor

·         Comparing Complete and Incomplete Recovery

·         Oracle Data Protection Solutions

·         Practical Exercise
    •   Lecture-16 Backup and Recovery Configuration
Live Lecture 
·         Configuring for Recoverability

·         Configuring the Fast Recovery Area

·         Multiplexing the Control File

·         Online Redo Log File

·         Multiplexing the Online Redo Log File

·         Archived Redo Log Files

·         Archiver Process

·         Archived Redo Log File Naming and Destinations

·         Practical ExerciseLecture-16 Backup and Recovery Configuration
Live Lecture 
·         Configuring for Recoverability

·         Configuring the Fast Recovery Area

·         Multiplexing the Control File

·         Online Redo Log File

·         Multiplexing the Online Redo Log File

·         Archived Redo Log Files

·         Archiver Process

·         Archived Redo Log File Naming and Destinations

·         Practical Exercise
    •   Lecture-17 Performing Database Backups
Live Lecture 
·         Backup Solutions 

·         Oracle Secure Backup 

·         User Managed Backup 

·         Backup Terminology and Types of Backups

·         Using Recovery Manager (RMAN)

·         Configuring Backup Settings

·         Oracle-Suggested Backup

·         Backing Up the Control File to a Trace File

·         Practical Exercise
    •   Lecture-18 Performing Database Recovery
Live Lecture 
·         Data Recovery Advisor

·         Loss of a Control File

·         Loss of a Redo Log File

·         Loss of a Data file in NOARCHIVELOG Mode

·         Loss of a Noncritical Data file in ARCHIVELOG Mode

·         Loss of a System-Critical Data file in ARCHIVELOG Mode

·         Practical Exercise
    •   Lecture-19 Moving Data
Live Lecture 
·         Moving Data: General Architecture

·         Oracle Data Pump

·         SQL*Loader

·         External Tables

·         Practical Exercise
    •   Lecture-20 Performing Database Maintenance
Live Lecture 
·         Database Maintenance (overview)

·         Viewing the Alert History

·         Terminology

·         Automatic Workload Repository (AWR)

·         Statistic Levels

·         Automatic Database Diagnostic Monitor (ADDM)

·         Advisory Framework

·         Enterprise Manager and Advisors

·         Practical Exercise
    •   Lecture-21 Managing Performance
Live Lecture 
·         Performance Monitoring

·         Tuning Activities

·         Performance Planning

·         Instance Tuning

·         Performance Tuning Methodology

·         Performance Tuning Data

·         Monitoring Performance

·         Managing Memory

·         Practical Exercise
    •   Lecture-22 Oracle Database Cloud Service
Live Lecture 
·         Database as a Service Architecture, Features & Tooling

·         Software Editions: Included Database Options &

       Management Packs

·         Automated Database Provisioning

·         Managing the Compute Node Associated With a Database

       Deployment

·         Managing Network Access to Database as a Service

·         Enabling Access to a Compute Node Port

·         Scaling a Database Deployment & Patching Database as a

       Service

·         Oracle Database Cloud Service Console to Manage Patches

·         Practical Exercise
    Basic understanding of Oracle database.
    Ans: The course offers a variety of online training options, including: • Live Virtual Classroom Training: Participate in real-time interactive sessions with instructors and peers. • 1:1 Doubt Resolution Sessions: Get personalized assistance and clarification on course-related queries. • Recorded Live Lectures*: Access recorded sessions for review or to catch up on missed classes. • Flexible Schedule: Enjoy the flexibility to learn at your own pace and according to your schedule.
    Ans: Live Virtual Classroom Training allows you to attend instructor-led sessions in real-time through an online platform. You can interact with the instructor, ask questions, participate in discussions, and collaborate with fellow learners, simulating the experience of a traditional classroom setting from the comfort of your own space.
    Ans: If you miss a live session, you can access recorded lectures* to review the content covered during the session. This allows you to catch up on any missed material at your own pace and ensures that you don't fall behind in your learning journey.
    Ans: The course offers a flexible schedule, allowing you to learn at times that suit you best. Whether you have other commitments or prefer to study during specific hours, the course structure accommodates your needs, enabling you to balance your learning with other responsibilities effectively. *Note: Availability of recorded live lectures may vary depending on the course and training provider.
    Education Provider
    profile
    Baroda Institute Of Technology - Training Program

    BIT (Baroda Institute Of Technology) Is A Training And Development Organization Catering To The Learning Requirements Of Candidates Globally Through A Wide Array Of Services. Established In 2002. BIT Strength In The Area Is Signified By The Number Of Its Authorized Training Partnerships. The Organization Conducts Trainings For Microsoft, Cisco , Red Hat , Oracle , EC-Council , Etc. Domains / Specialties Corporate Institutional Boot Camp / Classroom Online – BIT Virtual Academy Skill Development Government BIT’s Vision To Directly Associate Learning With Career Establishment Has Given The Right Set Of Skilled Professionals To The Dynamic Industry. Increased Focus On Readying Candidates For On-the-job Environments Makes It A Highly Preferred Learning Provider. BIT Is Valued For Offering Training That Is At Par With The Latest Market Trends And Also Match The Potential Of Candidates. With More Than A Decade Of Experience In Education And Development, The Organization Continues To Explore Wider Avenues In Order To Provide Learners A Platform Where They Find A Solution For All Their Up- Skilling Needs!

    Graduation
    2002
    Data Sciences

    More Courses by : Baroda Institute of Technology


    Baroda Institute of Technology
    ₹22000  ₹ 25000  

    12% off

     
    Buy Now
    This includes following
    •  100 Hours
    •  Completion certificate : Yes
    •  Language : Hinglish

    More Courses by : Baroda Institute of Technology


    Copyright © 2024 Digital Class World. All Rights Reserved.