Online Constraint eLearning
Constraint Training Provider? - Tell us about your Training!
From 123-CBT Computer Based Training
Excel 2002 Advanced

Excel 2002: Advanced Microsoft
Lesson 1: Sorting & Filtering Data Introduction Lesson Objectives Opening Excel Importing Data From A Web Page The New Web Query Dialog Box Selecting A Table Navigating Pages Web Query Options Saving A Web Query Placing Data The External Data Toolbar Editing A Query Data Range Properties Refreshing Data Running A Saved Query Full Screen View
more...
Excel 2002 Advanced
Oracle SQL Specifics Creating and Managing Database Objects

...ll learn how to create and manage tables, build integrity constraints, and use the COMMIT and ROLLBACK statements to control transactions. Learners will create and maintain views, sequences, indexes and synonyms. Additionally, users will learn how to control database access, add new users, and provide alternative names for objects using synonyms. Finally, participants will learn how to format
more...
Oracle Form Builder Including Reusable Oracle Components

Course Overview
This course is the sixth in a six-part Oracle Form Builder Series that is based on Oracle Developer/2000 Release 2. This course will help participants learn how to implement methods to use data sources, and to integrate charts, reports and timers in Forms. In addition, reusing components, objects and code will be taught. Finally, Form Builder's new features will be covered.
more...
SQL Server 7 0 - Implementing a Database - Part 2

...ta integrity. Match each type of data integrity with its constraint method. Identify the characteristics of the constraints. Select the considerations for using constraints. Perform the steps to enforce domain integrity. Perform the steps to enforce entity integrity. Select the guidelines for disabling complaints. Perform the steps to disable constraint checking. Perform the steps to
more...
SQL and PL SQL DML and DDL

...atabase. L earn To: Create tables and integrity constraints. Manipulate data using DML. Alter tables and constraints. Create sequences. Create views. Create indexes. Manage system privileges. C ontent Emphasis Skills-Based A udience Application Developers, Database Administrators, Designer/Developers, System Analysts, and Technical Support Professionals.
more...
Oracle8i Database Admin Manage Data Storage

... Identify the characteristics and types of triggers and constraints. Identify and maintain data integrity. Identify clusters and index-organized tables (IOTs). Identify and reorganize data. C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, Technical Support Professionals. Participants should have taken Oracle
more...
IBM DB2 Universal Database V6 1--Fundamentals

...fic characteristics. Identify the effects of table check constraints given a CREATE table statement. Identify characteristics of a trigger. Analyze data modification instructions to determine whether DB2 applies referential constraints given referential constraint definitions. Unit 3: Basic Structured Query Language Usage Duration: 2 Hour(s) Display data using a SELECT statement.
more...
IBM DB2 Universal Database V6 1--Fundamentals

...fic characteristics. Identify the effects of table check constraints given a CREATE table statement. Identify characteristics of a trigger. Analyze data modification instructions to determine whether DB2 applies referential constraints given referential constraint definitions. Unit 3: Basic Structured Query Language Usage Duration: 2 Hour(s) Display data using a SELECT statement.
more...
Oracle9i SQL DML and DDL

... 8 hours 61132 Objectives Unit 1: Creating Tables and Constraints 0.5 - 1 hour o Identify the data structures in an Oracle server. o Identify the rules for naming tables in a database. o Sequence the steps to create a table. o Identify the rules for referencing a table in another user's schema. o Match the Oracle datatypes with their definitions. o Identify the properties of
more...
Oracle9i Database Admin Manage Data Storage

...iggers. Identify the guidelines for implementing constraints and create the two types of constraints. Disable, enable and drop constraints and triggers in the validate and the novalidate mode, and identify the steps for using the EXCEPTIONS table. Retrieve constraint, constraint columns, PK-FK relationship information and trigger information by using Oracle SQL*Plus
more...
SAP Advanced Planner Optimizer APO Overview

This course introduces the learner to the basic concepts of Supply Chain Management, as well as the functions and advantages of SAP APO. This course also covers the components of SAP APO and their functions. Learn To: o Supply Chain Management and SAP APO. o Supply Chain Management (SCM). o Advanced Planner and Optimizer (APO). o APO Integration and Technology. o APO Planning
more...
Advanced Project Mgmt Building Productive Stakeholder Relationships

