Oracle Courses West Midlands

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

...procedures and functions - which interact with SQL to dramatically increase the functionality of your Oracle database. Introduction to PL/SQL Relation... Learn about: SQL Database, IT Development, Database training...

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

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

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

...create, monitor and support an Oracle Database 12c database. The Oracle Database 12c Essential Administration course is also suitable for support staff... Learn about: Database Administration, Full Time, Database training...

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

...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. Course content Oracle Database Architecture Installing and Configuring Oracle Creating and Managing an Oracle Instance...

...create, monitor and support an Oracle Database 12c database. The Oracle Database 12c Essential Administration course is also suitable for support staff... Learn about: Full Time, Database training, Network Training...

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

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

...SQL Worksheet Retrieving Data with the SELECT Statement (9 topics) The SELECT Statement The SELECT and FROM Clauses Conditions and the WHERE Clause Other... Learn about: Database Administration, Database training, Database Design...

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

...ALTER, DROP) Creating tables by asking (CREATE TABLE . AS SELECT ...) CONSTRAINTS Options NULL and NOT NULL CONSTRAINT clause Condition PRIMARY KEY Condition... Learn about: Database training, Database Management, Oracle SQL...