home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
C
 
All CoursesbalkjeGeneral courses » Introduction to HW & SW » Soft skills » TracksOperating systems » MVS - z/OS » Linux - UNIX » Mac OS X » iPad and iPhone iOSDatabases and middleware » Relational databases & SQL » Db2 for z/OS » Db2 for LUW » Oracle » SQL Server » MySQL & MariaDB » IMS » CICS » IBM MQ » WebSphere » Data Science, Big data and analyticsApplication development » Methods and techniques » TOGAF » PRINCE2 » Agile development and Scrum » Programming languages » Internet development » Object Oriented systems » Java » Development tools » SAS » XML » SOA & web servicesSystems management » ITIL » SecuritybalkjePractical informationRegistration 

Introducing domain 'Oracle'

Definition

Oracle Database

The Oracle database is an RDBMS from Oracle corporation, extensively used in product and internet-based applications on many different platforms. First ever commercially available RDBMS, Oracle Version 2 implemented the use of SQL for data manipulation purposes. Closely aligned with current evolution in information processing requirements. Technically, today, Oracle can be considered to be an object-relational database.

(Source: Webster's Dictionary of Computing)

Importance

Oracle - next to DB2 - is one of the most frequently used data bases in larger companies. But also in smaller companies, the Oracle database engine frequently stores important amounts of corporate data.

The Oracle database system is mostly used in very specific circumstances: as a platform for dynamic and less controllable applications; as a database engine for data-warehousing; as a database system for very specific, proprietary applications; or as a source for packaged applications - like SAP, Baan, to name a few. Then, after some time, integration with other database engines typically becomes an issue. Observe the management of an Oracle system requires specific and detailed knowledge; too frequently, Oracle is still used as black-box!

ABIS investments in Oracle are considerable; indeed, it is one of the most frequently encountered data bases within our customer base. Our in-depth Oracle knowledge, combined with our DB2 expertise, offers you true added value!

Core competencies

We focus specifically on the following points of interest:

Given the importance of Oracle, ABIS provides all required expertise for an efficient handling of relevant Oracle issues. End-user, developer, architect, systems manager, administrator - you will find all required - even conceptual - knowledge you desire and need.

The creation and management of an Oracle database system requires specific knowledge covering a broad range of topics. ABIS not only offers you an overview of the techniques required to master this challenging task; we also offer you an insight into the mechanism and philosophy behind these techniques - thus making sure that you will always be able to tackle any database challenge presented with. Amongst other things, we cover database management, system management and performance, data warehousing, backup and recovery.

Frequently, DB2 DBA's are required to also manage Oracle systems. Or Oracle data has to be kept synchronized with DB2 data. How do we accomplish all of this in an efficient and effective way? What are the different techniques at our disposal? And how do we set up this process in a timely and efficient fashion?

Certification

By means of the ABIS course hand-outs and based on practical experience, our participants and course leaders have already taking the following certificates (details - see Certification matrix 'Oracle') :

Course leaders

Kris Van Thillo, Responsible for the Oracle domain.

Training methods

Training

Classroom instruction

Cases
Exercises

Indivodual training

Coaching

Please find an overview of the standard trainings in this borchure.
On-site trainings are availble.

Available as individual trainings.

Available.

Installation and configuration of an Oracle environment.

System tuning.

Consulting
Projects

Projects
tuning of applications - evaluation SQL statements
system tuning
set-up of an Oracle environment
set-up and configuration offline replication DB2 versus Oracle.