...tify questions for determining stakeholders a a major constraint and risk tolerance. Identify the steps for developing a formal communication plan. Identify the stages of conflict resolution. Identify questions you can ask to determine how stakeholders define quality. Identify the
more...
Managing IT Projects Project Control Closure

... in the change management plan while balancing the triple constraint of time, cost, and quality. Unit 2: Quality, Risk, and Performance (1 - 1.5 hours) Identify features of quality management. Identify guidelines for managing risk. Identify techniques used for planning, monitoring, and controlling risk.
more...
Oracle8 Database Administration - Manage Data

...
Identify the characteristics and types of triggers and constraints.
Implement and maintain data integrity.
Retrieve information from the data dictionary.
Implement clusters and index-organized tables (IOTs).
Load and reorganize data in tables.
C ontent Emphasis
Skills-Based
A udience
Database Administrators, system administrators, network
more...
IBM DB2 Universal Database V6 1--Fundamentals

Course Overview This course will provide both database administrators and application developers with the broad foundation skills and knowledge needed to be successful with IBM DB2 Universal Database (UDB) V6.1 in a UNIX, Windows, or OS/2 environment. This course will teach students the basic concepts of DB2 UDB V6.1, creating and accessing database objects, basic Structured Query Language
more...
IBM DB2 Universal Database V6 1--Fundamentals

...fic characteristics. Identify the effects of table check constraints given a CREATE table statement. Identify characteristics of a trigger. Analyze data modification instructions to determine whether DB2 applies referential constraints given referential constraint definitions. Unit 3: Basic Structured Query Language Usage Duration: 2 Hour(s) Display data using a SELECT statement.
more...
IBM DB2 Universal Database V6 1--Administration

...ation strategies. Construct a referential integrity (RI) constraint for a table using the ALTER TABLE statement. Construct a view on a table using the CREATE VIEW statement. Construct a schema using the CREATE SCHEMA statement. Change communications parameters using the UPDATE DATABASE MANAGER CONFIGURATION command. Unit 2: Maintenance of an Existing Database Duration: 3 - 4 Hour(s)
more...
IBM DB2 Universal Database V6 1--Administration

...ation strategies. Construct a referential integrity (RI) constraint for a table using the ALTER TABLE statement. Construct a view on a table using the CREATE VIEW statement. Construct a schema using the CREATE SCHEMA statement. Change communications parameters using the UPDATE DATABASE MANAGER CONFIGURATION command. Unit 2: Maintenance of an Existing Database Duration: 3 - 4 Hour(s)
more...
Managing IT Projects Project Fundamentals Initiation

...t management. Identify the triple constraints. Identify guidelines for determining the project environment. Identify guidelines for implementing the typical phases of a project life cycle. Identify the project context. Simulation Overview: In the simulation at the end of this
more...
From Serebra Learning Corporation
Defining and Manipulating Data in Oracle 9i
To describe how to define database objects and manipulate the data stored within them in an Oracle9i database Junior database administrators, application developers, and database operators
more...
PL SQL Triggers
To create and manage triggers Database administrators, application developers, and database operators
more...
Advanced Project Management Building Productive Stakeholder Relationships
Advanced Project Management: Building Productive Stakeholder Relationships teaches learners how to classify stakeholders as primary, strategic, and operational sponsors and how to determine stakeholders needs and expectations. It covers how to create a formal communication plan, how to resolve conflict with stakeholders, and what steps are commonly used to control change. Finally, it teaches
more...
MS SQL Server 2000: Design and Implementation Part 2: Managing Data


This is the second course in a five part series that will teach students how to work with SQL Server data.
more...
Oracle9i SQL: DML and DDL


The Oracle SQL DML and DDL course is the third in a three-part series covering the Data Manipulation and Data Definition language statements supported by Oracle9i. This course introduces the participants to various objects in a database. The participants learn to create, update, and delete the database objects. The participants also learn to add rows, update, and delete existing rows from a table.
more...
Oracle9i Database Administration: Manage Data Storage


This course is the fourth in the series covering the database administration strategies and procedures provided in Oracle9. This course covers the concepts associated with tables, maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data.
more...
From Technology Ed
Design of Experiments DOE

Design of experiments (DOE) is a systematic, rigorous approach to engineering problem-solving that applies principles and techniques at the data collection stage so as to ensure the generation of valid, defensible, and supportable engineering conclusions. In addition, all of this is carried out under the constraint of a minimal expenditure of engineering runs, time, and money.
Design of
more...
