Oracle courses Scotland

...and work with an Oracle Database. This course is suitable for delegates intending to sit the following examinations: Introduction to Oracle9i...

...Oracle Database SQL Expert (IZ0-047) Objectives: By the end of this course, the delegate will be able to: Describe the basic structure of a relational... Learn about: Updating and deleting rows in database tables...

...Delegates will also be able to grant and control user access, understand the relationship between Application Server and Discoverer Components and configure...

...Procedures Using PSP's OID What is LDAP The Oracle Internet Directory Access the OID through ODM Delegated Administration Services (DAS) Bulk Command...

...Importing and Exporting Reports Advanced Features Analytical Functions Discoverer Viewer...

...will gain an understanding of the architecture. Suitable for: Anyone who needs to administer, monitor and support an Oracle 11g database. Oracle Database... Learn about: Installing and Configuring Oracle, Creating and Managing an Oracle Database...

...are required to plan and implement database backup and recovery strategies for Oracle Database 11g. This course is also suitable for delegates who...

...PL/SQL Programs Generating SQL*Plus and SQL Developer Output IF THEN ELSIF ELSE Statements CASE Expressions Basic Loops The WHILE and FOR Loops Nested...

...Report, Alert actions Transformation using XPath and XQuery Transport Header action Service callout Java Callout Validation Split-Join Dynamic Routing/... Learn about: XML training, J2ee training...

...Relational Operators Characteristics of declarative SQL language SQL Syntax Division language DQL, DML, DDL, DCL Language DQL (Data Query Language)... Learn about: Database training, Database Management...

...UNIQUE Condition FOREIGN KEY DEFAULT clause Transactions The command COMMIT, ROLLBACK, SAVEPOINT Language DCL Granting and revoking permissions (GRANT... Learn about: Database training, Oracle SQL, Database Management...

...the work environment Acquisition and modification of data Construction of the repository application Safety and concurrency runtime Notes The workshops... Learn about: Database training, Construction Training, Database Management...

...Impact indices DML operations Case Study - sorting Sorting memory Sort index Sort linguistic The effect of entropy to sort (Clustering Factor)... Learn about: Database training, Information Systems...

...and above all efficiently use the Oracle database, processing and analyzing stored in the large amounts of data Purpose of training The workshop aims... Learn about: Database training, Data Collection, Object oriented training...

...FOR UPDATE Associative arrays Packages The structure of the package: the specification and body Section Initialization and global variables... Learn about: Construction Training, Database training, Database Management...