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

...This course is delivered in the evening. Oracle Database Design and SQL Programming Course Summary: This course is delivered in the evening... Learn about: Database Design...

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

...Tables and Incremental Statistics in Oracle Database 11g Hash-Based Sampling for Column Statistics Multicolumn Statistics: Overview Expression Statistics...

...Introduction to Oracle9i: SQL Oracle Certified Professional examination (1Z0-007) Oracle Database SQL Expert (IZ0-047) Anyone who needs to use the...

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

...Delegates will also be able to use aggregate functions, use numeric, character, date, conversion and miscellaneous functions, use subqueries...

...the Primary Database Datafile & Controlfile Duplication Create Standby Instance Archive Log Loss Database Switchover Monitoring the Primary & Standby Databases...

...Topics Covered: Program Blocks Variables and Constants Data Types Using SQL Statements within PL/SQL Programs Generating SQL*Plus and SQL Developer Output...

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

...The Oracle database administrator will gain practical experience in setting up, administering and troubleshooting an Oracle10g database. Database administrators...

...ASM Installation and configuration Database installation and creation Management Monitoring real application clusters Monitoring Nodes Managing Nodes Managing...

...Functions Deterministic Functions Using Stored Functions in SQL Creating and Managing Packages Implementing Package Features and Constructs Wrapping Packages...

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

...up and Recovering the Database Support Workbench, Metalink, Service Requests and Patches...

...creating reports from a variety of sources. Integration with OBIEE and Oracle Discoverer are also covered, while also employing the BI Publisher Desktop...

...By the end of this course, the delegate will be able to: Describe the basic structure of a relational database Use the command line features of SQL*Plus...

...By the end of this course, the delegate will be able to: Select data from an Oracle Database using SQL*Plus and SQL Developer Create SQL statements... Learn about: Using PL/SQL Index-By table built-in functions...

...This course introduces delegates to the main concepts of Oracle backup and recovery. They will learn how to plan and implement a backup and recovery strategy using...

...full-stack Java 2 Enterprise Edition (J2EE) applications. Delegates on this course will learn how to use the tools to develop an end-to-end MVC sample...