Online Rows eLearning Training
 online course |
 instructor led class |
 learn at home |
 group study |
 self directed training |
 cd based training |
 DVD video training |
 printed book |
 e-book digital book |
 workshop seminar |
 train the trainer |
 computer based learning |
 discount pricing |
 online tutorial |
From Online Training Directory
Excel 2000 Level 1
This course familiarizes students with the basic features of Microsoft Excel 2000. Selected topics include understanding formulas and functions, working with columns and rows, using absolute references, and printing worksheets.
more...
This course familiarizes students with the basic features of Microsoft Excel 2000. Selected topics include understanding formulas and functions, working with columns and rows, using absolute references, and printing worksheets.
more...
Access 97
This course introduces the database functions of Microsoft Access 97, such as working with Access menus and dialog boxes, creating and editing tables, formatting columns and rows, and planning table design. Accomplished users will work on advanced forms, use parameter and crosstab queries, and employ complex calculation expressions and selection criteria.
more...
This course introduces the database functions of Microsoft Access 97, such as working with Access menus and dialog boxes, creating and editing tables, formatting columns and rows, and planning table design. Accomplished users will work on advanced forms, use parameter and crosstab queries, and employ complex calculation expressions and selection criteria.
more...
Access 97 Level 1
Students will learn the database fundamentals of Microsoft Access 97, such as working with Access menus and dialog boxes, creating and editing tables, formatting columns and rows, and planning table design. Students will also learn about records, wizards and shortcuts, and AutoForms.
more...
Students will learn the database fundamentals of Microsoft Access 97, such as working with Access menus and dialog boxes, creating and editing tables, formatting columns and rows, and planning table design. Students will also learn about records, wizards and shortcuts, and AutoForms.
more...
From Serebra Learning Corporation
Microsoft Excel for Windows 95 Fundamentals
This multimedia self-paced learning course will show how Excel 95 can make everyday tasks simpler and less time consuming. The unique Skill Builder instruction uses text, voice, questioning, practice, quizzes and multiple study paths to create a learning environment that enhances your enjoyment and comprehension. Mastery tests at the end of each unit allow you to verify your understanding of key
more...
This multimedia self-paced learning course will show how Excel 95 can make everyday tasks simpler and less time consuming. The unique Skill Builder instruction uses text, voice, questioning, practice, quizzes and multiple study paths to create a learning environment that enhances your enjoyment and comprehension. Mastery tests at the end of each unit allow you to verify your understanding of key
more...
Microsoft Excel 2000 Fundamentals
This course provides participants with the fundamental skills to use Microsoft Excel 2000 on a daily basis in their workplace. At the completion of this course, students will learn how to create and save a new workbook; add and manipulate worksheets; enter and manipulate data in single and multiple cells; use formulas and functions; format workbooks, worksheets and cells; and change fonts and data
more...
This course provides participants with the fundamental skills to use Microsoft Excel 2000 on a daily basis in their workplace. At the completion of this course, students will learn how to create and save a new workbook; add and manipulate worksheets; enter and manipulate data in single and multiple cells; use formulas and functions; format workbooks, worksheets and cells; and change fonts and data
more...
Microsoft SQL Server 7.0: Implementing a Database - Part 3
This is the third course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0.
more...
This is the third course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0.
more...
Basic Features of Excel 2002
To provide an overview of the basic features of Excel 2002 Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel
more...
To provide an overview of the basic features of Excel 2002 Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel
more...
Microsoft Excel 2000 Basic
This highly interactive CBT contains five units that cover basic Excel skills. Through step-by-step instruction within a realistic simulation of Microsoft Excel 2000, students learn how to build, edit, and format worksheets, and how to work with charts, formulas, and functions. Performance-based Pre- and Post-Assessments create a custom course path for each learner covering only the topics not yet
more...
This highly interactive CBT contains five units that cover basic Excel skills. Through step-by-step instruction within a realistic simulation of Microsoft Excel 2000, students learn how to build, edit, and format worksheets, and how to work with charts, formulas, and functions. Performance-based Pre- and Post-Assessments create a custom course path for each learner covering only the topics not yet
more...
Microsoft Excel 97 Basic
This highly interactive CBT contains five units that cover basic Excel skills. Through step-by-step instruction within a realistic simulation of Microsoft Excel 97, students learn how to build, edit, format, and manage worksheet and charts. Performance-based Pre- and post-Assessments create a custom course path for each learner covering only the topics not yet mastered. A searchable index and
more...
This highly interactive CBT contains five units that cover basic Excel skills. Through step-by-step instruction within a realistic simulation of Microsoft Excel 97, students learn how to build, edit, format, and manage worksheet and charts. Performance-based Pre- and post-Assessments create a custom course path for each learner covering only the topics not yet mastered. A searchable index and
more...
Managing Disconnected Data
To demonstrate how to relate tables and DataSets, bind DataSets to a DataGrid, and to modify, view, and select disconnected data C# programmers and candidates for the Microsoft MCSD and MCAD certification paths
more...
To demonstrate how to relate tables and DataSets, bind DataSets to a DataGrid, and to modify, view, and select disconnected data C# programmers and candidates for the Microsoft MCSD and MCAD certification paths
more...
Advanced ADO NET Programming
To explain how to modify DataSet data, update data sources, read and write XML data sources, and interact with ADO.NET Visual Basic .NET programmers and candidates for the Microsoft MCSD and MCAD certification paths
more...
To explain how to modify DataSet data, update data sources, read and write XML data sources, and interact with ADO.NET Visual Basic .NET programmers and candidates for the Microsoft MCSD and MCAD certification paths
more...
Explicit Cursors and Exception Errors
To use the FOR UPDATE and WHERE CURRENT OF clauses to lock and modify rows, process data using records and cursors, and outline how each of the PL/SQL exception types are raised and handled Database administrators, application developers, and database operators
more...
To use the FOR UPDATE and WHERE CURRENT OF clauses to lock and modify rows, process data using records and cursors, and outline how each of the PL/SQL exception types are raised and handled Database administrators, application developers, and database operators
more...
Group and Datetime Functions in Oracle Database 10g
To demonstrate how to use group and datetime functions in Oracle 10g Database administrators, application developers, and database operators
more...
To demonstrate how to use group and datetime functions in Oracle 10g Database administrators, application developers, and database operators
more...
Microsoft Excel 2002 Training
Excel 2002 Core Training will provide the learner with the core skills necessary to efficiently use Excel 2002, Microsoft's popular spreadsheet program. It is also excellent preparation for the Microsoft Office User Specialist (MOUS) certification exam. Designed for learners who currently use or are beginning to use Microsoft Excel 2002
more...
Excel 2002 Core Training will provide the learner with the core skills necessary to efficiently use Excel 2002, Microsoft's popular spreadsheet program. It is also excellent preparation for the Microsoft Office User Specialist (MOUS) certification exam. Designed for learners who currently use or are beginning to use Microsoft Excel 2002
more...
Formatting Data in Excel 2003
To demonstrate how to format worksheets in Excel 2003 Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at core level in the use of Microsoft Excel 2003; end-users seeking basic IT certification such as ECDL, ICDL, IC3, or an equivalent
more...
To demonstrate how to format worksheets in Excel 2003 Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at core level in the use of Microsoft Excel 2003; end-users seeking basic IT certification such as ECDL, ICDL, IC3, or an equivalent
more...
Microsoft Office 2000 - Excel for Power Users
To bring proficient users of Excel 2000 to an advanced level of competence in using macros and sharing, displaying, formatting, and analyzing data End-users seeking proficiency in the use of Microsoft Excel 2000 at an advanced level; end-users seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2000 at Expert level
more...
To bring proficient users of Excel 2000 to an advanced level of competence in using macros and sharing, displaying, formatting, and analyzing data End-users seeking proficiency in the use of Microsoft Excel 2000 at an advanced level; end-users seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2000 at Expert level
more...
Microsoft Office 2000 - Intermediate Excel
To equip students with the knowledge and skills required to accomplish common Excel 2000 tasks efficiently, and to prepare students for certification as Proficient Users of Excel 2000 Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel
more...
To equip students with the knowledge and skills required to accomplish common Excel 2000 tasks efficiently, and to prepare students for certification as Proficient Users of Excel 2000 Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel
more...
ECDL ICDL 4 Module 4 Spreadsheets - Formatting Data in Excel 2003
To demonstrate how to format worksheets in Excel 2003. Note: the exercise items included with this ECDL-approved training are not ECDL certification tests. See www.ecdl.com for further details. End users wanting to attain competency in using a spreadsheet application; end users wanting to attain competency in using Microsoft Excel 2003; end users wanting to attain an ECDL or ICDL certification or
more...
To demonstrate how to format worksheets in Excel 2003. Note: the exercise items included with this ECDL-approved training are not ECDL certification tests. See www.ecdl.com for further details. End users wanting to attain competency in using a spreadsheet application; end users wanting to attain competency in using Microsoft Excel 2003; end users wanting to attain an ECDL or ICDL certification or
more...
Adobe InDesign CS2 Tables and Paths
This course covers some advanced skills for working with tables and paths in Adobe InDesign CS2. In this course, you will learn to work with tables and paths. You will be introduced to the tools used to create and edit tables and paths. In addition, you will be able to insert text and graphics in tables, add color to the table, and add text to paths. This course is intended for graphic designers,
more...
This course covers some advanced skills for working with tables and paths in Adobe InDesign CS2. In this course, you will learn to work with tables and paths. You will be introduced to the tools used to create and edit tables and paths. In addition, you will be able to insert text and graphics in tables, add color to the table, and add text to paths. This course is intended for graphic designers,
more...
Oracle 8i PL/SQL - Functions, Tables, and Groups
This course covers the concepts of single row functions that enable the manipulation of data. The course essentially focuses on three single row functions: character functions number functions and date functions. The course also covers the concept of conversion that enables the conversion of a value from one datatype to another. The concept of retrieving data from more than one table by using
more...
This course covers the concepts of single row functions that enable the manipulation of data. The course essentially focuses on three single row functions: character functions number functions and date functions. The course also covers the concept of conversion that enables the conversion of a value from one datatype to another. The concept of retrieving data from more than one table by using
more...
MS SQL Server 2000: Design and Implementation Part 1: Introduction to SQL Server
This is the first course in a five part series that presents students with both theoretical and practical instruction in the areas of an overview to SQL Server, the Transact-SQL language, and SQL Server Databases.
more...
This is the first course in a five part series that presents students with both theoretical and practical instruction in the areas of an overview to SQL Server, the Transact-SQL language, and SQL Server Databases.
more...
MS SQL Server 2000: Design and Implementation Part 4: Managing Indexes
This is the fourth course in a five part series that will teach students how to work with SQL Server indexes. Students will learn how to plan for index creation, how to create and manage indexes, as well as learn how to optimize query performance and how to analyze queries.
more...
This is the fourth course in a five part series that will teach students how to work with SQL Server indexes. Students will learn how to plan for index creation, how to create and manage indexes, as well as learn how to optimize query performance and how to analyze queries.
more...
Oracle9i SQL: Basic SELECT Statements
This course covers relational database principles and Oracle concepts; writing basic SQL statements; restricting and sorting data; and using single-row functions. Additionally, this course provides an introduction to relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database.
more...
This course covers relational database principles and Oracle concepts; writing basic SQL statements; restricting and sorting data; and using single-row functions. Additionally, this course provides an introduction to relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database.
more...
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.
more...
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.
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...
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...
Oracle SQL for End Users Part 2
This course is the second in a two-part SQL for End Users series that is based on Introduction to Oracle: SQL and PL/SQL. In this course the learner displays data from multiple tables by using equijoins non-equijoins and self joins. In addition this course introduces the use of group functions in a SQL statement to display information about groups of rows in the database. This course also covers
more...
This course is the second in a two-part SQL for End Users series that is based on Introduction to Oracle: SQL and PL/SQL. In this course the learner displays data from multiple tables by using equijoins non-equijoins and self joins. In addition this course introduces the use of group functions in a SQL statement to display information about groups of rows in the database. This course also covers
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...
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...
Oracle SQL Specifics: Retrieving and Formatting Data
This course is the first in a two-part series on Oracle SQL Specifics that will teach participants how to use commands functions and operators supported by Oracle as extensions to standard SQL. Students will be introduced to the Oracle implementation of the relational database management system (RDBMS) and the object-relational database management system (ORDBMS). Users will learn how SQL
more...
This course is the first in a two-part series on Oracle SQL Specifics that will teach participants how to use commands functions and operators supported by Oracle as extensions to standard SQL. Students will be introduced to the Oracle implementation of the relational database management system (RDBMS) and the object-relational database management system (ORDBMS). Users will learn how SQL
more...
DB2 Application Programming (COBOL) (Rel 2.3)
This course teaches students how to use embedded SQL in their applications to retrieve and update information contained in DB2.
more...
This course teaches students how to use embedded SQL in their applications to retrieve and update information contained in DB2.
more...
DB2 Application Programming (PL/1) (Rel 2.3)
This course teaches students how to use embedded SQL in their applications to retrieve and update information contained in DB2.
more...
This course teaches students how to use embedded SQL in their applications to retrieve and update information contained in DB2.
more...
DB2 Application Programming (ver 3.1)
This course teaches students how to use embedded SQL in their applications to retrieve and update information contained in DB2.
more...
This course teaches students how to use embedded SQL in their applications to retrieve and update information contained in DB2.
more...
QMF Essentials (Ver 3.1)
Teaches the creation of data base queries using three languages: SQL, Prompted Query Mode and Query by Example (QBE).
more...
Teaches the creation of data base queries using three languages: SQL, Prompted Query Mode and Query by Example (QBE).
more...
MS SQL Server 6.5: Advanced Retrieval Structures
In this course, students will learn to implement a database design on Microsoft SQL Server 6.5. Specific topics include: summarizing and modifying data; database object creation, such as stored procedures and triggers; data referential integrity; the implementation of distributed data in a client/server environment; and the extensibility of SQL Server. This course, together with MS SQL Server
more...
In this course, students will learn to implement a database design on Microsoft SQL Server 6.5. Specific topics include: summarizing and modifying data; database object creation, such as stored procedures and triggers; data referential integrity; the implementation of distributed data in a client/server environment; and the extensibility of SQL Server. This course, together with MS SQL Server
more...
Microsoft Excel 97 Training
Excel 97 Training will provide the learner with fundamental skills and advanced techniques needed for Excel 97, Microsoft's premiere spreadsheet program. It is also excellent preparation for the Microsoft Office User Specialist (MOUS) certification exam.
more...
Excel 97 Training will provide the learner with fundamental skills and advanced techniques needed for Excel 97, Microsoft's premiere spreadsheet program. It is also excellent preparation for the Microsoft Office User Specialist (MOUS) certification exam.
more...
From 123-CBT Computer Based Training
Oracle9i SQL DML and DDL
... the database objects. The participants also learn to add rows, update, and delete existing rows from a table. The course also explains the use of external tables and how to create the external tables. Learn To: o Identify the data structures in an Oracle server. o Identify the rules for naming tables in a database. o Identify the DML and transaction control statements. o Insert rows
more...
... the database objects. The participants also learn to add rows, update, and delete existing rows from a table. The course also explains the use of external tables and how to create the external tables. Learn To: o Identify the data structures in an Oracle server. o Identify the rules for naming tables in a database. o Identify the DML and transaction control statements. o Insert rows
more...
Oracle9i SQL Data Retrieval Techniques
...one table. o Identify a Cartesian product. o Retrieve rows from two tables by using an equijoin. o Identify the features of a group function. o Write SQL statements that contain common group functions. o Manage null values when using group functions in a SQL statement. o Identify the requirements for using subqueries. o Identify the characteristics of each subquery type. o Write
more...
...one table. o Identify a Cartesian product. o Retrieve rows from two tables by using an equijoin. o Identify the features of a group function. o Write SQL statements that contain common group functions. o Manage null values when using group functions in a SQL statement. o Identify the requirements for using subqueries. o Identify the characteristics of each subquery type. o Write
more...
Oracle9i SQL Basic SELECT Statements
...ic SQL SELECT statement. o Write a query that restricts rows returned by using the WHERE clause. o Write a WHERE clause to accommodate different datatypes. o Use comparison operators with the WHERE clause. o Identify the different categories of datatypes. o Match the character datatypes with their descriptions. o Identify the features of the NUMBER datatype. Audience The target
more...
...ic SQL SELECT statement. o Write a query that restricts rows returned by using the WHERE clause. o Write a WHERE clause to accommodate different datatypes. o Use comparison operators with the WHERE clause. o Identify the different categories of datatypes. o Match the character datatypes with their descriptions. o Identify the features of the NUMBER datatype. Audience The target
more...
SQL Server 2000 Querying with Transact SQL Part 1 Manipulating Data
...ify the guidelines for using the WHERE clause to retrieve rows in a table. Retrieve specific columns from a table. Identify the characteristics of aggregate functions. Identify the considerations for using the GROUP BY clause. Identify the guidelines for using the GROUP BY clause with the HAVING clause Audience Candidates for this course operate in medium to very large computing
more...
...ify the guidelines for using the WHERE clause to retrieve rows in a table. Retrieve specific columns from a table. Identify the characteristics of aggregate functions. Identify the considerations for using the GROUP BY clause. Identify the guidelines for using the GROUP BY clause with the HAVING clause Audience Candidates for this course operate in medium to very large computing
more...
IBM DB2 Universal Database V6 1--App Development
...base technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Application Development students must also have solid programming skills using C, C++, Java, or equivalent programming language. In addition, participants should have taken the first part in this series, IBM DB2 UDB V6.1 Fundamentals
more...
...base technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Application Development students must also have solid programming skills using C, C++, Java, or equivalent programming language. In addition, participants should have taken the first part in this series, IBM DB2 UDB V6.1 Fundamentals
more...
IBM DB2 Universal Database V6 1--App Development
...base technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Application Development students must also have solid programming skills using C, C++, Java, or equivalent programming language. In addition, participants should have taken the first part in this series, IBM DB2 UDB V6.1 Fundamentals
more...
...base technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Application Development students must also have solid programming skills using C, C++, Java, or equivalent programming language. In addition, participants should have taken the first part in this series, IBM DB2 UDB V6.1 Fundamentals
more...
IBM DB2 Universal Database V6 1 App Devel Curriculum
...base technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Application Development students must also have solid programming skills using C, C++, Java, or equivalent programming language. When coupled with appropriate on-the-job experience, these courses will help prepare students for the IBM
more...
...base technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Application Development students must also have solid programming skills using C, C++, Java, or equivalent programming language. When coupled with appropriate on-the-job experience, these courses will help prepare students for the IBM
more...
IBM DB2 Universal Database V6 1 App Devel Curriculum
...base technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Application Development students must also have solid programming skills using C, C++, Java, or equivalent programming language. When coupled with appropriate on-the-job experience, these courses will help prepare students for the IBM
more...
...base technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Application Development students must also have solid programming skills using C, C++, Java, or equivalent programming language. When coupled with appropriate on-the-job experience, these courses will help prepare students for the IBM
more...
IBM DB2 Universal Database V6 1--Administration
...base technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Learners must have an understanding of the general database administrator role and function. In addition, participants should have taken the first part of this series, IBM DB2 UDB V6.1 Fundamentals (course 13431). When coupled with
more...
...base technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Learners must have an understanding of the general database administrator role and function. In addition, participants should have taken the first part of this series, IBM DB2 UDB V6.1 Fundamentals (course 13431). When coupled with
more...
IBM DB2 Universal Database V6 1--Administration
...base technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Learners must have an understanding of the general database administrator role and function. In addition, participants should have taken the first part of this series, IBM DB2 UDB V6.1 Fundamentals (course 13431). When coupled with
more...
...base technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Learners must have an understanding of the general database administrator role and function. In addition, participants should have taken the first part of this series, IBM DB2 UDB V6.1 Fundamentals (course 13431). When coupled with
more...
IBM DB2 Universal Database V6 1--Fundamentals
...base technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. When coupled with appropriate on-the-job experience, this course will help prepare students for the IBM Certified Solutions Expert Certification exam 509. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1:
more...
...base technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. When coupled with appropriate on-the-job experience, this course will help prepare students for the IBM Certified Solutions Expert Certification exam 509. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1:
more...
IBM DB2 Universal Database V6 1--Fundamentals
...base technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. When coupled with appropriate on-the-job experience, this course will help prepare students for the IBM Certified Solutions Expert Certification exam 509. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1:
more...
...base technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. When coupled with appropriate on-the-job experience, this course will help prepare students for the IBM Certified Solutions Expert Certification exam 509. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1:
more...
IBM DB2 Universal Database V6 1 Admin Curriculum
...base technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Learners must have an understanding of the general database administrator role and function. When coupled with appropriate on-the-job experience, these courses will help prepare students for the IBM Certified Solutions Expert
more...
...base technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Learners must have an understanding of the general database administrator role and function. When coupled with appropriate on-the-job experience, these courses will help prepare students for the IBM Certified Solutions Expert
more...
IBM DB2 Universal Database V6 1 Admin Curriculum
...base technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Learners must have an understanding of the general database administrator role and function. When coupled with appropriate on-the-job experience, these courses will help prepare students for the IBM Certified Solutions Expert
more...
...base technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Learners must have an understanding of the general database administrator role and function. When coupled with appropriate on-the-job experience, these courses will help prepare students for the IBM Certified Solutions Expert
more...
Oracle8i Performance Tuning Optimizing Sorts Minimizing Contention
...d chaining. Query a table to detect chained and migrated rows by using the ANALYZE TABLE command. Remove the chained and migrated rows from a given table by using a four-step procedure. Reclaim the space from the high water mark by using an ALTER TABLE command. Query the results of an ANALYZE command to evaluate Oracle data block usage. Monitor the space used for an index by using the
more...
...d chaining. Query a table to detect chained and migrated rows by using the ANALYZE TABLE command. Remove the chained and migrated rows from a given table by using a four-step procedure. Reclaim the space from the high water mark by using an ALTER TABLE command. Query the results of an ANALYZE command to evaluate Oracle data block usage. Monitor the space used for an index by using the
more...
Oracle8i Database Admin Manage Data Storage
Course Overview This course is the fourth in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts associated with tables. In addition, this course will teach users about maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data. L
more...
Course Overview This course is the fourth in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts associated with tables. In addition, this course will teach users about maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data. L
more...
Oracle Form Builder R6 Controlling the User Interface Programmatically
Course Overview This course is the fifth in a six-part Oracle Developer series based on Oracle Developer Release 6. This course enables learners to create Key triggers, to write code that responds to mouse events, to manage windows and canvases, and to use the Object Navigator. In addition, learners work with multiple form applications, record groups, and list items. L earn To:
more...
Course Overview This course is the fifth in a six-part Oracle Developer series based on Oracle Developer Release 6. This course enables learners to create Key triggers, to write code that responds to mouse events, to manage windows and canvases, and to use the Object Navigator. In addition, learners work with multiple form applications, record groups, and list items. L earn To:
more...
Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention
...migration and chaining.
Query a table to display chained rows.
Remove migrated rows from a given table.
Reclaim space above the high water mark.
Query the results of a table analysis to display important information.
Use DBMS_SPACE package to display space use in segments.
Assess index structure and display the percentage of deleted entries.
Rebuild an index.
Unit 2: Optimizing Sort
more...
...migration and chaining.
Query a table to display chained rows.
Remove migrated rows from a given table.
Reclaim space above the high water mark.
Query the results of a table analysis to display important information.
Use DBMS_SPACE package to display space use in segments.
Assess index structure and display the percentage of deleted entries.
Rebuild an index.
Unit 2: Optimizing Sort
more...
Oracle8 Database Administration - Manage Data
...racle SQL Worksheet.
Obtain the physical location of the rows in a table by using Oracle SQL Worksheet.
Unit 2: Maintaining Data Integrity
Duration: 1 - 2 Hour(s)
Identify the features of integrity constraints.
Identify the functions of the various types of declarative integrity constraints.
Identify the data processing procedure for various constraint states.
Match the deferred
more...
...racle SQL Worksheet.
Obtain the physical location of the rows in a table by using Oracle SQL Worksheet.
Unit 2: Maintaining Data Integrity
Duration: 1 - 2 Hour(s)
Identify the features of integrity constraints.
Identify the functions of the various types of declarative integrity constraints.
Identify the data processing procedure for various constraint states.
Match the deferred
more...
Oracle Form Builder Handling Multiple Object Relationships
...groups. Match the built-ins used to process record group rows with their functionality. Identify the built-in functions that are used to search for record group objects. Define a query record group by using built-ins. Define a non-query record group by using built-ins. Write the code to manipulate record group rows by using built-ins. Write the code to manipulate selected record group
more...
...groups. Match the built-ins used to process record group rows with their functionality. Identify the built-in functions that are used to search for record group objects. Define a query record group by using built-ins. Define a non-query record group by using built-ins. Write the code to manipulate record group rows by using built-ins. Write the code to manipulate selected record group
more...
Frontpage 2000 Proficient User
...n image hotspot. Insert a table into a Web page. Modify rows and columns in a table. Modify table cells. Unit 3: Creating Webs Duration: 2 Hour(s) Create a Web using a template. Open an existing FrontPage 2000 Web. Add a new page to a Web. Apply a theme to Web. Modify an existing theme. Add a page transition to a Web page. Add a hit counter to a Web page. Unit 4:
more...
...n image hotspot. Insert a table into a Web page. Modify rows and columns in a table. Modify table cells. Unit 3: Creating Webs Duration: 2 Hour(s) Create a Web using a template. Open an existing FrontPage 2000 Web. Add a new page to a Web. Apply a theme to Web. Modify an existing theme. Add a page transition to a Web page. Add a hit counter to a Web page. Unit 4:
more...
Frontpage 2000 Proficient User
...n image hotspot. Insert a table into a Web page. Modify rows and columns in a table. Modify table cells. Unit 3: Creating Webs Duration: 2 Hour(s) Create a Web using a template. Open an existing FrontPage 2000 Web. Add a new page to a Web. Apply a theme to Web. Modify an existing theme. Add a page transition to a Web page. Add a hit counter to a Web page. Unit 4:
more...
...n image hotspot. Insert a table into a Web page. Modify rows and columns in a table. Modify table cells. Unit 3: Creating Webs Duration: 2 Hour(s) Create a Web using a template. Open an existing FrontPage 2000 Web. Add a new page to a Web. Apply a theme to Web. Modify an existing theme. Add a page transition to a Web page. Add a hit counter to a Web page. Unit 4:
more...
Oracle SQL Specifics Retrieving and Formatting Data
...etrieve data based on a hierarchical relationship between rows.
L earn To:
Define relational database concepts and object relational database concepts.
Use the Oracle SELECT statement.
Implement functions, including single row, conversion, and group functions.
Use SET operators.
Use subqueries.
Retrieve hierarchical data.
C ontent Emphasis
Skills-Based
A
more...
...etrieve data based on a hierarchical relationship between rows.
L earn To:
Define relational database concepts and object relational database concepts.
Use the Oracle SELECT statement.
Implement functions, including single row, conversion, and group functions.
Use SET operators.
Use subqueries.
Retrieve hierarchical data.
C ontent Emphasis
Skills-Based
A
more...
Oracle SQL Specifics Creating and Managing Database Objects
...statement and an embedded subquery to create a table from rows in another table.
Match the data dictionary views used to confirm tables and constraints with their purpose.
Identify the naming conventions to follow when naming tables and columns.
Identify the four most common datatypes used in the Oracle8 database.
Match the five Oracle8 data integrity constraints with their descriptions.
more...
...statement and an embedded subquery to create a table from rows in another table.
Match the data dictionary views used to confirm tables and constraints with their purpose.
Identify the naming conventions to follow when naming tables and columns.
Identify the four most common datatypes used in the Oracle8 database.
Match the five Oracle8 data integrity constraints with their descriptions.
more...
Oracle SQL and SQL Plus Advanced SELECT Statements
...erarchical query.
Complete a SELECT statement to display rows from a table that has a hierarchy.
Complete the statement to format a hierarchical report by using the PRIOR operator and LEVEL pseudocolumn.
Complete a statement to prune a hierarchical tree.
Unit 6: Set Operators
Duration: 1 Hour(s)
Write the compound queries by using the different set operators.
Write a compound
more...
...erarchical query.
Complete a SELECT statement to display rows from a table that has a hierarchy.
Complete the statement to format a hierarchical report by using the PRIOR operator and LEVEL pseudocolumn.
Complete a statement to prune a hierarchical tree.
Unit 6: Set Operators
Duration: 1 Hour(s)
Write the compound queries by using the different set operators.
Write a compound
more...
Word 2000 Proficient User
... table. Resize a table. Merge cells in a table. Modify rows and columns in a table. Change cell formats. Rotate the text in a table. Create a newspaper column. Modify columns. Balance the column length to lay out the text in a newspaper style. Unit 2: Enhancing a Presentation Visually Duration: 2 - 3 Hour(s) Match the buttons of the Drawing toolbar with their functions.
more...
... table. Resize a table. Merge cells in a table. Modify rows and columns in a table. Change cell formats. Rotate the text in a table. Create a newspaper column. Modify columns. Balance the column length to lay out the text in a newspaper style. Unit 2: Enhancing a Presentation Visually Duration: 2 - 3 Hour(s) Match the buttons of the Drawing toolbar with their functions.
more...
Excel 2000 Fundamentals
...heet. Replace a text string with another string. Select rows and columns in a worksheet. Select a specified range of cells in a worksheet. Copy a range of cells from a specified location to another. Move a cell range from a specified location to another. Modify the layout of a page prior to printing. Add marginal data to customize a worksheet before printing. Modify the placement of
more...
...heet. Replace a text string with another string. Select rows and columns in a worksheet. Select a specified range of cells in a worksheet. Copy a range of cells from a specified location to another. Move a cell range from a specified location to another. Modify the layout of a page prior to printing. Add marginal data to customize a worksheet before printing. Modify the placement of
more...
Excel 2000 Expert User
Course Overview This course provides participants the knowledge to use the advanced features of Microsoft Excel 2000. At the completion of this course, students will learn how to create and use templates; retrieve, sort and manipulate data from a list; create and modify shared workbooks; and analyze data by using Data Map, Pivot Table, Data Table Scenario and Data Analysis tools. L earn To:
more...
Course Overview This course provides participants the knowledge to use the advanced features of Microsoft Excel 2000. At the completion of this course, students will learn how to create and use templates; retrieve, sort and manipulate data from a list; create and modify shared workbooks; and analyze data by using Data Map, Pivot Table, Data Table Scenario and Data Analysis tools. L earn To:
more...
SQL Server 7 0 - Implementing a Database - Part 3
...ISTS and NOT EXISTS subqueries. Perform the steps to add rows to a table. Perform the steps to delete rows from a table. Perform the steps to remove rows based on other tables. Perform the steps to update rows. Select the benefits of cursors. Select the methods for requesting a cursor. Select the uses of Transact-SQL cursors. Sequence the steps of the Transact-SQL cursor procedure.
more...
...ISTS and NOT EXISTS subqueries. Perform the steps to add rows to a table. Perform the steps to delete rows from a table. Perform the steps to remove rows based on other tables. Perform the steps to update rows. Select the benefits of cursors. Select the methods for requesting a cursor. Select the uses of Transact-SQL cursors. Sequence the steps of the Transact-SQL cursor procedure.
more...
SQL and PL SQL PL SQL Basics
Course Overview This course introduces the learner to the basics of PL/SQL. The course builds the necessary skills for using Oracle PL/SQL. It will help the learner acquire the expertise to design, develop, and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming.
more...
Course Overview This course introduces the learner to the basics of PL/SQL. The course builds the necessary skills for using Oracle PL/SQL. It will help the learner acquire the expertise to design, develop, and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming.
more...
SQL and PL SQL Basic SELECT
... SQL*Plus environment, features, and commands. Restrict rows retrieved by a query. Identify comparison operators that can be used in defining row retrieval restrictions. Identify logical operators that can be used to define row retrieval restrictions. Sort rows retrieved by a query. Describe the types of SQL funcitons, in order to define single-row functions. Demonstrate the use of
more...
... SQL*Plus environment, features, and commands. Restrict rows retrieved by a query. Identify comparison operators that can be used in defining row retrieval restrictions. Identify logical operators that can be used to define row retrieval restrictions. Sort rows retrieved by a query. Describe the types of SQL funcitons, in order to define single-row functions. Demonstrate the use of
more...
SQL and PL SQL Data Retrieval Techniques
...y the user will be covered. L earn To: Retrieve rows from 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.
more...
...y the user will be covered. L earn To: Retrieve rows from 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.
more...
SQL and PL SQL DML and DDL
...efine a unique constraint for a column to ensure that two rows do not contain the same value. Define a PRIMARY KEY constraint using the CREATE TABLE statement. Create a referential integrity constraint for a foreign key column. Define a check constraint to ensure that appropriate values are stored in the table. Create a table within the SQL*Plus environment. Create a table using the rows
more...
...efine a unique constraint for a column to ensure that two rows do not contain the same value. Define a PRIMARY KEY constraint using the CREATE TABLE statement. Create a referential integrity constraint for a foreign key column. Define a check constraint to ensure that appropriate values are stored in the table. Create a table within the SQL*Plus environment. Create a table using the rows
more...
IBM DB2 Universal Database V6 1--Fundamentals
...base technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. When coupled with appropriate on-the-job experience, this course will help prepare students for the IBM Certified Solutions Expert Certification exam 509. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1:
more...
...base technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. When coupled with appropriate on-the-job experience, this course will help prepare students for the IBM Certified Solutions Expert Certification exam 509. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1:
more...
IBM DB2 Universal Database V6 1--Fundamentals
...base technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. When coupled with appropriate on-the-job experience, this course will help prepare students for the IBM Certified Solutions Expert Certification exam 509. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1:
more...
...base technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. When coupled with appropriate on-the-job experience, this course will help prepare students for the IBM Certified Solutions Expert Certification exam 509. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1:
more...
Oracle SQL for End Users--Part 1
...ions. Write a SELECT statement that displays columns and rows from a table. Write a SQL statement that includes an arithmetic expression. Assign an alias to a column heading when retrieving data from a table. Concatenate multiple columns that are selected from a table. Embed a literal character string in a SELECT clause to customize the output displayed. Eliminate duplicate rows from the
more...
...ions. Write a SELECT statement that displays columns and rows from a table. Write a SQL statement that includes an arithmetic expression. Assign an alias to a column heading when retrieving data from a table. Concatenate multiple columns that are selected from a table. Embed a literal character string in a SELECT clause to customize the output displayed. Eliminate duplicate rows from the
more...
Oracle SQL for End Users--Part 2
...in a SQL statement to display information about groups of rows in the database. This course also covers how to embed subqueries in SQL statements. Finally, the learner creates interactive reports by using substitution variables, and executes a formatted report by using SQL*Plus commands. L earn To: Access data from more than one table by using equijoins and nonequijoins and join a
more...
...in a SQL statement to display information about groups of rows in the database. This course also covers how to embed subqueries in SQL statements. Finally, the learner creates interactive reports by using substitution variables, and executes a formatted report by using SQL*Plus commands. L earn To: Access data from more than one table by using equijoins and nonequijoins and join a
more...
Excel XP Expert User
...lumns. • Sort a column in a list by using multiple rows. • Create a custom sort order. • Apply a custom filter to a list. • Summarize data in a list by using subtotals. Unit 2: Workbook Capabilities 2 - 3 hours • Create a shared workbook. • Highlight changes in a shared workbook. • Accept a change in a shared workbook. • Merge
more...
...lumns. • Sort a column in a list by using multiple rows. • Create a custom sort order. • Apply a custom filter to a list. • Summarize data in a list by using subtotals. Unit 2: Workbook Capabilities 2 - 3 hours • Create a shared workbook. • Highlight changes in a shared workbook. • Accept a change in a shared workbook. • Merge
more...
Frontpage XP Proficient User
...t a table onto a Web page. • Add table columns and rows. Unit 3: Creating Web Sites 2 hours • Identify features of a Web site wizard. • Create a Web site by using a template. • Preview a Web site. • Publish a Web site. • Add a new page to a Web site. • Apply a theme to a Web site. • Modify a theme in a Web site. • Add a hit
more...
...t a table onto a Web page. • Add table columns and rows. Unit 3: Creating Web Sites 2 hours • Identify features of a Web site wizard. • Create a Web site by using a template. • Preview a Web site. • Publish a Web site. • Add a new page to a Web site. • Apply a theme to a Web site. • Modify a theme in a Web site. • Add a hit
more...
Word XP Proficient User
...a table. • Merge cells in a table. • Modify rows and columns in a table. • Modify properties of a table. • Sort data in a table. • Calculate a formula in a table. • Create columns in a document before entering text. • Apply a column format to text in a document. • Modify columns in a document. • Insert hyperlinks into a document.
more...
...a table. • Merge cells in a table. • Modify rows and columns in a table. • Modify properties of a table. • Sort data in a table. • Calculate a formula in a table. • Create columns in a document before entering text. • Apply a column format to text in a document. • Modify columns in a document. • Insert hyperlinks into a document.
more...
CIW Database Specialist Part 4 Advanced JDBC
This is the final course in a four part series that teaches metadata, improving JDBC programs, and building applications using JDBC. Topics covered include introduction to metadata and to ResultSetMetaData, SQL exceptions, scrollable and updateable result sets, batch updates, and prepared statements. Finally, the Building Applications Using JDBC teaches about Swing, the Layout Manager, UML and
more...
This is the final course in a four part series that teaches metadata, improving JDBC programs, and building applications using JDBC. Topics covered include introduction to metadata and to ResultSetMetaData, SQL exceptions, scrollable and updateable result sets, batch updates, and prepared statements. Finally, the Building Applications Using JDBC teaches about Swing, the Layout Manager, UML and
more...
SAP R 3 CO Cost Center Acct Settings for Periodical Processing
The Computer Based Training course (CBT) SAP R/3 CO: Cost Center Accounting Settings for Periodical Processing is used to determine where costs occur within an organization and to assign costs to cost centers. You will learn the fundamentals focus on the customizing features as initial setups, how to post within Cost Centers, allocations and reports that are used in R/3 for internal accounting
more...
The Computer Based Training course (CBT) SAP R/3 CO: Cost Center Accounting Settings for Periodical Processing is used to determine where costs occur within an organization and to assign costs to cost centers. You will learn the fundamentals focus on the customizing features as initial setups, how to post within Cost Centers, allocations and reports that are used in R/3 for internal accounting
more...
From The Virtual Training Company
Microsoft Excel 2000
With Microsoft Excel 2000, you can take advantage of comprehensive tools to create spreadsheets and share them on the Web for universal viewing and collaboration. Excel allows you to easily analyze data with charts, Microsoft PivotTable, and graphs. You can even use automatic formatting to create data-rich spreadsheets. In this tutorial, you are guided from basic thorough advanced techniques by
more...
With Microsoft Excel 2000, you can take advantage of comprehensive tools to create spreadsheets and share them on the Web for universal viewing and collaboration. Excel allows you to easily analyze data with charts, Microsoft PivotTable, and graphs. You can even use automatic formatting to create data-rich spreadsheets. In this tutorial, you are guided from basic thorough advanced techniques by
more...
From Teach Me IT
SQL Basic Skills
The SQL Basic Skills WBT is the first course in the SQL Programming curriculum that consists of two courses. This course acquaints students with SQL and discusses the techniques used for normalizing a database. It also describes various commands and clauses used to query and manipulate a database. After completing this course, the student will be able to:
Define a relational database
List the
more...
The SQL Basic Skills WBT is the first course in the SQL Programming curriculum that consists of two courses. This course acquaints students with SQL and discusses the techniques used for normalizing a database. It also describes various commands and clauses used to query and manipulate a database. After completing this course, the student will be able to:
Define a relational database
List the
more...
Getting Started with Excel 2000
The Getting started with Excel 2000 WBT is the first course in the Excel 2000 curriculum. It familiarizes the students with the fundamentals of Excel 2000. This course teaches the students how to create and manage workbooks and enter data, and insert and create graphics in an Excel workbook. After completing this course, the students will be able to:
List the new features in Excel 2000
more...
The Getting started with Excel 2000 WBT is the first course in the Excel 2000 curriculum. It familiarizes the students with the fundamentals of Excel 2000. This course teaches the students how to create and manage workbooks and enter data, and insert and create graphics in an Excel workbook. After completing this course, the students will be able to:
List the new features in Excel 2000
more...
online course |
instructor led class |
learn at home |
group study |
self directed training |
cd based training |
DVD video training |
printed book |
e-book digital book |
workshop seminar |
train the trainer |
computer based learning |
discount pricing |
online tutorial |
