Workshop
digicode: ODADMI
Oracle for Database Administrators
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
Download as PDF- Installing the Oracle database independently
- Administering the Oracle database independently
- Analyzing the Oracle database independently using available tools
- Gaining comprehensive knowledge of the core capabilities of the Oracle database
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 as well as a basic understanding of servers and operating systems.
You are familiar with terms such as CPU, memory, storage space, IP address, etc.