Oracle courses Birmingham

...Outer Joins and Self Joins Grouping and Sorting Output Sub-queries and In-line Views Character, Date and Numeric Functions SQL*Plus Run-time Parameters...

...theOracle Database 11g: SQL Fundamentals (IZ0-051)examination. Together with the Oracle SQL Advanced course, this course is suitable for delegates intending...

...Miscellaneous Functions Conversion Functions The NVL and NVL2 Functions The DECODE Function CASE Expressions The COALESCE and NULLIF Functions SQL*Plus...

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

...and UnNamed Exceptions Generating User Defined Exceptions Nested and Labelled Block Structures Scope of Variables PL/SQL Records PL/SQL Tables of Records...

...Topics Covered: Program Blocks Variables and Constants Data Types Using SQL Statements within PL/SQL Programs Generating SQL*Plus and SQL Developer Output...

...Regular Expression Support Regular Expression Notation Character matching Repetition operators Sub expression grouping Regular expression functions Manage...

...Structures Scope of Variables PL/SQL Records PL/SQL Tables of Records Handling PL/SQL Tables Requirements: A working knowledge of Oracle's SQL*Plus...

...Profiles, Privileges and Roles Managing Undo Data and Temporary Segments Monitoring and Resolving Lock Conflicts Maintaining Database Security Monitoring...

...Modules Hide all Introduction (8 topics) Oracle product overview Oracle Support services Relational database concepts Oracle architecture Oracle 12c Multitenant... Learn about: Full Time, Network Training, Database Administration...

...This course is designed to introduce Oracle DBAs, software development personnel and database support staff to the primary features and constructs of...

...Use SQL run time parameters Use aggregate functions Use numeric, character, date, conversion and miscellaneous functions Use subqueries Create and alter tables... Learn about: Updating and deleting rows in database tables...

...Managing Data and Concurrency Maintaining Database Security Database Maintenance Managing Performance Moving Data withSQL*Loader and Data Pump Backing...

...Modules Hide all Introduction (8 topics) Oracle product overview Oracle Support services Relational database concepts Oracle architecture Oracle 12c Multitenant... Learn about: Network Training, Full Time, Database Administration...

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

...Skills Gained The delegate will practise: Planning a backup strategy and a disaster recovery strategy Altering a database to archivelog and noarchivelog...

...Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience. Topics Covered... Learn about: Using PL/SQL Index-By table built-in functions...

...Table Aliases Outer Joins Self Joins ANSI Standard Joins Set Operators Numeric, Character and Date Functions (6 topics) Function Types Using the Table... Learn about: Database Administration, Database Design, Database training...

...Architecture database and instance Server processes Memory structure (SGA, PGA) Parsing and share cursors The data files, log files, parameter files Analysis... Learn about: Database training, Information Systems...

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