home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
C
All CoursesbalkjeGeneral » Introduction to HW & SW » Soft skills » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » 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 » 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 
Oracle fundamentals course

Objectives

This course:

  • gives an overview of the Oracle RDBMS architecture;
  • examines the physical and logical Oracle objects, and their relationship;
  • describes the general and syntactical characteristics of the Oracle RDBMS: security, locking, utilities;
  • gives some basic rules concerning application performance.

Main topics

  • Oracle architecture:
  • Oracle instance and Oracle database • Oracle Client/server architecture
  • Data definition and Oracle Objects:
  • Oracle logical object structure • link with physical structure • DDL statements
  • Application development:
  • overview 3GL and 4GL
  • Catalog:
  • catalog • performance tables
  • Security concepts:
  • type privileges • roles
  • Basic utilities:
  • export/import • loader • scenarios
  • Locking:
  • lock types • vVersioning'
  • Performance and Tuning:
  • explain utility
 

Intended for

Analysts, programmers and database administrators who are going to use Oracle. Everybody who wants a thorough overview of the Oracle RDBMS.

Background

General knowledge of informatics and some familiarity with database systems and SQL (see course SQL and relational databases fundamentals). You can test for yourself to see if you have enough background by filling out the online self-test.

Training method

Classroom instruction with practical exercises.

Course leader

Koen De Backer, Sandy Schillebeeckx, Kris Van Thillo.

Duration

3 days.

Schedule

You can enrol by clicking on a date
datedur.lang.  location  price
10 May3ELeuven  (BE)1350 EUR  (excl. VAT) 
14 Jun3NWoerden  (NL)1350 EUR  (exempt from VAT) 
13 Sep3NWoerden  (NL)1350 EUR  (exempt from VAT) 
11 Oct3?Leuven  (BE)1350 EUR  (excl. VAT) 
06 Nov3EWoerden  (NL)1350 EUR  (exempt from VAT) 

Global score

   
4.2/5 (based on 246 evaluations)

Reviews

     
goed beeld van oracle (, )
     
Prima cursus (, )
     
goed tot zeer goed (, )
     
++++++ could not be better ! (, )
     
zeer goede kursus, praktisch, exact wat we zochten (, )
     
Prettig (, )
     
Inhoudelijk zeer sterke cursus, met een goede verhouding tussen theorie en praktijk. (, )
     
prima cursus structuur mag aan het begin iets uitgebreider behandeld worden (, )
     
cours tres bien mais d'un niveau un peu trop haut (, )
     
weinig poespas gewoon theorie en oefeningen. een duidelijke opbouw van de materie. (, )

Refresh this page to see other comments.