Oracle Courses Midlothian/Edinburghshire

...Java developers will learn how to customise such an application using hand-written code. The course also includes an analysis of the advantages and disadvantages...

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

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

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

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

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

...Oracle Database SQL Expert (IZ0-047) Oracle Database 11g: SQL Fundamentals (IZ0-051) Delegates: This course is designed for anyone who needs to access...

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

...and configuring all the commonly used products that make up 10gAS. 10gAS is based on Oracle 9iAS Release 2 (9. 0. 2 onwards) which built on the functionality...

...and Discoverer Starting and Stopping Discoverer Services Managing Discoverer Connections Monitoring Discoverer Discoverer and Oracle Web Cache Managing...

...major topics required for the following Oracle examinations: Introduction to Oracle9i: SQL Oracle Certified Professional examination (1Z0-007)...

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

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

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

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

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

...the configuration of a physical standby database, and role transitions. Training Course Contents: Oracle Data Guard Introduction Requirements for Maintaining...

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

...program units and packages. Objectives: By the end of this course, the delegate will be able to write and manage stored program units, implement package constructs and features...

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