Oracle courses Scotland

...You'll study: Database Design and Implementation. Data Modelling. Intro to SQL. Professional Skills. Software Development: Relational Database Systems... Learn about: Database Design, Database training...

...to be twenty weeks based on three hours per week on-line study. The course also comprises tutorial support on an on-line basis, should participants require... Learn about: Database Design...

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

...This course is designed to introduce the new features and enhancements in Oracle11g database to existing DBA's and those familiar with previous versions...

...delegates must ensure they have the recommended experience. Topics Covered: SQL Developer Hierarchical Queries Enhanced Grouping Extensions and Functions TIMESTAMP...

...the use of SQL functions and the basic table and view handling statements are introduced. Relational Database Concepts What is an Oracle Database Relational...

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

...delegates learn how to use Oracle Data Guard to help protect their Oracle database against planned and unplanned downtimes. They also learn how Data Guard...

...IF THEN ELSIF ELSE Statements CASE Expressions Basic Loops The WHILE and FOR Loops Nested and Labelled Loops Using Cursors Parameterised Cursors Handling...

...or Associative Arrays PL/SQL Table Built-in Functions Manipulating PL/SQL Tables or Associative Arrays...

...will gain an understanding of the architecture and processes of the Oracle server. They will be able to ensure the integrity and availability of a company's...

...This course introduces students to the advanced database configuration and network controls needed to manage and configure Oracle 11g Real Application Clusters...

...They will also be able to describe and use some of the Oracle-supplied packages. Together with the PL/SQL course, this course is suitable for delegates...

...Materials Course Structure and Agenda Delegate and Trainer Introductions Retrieve Data Using Subqueries ANY, ALL or SOME Operators Correlated Subqueries...

...will gain an understanding of the architecture and processes of the Oracle server. They will be able to ensure the integrity and availability of a company's...

...1. 3. 4 version: creating reports from a variety ofsources. Integration with OBIEE and Oracle Discoverer are also covered, while also employing the...

...have the recommended experience. Topics Covered: The Structure of a Relational Database Using SQL*Plus Using SQL Developer The Basic SQL Select Statement...

...Data Related Data Dictionary Tables and Views The Structure of a PL/SQL Block Declaring and Using Variables and Constants Using SQL Statements in PL/SQL... Learn about: Using PL/SQL Index-By table built-in functions...

...Perform Tablespace Point-in-Time Recovery Create a Duplicate Database withRMAN Additional Recovery Issues Use Flashback Technology to Recover a Database...

...indexes Building ADF View Components JSP and Struts Tags Web Application Configuration: web. xml Struts Configuration Struts Components The Struts Lifecycle...