Online Column 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 Serebra Learning Corporation
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 1
This is the first 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 first 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...
Microsoft Office 2000 - Beginning Excel
To provide an introduction to the core concepts of Microsoft Excel 2000 Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel
more...
To provide an introduction to the core concepts of Microsoft Excel 2000 Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel
more...
Transferring Files Settings to Your Microsoft Windows Vista PC
The Transferring Files and Settings to Your New Microsoft Windows Vista PC course provides an overview of transferring files and settings to a new Windows Vista computer. In this course, the learner will understand the requirements for transferring files and settings. The course covers the Windows Easy Transfer wizard to transfer files and settings over a network or using a removable media.
more...
The Transferring Files and Settings to Your New Microsoft Windows Vista PC course provides an overview of transferring files and settings to a new Windows Vista computer. In this course, the learner will understand the requirements for transferring files and settings. The course covers the Windows Easy Transfer wizard to transfer files and settings over a network or using a removable media.
more...
Accounting Systems and Closing Activities
Some businesses carry out hundreds of transactions in a single day. You can imagine the accounting data at the end of the day, or the end of the month. Ultimately, these transactions can be categorized into a few different types. Organizing the transactions through special journals actually reduces the work and allows you to be more efficient in your accounting activities at the end of every
more...
Some businesses carry out hundreds of transactions in a single day. You can imagine the accounting data at the end of the day, or the end of the month. Ultimately, these transactions can be categorized into a few different types. Organizing the transactions through special journals actually reduces the work and allows you to be more efficient in your accounting activities at the end of every
more...
Accounting for Cash Control
Businesses operate on cash and strive to earn it. Cash can be defined as dollars and coins, checks, vouchers, and money orders. Accounting procedures are established to ensure that cash receipts and cash disbursements are protected. This course explores the accounting methods for internal control of cash such as petty cash, bank reconciliation, and payroll. Understanding the processing, recording,
more...
Businesses operate on cash and strive to earn it. Cash can be defined as dollars and coins, checks, vouchers, and money orders. Accounting procedures are established to ensure that cash receipts and cash disbursements are protected. This course explores the accounting methods for internal control of cash such as petty cash, bank reconciliation, and payroll. Understanding the processing, recording,
more...
Programming with XHTML 1 1 Advanced Tags
...d their attributes to create and format tables and define column groups. The course also explains the tags used to create static forms and frames. In addition, the course covers creating menus, specifying special characters, and setting colors for a Web page. Finally, the course describes the key concepts related to internationalization. The intended audience for this course includes Technical
more...
...d their attributes to create and format tables and define column groups. The course also explains the tags used to create static forms and frames. In addition, the course covers creating menus, specifying special characters, and setting colors for a Web page. Finally, the course describes the key concepts related to internationalization. The intended audience for this course includes Technical
more...
Oracle Database 10g New Data Loading Features
To discuss new data loading features in Oracle 10g 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...
To discuss new data loading features in Oracle 10g 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...
Oracle Database 10g New Features in Security and Software Maintenance
To use the new security and software upgrade features in Oracle 10g 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...
To use the new security and software upgrade features in Oracle 10g 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...
Subqueries and Hierarchical Queries in Oracle Database 10g
To demonstrate how to use subqueries and hierarchical queries in Oracle 10g Database administrators, application developers, and database operators
more...
To demonstrate how to use subqueries and hierarchical queries in Oracle 10g Database administrators, application developers, and database operators
more...
Advanced Data Management in Excel 2002
To provide an overview of the advanced data management and organization features in Excel 2002 End-users seeking proficiency in the use of Microsoft Excel 2002 at an advanced level; end-users seeking to obtain Microsoft Office User Specialist (MOUS) certification in Microsoft Excel 2002 at Expert level
more...
To provide an overview of the advanced data management and organization features in Excel 2002 End-users seeking proficiency in the use of Microsoft Excel 2002 at an advanced level; end-users seeking to obtain Microsoft Office User Specialist (MOUS) certification in Microsoft Excel 2002 at Expert level
more...
Structuring Editing Saving and Opening Documents in Word 2007
...e use of page and section breaks, spacing adjustment, and column insertion, and explores the basic editing tools packaged with Word 2007. A new feature of Word 2007 demonstrated in the course is the ability to save a document in PDF or XPS format, in addition to being able to save as a web page. The course also explains how to save documents so that they can be viewed in previous versions of
more...
...e use of page and section breaks, spacing adjustment, and column insertion, and explores the basic editing tools packaged with Word 2007. A new feature of Word 2007 demonstrated in the course is the ability to save a document in PDF or XPS format, in addition to being able to save as a web page. The course also explains how to save documents so that they can be viewed in previous versions of
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...
Microsoft Office 2000 - Intermediate Project 2000
To explain and demonstrate how to customize projects and handle multiproject environments using Microsoft Outlook and Project Central Business managers, planners, and team members who want to track and manage project tasks, costs, and resources; candidates for Microsoft Office Specialist certification; anyone wishing to gain a basic understanding of Project 2000; end users seeking competence in
more...
To explain and demonstrate how to customize projects and handle multiproject environments using Microsoft Outlook and Project Central Business managers, planners, and team members who want to track and manage project tasks, costs, and resources; candidates for Microsoft Office Specialist certification; anyone wishing to gain a basic understanding of Project 2000; end users seeking competence in
more...
Microsoft Word 97 Advanced
This highly interactive CBT contains six units that cover advanced Word skills. Through step-by-step instruction within a realistic simulation of Microsoft Word 97, students learn how to work with larger documents and collaborate with others working on the same document, arrange text and text objects, create and modify charts and forms, and customize the Word environment. Performance-based Pre-
more...
This highly interactive CBT contains six units that cover advanced Word skills. Through step-by-step instruction within a realistic simulation of Microsoft Word 97, students learn how to work with larger documents and collaborate with others working on the same document, arrange text and text objects, create and modify charts and forms, and customize the Word environment. Performance-based Pre-
more...
Microsoft Access 97 Advanced
This highly interactive CBT contains three units that cover advanced Access 97 skills. Through step-by-step instruction within a realistic simulation of Microsoft Access, individuals learn how to add complex objects to a form, manage database objects, create macros and modules and maintain a database. Performance-based Pre- and Post-Assessments create a custom course path for each learner covering
more...
This highly interactive CBT contains three units that cover advanced Access 97 skills. Through step-by-step instruction within a realistic simulation of Microsoft Access, individuals learn how to add complex objects to a form, manage database objects, create macros and modules and maintain a database. Performance-based Pre- and Post-Assessments create a custom course path for each learner covering
more...
Oracle Applications 11i: General Ledger: Reporting and Analysis
This course covers the procedures for submitting report requests. It also covers tools such as Report Wizard and FSG components that are used for creating financial reports, and tools for integrating Oracle Business Intelligence Systems (OBIS) with OGL.
more...
This course covers the procedures for submitting report requests. It also covers tools such as Report Wizard and FSG components that are used for creating financial reports, and tools for integrating Oracle Business Intelligence Systems (OBIS) with OGL.
more...
IBM DB2 UDB Essentials Part 3 - SQL Fundamentals
This course introduces the learner to the fundamental elements of the SQL language. Simple query running is covered before moving on to more complex procedures such as retrieving data from multiple tables and creating single reports from multiple queries. Scalar and column functions are covered. Coverage is also given to running subqueries and maintaining data. On completion of the course the
more...
This course introduces the learner to the fundamental elements of the SQL language. Simple query running is covered before moving on to more complex procedures such as retrieving data from multiple tables and creating single reports from multiple queries. Scalar and column functions are covered. Coverage is also given to running subqueries and maintaining data. On completion of the course the
more...
MS Excel 2003 Proficient User
This course maps to the Microsoft Office Specialist certification objectives for the Excel 2003 Expert exams. Learners completing these courses should be well prepared for the certification exams, and have a solid foundation in basic Excel skills.
more...
This course maps to the Microsoft Office Specialist certification objectives for the Excel 2003 Expert exams. Learners completing these courses should be well prepared for the certification exams, and have a solid foundation in basic Excel skills.
more...
Microsoft Word 2002 Proficient User
This course covers more advanced skills of working with documents in Word 2002. Learners will deal with document enhancement, table management, and column management. This course also covers visual enhancements including WordArt, graphics, and diagrams. Lastly, learners will cover mail merge and workgroup collaboration.
more...
This course covers more advanced skills of working with documents in Word 2002. Learners will deal with document enhancement, table management, and column management. This course also covers visual enhancements including WordArt, graphics, and diagrams. Lastly, learners will cover mail merge and workgroup collaboration.
more...
Microsoft Excel 2002 Fundamentals
This course presents learners with the fundamental elements of Excel 2002. The course covers the Excel interface and navigation, how to create and format worksheets. Topics such as creating formulas, copying, inserting and deleting a range of cells are covered in the course.
more...
This course presents learners with the fundamental elements of Excel 2002. The course covers the Excel interface and navigation, how to create and format worksheets. Topics such as creating formulas, copying, inserting and deleting a range of cells are covered in the course.
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...
MS Office 2000: Word for Professionals II
In this course, the student will learn how to create and modify newspaper column structures in MS Word 2000. This course also teaches the student how to prepare and print envelopes and labels.
more...
In this course, the student will learn how to create and modify newspaper column structures in MS Word 2000. This course also teaches the student how to prepare and print envelopes and labels.
more...
Microsoft Word 2002 Proficient User
This course covers more advanced skills of working with documents in Word 2002. Learners will deal with document enhancement table management and column management. This course also covers visual enhancements including WordArt graphics and diagrams. Lastly learners will cover mail merge and workgroup collaboration.
more...
This course covers more advanced skills of working with documents in Word 2002. Learners will deal with document enhancement table management and column management. This course also covers visual enhancements including WordArt graphics and diagrams. Lastly learners will cover mail merge and workgroup collaboration.
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...
SQL Queries
Describes SQL querying from simple one column, one table queries to advanced joining and merging of data from multiple tables.
more...
Describes SQL querying from simple one column, one table queries to advanced joining and merging of data from multiple tables.
more...
From 123-CBT Computer Based Training
Oracle9i Peformance Tuning Managing Memory and Disk I O
This course introduces students to the importance of good initial database design, and the methods used to tune an Oracle9i production database. Students learn how to use the available Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database. Learn To: o Match the optimizer modes with their descriptions. o Match the
more...
This course introduces students to the importance of good initial database design, and the methods used to tune an Oracle9i production database. Students learn how to use the available Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database. Learn To: o Match the optimizer modes with their descriptions. o Match the
more...
Oracle9i SQL DML and DDL
... rows in a table by using the INSERT statement. o Add a column to a table in an Oracle database. o Change the table structure by modifying the characteristics of an existing column. o Identify the features of an Oracle sequence. o Create a sequence by using the CREATE SEQUENCE statement. o Identify the properties of views. o Match the clauses of the CREATE VIEW statement with their
more...
... rows in a table by using the INSERT statement. o Add a column to a table in an Oracle database. o Change the table structure by modifying the characteristics of an existing column. o Identify the features of an Oracle sequence. o Create a sequence by using the CREATE SEQUENCE statement. o Identify the properties of views. o Match the clauses of the CREATE VIEW statement with their
more...
IBM DB2 Universal Database V6 1--App Development
...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...
...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
...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...
...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--Fundamentals
...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: Introduction to
more...
...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: Introduction to
more...
IBM DB2 Universal Database V6 1--Fundamentals
...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: Introduction to
more...
...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: Introduction to
more...
Oracle8i Performance Tuning Managing Memory Disk I O
...alls that find a cursor to share by using the GETHITRATIO column of the V$LIBRARYCACHE view. Determine the reloads-to-pins ratio by using the V$LIBRARYCACHE view. Compute the amount of sharable memory that has been used by using the V$SQLAREA view. Keep a large object in memory by using the KEEP procedure of the DBMS_SHARED_POOL package. View the reserved pool space within the shared pool
more...
...alls that find a cursor to share by using the GETHITRATIO column of the V$LIBRARYCACHE view. Determine the reloads-to-pins ratio by using the V$LIBRARYCACHE view. Compute the amount of sharable memory that has been used by using the V$SQLAREA view. Keep a large object in memory by using the KEEP procedure of the DBMS_SHARED_POOL package. View the reserved pool space within the shared pool
more...
Oracle Reports R6 Enhance Reports
...eport by creating queries. Enhance a report by creating columns. Identify the sections of the Layout Model. Identify the components in the Data Model view. Control the common layout properties. Create a link file. Identify the objects in the Data Model and the Layout Model to enhance matrix reports. Create nested matrix reports. C ontent Emphasis Skills-Based A udience
more...
...eport by creating queries. Enhance a report by creating columns. Identify the sections of the Layout Model. Identify the components in the Data Model view. Control the common layout properties. Create a link file. Identify the objects in the Data Model and the Layout Model to enhance matrix reports. Create nested matrix reports. C ontent Emphasis Skills-Based A udience
more...
Oracle Form Builder R6 Including Reusable Oracle Components
...e Data Wizard. Create a data block on a table with a REF column by using the Data Wizard. Identify the benefits of using the REF LOVs. Create a REF LOV by using the Data Block Wizard. Update the REF values by using a REF LOV. Unit 3: Reusing Components, Objects, and Code Duration: 1 Hour(s) Identify the benefits of reusing objects. Create a Property class with properties by
more...
...e Data Wizard. Create a data block on a table with a REF column by using the Data Wizard. Identify the benefits of using the REF LOVs. Create a REF LOV by using the Data Block Wizard. Update the REF values by using a REF LOV. Unit 3: Reusing Components, Objects, and Code Duration: 1 Hour(s) Identify the benefits of reusing objects. Create a Property class with properties by
more...
Oracle8 Performance Tuning Managing Memory and Disk I O
...parse calls that find a cursor to share using GETHITRATIO column of the V$LIBRARYCACHE view
Perform the steps to determine the reloads-to-pins ratio from the V$LIBRARYCACHE view.
Identify the steps used to size the Library Cache.
Perform the steps to compute the amount of sharable memory that has been used using SELECT SUM query.
Perform the steps to keep large objects using the supplied
more...
...parse calls that find a cursor to share using GETHITRATIO column of the V$LIBRARYCACHE view
Perform the steps to determine the reloads-to-pins ratio from the V$LIBRARYCACHE view.
Identify the steps used to size the Library Cache.
Perform the steps to compute the amount of sharable memory that has been used using SELECT SUM query.
Perform the steps to keep large objects using the supplied
more...
Oracle Report Builder Enhancing Reports
...a single query or a multiple query. Match the Data Model column types with their functions. Identify the properties of a summary column. Create a formula column using the tool palette in the Data Model. Identify the uses of the placeholder column. Unit 2: Enhancing a Report - Layout Model Duration: 1 - 2 Hour(s) Identify the descriptions of the Layout Model regions. Design a
more...
...a single query or a multiple query. Match the Data Model column types with their functions. Identify the properties of a summary column. Create a formula column using the tool palette in the Data Model. Identify the uses of the placeholder column. Unit 2: Enhancing a Report - Layout Model Duration: 1 - 2 Hour(s) Identify the descriptions of the Layout Model regions. Design a
more...
Lotus Notes R5 Managing and Sharing Information
...a form. Create a form section. Create a view. Insert a column into a view. Set column properties in a view. Specify a selection condition to display documents in a view. Indent response documents in a view. Grant a specific user the access to a view. Cascade views. Unit 2: Searching for Information Duration: 1.5 - 2 Hour(s) Search a view sequentially for documents that
more...
...a form. Create a form section. Create a view. Insert a column into a view. Set column properties in a view. Specify a selection condition to display documents in a view. Indent response documents in a view. Grant a specific user the access to a view. Cascade views. Unit 2: Searching for Information Duration: 1.5 - 2 Hour(s) Search a view sequentially for documents that
more...
Lotus Notes R5 Managing and Sharing Information
...a form. Create a form section. Create a view. Insert a column into a view. Set column properties in a view. Specify a selection condition to display documents in a view. Indent response documents in a view. Grant a specific user the access to a view. Cascade views. Unit 2: Searching for Information Duration: 1.5 - 2 Hour(s) Search a view sequentially for documents that
more...
...a form. Create a form section. Create a view. Insert a column into a view. Set column properties in a view. Specify a selection condition to display documents in a view. Indent response documents in a view. Grant a specific user the access to a view. Cascade views. Unit 2: Searching for Information Duration: 1.5 - 2 Hour(s) Search a view sequentially for documents that
more...
Lotus Notes R5 Messaging and Working Remotely
...(s) Sort mail messages in the Inbox folder by using a column heading. Create a mail rule to filter mail messages. Delete a mail message from all folders and views in the mail database. Archive mail messages from the mail database. Set the delivery options for a mail message. Add a signature to outgoing mail messages. Add an address in the Personal Address Book. Create a group in the
more...
...(s) Sort mail messages in the Inbox folder by using a column heading. Create a mail rule to filter mail messages. Delete a mail message from all folders and views in the mail database. Archive mail messages from the mail database. Set the delivery options for a mail message. Add a signature to outgoing mail messages. Add an address in the Personal Address Book. Create a group in the
more...
Lotus Notes R5 Messaging and Working Remotely
...(s) Sort mail messages in the Inbox folder by using a column heading. Create a mail rule to filter mail messages. Delete a mail message from all folders and views in the mail database. Archive mail messages from the mail database. Set the delivery options for a mail message. Add a signature to outgoing mail messages. Add an address in the Personal Address Book. Create a group in the
more...
...(s) Sort mail messages in the Inbox folder by using a column heading. Create a mail rule to filter mail messages. Delete a mail message from all folders and views in the mail database. Archive mail messages from the mail database. Set the delivery options for a mail message. Add a signature to outgoing mail messages. Add an address in the Personal Address Book. Create a group in the
more...
SAP R 3 v4 x SD Order Processing
Course Overview
Within the Sales and Distribution module, this course will help you to understand the stages involved in the ordering cycle which include receiving the initial order through to delivery and invoicing. You will also learn in detail how to create and process orders.
L earn To:
Sales Order Processing.
Order Entry.
Order Header.
Order Items.
Schedule Lines.
more...
Course Overview
Within the Sales and Distribution module, this course will help you to understand the stages involved in the ordering cycle which include receiving the initial order through to delivery and invoicing. You will also learn in detail how to create and process orders.
L earn To:
Sales Order Processing.
Order Entry.
Order Header.
Order Items.
Schedule Lines.
more...
Outlook 2000 Proficient User
...contact.
Delete a contact.
Sorting contacts using field column headings in the table view.
Flag a contact for follow-up.
Track activities with contacts using the Contact Activities feature.
Add an existing vCard to a message.
Identify the built-in views in Contacts.
Identify the customization options available for Contacts.
Unit 2: Recording Tasks, Journals and Notes
Duration: 2 -
more...
...contact.
Delete a contact.
Sorting contacts using field column headings in the table view.
Flag a contact for follow-up.
Track activities with contacts using the Contact Activities feature.
Add an existing vCard to a message.
Identify the built-in views in Contacts.
Identify the customization options available for Contacts.
Unit 2: Recording Tasks, Journals and Notes
Duration: 2 -
more...
Outlook 2000 Fundamentals
...ark messages as read and unread.
Sort messages using the column headings.
Set AutoArchive options.
Identify the built-in views to filter the list of messages using the View menu.
Apply a filter to a list of messages using the Filter dialog box.
Change the default viewing options using the Other Settings dialog box.
Identify the customization options available for Messages in the Options
more...
...ark messages as read and unread.
Sort messages using the column headings.
Set AutoArchive options.
Identify the built-in views to filter the list of messages using the View menu.
Apply a filter to a list of messages using the Filter dialog box.
Change the default viewing options using the Other Settings dialog box.
Identify the customization options available for Messages in the Options
more...
Oracle Database 10g SQL Fundamentals I Part 2
...ntify syntax for performing various tasks for maintaining columns.
Identify the code for retrieving data hierarchically from a table.
Identify the code for formatting hierarchical reports.
Identify features of regular expression functions.
Audience:
The audience for this course includes PL/SQL Developers, System Analysts, Technical Consultants, Forms Developers, Portal Developers,
more...
...ntify syntax for performing various tasks for maintaining columns.
Identify the code for retrieving data hierarchically from a table.
Identify the code for formatting hierarchical reports.
Identify features of regular expression functions.
Audience:
The audience for this course includes PL/SQL Developers, System Analysts, Technical Consultants, Forms Developers, Portal Developers,
more...
SAP R 3 FI AR AP Organization Master Records and Posting
...tructure.
Global Settings.
Creating a Display Variant.
Column Heading.
Displaying Fields during the Creation of Master Data.
Unit 2: Master Data
Duration: 2 - 3 Hour(s)
Create.
Creating Master Data.
Starting the Program.
General Data.
Company Code Data.
Displaying Master Data.
Maintain/Change.
Changing Master Data.
Starting the Program.
Selecting Individual Screens.
more...
...tructure.
Global Settings.
Creating a Display Variant.
Column Heading.
Displaying Fields during the Creation of Master Data.
Unit 2: Master Data
Duration: 2 - 3 Hour(s)
Create.
Creating Master Data.
Starting the Program.
General Data.
Company Code Data.
Displaying Master Data.
Maintain/Change.
Changing Master Data.
Starting the Program.
Selecting Individual Screens.
more...
Oracle SQL Specifics Retrieving and Formatting Data
...e NVL function to convert null values to zero.
Display a column with a column alias.
Use the concatenation operator to combine query results from multiple table columns into a single column.
Perform a query using a pseudocolumn.
Identify the components of a basic WHERE clause.
Use the WHERE clause to query for a character string or a date.
Match each type of operator to the correct
more...
...e NVL function to convert null values to zero.
Display a column with a column alias.
Use the concatenation operator to combine query results from multiple table columns into a single column.
Perform a query using a pseudocolumn.
Identify the components of a basic WHERE clause.
Use the WHERE clause to query for a character string or a date.
Match each type of operator to the correct
more...
Oracle SQL Specifics Creating and Managing Database Objects
...y 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.
Identify the default constraint name generated by Oracle8.
Use the CREATE TABLE statement to create a table with integrity constraints.
Use the ALTER TABLE statement with the ADD
more...
...y 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.
Identify the default constraint name generated by Oracle8.
Use the CREATE TABLE statement to create a table with integrity constraints.
Use the ALTER TABLE statement with the ADD
more...
Oracle SQL and SQL Plus Advanced SELECT Statements
...single-row subqueries.
Write multiple-row and multiple-column subqueries.
Write correlated subqueries.
Write queries using number DECODE and character functions.
Write hierarchical queries and format hierarchical reports.
Write compound queries by using set operators and control the order of the output of the compound queries.
C ontent Emphasis
Skills-Based
A udience
more...
...single-row subqueries.
Write multiple-row and multiple-column subqueries.
Write correlated subqueries.
Write queries using number DECODE and character functions.
Write hierarchical queries and format hierarchical reports.
Write compound queries by using set operators and control the order of the output of the compound queries.
C ontent Emphasis
Skills-Based
A udience
more...
Oracle SQL and SQL Plus SQL Plus and Reporting
...egories with sample tasks.
Write the code to display the column definitions of a given table.
Complete the SELECT statement that prompts the user to input a value at run-time by using the & substitution variable.
Write the SET command to display the text of a command before and after it replaces substitution variables with values.
Complete the SELECT statement that reuses a substitution
more...
...egories with sample tasks.
Write the code to display the column definitions of a given table.
Complete the SELECT statement that prompts the user to input a value at run-time by using the & substitution variable.
Write the SET command to display the text of a command before and after it replaces substitution variables with values.
Complete the SELECT statement that reuses a substitution
more...
Oracle SQL Tuning Tuning SQL and the Optimizer
...ines for coding SQL in order to share cursors.
Match the columns of the V$LIBRARYCACHE view with the information that they contain.
Match the columns of the V$SQLAREA view with the information that they contain.
Unit 2: Efficient SQL Code Design: Guidelines
Duration: 2 - 3 Hour(s)
Identify the type of the SQL statements that are most likely to benefit from tuning.
Identify the
more...
...ines for coding SQL in order to share cursors.
Match the columns of the V$LIBRARYCACHE view with the information that they contain.
Match the columns of the V$SQLAREA view with the information that they contain.
Unit 2: Efficient SQL Code Design: Guidelines
Duration: 2 - 3 Hour(s)
Identify the type of the SQL statements that are most likely to benefit from tuning.
Identify the
more...
Programming XML Using XML
... To differentiate between functions of the XML Column and XML Collection storage methods. To identify consequences of enabling a database using DB2 XML Extender. To identify situations where the XML Collection method should be used to store an XML document. Audience The target audience is enterprise application architects.
more...
... To differentiate between functions of the XML Column and XML Collection storage methods. To identify consequences of enabling a database using DB2 XML Extender. To identify situations where the XML Collection method should be used to store an XML document. Audience The target audience is enterprise application architects.
more...
Word 2000 Proficient User
...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. Insert a
more...
...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. Insert a
more...
PowerPoint 2000 Expert User
... a table. Format the text in a cell. Insert a row and a column. Unit 4: Enhancing a Presentation Duration: 1 Hour(s) Import the contents of a Word file. Import a chart from an Excel file. Import a presentation. Import a sound clip that is saved as a file. Import a movie clip that is saved as a file. Import an animated GIF file. Add an action button to a slide. Create a
more...
... a table. Format the text in a cell. Insert a row and a column. Unit 4: Enhancing a Presentation Duration: 1 Hour(s) Import the contents of a Word file. Import a chart from an Excel file. Import a presentation. Import a sound clip that is saved as a file. Import a movie clip that is saved as a file. Import an animated GIF file. Add an action button to a slide. Create a
more...
SQL and PL SQL Basic SELECT
...T statements. Write a SELECT statement that displays all columns and rows of a table. Write a SELECT statement that displays specific columns from a table. Identify precedence in evaluating an arithmetic expression within a SQL statement. Specify an alias for a column heading when extracting data from a table. Concatenate multiple columns that are selected from a table. Embed a literal
more...
...T statements. Write a SELECT statement that displays all columns and rows of a table. Write a SELECT statement that displays specific columns from a table. Identify precedence in evaluating an arithmetic expression within a SQL statement. Specify an alias for a column heading when extracting data from a table. Concatenate multiple columns that are selected from a table. Embed a literal
more...
SQL and PL SQL Data Retrieval Techniques
...OUP BY clause. Write single-row, multiple row, multiple-column subqueries. Obtain values at run time by creating and maintaining substitution variables. Use SQL*Plus format commands to format report output. Run a formatted report using a SQL*Plus script file. C ontent Emphasis Skills-Based A udience Application developers, database administrators, designer/developers, and
more...
...OUP BY clause. Write single-row, multiple row, multiple-column subqueries. Obtain values at run time by creating and maintaining substitution variables. Use SQL*Plus format commands to format report output. Run a formatted report using a SQL*Plus script file. C ontent Emphasis Skills-Based A udience Application developers, database administrators, designer/developers, and
more...
SQL and PL SQL DML and DDL
...he NOT NULL constraint. Define 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.
more...
...he NOT NULL constraint. Define 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.
more...
Programming XML Using XML
... To differentiate between functions of the XML Column and XML Collection storage methods. To identify consequences of enabling a database using DB2 XML Extender. To identify situations where the XML Collection method should be used to store an XML document. Audience The target audience is enterprise application architects.
more...
... To differentiate between functions of the XML Column and XML Collection storage methods. To identify consequences of enabling a database using DB2 XML Extender. To identify situations where the XML Collection method should be used to store an XML document. Audience The target audience is enterprise application architects.
more...
Project 2000 Proficient User
...ation: 2 - 3 Hour(s) Create a custom table. Insert a column in a table. Restore the default settings of a specific table. Create a custom view. Sort a displayed view in the ascending order. Apply a predefined group to the displayed project. Create a custom group. Modify the WBS of a project. Apply the predefined WBS code to a project. Define a custom WBS code for a project. Apply
more...
...ation: 2 - 3 Hour(s) Create a custom table. Insert a column in a table. Restore the default settings of a specific table. Create a custom view. Sort a displayed view in the ascending order. Apply a predefined group to the displayed project. Create a custom group. Modify the WBS of a project. Apply the predefined WBS code to a project. Define a custom WBS code for a project. Apply
more...
IBM DB2 Universal Database V6 1--Fundamentals
...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: Introduction to
more...
...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: Introduction to
more...
IBM DB2 Universal Database V6 1--Fundamentals
...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: Introduction to
more...
...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: Introduction to
more...
Oracle SQL for End Users--Part 1
...racle implementation of ORDBMS and RDBMS. Match database column values with their data types. Match the names of the three tables used in this course with the information they contain. Unit 2: Writing Basic SQL Statements Duration: 1 - 2 Hour(s) Match the capabilities of SQL SELECT statements with their definitions. Match SQL statement elements with their descriptions. Write a
more...
...racle implementation of ORDBMS and RDBMS. Match database column values with their data types. Match the names of the three tables used in this course with the information they contain. Unit 2: Writing Basic SQL Statements Duration: 1 - 2 Hour(s) Match the capabilities of SQL SELECT statements with their definitions. Match SQL statement elements with their descriptions. Write a
more...
Oracle SQL for End Users--Part 2
...ersand and surrounded by single quotation marks. Specify column names and expressions at run time using substitution variables. Prompt the user for a value by using a variable prefixed with a double ampersand. Accept user input at run time by using the ACCEPT command. Maintain a variable at run time by using the DEFINE and UNDEFINE commands. Match the SET command variables with their
more...
...ersand and surrounded by single quotation marks. Specify column names and expressions at run time using substitution variables. Prompt the user for a value by using a variable prefixed with a double ampersand. Accept user input at run time by using the ACCEPT command. Maintain a variable at run time by using the DEFINE and UNDEFINE commands. Match the SET command variables with their
more...
Excel XP Fundamentals
...tents of a cell in a worksheet. • Insert a row and column in a worksheet. • Delete a row and column from a worksheet. • Hide a row and column in a worksheet. Audience The intended audience for this course includes end users and power users who may or may not be familiar with previous versions of Microsoft Excel. Their relevant duties may include office or managerial
more...
...tents of a cell in a worksheet. • Insert a row and column in a worksheet. • Delete a row and column from a worksheet. • Hide a row and column in a worksheet. Audience The intended audience for this course includes end users and power users who may or may not be familiar with previous versions of Microsoft Excel. Their relevant duties may include office or managerial
more...
Excel XP Expert User
...ata form. • Sort a row in a list by using multiple columns. • 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. •
more...
...ata form. • Sort a row in a list by using multiple columns. • 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. •
more...
Word XP Curriculum
...uments, use of Word Help, document enhancement, table and column management, in addition to visual enhancements to include WordArt, and graphics. This curriculum consists of three Skill Builder courses: Course 74020 Microsoft Word 2002 Fundamentals Course 74021 Microsoft Word 2002 Proficient User Course 74022 Microsoft Word 2002 Expert User Learn To See individual course descriptions for
more...
...uments, use of Word Help, document enhancement, table and column management, in addition to visual enhancements to include WordArt, and graphics. This curriculum consists of three Skill Builder courses: Course 74020 Microsoft Word 2002 Fundamentals Course 74021 Microsoft Word 2002 Proficient User Course 74022 Microsoft Word 2002 Expert User Learn To See individual course descriptions for
more...
Word XP Proficient User
...ill deal with document enhancement, table management, and column management. This course also covers visual enhancements including WordArt, graphics, and diagrams. Lastly, learners will cover mail merge and workgroup collaboration. Learn To • Insert page numbers into a document. • Insert a header and a footer into a document. • Insert a date and time into a document.
more...
...ill deal with document enhancement, table management, and column management. This course also covers visual enhancements including WordArt, graphics, and diagrams. Lastly, learners will cover mail merge and workgroup collaboration. Learn To • Insert page numbers into a document. • Insert a header and a footer into a document. • Insert a date and time into a document.
more...
Project 2002 Proficient User
...a custom table in Microsoft Project 2002. o To insert a column in a table in Microsoft Project 2002. o To identify options to customize toolbars in Microsoft Project 2002. o To create a menu in Microsoft Project 2002. o To record a macro in Microsoft Project 2002. o To create a subproject from a large project in Microsoft Project 2002. o To create a consolidated project in Microsoft
more...
...a custom table in Microsoft Project 2002. o To insert a column in a table in Microsoft Project 2002. o To identify options to customize toolbars in Microsoft Project 2002. o To create a menu in Microsoft Project 2002. o To record a macro in Microsoft Project 2002. o To create a subproject from a large project in Microsoft Project 2002. o To create a consolidated project in Microsoft
more...
Visual Basic NET-Web Based Development Part 3
...lay data by using a DataGrid control. o Create a custom column header in a DataGrid control. o Page a DataGrid control. o Identify the stages for displaying data using the Repeater and DataList controls. o Match template types with their features. o Identify the syntax for using templates with a DataList control. o Match style properties of ASP.NET controls with their features.
more...
...lay data by using a DataGrid control. o Create a custom column header in a DataGrid control. o Page a DataGrid control. o Identify the stages for displaying data using the Repeater and DataList controls. o Match template types with their features. o Identify the syntax for using templates with a DataList control. o Match style properties of ASP.NET controls with their features.
more...
Customer Relationship Mgt Fundamentals of CRM
...mpetitor is going to launch a television show, syndicated column, and product line, which would directly compete with Lillian Alley. At this meeting, you want to recommend that Lillian Alley Enterprises develops itself as a market intelligence enterprise and discuss with Lillian and Greg which marketing tier would best serve the company's needs. Unit 2: Principles of CRM (0.5 - 1 hour)
more...
...mpetitor is going to launch a television show, syndicated column, and product line, which would directly compete with Lillian Alley. At this meeting, you want to recommend that Lillian Alley Enterprises develops itself as a market intelligence enterprise and discuss with Lillian and Greg which marketing tier would best serve the company's needs. Unit 2: Principles of CRM (0.5 - 1 hour)
more...
Lotus Domino R5 Development Part 2 Application Devel Fundamentals
...tabase by using the Design pane. Set the properties of a column in a view. Set the properties of a view. Organize the documents in a view. Create a hierarchical view that displays response documents indented under their parent documents in a database. Create a database icon by using the Design pane. Create an About This database document for a database by using the Design pane. Create a
more...
...tabase by using the Design pane. Set the properties of a column in a view. Set the properties of a view. Organize the documents in a view. Create a hierarchical view that displays response documents indented under their parent documents in a database. Create a database icon by using the Design pane. Create an About This database document for a database by using the Design pane. Create a
more...
Excel 2003 Proficient User
...mments in cells. Hide a row and a column.. Identify methods for sizing a row and a column. Freeze a row and a column. Insert a worksheet. Identify formatting options on the Sheet menu. Move a worksheet within a workbook by using the Edit menu.
more...
...mments in cells. Hide a row and a column.. Identify methods for sizing a row and a column. Freeze a row and a column. Insert a worksheet. Identify formatting options on the Sheet menu. Move a worksheet within a workbook by using the Edit menu.
more...
From Sessions Online School of Design
Advanced Layout Design Course
...e common grid systems used by designers: manuscript grid, column grid, modular grid, and hierarchical grid. In the exercise, you'll apply these concepts to the design of a 4-page magazine spread.
LESSON 2 Geometric Design Order is a necessary element in all design and a complement to creativity. Lesson Two explores creative applications for a geometrical approach to page composition. Classic
more...
...e common grid systems used by designers: manuscript grid, column grid, modular grid, and hierarchical grid. In the exercise, you'll apply these concepts to the design of a 4-page magazine spread.
LESSON 2 Geometric Design Order is a necessary element in all design and a complement to creativity. Lesson Two explores creative applications for a geometrical approach to page composition. Classic
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 |
