Workshop
ODADMI
Oracle for Database Administrators («ODADMI»)
This workshop teaches the skills required to operate and administer an Oracle database. It provides the knowledge that turns the black box “Oracle database” into a powerful and flexible tool.
Duration
5 days
Price
3'950.–
Course documents
Digital courseware
Course facts
- Installing the Oracle database
- Administrating the Oracle database
- Analysing the Oracle database using existing tools
- Acquiring comprehensive knowledge of the Oracle database core competencies
The database architecture is covered as well as its configuration and administration. Of course, Oracle network configuration is also covered, as well as user and object management.
Topics:
- Architecture of the database server
- Components of the database
- Components of the instance
- Architecture of the multitenant database
- Database parameters
- Dynamic Performance Views
- The data dictionary
- Character sets
- Installation basics
- OFA: the only abbreviation where the “O” at the beginning does not stand for “Oracle”
- Startup/Shutdown
- Oracle network: listener configuration and client configuration
- Creating and managing tablespaces and datafiles
- Segments: Tables, indexes & co
- Overview of backup & recovery
Theory and practical exercises as well as system demonstrations.
This workshop is aimed at (prospective) Oracle database administrators as well as Oracle developers and architects who want to know more about the inner workings of the database.
You have knowledge of SQL.