Oracle courses Scotland

...Objectives: By the end of this course, the delegate will be able to: Describe the structure of a relational database Use the command line features of SQL*Plus...

...indexes and views Create, update and delete records Manage sequences and synonymns Use the Data Dictionary Note: Exams are not included as part of the course... 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...

...Encryption & the Secure Socket Layer Intro to SSL PL/SQL Gateway Intro to the PL/SQL Gateway Installing Configuration PLSQL Web Toolkit Invoking Database...

...Delegates will also be able to chart and analyse data, produce reports, use Discoverer Plus & Discoverer Viewer. Course content Discoverer Concepts...

...Creating and Managing Database Storage Structures Managing Redo Log Files and Control Files Managing Schema Objects Managing Users, Profiles... Learn about: Installing and Configuring Oracle, Creating and Managing an Oracle Database...

...Recovery Strategy Validate the Recovery Strategy Session 2: ORACLE RECOVERY STRUCTURES AND PROCESSES Architectural Components of Backup and Restore Redo...

...Some previous programming experience will also prove advantageous...

...ESB, XML, SOA and related topics for example Java/J2EE. Introduction to Oracle Service Bus Installation Oracle XE and OSB 11g Creation of Domain OSB Console... Learn about: XML training, J2ee training...

...ALTER, DROP) Creating tables by asking (CREATE TABLE . AS SELECT ...) CONSTRAINTS Options NULL and NOT NULL CONSTRAINT clause Condition PRIMARY KEY Condition... Learn about: Database Management, Database 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, Oracle SQL, Database Management...

...any prior knowledge of the Oracle database, or other relational database systems, even though such knowledge may be useful. Exams and Certificates... Learn about: Database training, Database Management, Construction Training...

...to optimize Control work cost-based optimizer by: Session parameters and instance Tips (hints) Patterns of query plans Statistics and Histograms Impact... 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: Object oriented training, Data Collection, Data analysis...

...covers the training material required to pass the exam 1Z0-144 Oracle Database 11g Program with PL / SQL and obtain the title of Oracle PL / SQL Developer... Learn about: Database Management, Construction Training, Database training...