Oracle: Database concepts for developers

This course is only available in Dutch. Would you prefer to take the course in English? Please contact us.

An Oracle applications developer must be well-versed in the tools used to build these applications (Oracle Developer and/or Oracle Designer). However, to make the right decisions during application development regarding where to allocate specific functionality, and to understand the implications of these choices, certain knowledge of the Oracle Server is indispensable. This course covers those aspects of the Server that are considered essential knowledge for a developer.

 

You will learn

  • How to describe the functionality of Oracle
  • The potential storage methods used by Oracle for data in a database
  • How to allocate database space to objects
  • How to utilize the Oracle data dictionary
  • How to manage privileges for application development and how to install necessary database objects

Topics

  • Oracle architecture
  • Background processes
  • Read consistency and locking
  • Tablespaces
  • Storage clause
  • Overview of database objects and the data dictionary
  • Aspects of user management
  • Database security, privileges, and roles
  • Deferred constraints

Who should attend?

This course is intended for system developers and application designers who work with an Oracle database.

Prior knowledge

Basic knowledge of Oracle SQL is required. Knowledge of Oracle PL/SQL is strongly recommended. For more information, see the introductory courses Oracle: Work with SQL and Oracle: PL/SQL programming.

Price per person

€ 1.300,-  (excluding VAT)

Duration of this course

2 days

Course dates

21 - 22 january 2025
21 - 24 february 2025
21 - 24 march 2025
22 - 23 april 2025
21 - 22 may 2025
23 - 24 june 2025
23 - 24 december 2024

Share this training

FacebooktwitterlinkedinmailFacebooktwitterlinkedinmail