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...
Microsoft Access 2000 Basic 
This highly interactive
CBT contains five units that cover basic
Access skills. Through step-by-step instruction within a realistic simulation of
Microsoft Access 2000, students learn how to create and manage data and tables, create forms and reports, and modify a database structure. Performance-based
Pre- and
Post-Assessments create a custom course path for each learner covering only the topics
more...
Microsoft Access 97 Basic 
This highly interactive
CBT contains five units that cover basic
Access skills. Through step-by-step instruction within a realistic simulation of
Microsoft Access 97, students learn how to create and manage data and tables, create forms and reports, and modify a database structure. This course is designed to help individuals who want to achieve basic proficiency in MS Access 97. Individuals who
more...
Participating Effectively in Business Meetings 
...ivity or project requires a meeting, or meetings, of some sort. Knowing how to hold efficient and effective meetings can help make projects successful. In a good meeting, participants' ideas are heard, decisions are made through group discussion and with reasonable speed, and activities are focused on desired results. Good meetings help generate enthusiasm for a project, build skills for future
more...
Administrative Functions 
Administrative support professionals are the central nervous systems of an office. Their responsibilities are numerous and vital to the operation of their organization. Knowing the best ways to perform office functions will enable administrative support professional to complete their responsibilities efficiently and effectively. This course will present you with information that will help you
more...
Lean Logic 
Suppose a friend told you that it was more efficient to put on your shoes before your pants when getting dressed. What is the logic behind taking an action that seems so counterintuitive? You probably wouldn't implement this new methodology without a thorough explanation of its origin and logic, right? Some of the lean manufacturing suggestions may also strike you as counterintuitive. That's
more...
Using Advanced Data Management Techniques 
...ow to create lists in
Excel and manage them by filtering, sorting, subtotaling data, and specifying validation criteria. Additionally, it explains the procedures involved in importing data in Excel from external sources, such as
Access databases, text files, and
Web pages. The course also takes the user through the process of creating and managing
PivotTables and
PivotCharts as well as
more...
Microsoft Word 97 Basic 
This highly interactive
CBT contains five units that cover basic
Word skills. Through step-by-step instruction within a realistic simulation of
Microsoft Word 97, students learn how to design, create, edit, and enhance documents. 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 online glossary
more...
Microsoft Access 97 Intermediate 
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 create multiple task queries, develop form as and sub-forms, create complex reports, share access information with other office programs and create advanced queries. Performance-based
Pre- and
more...
Microsoft Word 2000 Basic 
This highly interactive
CBT contains five units that cover basic
Word skills. Through step-by-step instruction within a realistic simulation of
Microsoft Word 2000, students learn how to design, create, edit, and enhance documents. 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 online
more...
Advanced Features of MS Project 2000 
This is the second course in the
Project 2000 curriculum. It acquaints the students with the advanced capabilities of Project 2000. It enables students to plan, create and assign tasks and resources. It also enables students to manage and generate project reports, and access risks. Additionally, it enables students to use
Project Central 2000 for communicating information and managing the
Project more...
SQL Server 7.0 Installing and Upgrading 
...ws NT User
Account network protocols management tools and sort orders. The course then covers installing and de-installing the
SQL Server 7.0 software and
OLAP services and how to plan for an upgrade of SQL Server 6.0 or 6.5 to
Version 7.0. This course is written to SQL Server 7.0. Related
Exams:
Prepares users for both Microsoft Exams #070-028 Administering Microsoft SQL Server 7.0 and
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...
Oracle9i Performance Tuning: Optimizing Sorts and Minimizing Contention 


The content of this course includes details about each component of an
Oracle database instance, such as data blocks, disks, memory,
CPU, and dynamic views. Students learn about migration and chaining, reorganizing indexes, optimizing sort operations, tuning rollback segments, managing automatic undo, monitoring activities, implementing the Oracle shared server, and troubleshooting.
more...
Oracle8i Performance Tuning: Optimizing Sorts and Minimizing Contention 
...rse introduces the participants improving performance for sort operations. The student will be able to identify the
SQL operations that require sorts ensure that sorting is done in memory where possible use direct writes for large sorts and allocate temporary space appropriately. The student will use
Oracle tools to diagnose and resolve contention given the possible causes of contention.
more...
Oracle9i Performance Tuning: Optimizing Sorts and Minimizing Contention 
The content of this course includes details about each component of an
Oracle database instance such as data blocks disks memory
CPU and dynamic views. Students learn about migration and chaining reorganizing indexes optimizing sort operations tuning rollback segments managing automatic undo monitoring activities implementing the Oracle shared server and troubleshooting.
more...
Oracle SQL for End Users Part 1 
Oracle
SQL and SQL*Plus are powerful components of
Oracle's relational and object relational database management systems. This course is designed for end users who want to learn how to write
SQL SELECT statements to retrieve data from a database. This course identifies relational database properties introduces the Oracle server and indicates how SQL and SQL*Plus are used in the Oracle product
more...
Oracle8 Performance Tuning: Optimizing Sorts and Minimizing Contention 
...rse introduces the participants improving performance for sort operations. The student will be able to identify the
SQL operations that require sorts ensure that sorting is done in memory where possible use direct writes for large sorts and allocate temporary space appropriately. The student will use
Oracle tools to diagnose and resolve contention given the possible causes of contention.
more...
From 123-CBT Computer Based Training
Oracle8i Performance Tuning Optimizing Sorts Minimizing Contention 

