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 
Oracle SQL performance

It is extremely hard to write efficient SQL without having a thorough understanding of the Oracle optimizer. We therefore first discuss its characteristics, and determine where, and how, we can influence its behaviour. A number of techniques are discussed: creation and use of indexes, use of hints, the importance of statistics gathering. The tools available to evaluate the optimization process and the queries we write, are discussed as well: Explain, SQL Trace, autotracce.

Finally, the impact of the use of PL/SQL as an alternative to writing SQL statements is introduced, and its advantages discussed.

Participants have the opportunity to practise all the discussed topics during practical labs.

Schedule

datedur.lang.  location  price
05 Oct2?Leuven  (BE)1000 EUR  (excl. VAT) 
SESSION INFO AND ENROLMENT

Intended for

Analyst programmers, technical designers, DBAs, functional analysts.

Background

A basic knowledge of SQL and of the Oracle database structure is required (see Oracle fundamentals course).

Main topics

Training method

Classroom instruction with exercises.

Duration

2 days.

Course leader

Kris Van Thillo.

Global score

   
3.9/5 (based on 55 evaluations)

Reviews

     
Te weinig praktijk of oefeningen (, )
     
Er zou een elektronische versie beschikbaar moeten zijn, met referentiemateriaal. (, )
     
very good course (, )
     
tres interessant - donné un peu rapidement - pourrait etre étalé sur 3 jours? (, )
     
ok, maar in ons geval meer als achtergrondinfo (, )
     
zeer interessant, misschien niet alles van toepassing in onze situatie (, )
     
good, have seen a lot (, )
     
Goed en grondig uitgelegd. Zeer interessant (, )
     
Ok, doch eerder ervaren als een overview dan een echte cursus. Vele items vragen nog veel uitzoekwerk achteraf. (, )
     
goed, duidelijke cursus, voldoende ruimte om vragen te stellen (, )

SESSION INFO AND ENROLMENT