Why should you attend the O-AI course? Our instructor Martin Berger explains the benefits and added value in this short video!
Is an Oracle database in deployment in your organization, or are you planning to install and run one? After attending this course, you will understand the architecture, concepts, and possibilities of Oracle RDBMS 11g and 12c. You will be able to optimally and efficiently create, parameterize, and administer Oracle databases in terms of the application. You will know the options and functions, and where they are used. Numerous demos, exercises, handouts, and tips from our consulting activities supplement the course. The database course “Oracle Architecture and Internals” provides you with the basis for advanced themes such as Backup & Recovery, Data Guard, Real Application Cluster, or Tuning and Development in the Oracle environment.
-
Duration
7 days -
Goal
After attending our Oracle database course,
- you will understand the database architecture of Oracle 11g and 12c,
- you will be able to create, parameterize, and manage an Oracle database,
- you will know the possibilities and features of an Oracle database.
-
Target group
- Prospective Oracle database administrators
- Oracle developers
- System administrators with responsibility for Oracle databases
-
Contents
- Licensing, support, releases, editions and options
- Architecture overview
- Processes and files
- Memory architecture
- Tablespaces
- Transaction management and undo
- Database creation
- Patch, Upgrade, Migration
- Oracle Net
- User administration
- Database security
- Storage structures and reorganization
- Large Objects database objects
- Data exchange with Oracle Data Pump
- Monitoring and performance monitoring
- Statistics and Optimizer
- SQL optimization and monitoring
- Flashback
- Multitenant
-
Methods
- Presentation and discussion
- Demos
- Exercises on live systems
- Best practices and experiences of our instructors from day-to-day deployments at customer
-
Requirements
Linux Terminal Basic Know-How
- SSH connections to Linux based server e.g. Oracle Linux
- Navigation in operating system, directory creation
- Login and user switch between different operating system users
SQL*Plus Basic Know-How
- SELECT / INSERT / UPDATE /DELETE
Network Basic Know-How
- SSH- and RDP connections to server
-
Follow-up Courses and Workshops
- Oracle Multitenant (O-MT)
- Oracle GoldenGate (O-GG)
- Oracle Enterprise Manager Cloud Control 13c (O-EM)
- Oracle Security (O-SEC)
- Oracle Backup and Recovery (O-BR)
- Oracle Real Application Clusters (O-RAC)
- Oracle Database Performance Troubleshooting and Tuning (O-TUN)
- Oracle Data Guard (O-DG)
- Oracle Architecture and Internals for Advanced DBAs (O-AI-DBA)
- Oracle SQL Optimizer and Performance Workshop (O-OPT)
-
Recommended Courses & Workshops
Contact to our service center
+49 (0) 711 90363245
+41 (0) 584 595795
+43 (01) 33 2353160
+41 (0) 584 595454
Early booking pays off
Book your training at least 3 or 6 months before the start of the course and take advantage of the flexible pricing.
> 6 months
€ 3.480,00
> 3 months
€ 3.910,00
0-3 months
€ 4.340,00
| Place | Date | Language | Price | |
|---|---|---|---|---|
| Virtual Classroom | 12.06 - 15.06.2023 19.06 - 21.06.2023 |
de | € 4.340,00 | |
| Virtual Classroom | 11.09 - 14.09.2023 18.09 - 20.09.2023 |
de | € 3.910,00 | |
| Virtual Classroom | 11.12 - 14.12.2023 18.12 - 20.12.2023 |
de | € 3.480,00 | |
| In-house training courses on request | Inquiry | |||
- Guaranteed to take place
- The course will definitely take place if you make a booking
- There are no free places left on this course. If you still book it, we will place you on the waiting list.
- The course price is shown in the currency EUR. For orders from Switzerland, we convert the price into CHF and take into account the appropriate VAT rate. We are also happy to assist you with your order by telephone: CH +41 58 459 57 95 or DE +49 711 903 632 45.
Ausgezeichnet und geprüft
