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

Reviews

     
goede basis om mee verder te gaan (, )
     
++++++ could not be better ! (, )
     
Veel meer begrip van opbouw en werking van Oracle gekregen (, )
     
Uitstekende cursus waarbij vermeld moet worden dat de docent op een zeer duidelijke manier uiteen heeft gezet hoe Oracle werkt (, )
     
Is zinnig en goed toepasbaar (, )
     
veel bijgeleerd (, )
     
Cours intéressant et très divérsifié (, )
     
zeer informatief, goed ritme, to the point (, )
     
Uitstekend (, )
     
Kennis was/is deels aanwezig bij mij. Introductie Oracle was denk ik 1 dag voor mij voldoende. (, )

Refresh this page to see other comments.