Oracle Courses Avon

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

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

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

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

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

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

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

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

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

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

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

...Part II course introduces the delegate to advanced administration tasks. Participants will learn how to plan and implement a backup and recovery strategy using Recovery Manager...

...Use aggregate functions Use numeric, character, date, conversion and miscellaneous functions Use subqueries Create and alter tables, indexes and views Create... Learn about: Using PL/SQL Index-By table built-in functions...