...rse introduces the participants improving performance for sort operations. The student will be able to identify the
SQL operations that require sorts, ensure that sorting is done in memory where possible, use direct writes for large sorts and allocate temporary space appropriately. The student will use
Oracle tools to diagnose and resolve contention, given the possible causes of contention.
more...
Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention 

...rse introduces the participants improving performance for sort operations. The student will be able to identify the
SQL operations that require sorts, ensure that sorting is done in memory where possible, use direct writes for large sorts and allocate temporary space appropriately. The student will use
Oracle tools to diagnose and resolve contention, given the possible causes of contention.
more...
Lotus Notes R5 Messaging and Working Remotely 

...ssaging:
Advanced Features Duration: 2 - 3 Hour(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
more...
Lotus Notes R5 Messaging and Working Remotely 

...ssaging:
Advanced Features Duration: 2 - 3 Hour(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
more...
Outlook 2000 Fundamentals 

...ing the
Actions menu.
Mark 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
more...
Visual Basic 6 0 Designing Implementing Desktop Applications - Part 3 

...t allow navigation through a recordset. Identify code to sort records. Identify code to filter and search records. Update data using the
Execute method. Update data using a recordset. Create a disconnected
Recordset object. Identify the methods used in data persistence. Identify how much connection information is required to reconnect to a data source. Identify issues related to the
more...
Oracle SQL Specifics Retrieving and Formatting Data 

...a query using a
SQL operator.
Use the
ORDER BY clause to sort query results.
Use a join to query data from multiple tables.
Use an outer join to return records without a direct match.
Identify the features of the SQL*Plus environment.
Log in to SQL*Plus.
Use the
DESCRIBE command to display the structure of a table.
Match SQL*Plus editing commands to their descriptions.
Match SQL*Plus
more...
Word 2000 Proficient User 

Course
Overview This course provides participants with the intermediate skills to use
Microsoft Word 2000 on a daily basis in their workplace. At the completion of this course, students will learn to format and proof a document; enhance a document with drawing objects, charts,
Clip Art, graphics and presentation enhancements; create a mail merge; and create envelopes and labels by merging an
more...
Word 2000 Expert User 

Course
Overview This course provides participants the knowledge to use the advanced features of
Microsoft Word 2000. At the completion of this course, students will learn to perform advanced text editing and handling operations; manage documents within a workgroup environment; and insert table of contents, cross-references and bookmarks in a document. L earn To:
Perform advanced text
more...
SQL Server 7 0 System Administration - Part 1 

...roperties of a character set.
Identify the properties of sort orders.
Identify the properties of
Unicode collation.
Identify the network libraries and protocols supported in
SQL Server.
Identify the SQL Server service account properties.
Perform the steps to auto start SQL Server.
Perform the steps to manually start SQL Server.
Perform the steps to manually pause SQL Server services.
more...
Microsoft Works Suite 2005 Creating Databases 

This course helps the learner create databases by covering
Works Database essentials such as working with databases, fields, records, forms, and reports. It also covers database fundamentals such as the Works Database interface and database views.
Learn To:
Identify components of the Works Database interface.
Create a database from an existing template.
Identify the steps to create a
more...
SQL and PL SQL Basic SELECT 

...e concepts; writing basic
SQL statements; restricting and sorting data; and using single-row functions. L earn To:
Identify relational database concepts and properties. Describe database design processes by explaining the system development life cycle and entity relationship modeling. Describe the concept of object relational database management systems. Write
SQL SELECT more...
Project 2000 Proficient User 

...ult 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 a predefined filter. Apply
AutoFilter on a column to filter data in a specific view. Apply a
more...
Oracle SQL for End Users--Part 1 

...T statements and customizes these queries to restrict and sort the results. In addition, the learner writes statements that contain a variety of single-row functions. L earn To:
Identify database principles and concepts concerning the
Oracle server,
SQL, and SQL*Plus. Write basic
SQL SELECT statements. Add clauses to basic SQL SELECT statements to restrict and sort data retrieved
more...
Access XP Proficient User 

... Identify the effects of opening queries. Sort a query by output. Apply a criterion to a query. Apply an aggregate tool to a query. Add a table to a query. Add a calculated field to a query. Match the field properties with their features. Unit 2:
Forms Introduction 1 - 2 hours Identify features of the
Form Wizard.
more...
Excel XP Expert User 

...49; Enter data in a list by using the data 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
more...
Word XP Proficient User 

Course
Overview 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. Learn To Insert page numbers into a document.
more...
Crystal Reports 8 5 Introductory Report Design Part 1 

... designing reports, record selection, record grouping and sorting, formatting reports, and distributing reports. Students will learn to create and distribute a simple report. Learn To Identify the fundamentals for using
Crystal Reports. Create reports, manipulate objects in a report and design reports for a business scenario. Identify how to select, sort and group
more...
Windows 2000 Implementing Security Part 1 

...n functions of
Group Policy. Sort features of user-account authentication methods. Identify methods used to secure resource access. Sort characteristics of the security groups used for resource access. Identify features of symmetric key encryption that secures data on a network.
more...