Oracle courses Bristol

...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: Creating and Managing an Oracle Database, Installing and Configuring Oracle...

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

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

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

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

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