Database Administration Courses Midlothian/Edinburghshire

...DB2 application programs written in COBOL, PL1 or C. Course Objectives The aim of this Course is to provide the programmer, familiar with...

...This course is suitable for delegates intending to sit the following examinations: Introduction to Oracle9i: SQL Oracle Certified Professional examination (IZ0-007)...

...Date and Item Hierarchies Using Summary Folders Using the Automated Summary Management Feature (ASM) EULStatus Workbooks Introduction to Application Server...

...application based on Oracle's 10g database and Java technologies including JavaServer Pages, the Apache Struts framework and Enterprise JavaBeans...

...Enhancements Lob Data Storage Enhancements Number of Open Datasets IRLM Storage Enhancements Increased Log Datasets PARTITIONING ENHANCEMENTS Increased...

...The SELECT and FROM Clauses Conditions and the WHERE Clause Other Conditional Operators Logical Operators The ORDER BY Clause Column Aliases Arithmetic...

...At the end of this course the successful delegate will be able to create Discoverer Workbooks, view, create, modify and run ad hoc queries. Delegates...

...will gain an understanding of the architecture and processes of the Oracle database server. They will be able to ensure the integrity and availability... Learn about: Installing and Configuring Oracle, Creating and Managing an Oracle Database...

...DB2 development process together with an understanding on the DB2 design process. It is aimed at programmers who need to design, code or support DB2 application...

...Cursors Exceptions and Nested Blocks The EXCEPTION Section Types of Exception Handling Named System-Raised Exceptions Handling Un-named System-Raised Exceptions...

...knowledge of the issues involved in writing, monitoring and tuning DB2 SQL queries and applications to perform efficiently. In addition, the Course covers...

...Features Review of basic grouping concepts The ROLLUP and CUBE extensions The GROUPING SETS extension Using the GROUPING and GROUPING_ID functions Manage...

...Procedures either using the Stored Procedure Builder, WSAD or RAD. The course can also optionally include tuition of the SQL Procedural Language (SQL-PL)...

...and the Microsoft products that you can use to implement the solution. Creating Multidimensional Databases This module provides an introduction to multidimensional...

...already familiar with DB2 applications program development using COBOL or PL1, with the necessary skills required to use some of the more recent development...

...This course is suitable for anyone intending to sit the Oracle Database 11g: SQL Fundamentals (IZ0-051) examination. Together with the Oracle SQL Advanced course... Learn about: Updating and deleting rows in database tables...

...or support DB2 application programs written in Assembler. Course Objectives The aim of this Course is to provide the programmer, unfamiliar with...

...This course covers the main topics of the Oracle exam #1Z0-053 Oracle. Oracle Database 11g Release 2 DBA - Part II Course Overview This Oracle Database 11g Release 2...

...Course Objectives The aim of this Course is to provide the delegate with the necessary skills to perform simple and complex queries using DB2I / SPUFI...

...Select data from an Oracle Database using SQL*Plus and SQL Developer Create SQL statements to select data from an Oracle Database Use SQL run time parameters... Learn about: Using PL/SQL Index-By table built-in functions...