Training objectives
- Understand the basics of the Oracle database architecture
- Create and configure Oracle databases
- Understand database security: privileges and roles
- Administer Oracle databases with usual tasks
- Understand Oracle network protocols
- Understand the different Backup techniques
Topics
- Oracle database file types: spfile, control file, data file, redo log file
- Oracle Database Creation Assistant (DBCA)
- Oracle Network Infrastructure (OracleNet, listener)
- Oracle Data Pump Export/Import utility
- Oracle backup & recovery with RMAN
- Startup & Shutdown (Oracle Restart)
- Introduction to the different high availability solutions
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 essentials
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