Oracle courses Scotland

...This course will give you an introduction to database design and programming using Oracle Academy curriculum teaching materials, software and online exams... Learn about: Database Design, Database training...

...Course Content: This course is delivered on-line and includes database construction and interrogation using Oracle software. Course duration is estimated... Learn about: Database Design...

...Course content Program Blocks Variables and Constants Data Types * UsingSQLStatements within PL/SQL Programs GeneratingSQL*Plus andSQLDeveloper Output...

...Setup ASM Scalability & Performance Enhancements SYSASM & ASM Disk ASMCMD Extensions SecureFiles: Overview Data Recov. Advisor, Flashback Repairing...

...By the end of this course, the delegate will be able to: Use SQL Developer as an alternative to SQL*Plus, Manage Schema Objects with Data Dictionary Views...

...Synonyms Create a Sequence View Sequence Details Create a Synonym List Synonyms...

...and Variables Creating and Changing Tables and Views Constraints and Indexes Inserting, Updating and Deleting Data Basic Transaction Control Controlling...

...delegates learn how to use Oracle Data Guard to help protect their Oracle database against planned and unplanned downtimes. They also learn how Data Guard...

...Program with PL/SQL. Suitable for: This course is designed to introduce Oracle DBAs, software development personnel and database support staff to the primary...

...Values Using SQL Statements in Code Generating Output to SQL or SQL Developer Program Logic IF THEN ELSIF ELSE Statements CASE Statements The Basic...

...Configuring Shared Servers Creating and Managing Database Storage Structures Managing Redo Log Files and Control Files Managing Schema Objects Managing Users...

...ASM Installation and configuration Database installation and creation Management Monitoring real application clusters Monitoring Nodes Managing Nodes Managing...

...program units and packages. Objectives: By the end of this course, the delegate will be able to write and manage stored program units, implement package constructs and features...

...Flashback Technology Flashback Query The DBMS_FLASHBACK Package The AS Clause Flashback Table Flashback Drop Flashback Data Archive Date, Time and Timezone Support...

...This course is designed to give database administrators the knowledge and skills needed to maintain successful and efficient day-to-day operations of an Oracle database...

...Create Templates for a Sample Report. Create Templates for BI Publisher Reports. Insert Tables, Forms and Charts. Use MS Word to format RTF Templates...

...Oracle Database SQL Expert (IZ0-047) This course is designed for anyone who needs to access and work with an Oracle Database. This course is suitable...

...Expressions and LOOP Constructs Declare and use Cursors Use record types and PL/SQL Tables Handle Errors and Exceptions within PL/SQL Scripts... Learn about: Using PL/SQL Index-By table built-in functions...

...automate tasks with the Scheduler and use Automatic Storage Management (ASM). Course content Manage Memory Plan a Backup and Recovery Strategy Oracle Recovery...

...an Application The Facade Pattern Portability Oracle Products and Tools Oracle 10g Database Toplink JDeveloper Oracle Containers For J2EE (OC4J)...