Oracle for Database Administrators («ODADMI»)

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.