October 04, 2024

Choisir la langue

Training Oracle 11g

» Description

Oracle data helps customers reduce IT costs and provide a better quality service to the consolidation towards Clouds database and production systems, such as Oracle Exadata and Oracle Database Appliance. The Oracle Database 11g database is fast, reliable, secure and easy to manage for all types of workloads, database, including business applications, data warehouses and analysis of Big Data.

 

» Objectives

This Oracle 11g Administration training will allow you to :

  • Understanding the Oracle general operation
  • Know how to install Oracle products
  • Knowing the detailed architecture of Oracle (memory and disk)
  • mplement data storage (tablespaces, segments, ...)
  • Managing instances and databases
  • Manage files (logs, datafile, control, ...)
  • Implement data security
  • Use the data dictionary as administrator Oracle
  • Configure the Oracle server and client-side network (SQL * Net listener, tnsnames.ora, ODBC, JDBC)
  • Implement basic backups (files, archivelog)
  • Import and export data (sql*Loader, data pump)
  • Monitor database activity
  • Knowing the entry points to optimize database performance (index, statistics, optimizer, ...)

 

» Public

Administrators Oracle databases, application administrators and consultants

 

» Required Prerequisites

Basic knowledge of SQL and Oracle DBMS. Required experience on the use of DBMS Windows or Linux environment

 

» Program

  • The architecture of Oracle 11g and Installation
  • he files constituting the database. The structure of data storage
  • Les zones mémoire. Les processus d'arrière plan
  • Transaction management. Multi-threaded Server Architecture
  • Administrator stains
  • Installing SDBGR
  • Required Prerequisites according systems. Installation tasks on Unix
  • The OFA architecture. Using Oracle Universal Installer (OUI)
  • The Advanced Installation in Silent Mode
  • Enterprise Manager Configuration Assistant
  • The architecture of Automatic Storage Management (ASM)
  • Instance management and network configuration
  • Control methods of identification
  • Setting the instance with PFILE or SPFILE
  • States starting an instance
  • Options for stopping an instance
  • Views: dynamic, data dictionary
  • Trace files and alert files
  • Network configuration. Configuring Oracle Net Services
  • The file " listener.ora "
  • The client configuration
  • Network configuration and name resolution LDAP
  • Creating and deleting databases
  • Understand and use Oracle Managed Files (OMF)
  • The configuration wizard database
  • Manage the control file and manage log files
  • The functions of the control file. Its content
  • Multiplexing the control file
  • Manage log files
  • The role of log files
  • Manage, multiplex and archive log files
  • The logical disk space
  • Types of tablespaces. The creation of a permanent tablespace, temporary and undo
  • The file extension
  • The expansion and movement of a tablespace
  • Structures of the database
  • The storage structure
  • Settings storage tablespaces
  • The use of extents
  • The block structure of a database
  • Data storage defined as BLOB or CLOB
  • Statistics and information storage tables
  • The High Water Mark and block chaining
  • Reorganization of storage and unused space
  • Manage canceled data
  • The undo segments
  • Set the retention period for undo information
  • Ensure the conservation of canceled information
  • Use Wizard Undo
  • Flashback Database
  • Flashback Database Architecture
  • Perform a flashback of deleted tables
  • Flashback Query, Version Query and Transaction Query
  • Administration of objects
  • Create and use directory objects
  • Les tables externes et temporaires
  • Index : B*-tree, bitmap et basé sur une fonction
  • Partitioning tables, indexes
  • Materialized views
  • Managing users and security
  • Creating a User
  • Expiration and archiving passwords
  • System privileges and objects
  • Roles. Profiles
  • Materialized views
  • Complements
  • Backup and Restore
  • The ARCHIVELOG and NOARCHIVELOG Mode
  • Base backup stopped and open base
  • Managing the AWR repository
  • Using the monitor ADDM
  • Set alert thresholds
  • Use server-generated alerts
  • Use automated tasks
  • Introduction to SQL * Loader
  • Unblock user sessions
  • Collection of statistics
  • Presentation and Export Import Datapump

 

» Experience of trainers

Certified Oracle experts with extensive experience in the administration of databases.

 

» Location

Yaoundé, Headquarters Elios Consulting

 

» NB

Related documentation will be provided to participants during the course of their training. It will focus on :

  • Course materials and appendices
  • Practical cases centered on the needs of participants