office@promanagement.ro

0721.391.236

021.317.09.29

full-oracle

Oracle Database 11g Course: Comprehensive Introduction and Administration

595 € +VAT
, , ,
Organized on request Days: 5
8 Hours/Day Online
9:00 - 17:00
The course is accredited by ANC – Assistant Programmer – COR 351201
The diploma is recognized by the Ministry of Labor, Family and Social Protection and the Ministry of Education, Research and Innovation and certifies all professional skills of the occupation.
This course will provide students with a solid foundation for basic administration of the Oracle 11g database. Students will learn how to prepare a system for installing Oracle software and how to install Oracle software.
At the same time, students will understand the architecture of the Oracle database at a conceptual architectural level, how Oracle’s internal components work. During the course will be covered common administration tasks such as: creating a new database, database structure management, database security, user management, concepts and restoration techniques.

This course will provide participants with the skills to:

  • Performs user management
  • Understand the concepts of backup and restore
  • Installing the Oracle database and configuring the operating system to install Oracle

The price includes:

Electronic course support, lunch, coffee break, ANC exam and ANC certificate.

Conditions of access and documents required for registration:

Enrollment in the training program is conditioned by the graduation of secondary education:

  • Copy of identity card.
  • Copy of the baccalaureate diploma.

Volume discount:

Negotiable volume discounts are granted. Request a special offer for your company!

Email: office@promanagement.ro

Graduation certificate template:

  • 1. Oracle database architecture

    • Overview
    • Working with the Oracle database
    • ORACLE internal architecture and processes
    • Dtorage system architecture
    • Physical and logical structures of the Oracle database
    • Tablespaces and Datafiles
    • Tablespaces SYSTEM and SYSAUX
    • Segments, Extents, and Blocks

    No items in this section
  • 2. Preparing the operating system for Oracle installation

    • Oracle Database Installation: System Requirements
    • Optimal Flexible Architecture (OFA)
    • Setting Environment Variables
    • Oracle Universal Installer (OUI)
    • Configuring Database Options Oracle
    • Advanced installation options

    No items in this section
  • 3. Creating a new database

    • Oracle database types
    • Listener configuration
    • Using the DBCA utility to create a new database
    • Password management
    • Creating a Template
    • Using DBCA to delete a database
    • Other options when using DBCA

    No items in this section
  • 4. Oracle court management

    • Oracle Enterprise Manager
    • Initialization parameters
    • Starting and stopping the database
    • Types of stopping the database
    • Viewing Alert History
    • Using files Trace
    • Data Dictionary: Concept and architecture

    No items in this section
  • 5. Configure the Oracle network environment

    • Oracle Net Services & Listener
    • Network Configuration and Management Tools
    • OracleNet Services in Enterprise Manager
    • Naming Methods
    • SGA and PGA
    • Using Shared Server connections

    No items in this section
  • 6. Management of storage structures

    • Storage structures
    • How data is stored in tables Anatomy of a
    • Database block
    • Space management in Tablespaces
    • Tablespaces in preconfigured databases
    • Oracle Managed Files (OMF)
    • ASM: Concept

    No items in this section
  • 7. User security management

    • User accounts in the database
    • Predefined accounts: SYS and SYSTEM
    • Authentication as administrator
    • Advantages of roles
    • Predefined roles
    • Implementation of security functionalities of passwords

    No items in this section
  • 8. Managing objects in a schema

    • Understanding the schema concept
    • Accessing objects in a schema
    • Creating and modifying Tables
    • Ensuring data integrity
    • Indexes and Sequence views
    • Tables temporary

    No items in this section
  • 9. Management of data and competing processes

    • Manipulating data using SQL
    • PL / SQL
    • Managing PL / SQL objects
    • Functions, packages, procedures and triggers
    • Solving locks using SQL

    No items in this section
  • 10. “Undo Data” Management

    • Manipulating data
    • Transactions and “UNDO DATA”
    • Undo Data Versus Redo Data
    • Configuring UNDO RETENTION (undo_retention parameter)
    • Using Undo Advisor
    • Viewing activities in the system

    No items in this section
  • 11. Implementing security in the Oracle database

    • Fine Grained Audit
    • DBA Audit
    • Applying Security Patches

    No items in this section
  • 12. Database maintenance

    • Optimizer statistics
    • Automatic Workload Repository (AWR)
    • Automatic Database Diagnostic Monitor (ADDM)
    • Automatic maintenance tasks
    • Server-generated alerts
    • Implementation and resolution of alerts

    No items in this section
  • 13. Performance management

    • Performance monitoring
    • Memory component management
    • Using Automatic Memory Management (AMM)
    • Automatic Shared Memory Advisor
    • Using Memory Advisors
    • Dynamic performance statistics
    • Troubleshooting and Tuning Views
    • Invalid and null objects

    No items in this section
  • 14. Backup and Recovery concepts

    • Human errors and system errors
    • Instance restoration
    • Phases of instance restoration
    • Using MTTR Advisory
    • Media Failure
    • Archived log files

    No items in this section
  • 15. Making backups

    • Oracle-suggested backups
    • Recovery Manager (RMAN)
    • Configuring RMAN settings
    • Control file backup to trace file
    • Flash Recovery Area monitoring

    No items in this section
  • 16. Performing restorations

    • Opening a database
    • Data Recovery Advisor
    • Loss of a control file
    • Loss of a Redo Log file
    • Data Recovery Advisor
    • Data Recovery Advisor views

    No items in this section
  • 17. Moving data

    • Architecture
    • Directory objects
    • SQL * Loader
    • Data Pump
    • Enterprise Manager and Data Pump jobs
    • Data dictionary

    No items in this section

Sign Up for this Course

If you would like to register more people with the same billing information or benefit from the group discount, please contact us by email at office@promanagement.ro