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

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

...staff who wish to gain a comprehensive understanding of how the Oracle Procedural Language / Structured Query Language (PL/SQL) is used. AUDIENCE...

...are designed to mimic a true application building process. This course is for programmers and developers who need to design applications to access the Oracle database...

...Knowledge of the GUI environment would be advantageous. DURATION: 3 days. Hands on. OBJECTIVES: This course covers the fundamental concepts of Oracle Reports...

...of a DBA and be able to perform the tasks associated with the role. Delegates will be provided with the skills to describe the architecture of an Oracle system and configure...

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

...options Native dynamic SQL enhancements Review of new PL/SQL packages XML additions Data management LOBs IOT Skip scanning of Indexes Redefining tables...

...Creating a SQL Tuning Set, Creating a SQL performance analyzer task, Reporting 4 Transaction management LogMiner interface in Oracle Enterprise Manager...

...Importing Managed Scheduled Workbooks Refreshing a Business Area Setting the Default EUL Command Line Options Using EUL Status Workbooks...

...OBJECTIVES: On completion of the course delegates will be able to: - Create, modify and run ad hoc queries. - Create filters and use functions...

...Power end users proficient in basic SQL, Data warehouse support team, First line support, BusinessObjects "managers", SQL support, Central Oracle support team members...

...OPEN_CURSORS, CURSOR_SPACE_FOR_TIME, session_cached_cursors Causes of PL/SQL Performance Problems Badly Written SQL Statements in a PL/SQL Program...

...an update locks a table for 30 minutes while it modifies. Suitable for: This course is designed for: Database administrators, Developers, Data warehouse support team members...

...Discuss and understand Service-Oriented Architecture (SOA). - Understand how the Application Server supports industry standards for Java...

...* Describe components of Oracle''s Application Express * Retrieve data & create reports from an Oracle database using Application Express * Create...

...SQL*Plus Oracle on the UNIX/Linux platform Oracle on the Windows platform Client/Server communications The Oracle Data Dictionary Common Problems on...

...system on which the database is mounted (e.g. Unix, Windows etc). DURATION: 2 days. Hands on. OBJECTIVES: On completion of the course delegates will be able...