Verhoef Training Ltd. courses

...Hands on. OBJECTIVES: The goal of this course is to gain more competence in operating an OpenVMS system. COURSE CONTENT: VAX/Alpha Architectures Customer-Specific...

...The goal of this course is to enable attendees to provide more effective and proactive OpenVMS system management. Suitable for: Deelgates requiring a...

...This course introduces delegates to the concepts of relational databases and provides an in-depth look at SQL in the SQL*Plus environment in order to retrieve...

...security and maintenance of objects in an Oracle database. In addition the course will provide an understanding of SQL performance issues. On completion...

...( Incorporating ANSI and BSI) standards Quiz Programming Local variables Database derived variables User defined records User defined variables Variable assignment If...

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

...The workshops are designed to mimic a true application building process. PREREQUISITES: A good knowledge of SQL and PL/SQL, preferably gained through attendance...

...Export and Import SQL*Loader Log Miner Advanced Topics Overview Performance - Table compression, indexing choices OLAP processing - Materialized views...

...an earlier release or who have already done so. PREREQUISITES: Delegates should be experienced Oracle 9i DBAs who are familiar with the features of the Oracle 9i release...

...New datatypes PL/SQL new features The common PL/SQL parser Case statement Seamless support for LOBS Object enhancements New optimizer and stats gathering...

...This event is designed to bring existing R10.2 DBAs up to date with the new features in the 11g release, covering the following areas: 1) 11g DBA database...

...ITEM Classes with the ITEM Class Wizard The ITEM Classes tab The EFFECT on the ITEM Class Editing ITEM Classes Deleting ITEM Classes ITEM Class Properties...

...Share workbooks with other users and export reports to other applications. Suitable for: This course is for Oracle Discoverer end users and technical support professionals...

...NULL Values and Negations 8. Sorting, Aggregation, and Set Operators Group Functions order by select distinct group by, having union, minus...

...Essentially there are two main avenues for RDBMS optimisation. Strategies deployed by the DBA, such as cache management and DBWR and LGWR optimisation...

...Assessing physical reads Segment statistics Segment wait events Longops facility Disk I/O DBWR slaves Optimize Sort Operations Fundamentals of sorts Recognisng...

...server administration and security will help attendees. Together with Unix, Linux and/or Windows O/S familiarity and a knowledge of XML and...

...Oracle Application Express (formerly HTML DB) is a Web-based application development tool integrated with Oracle9i Database Release 2 and all releases of Oracle Database...

...line support of Oracle databases. Such delegates would include Help Desks, PC support, network support, mainframe operators or UNIX system administrators...

...On completion of the course delegates will be able to: Query and manipulate data. Use SQL*Plus to format query output. Suitable for: The course has...