Online Outer eLearning Training Certification Training

From Serebra Learning Corporation

DB2 Universal Database (UDB) Fundamentals

DB2 Universal Database (UDB) Fundamentals more...

This course continues from the Basic COBOL course and extends the student's knowledge of COBOL programming in both volume and depth. The course begins by thoroughly describing the seven major sections within the DATA DIVISION and the purpose of each. The student learns many of the more subtle ways to define and store data. All the major clauses available in a data description item are discussed more...

Oracle Database 10g New Tuning Performance-monitoring and Analysis Features

To use Oracle 10g's new tuning, performance-monitoring, and analysis features Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g more...

Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g

To demonstrate how to retrieve data from multiple tables using joins and how to use set operators in Oracle 10g databases Database administrators, application developers, and database operators more...

Manipulating Data with DB2 UDB

To execute queries using SQL Anyone wishing to gain knowledge of DB2 UDB; end users seeking competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 Family Fundamentals certification more...

From 123-CBT Computer Based Training

Oracle9i SQL Data Retrieval Techniques

This course covers joins, group functions, subqueries, and the iSQL*Plus report variables. Additionally, this course shows students how to access data from multiple table using joins, aggregate data using group functions, create subqueries, and use iSQL*Plus commands to create customized queries. Learn To: o Identify the four Oracle join types used to display data from more than one table. o more...

Oracle Database 10g SQL Fundamentals I Part 1

In this course, learners will be introduced to the concepts of relational databases and the Oracle Database 10g database technology. Additionally, the learners will be introduced to the powerful SQL programming language and its features. Learn To: Match the different phases of system development life cycle (SDLC) with their features. Identify features of an Entity Relationship (ER) more...

Oracle SQL Specifics Retrieving and Formatting Data

.... Use a join to query data from multiple tables. Use an outer join to return records without a direct match. Identify the features of the SQL*Plus environment. Log in to SQL*Plus. Use the DESCRIBE command to display the structure of a table. Match SQL*Plus editing commands to their descriptions. Match SQL*Plus file commands to their descriptions. Unit 3: Implementing Functions more...

SQL and PL SQL Data Retrieval Techniques

... multiple tables by using an equijoin, a non-equijoin, an outer join, and a self join. Write SQL statements that contain common group functions. Restrict groups of rows retrieved by using the HAVING clause and to write SQL statements that contain common group functions. Group rows retrieved by using the GROUP BY clause. Write single-row, multiple row, multiple-column subqueries. more...

Oracle Database 10g New Features for Administrators Part 2

Oracle Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers new features of Oracle Database 10g such as automatic management, manageability infrastructure, and application tuning and monitoring. Learn To: Identify features of Automatic Database Diagnostic Monitor more...

Online Outer eLearning Training

Outer Training Seminars and Classes