Verhoef Training Ltd. courses

...Systems Overview Logging In Navigation System Shutdown/Startup Processes User Management File System Queue Management Fundamentals I/O Management Fundamentals...

...Deelgates requiring a more advanced look at System Management functions in OpenVMS. PREREQUISITES: OpenVMS system management experience. DURATION...

...This course is suitable for Oracle 9i, 10G and 11G. On completing the course, delegates will be able to: - Utilise the SQL language to retrieve data from an Oracle Database...

...performance issues & tracing Optimiser Hints Introduction Optimiser goal hints Access method hints Join order hints Join operation hints Parallel execution...

...and sqlerrm Nested blocks Quiz practical session on exception handling Cursors Introduction Cursor Open Fetch Close Cursor for loop Data modifications...

...units Adding Windows Functionality Radio groups Check boxes and list items Buttons & toolbars Visual attributes Editors Alerts Creating application windows...

...in order to allow the delegate to create reports, making effective use of the enhanced procedural and report layout features. Delegates will gain sufficient...

...most concepts are also applicable to Standard Edition and Standard Edition One versions of Oracle 10G. PREREQUISITES: An understanding of using an Oracle based system is required...

...Manager and Profiles Tuning Improvements Buffer Cache flushing - user initiated Automated checkpoint tuning CPU Costing Dynamic sampling Easy transaction...

...OBJECTIVES: The course is intended for Oracle development specialists who need to familiarise themselves with the new development features embodied in the ORACLE 10G database...

...LogMiner command line interface, Flashback Data Archive 5 Table and index partitioning Extended composite partitioning, Reference partitioning...

...Working with SORTS, TOTALS, Percentages Drilling the Data Graphing Data Workbook maintenance Working with SQL and setting options Using SQL functions...

...of calculations Creating simple and complex calculated items Modifying a calculation Passing parameters to calculations Applying simple and complex...

...from the corporate mainframe, to enterprise Unix servers, down to departmental level intel platforms. For a database of any significant...

...with Object Types and Collections Compiling PL/SQL Code for Native Execution Inserting PL/SQL record(s) into a table Querying data into collections...

...For a database of any significant size, performance immediately becomes an issue. Users may resent a query taking 3.5h, for instance. Or on the other...

...and Java and web-based application developers interested in becoming familiar with the application server platform. PREREQUISITES: A background in Web Development...

...Graphs Calendar Computations, Processes and Validations (CH13) Validations Computations Processes...

...They will be able to provide support and advice to users of an Oracle database up to and including 9i. Suitable for: The course is for support staff...

...The course has been designed for System Analysts, Managers and End Users. PREREQUISITES: IT professionals who have some familiarity with the base operating...