Verhoef Training Ltd. courses

...Delegates needing an introduction to OpenVMS Operations. AUDIENCE: Delegates needing an introduction to OpenVMS Operations. DURATION: 1...

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

...Edit, store and recall queries in SQL*Plus, format results, and create standard queries with substitution variables. COURSE CONTENT: Introduction...

...Index only tables Partitioned tables Clusters Indexing Hashing Hashing vs. Indexing Views Materialised views Synonyms Sequences Dropping objects Quiz...

...Procedures and Stored Functions. This course is suitable for Oracle 9i/10g/11g users. On completion, delegates will be able to: - Write PL/SQL Control Structures...

...This course is for programmers and developers who need to design applications to access the Oracle database. This course takes students though application...

...knowledge from this course to enable them to become productive immediately on completion. COURSE CONTENT: Oracle Reports Overview Introduction The environment...

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

...Bigfile tablespace Cross-platform Transportable Tablespaces Extended ROWID format Automated Storage Management (ASM) Backup and Recovery New Features Extended...

...The course covers a wide range of topics showing the main changes in the SQL command set and in PL/SQL techniques used by developers. Suitable...

...Partition Advisor 6 Schema management DDL wait option, Adding columns with a default value, Virtual columns, Invisible indexes, Read only tables 7 Storage NFS improvements...

...with Folders and Joins Working with Folders Adding Folders with the LOAD Wizard Managing Folders Deleting Folders Creating Custom Folders Adding an empty...

...Applying Conditions and using Parameters Selecting and applying predefined conditions Creating conditions Creating complex conditions Creating parameters...

...This course is ideal for: Database administrators, Developers, Power end users proficient in basic SQL, Data warehouse support team, First line support...

...and implicit data locking Detecting locks as a cause of poor performance Commit point planning in bulk updates DISTRIBUTED_LOCK_TIMEOUT MB07/01...

...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...

...Configure critical instance components used for identity management, such as Single Sign-on (SSO), Certificate Authority and Oracle Internet Directory (OID)...

...It enables anyone with limited programming experience and a Web browser to rapidly develop scalable Web applications that can be quickly deployed to...

...On completion of the course delegates will appreciate the concept of Relational Database Management Systems (RDBMS) and Oracle in particular...

...statement Restrict and sort data Discuss single row functions and the use of NUMBER and CHAR functions Discuss single row DATE and CONVERSION functions...