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


      Network Basic Know-How

      • SSH- and RDP connections to server

    • Our quality promise

    Contact to our service center

    DE+49 (0) 711 90363245

    CH+41 (0) 584 595795

    AT+43 (01) 33 2353160

    FR+41 (0) 584 595454

    EN+49 (0) 711 90363245

    DA+49 (0) 711 90363245

    email[email protected]

    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 months


    0-3 months


    Place Date Language Price
    Virtual Classroom 19.09 - 22.09.2022
    26.09 - 28.09.2022
    de  3.910,00
    Virtual Classroom 07.11 - 10.11.2022
    14.11 - 16.11.2022
    de  3.910,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

    Erfahrungen & Bewertungen zu Trivadis Training Erfahrungen & Bewertungen zu Trivadis Training anzeigen
    Back to overview
    0
    Trivadis, Bernd Rössler, Head of Training

    Bernd Rössler

    Solution Manager Trivadis Training

    DE: +49 (0) 711 90363245
    CH: +41 (0) 584 595795
    AT: +43 (0) 133 2353160
    FR: +41 (0) 584 595454
    EN: +49 (0) 711 90363245
    DA: +49 (0) 711 90363245

    E-Mail: [email protected]

    “I'll be glad to advise you on topics such as individual coaching, workshops, project support, and online training courses.”

    Your Bernd Rössler

    trivadis training satisfaction guarantee

    Guarantee of quality

    Following completion by the participants, every single training course is assessed at the levels

    • suitability of the training room,
    • suitability of the workplace,
    • functionality of the technical equipment, and
    • satisfaction throughout the entire course / seminar,

    and recorded in our "TRIVALUATION" feedback system for quality assurance purposes. This enables us to consistently ensure the high quality and satisfaction of our valued customers. We really appreciate the overall rating of 9.3 from 10 points awarded by our many enthusiastic customers.


    rivadis training success guarantee

    Success guarantee

    Trivadis guarantees the success of your training. Having completed the course / seminar, do you have any questions about the practical aspects? Would you like to repeat any of the exercises in the lab environment?

    Our success guarantee allows you to repeat individual days, or even the entire training course, free of charge for up to 6 months after attending a training course. You bring with you the course materials from the previous training course.