Scribd Logo
Upload

Welcome to Scribd!

  • 0 views

    Oracle Database 19c Administration Track

    Uploaded by

    a.elcobtan
    The document outlines the Oracle Database 19c Administration Track, detailing various courses including SQL introduction, administration, and backup & recovery workshops. Each course aims to equip participants with essential skills for managing Oracle databases, covering topics such as database architecture, security, and recovery procedures. Additionally, it includes terms and conditions for public group training, including pricing, cancellation policies, and certification upon completion.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Oracle Database 19c Administration Track

    Uploaded by

    a.elcobtan
    0 views7 pages
    The document outlines the Oracle Database 19c Administration Track, detailing various courses including SQL introduction, administration, and backup & recovery workshops. Each course aims to equip participants with essential skills for managing Oracle databases, covering topics such as database architecture, security, and recovery procedures. Additionally, it includes terms and conditions for public group training, including pricing, cancellation policies, and certification upon completion.

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document outlines the Oracle Database 19c Administration Track, detailing various courses including SQL introduction, administration, and backup & recovery workshops. Each course aims to equip participants with essential skills for managing Oracle databases, covering topics such as database architecture, security, and recovery procedures. Additionally, it includes terms and conditions for public group training, including pricing, cancellation policies, and certification upon completion.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    0 views7 pages

    Oracle Database 19c Administration Track

    Uploaded by

    a.elcobtan
    The document outlines the Oracle Database 19c Administration Track, detailing various courses including SQL introduction, administration, and backup & recovery workshops. Each course aims to equip participants with essential skills for managing Oracle databases, covering topics such as database architecture, security, and recovery procedures. Additionally, it includes terms and conditions for public group training, including pricing, cancellation policies, and certification upon completion.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 7

    Oracle Database 19c Administration Track

    # Course Title Hours


    1 Oracle Database 12c: Introduction to SQL
    2 Oracle Database 19c: Administration Workshop
    120
    3 Oracle Database 19c: Backup & Recovery Workshop
    4 Oracle Database 19c: Managing Oracle on Linux for DBAs
    1- Oracle Database12c: Introduction to SQL

    This Oracle Database: Introduction to SQL training helps you write subqueries, combine
    multiple queries into a single query using SET operators and report aggregated data using
    group functions. Learn this and more through hands-on exercises.

    Learn To:

     Understand the basic concepts of relational databases ensure refined code by


    developers.
     Create reports of sorted and restricted data.
     Run data manipulation statements (DML).
     Control database access to specific objects.
     Manage schema objects.
     Manage objects with data dictionary views.
     Retrieve row and column data from tables.
     Control privileges at the object and system level.
     Create indexes and constraints; alter existing schema objects.
     Create and query external tables.

    Benefits to You

    Ensure fast, reliable, secure and easy to manage performance. Optimize database
    workloads, lower IT costs and deliver a higher quality of service by enabling consolidation
    onto database clouds.

    Learn Advanced Features of SQL

    This course will help you understand the advanced features of SQL. Learning these
    features will help you query and manipulate data within the database, use the dictionary
    views to retrieve metadata and create reports about their schema objects. Some of the
    date-time functions available in the Oracle Database are also covered. This course also
    discusses how to use the regular expression support in SQL through expert instruction.

    Use Development Tools

    The main development tool used in this training is Oracle SQL Developer. SQL*Plus is
    available as an optional development tool. This is appropriate for a 10g, 11g and 12c
    audience.

    Course Bundle
    Note: This course is a combination of Oracle Database: SQL Workshop I and Oracle
    Database: SQL Workshop II courses.

    Objectives

     Identify the major structural components of the Oracle Database 12c


     Create reports of aggregated data
     Write SELECT statements that include queries
     Retrieve row and column data from tables
     Run data manipulation statements (DML) in Oracle Database 12c
     Create tables to store data
     Utilize views to display data
     Control database access to specific objects
     Manage schema objects
     Display data from multiple tables using the ANSI SQL 99 JOIN syntax
     Manage objects with data dictionary views
     Write multiple-column sub-queries
     Employ SQL functions to retrieve customized data
     Use scalar and correlated sub-queries
     Create reports of sorted and restricted data

    Topics

     Introduction
     Retrieving Data using the SQL SELECT Statement
     Restricting and Sorting Data
     Using Single-Row Functions to Customize Output
     Using Conversion Functions and Conditional Expressions
     Reporting Aggregated Data Using the Group Functions
     Displaying Data from Multiple Tables Using Joins
     Using Subqueries to Solve Queries
     Using the SET Operators
     Managing Tables using DML statements
     Introduction to Data Definition Language
     Introduction to Data Dictionary Views
     Creating Sequences, Synonyms, Indexes
     Creating Views
     Managing Schema Objects
     Retrieving Data by Using Subqueries
     Manipulating Data by Using Subqueries
     Controlling User Access
     Manipulating Data
     Managing Data in Different Time Zones
    2- Oracle Database 19c: Administration Workshop

    This course provides detailed information on the architecture of an Oracle Database


    instance and database, enabling you to effectively manage your database resources.
    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. Basic information on
    backup and recovery techniques is presented in this course.
    To provide an acceptable response time to users and manage resources effectively, you
    learn how to monitor your database and manage performance.

    Objectives

    Upon completion of this course, the student should be able to:

     Describe Oracle Database architecture


     Describe 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

    Topics

     Introduction
     Oracle Database Architecture
     Introduction to Oracle Database Cloud Service
     Creating DBCS Database Deployments
     Accessing an Oracle Database
     Managing DBCS Database Deployments
     Managing Database Instances
     Understanding Oracle Net Services
     Administering User Security
     Creating PDBs
     Creating Master Encryption Keys for PDBs
     Creating and Managing Tablespaces
     Managing Storage Space
     Managing Undo Data
     Moving Data
     Backup and Recovery Concepts
     Backup and Recovery Configuration
     Creating Database Backups
     Performing Database Recovery
     Monitoring and Tuning Database Performance
     SQL Tuning
     Miscellaneous

    3- Oracle Database 19c: Backup & Recovery Workshop

    The student begins by gaining a deeper understanding of possibly the most important job
    of a DBA - backup and recovery. The concepts and architecture that support backup
    and recovery, along with implementation in various ways and situations are covered in
    detail. Students gain knowledge of the Recovery Manager (RMAN) command-line
    interface for various backup, failure, restore, and recovery scenarios, including data
    duplication.

    Extensive hands-on practices and workshop scenarios provide the student with
    experience in a realistic technical environment. This course includes an interactive
    workshop that provide participants with opportunities to diagnose and recover from
    several failure scenarios, based on backup and recovery case studies.

    After completing this course, students should be able to evaluate their own recovery
    requirements and develop an appropriate strategy for backup and recovery procedures.

    Versions Supported: 19c, 18c, 12c

    Learn To:

     Develop appropriate backup and recovery procedures to address your business


    needs.
     Implement backup and recovery settings and perform backup operations to disk
    and tape.
     Employ Oracle Database recovery procedures to recover from media and other
    failures.
     Diagnose and repair data failures.
     Use flashback technologies and data duplication to complement backup and
    recovery procedures.
     Secure the availability of your database by appropriate backup and recovery
    strategies.
    Benefits

    The student benefits by gaining a deeper understanding of possibly the most important
    job of a DBA - backup and recovery. The concepts and architecture that support backup
    and recovery, along with implementation steps in various ways and situations, are
    presented in detail.

    Students gain knowledge of the Recovery Manager (RMAN) command-line interface for
    various backup, failure, restore, and recovery scenarios, including data duplication.

    Objectives

    Upon completion of this course, the student should be able to:

     Describe the Oracle Database architecture components related to backup and


    recovery operations.
     Plan effective backup and recovery procedures.
     Describe Oracle Database backup methods and recovery operations that can be
    used to resolve database failure.
     Configure the database for recoverability.
     Use Recovery Manager (RMAN) to create backups and perform recovery
    operations.
     Use the Data Recovery Advisor to diagnose and repair failures.
     Use Oracle Flashback Technologies to recover from human error.
     Perform an encrypted database backup and restore.
     Perform tablespace point-in-time recovery.

    Topics

     Introduction and Configuration


    o Introduction
    o Getting Started
    o Configuring for Recoverablility
    o Using the RMAN Recovery Catalog
     Backup
    o Backup Strategies and Terminology
    o Performing Backups
    o Improving Your Backups
    o Using RMAN-Encrypted Backups
     Recovery
    o Diagnosing Failures
    o Restore and Recovery Concepts
    o Performing Complete Recovery
    o Performing Point-in-Time Recovery
    o Performing Additional Recovery Operations
     Additional Technologies
    o Using Flashback Technologies
    o Using Flashback Database
    o Transporting Data
    o Duplicating a Database
    o RMAN Troubleshooting and Tuning
     Hands-On
    o Backup and Recovery Workshop

    Terms and Conditions for Public Group:


    1. Training Kits: The prices include the Oracle training kits from Oracle.
    2. Number of attendees: Group Max 10 attendees
    3. Certificates: After completion of course, students will receive a (Certificate of
    Completion) from Global academy – Oracle Approved Education Partner.
    4. Prices: The prices showed in proposal are in (EGP).
    5. Payment: 100% two weeks prior the course start date.
    6. Cancelation:
     Global academy reserves the right to cancel or reschedule any course with
    prior notice due to circumstances beyond its control without any liability on
    its part.
     Customers will be refunded for cancelled courses which they have already
    prepaid upon request.
     Cancellation requests must be sent by email at least 4 weeks before the
    course start date, otherwise they will not refund the payment.
     No course cancellations will be accepted within the 4 weeks before the
    course start date.
    7. No Show: will be due for payment in full and no refund.

    You might also like