Training objectives
- Understand all the concepts of the Oracle database architecture
- Create and configure Oracle databases
- Understand database security: privileges and roles
- Administer Oracle databases
- Manage Oracle network protocols
- Be acquainted with Oracle Enterprise Manager Database Console (Monitoring) and Oracle Recovery Manager
Topics
- Oracle database file types: spfile, control file, data file, redo log file
- Storage, process, and memory structures as well as Oracle Automatic Storage Management (ASM)
- Oracle Database Creation Assistant (DBCA)
- Oracle Network Infrastructure (OracleNet, listener)
- Space management
- Oracle Automatic Diagnostic Repository (ADR)
- Startup & Shutdown (Oracle Restart)
- Job Scheduler (DBA_SCHEDULER)
- Oracle Data Pump Export/Import utility
- Oracle optimizer
- Globalization support
- Oracle Database Upgrade Assistant
Method
- Presentation with countless practical exercises and trainings
- Case studies, live demos, discussions
- Networking during coffee break, lunch, and apéro on last day (included in price, except for on-site workshop courses)
Target groups
- Database administrators (DBA) as well as network, system, and application administrators responsible for or supporting Oracle databases
Related Trainings & Events
- dbi InSite Workshop Linux for Oracle DBAs
- dbi InSite Workshop Oracle Backup & Recovery
- dbi InSite Workshop Oracle Data Guard
- dbi InSite Workshop Oracle Database Appliance (ODA)
- dbi InSite Workshop Oracle DBA Basics
Language & documentation
- Workshop in English, French or German
- Documentation: content details, scripts, case study solutions as PDF file (in English)
More information on dbi services:
- Performance Management: Reviews and Tuning
- dbi services is Oracle Platinum Partner