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
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 242 evaluations)

Reviews

     
Veel informatie met betrekking tot kleine basis queries waar ik in mijn praktijk waarschijlijk niets mee kan (maar wel goed om eens te zien). De algemene opbouw en werking is voor mij van belang. (, )
     
goed tot zeer goed (, )
     
++++++ could not be better ! (, )
     
Prima cursus,prima docent. (, )
     
Is zinnig en goed toepasbaar (, )
     
Helder (, )
     
Goed, veel gezien veel gehoord. (, )
     
Kennis was/is deels aanwezig bij mij. Introductie Oracle was denk ik 1 dag voor mij voldoende. (, )
     
Goede curcus, al heb ik het gevoel dat er nog veel meer basis Oracle zaken zijn. Ik denk aan ASM, RMAN, CRON. Maar dan 3 weken cursus nodig. (, )
     
cours tres bien mais d'un niveau un peu trop haut (, )

Refresh this page to see other comments.