Oracle Courses Greater Manchester

...use subqueries, create and alter tables, indexes and views, create, update and delete records, manage sequences and synonymns and use the Data Dictionary...

...This course introduces the concepts behind these configuration options and demonstrates the practical hands-on techniques needed to manage and control these complex implementations...

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

...Statistics Gathering Dynamic Statistics Online Statistics Gathering for Bulk Loads Sorts How Oracle Processes Sorts Temporary Disk Space Assignment... Learn about: Oracle 10g...

...the PL/SQL Stored Program Units course, this course is suitable for delegates intending to sit the Oracle examination #1Z0-147: Program with PL/SQL. Course...

...Enterprise JavaBeans and Web Services. The course explores the full functionality of the, now mature IDE, JDeveloper 10g, including the use of the various development wizards...

...By the end of the course, the delegate will be able to write programs which use some or all of the primary PL/SQL programming constructs. Together...

...to Reports Create a Link to a Printer-Friendly version of a Report Save and Print Reports in Different Formats Using Files Uploading Images Creating Cascading...

...data within the Oracle environment. This course covers the main topics of the Oracle exam #1Z1-042 Oracle Database 10g: Administration I.Course content...

...in the latest release of the Oracle database. Training Course Contents: Introduction Oracle Database Innovation Enterprise Grid Computing Oracle Database...

...of a company's data within the Oracle environment. They will be able to monitor the performance of the database and perform basic backup and recovery of the database... Learn about: Creating and Managing an Oracle Database, Installing and Configuring Oracle...

...Expressions Precedence of Operators Aggregate Functions Overview of Built In Aggregate Functions The GROUP BY Clause The HAVING Clause Joining Tables Overview...

...data within the Oracle environment. Course content Oracle Database Architecture Installing and Configuring Oracle Creating and Managing an Oracle Instance...

...product to create and publish report templates. Attendees will cover administrative tasks, with hands-on coverage of features such as report templates...

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

...Large Data Sets Multi-table Inserts Conditional and Unconditional Inserts Merging Data into a Table Table and View Based Merge A Sub Query Based Merge...

...Database Resources using Resource Manager Automate Management Tasks with the Scheduler Administer the Scheduler Use Globalization...

...EXPLAIN PLAN and Autotrace Commands Reading an Execution Plan The SQL Trace and tkprof Programs Generate and Interpret an Optimizer Trace How to Influence...

...this course is suitable for delegates intending to sit the following exams: Introduction to Oracle9i: SQL Oracle Certified Professional (1Z0-007)... Learn about: Updating and deleting rows in database tables...

...User-Declared Exceptions and Application Errors WHEN OTHERS THEN NULL Nested and Labelled Blocks Propagation of Exceptions Scope of Variables and Cursors...