Oracle courses Scotland

...SQL Oracle Certified Professional examination (IZ0-007) Oracle Database SQL Expert (IZ0-047) Oracle Database 11g: SQL Fundamentals (IZ0-051)...

...Sub-queries and In-line Views Character, Date and Numeric Functions SQL*Plus Run-time Parameters and Variables Creating and Changing Tables and Views Constraints... Learn about: Updating and deleting rows in database tables...

...a Business Area Granting Access to a Business Area Granting End User Privileges Simple, Complex and Custom Folders Managing Folders Managing Folder Items...

...Architecture of the IAS Basic Architecture of a Web Server Client Request Web Server Response Installation Versions Internet Connections & Intranet Domains...

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

...of the Database Loading and Unloading Data Backing Up and Recovering the Database Who will the Course Benefit? The Oracle Database 11g Release 2... Learn about: Creating and Managing an Oracle Database, Installing and Configuring Oracle...

...Release 2 Data Guard Oracle 10g Application Server Administration NOTE: Course technical content is subject to change without notice. Oracle Database 11g Release 2...

...delegates must ensure they have the recommended experience. Topics Covered: Program Blocks Variables and Constants Data Types Using SQL Statements within...

...Publishing Service virtualization Security Service Pooling... Learn about: XML training, J2ee training...

...SELECT queries Aliases columns, tables Service date (DATE types, display functions, formatting) Group Features Combining internal and external tables UNION... Learn about: Database training, Database Management...

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

...Purpose of training The workshop aims to familiarize participants with the Oracle database techniques to build database structures and data manipulation... Learn about: Database training, Construction Training, Database Management...

...cost optimization Methods of data storage and indexing Monitoring database performance and processes based on dictionaries and track system applications... Learn about: Information Systems, Database training...

...Import / Export Data Database performance and tuning SQL statements Architecture database and instance Analysis of the plan to run a command to read... Learn about: Data analysis, Data Collection, Database training...

...the organization of the working environment Create scripts and stored program units that operate on data Notes The workshops are based on the software version 11g... Learn about: Database training, Database Management, Construction Training...