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 Excel 2000 Proficient User 
This course provides participants with the skills to use
Microsoft Excel 2000 on a daily basis in their workplace. At the completion of this course, students will learn how to format and print data in a worksheet; make worksheet calculations by using the advanced formulas and functions provided by
Excel; manipulate data in a worksheet; create and edit workbooks for integrating with
Web technology;
more...
OS 390 Managing DB2 Data Warehouse 
...ty of sources, converting and storing data, synchronizing data in a distributed environment, and accessing data for decision-support. The course is designed for managers and technical professionals who are considering implementing a data warehouse using
DB2. Technical professionals will find hints for designing and tuning DB2 for maximum performance in a data warehouse environment. Managers
more...
OS 390 Assembler Language Programming Intermediate 
This course provides instruction and practice in the use of the standard assembler language instructions. The course covers executable instruction and practice in the use of the standard assembler language instructions. In addition, the course covers executable instructions for data manipulation including loading and storing data, moving data in main storage, bit manipulation, binary and decimal
more...
Analyzing Data in Excel 2007 
Excel 2007 provides powerful data analysis tools that enable you to explore large amounts of data and to make educated business decisions based on that data. With
PivotTable reports you can interactively summarize data, making it easier to analyze and present the results. PivotChart reports provide a graphical view of PivotTable report data. Using
Goal Seek and
Solver enables you to retrieve
more...
Business Contact Manager with Outlook 2007 
Microsoft
Outlook 2007 with
Business Contact Manager helps to save time and improve sales and marketing to ensure excellent customer service by providing customer and contact management in one central location. It allows you to easily manage all your contacts, customer information, and opportunities in one location making it easier to find and manage. It also allows you to create marketing
more...
Norton Personal Firewall 2005 
...05. You will learn about keeping hackers out and personal data in and facilitating robust firewall protection by automatically hiding your PC on the
Internet and blocking suspicious connections. You will also learn about protecting your privacy using the
Personal Firewall by preventing confidential information from being sent out without your knowledge. The course is intended for users with
more...
Data Management and Analysis with Excel 2002 
...m. This course teaches the user how to effectively manage data in
Excel and analyse data based on certain functions. The functions dealt with in this course include mathematical, logical, date and time, text, lookup and reference, financial, and statistical functions. Additionally, the course teaches the usage of the
Analysis ToolPak Data Analysis tools to perform various calculations in a
more...
Using Advanced Data Management Techniques 
...ionally, 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 scenarios and reports to analyze data. Users can also learn how to create and use macros to automate long and repetitive tasks in
more...
Getting Started With Excel 2003 
The
Getting Started With Excel 2003WBT is the first course in the
Excel 2003 curriculum. It familiarizes the students with the fundamentals of Excel 2003. This course teaches the students how to create and manage workbooks and enter data, and edit data in an
Excel workbook. The course also teaches the user to apply various types of formatting and enhancements to data in a worksheet. This course is
more...
Norton Personal Firewall 2004 
This course will provide users with an overview of the features and benefits of
Norton Personal Firewall to show how it keeps hackers out and personal data in. It makes robust firewall protection easy by automatically hiding your PC on the
Internet and blocking suspicious connections. This course will also show how Norton Personal Firewall protects your privacy by preventing confidential
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...
Oracle SQL: Basic SELECT Statements 
This course is the first in a three-part
Oracle SQL series that is based on the
ILT course
Introduction to
Oracle:
SQL and PL/SQL. This course introduces the learner to Oracle relational database concepts and the use of SQL for storing retrieving and manipulating data in a relational database. This course covers relational database principles and Oracle concepts; writing basic SQL statements;
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...
Data Management in MS Excel 2000 
This course is the second course in a series of three in the
Excel 2000 curriculum. This course teaches the students how to effectively work with and manage data in Excel 2000. The tasks involved in working and managing data include formatting data, performing calculations, using functions to perform calculations, and sorting, summarizing, and analyzing data using
Excel.
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...
Managing MS SQL Server 7.0 
This course provides the student with ways to configure
SQL Server and managing data in SQL Server. It also presents ways to manage various administrative tasks. In addition, the course prepares the student to take the Microsoft Certification Administering Microsoft SQL Server 7.0.
more...
Data Storage Manipulation in C 
This is the last course in a series of four courses. It provides skills that enable the student to store data in the form of linked lists, binary trees, stacks, and queues. It also enables the students to perform bit-level operations.
more...
From 123-CBT Computer Based Training
Oracle9i SQL Basic SELECT Statements 

... the use of
SQL for storing, retrieving, and manipulating data in a relational database. Learn To: o
Identify the components of the relational model. o
Match the structural elements of a relational database table with their descriptions. o
Sequence the phases of the system development life cycle. o Match the types of SQL statements with their descriptions. o Match the capabilities
more...
ASP NET Part 2 ADO NET Partitioning Tracing 

...ET object model. Sequence the steps in accessing data in
ADO.NET. Identify features of
DataSets. Identify the syntax for using a code-behind page. Identify the syntax used to create a class file in
Visual Basic (VB). Identify the syntax used to access controls in a code-behind page. Identify features of
ASP.NET tracing. Identify the
more...
ASP NET Part 2 ADO NET Partitioning Tracing 

...ET object model. Sequence the steps in accessing data in
ADO.NET. Identify features of
DataSets. Identify the syntax for using a code-behind page. Identify the syntax used to create a class file in
Visual Basic (VB). Identify the syntax used to access controls in a code-behind page. Identify features of
ASP.NET tracing. Identify the
more...
IBM DB2 Universal Database V6 1--App Development 

...nto a single result table using set operations. Retrieve data in a restricted condition using a subquery. Retrieve data with referenced values using a correlated subquery. Retrieve data using scalar functions. Retrieve summarized data for groups using grouping functions. Create different levels of aggregation data using
GROUPING SETS operations. Identify characteristics of
STAR schemas
more...
IBM DB2 Universal Database V6 1--App Development 

...nto a single result table using set operations. Retrieve data in a restricted condition using a subquery. Retrieve data with referenced values using a correlated subquery. Retrieve data using scalar functions. Retrieve summarized data for groups using grouping functions. Create different levels of aggregation data using
GROUPING SETS operations. Identify characteristics of
STAR schemas
more...
Oracle Reports R6 Enhance Reports 

...perties of a query, changing group structure an filtering data in a group. Build a report 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
more...
Oracle Form Builder R6 Controlling the User Interface Programmatically 

...functionality. Identify the built-ins used to manage the data in record groups. Define a query record group by using built-ins. Define a non-query record group by using built-ins. Match the built-ins used to process record group rows with their functionality. Write the code to manipulate record group rows by using built-ins. Write the code to manipulate selected record group rows by using
more...
Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention 

... the scope of a structure tuning session.
View collected data in the
Oracle Expert repository.
Specify the options to display the database class data.
Change the duration and sample frequency of collecting instance statistics.
Access schema class data.
View environment class data.
View the workload class data.
View the display and edit options for collected data.
Locate the default
more...
Oracle8 Database Administration - Manage Data 

... addition, this course will teach users about maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data.
L earn To:
Identify the characteristics of various tables and datatypes.
Create and manage tables.
Retrieve table information from the data dictionary.
Identify the characteristics and types of triggers and constraints.
more...
Oracle Form Builder Handling Multiple Object Relationships 

...functionality. Identify the built-ins used to manage the data in record 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
more...
C Programming - Part 4 

... Identify the advantages of using linked lists to store data in memory. Identify the C code to create the first node of a single linked list. Identify the C code to traverse the nodes of a single linked list. Identify the C code to add a node in an unsorted single linked list. Identify the C code to add a node in a sorted single linked list. Identify the C code to search a node in a
more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 2 

...Identify the factors that need to be considered to filter data in a data warehouse. Identify the features of the architectural approaches for data warehouse design. Identify the solution that meets the design requirements of a data warehouse for a given scenario. Identify the factors that determine the feasibility of implementing data warehouse architecture. Identify the reason based on
more...
Macromedia Flash MX 2004 Fundamentals of ActionScript 

...
Identify the tasks for defining a variable and storing data in it.
Identify the types of operators.
Identify the tasks involved in creating a function.
Audience:
This course is targeted at beginning and intermediate level users of
Flash to develop applications or learn
ActionScript.
Deployment:
Self-Study
Accreditation
CEU credits: 0.40 CEUs
Language
Options:
more...
Oracle Database 10g PL SQL Fundamentals Part 1 

...ith their functions.
Identify guidelines for retrieving data in PL/
SQL.
Identify codes for manipulating data using
DML statements.
Identify the syntax for testing the outcome of SQL statements using cursors.
Identify the syntax of the IF statement.
Identify the syntax of the
CASE construct.
Identify considerations for handling nulls.
Identify considerations for building
Boolean more...
Advanced Six Sigma The Measure Analysis Phases of DMAIC 

...ective action.
Learn To:
Understand the role of data in the implementation of
Six Sigma.
Understand how different types of data can be used differently in Six Sigma projects.
Understand how metric systems help in collecting appropriate data.
Develop a data collection plan.
Understand the parameters for evaluating the data collection plan.
Discuss the features of different
more...
Introduction to Data Warehousing 

...ss.
Identify the prerequisites for the transportation of data into the warehouse.
Identify the types of metadata.
Identify the factors impacting the refresh time period of the data warehouse.
Identify the methods for capturing the changed data.
Identify the benefits of replication for refreshing the data in the warehouse.
Identify the storage requirements of a warehouse database.
more...
Oracle SQL Specifics Retrieving and Formatting Data 

...functions.
Use a character function to display character data in a specific format.
Use a number function to display numeric values in a specific format.
Perform a query combining an arithmetic operator with a date.
Use a date function to perform a calculation with a date value.
Match each conversion function to its purpose.
Use the TO_CHAR function to convert a date value from the
more...
Word 2000 Proficient User 

... data within a document. Create a chart from the tabular data in a document. Import data from an
Excel application to create a chart. Edit a chart. Add the chart elements to a chart. Insert a non-breaking space into a document. Create a watermark in a document. Create a hyperlink. Customize a built-in toolbar. Create a custom toolbar. Unit 3:
Mail Merge,
Envelopes and
Labels more...
Word 2000 Expert User 

...ord document. Modify the form controls of a form. Enter data in the controls form. Unit 3: Advanced Document Capabilities Duration: 2 Hour(s) Create a table of contents. Modify a table of contents. Insert a cross-reference in a document. Add a bookmark to a document. Create an index to list a word in a document. Create a concordance file for listing index entries. Generate an
more...
Excel 2000 Fundamentals 

...book; 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 formats. L earn 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,
more...
Excel 2000 Proficient User 

... this course, students will learn how to format and print data in a worksheet; make worksheet calculations by using the advanced formulas and functions provided by
Excel; manipulate data in a worksheet; create and edit workbooks for integrating with
Web technology; and add and modify charts, graphics and 3D shapes to a worksheet. L earn To:
Format and print data in a worksheet. Make
more...
Excel 2000 Expert User 

...s template. Enter a record in a list. Retrieve specific data in a list by using a criteria. Apply filters to a list. Summarize the data in a list. Query a database. Open a table within a database. Extract field data from an open database query. Define a criteria for retrieving specific data from the selected fields in a database query. Run a
Web query. Unit 2:
Workbook Capabilities more...
SQL Server 7 0 System Administration - Part 3 

Course Overview
This is the third course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot
Microsoft SQL Server 7.0.
L earn To:
Identify the concepts, interfaces and fixed roles involved in performing backups.
Gain a working knowledge of database, transaction log and filegroup backups and perform these backups as
more...
Site Server 3 0 Implementation - Part 2 

...types of access. Identify the ways to include additional data in catalogs. Perform the steps to create a catalog definition. Perform the steps to build a catalog. Perform the steps to test a catalog. Identify the catalog schema that allows site visitors to find information using
Search. Perform the steps to modify an existing
Web page to search catalog categories. Perform the steps to
more...
Microsoft Works Suite 2005 Creating Spreadsheets 

This course will cover the basics of
Works Spreadsheet including spreadsheet essentials such as the interface, templates, and
Help options. It will also include working with formulas and functions in a spreadsheet as well as how to perform common tasks such as copying, pasting, and printing.
Learn To:
Identify the components on the Works Spreadsheet interface.
Create a spreadsheet.
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...
Oracle 11i10 Project Foundation Fundamentals Part 2 

Oracle 11i10 Project Foundation Fundamentals:
Part 2 introduces the learner to methods used to define periods and calendars in
Oracle Projects. The course covers different implementation options for Oracle Projects. Additionally, this course teaches the learner to define page layouts and user-defined attributes.
Learn To:
Identify uses of different types of periods.
Identify steps to
more...
Crystal Reports v10 Introduction to Report Design Part 1 

This course is the first in a three-part series that focuses on the basics of reporting using
Crystal Reports v10. This course introduces the user to Crystal Reports and its environment. It also covers the fundamentals of databases and the key concepts associated with relational databases. In this course, you will learn to plan, create, preview, save, and distribute reports.
Learn To:
more...
SQL and PL SQL PL SQL Basics 

...or. Use operators with the PL/
SQL variables. Manipulate data in PL/SQL variables by using SQL functions. Convert the datatype of a variable by using a data conversion function. Identify the features of variable scoping in nested PL/SQL blocks. Create a bind variable in the SQL*Plus environment. Identify the case conventions for writing PL/SQL code. Match the identifiers with their naming
more...
SQL and PL SQL Basic SELECT 

... the use of
SQL for storing, retrieving, and manipulating data in a relational database. This course covers relational database principles and
Oracle 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
more...
Excel XP Expert User 

...49; Open a spreadsheet solutions template. 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
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...
XML Building XML-Based Web Applications Part 1 

...M). Learn To Identify benefits of structured data in
Web-based applications. Identify challenges associated with information processing. Identify the origins of
XML. Identify features of cascading style sheets. Identify features of
XSL style sheets. Identify the syntax for applying an XSL style sheet to an XML document. Audience
more...
XML Building XML-Based Web Applications Part 1 

...M). Learn To Identify benefits of structured data in
Web-based applications. Identify challenges associated with information processing. Identify the origins of
XML. Identify features of cascading style sheets. Identify features of
XSL style sheets. Identify the syntax for applying an XSL style sheet to an XML document. Audience
more...
MS Win XP Install Admin Part 2 Networks Desktops 

...al installation. o
Identify features of backing up user data in
Windows XP Professional. o Identify features of backing up user data in Windows XP Professional. o Identify guidelines for restoring a computer running Windows XP Professional. o Identify guidelines for restoring a computer running Windows XP Professional. Unit 2: Configuring Windows XP Professional 2 - 3 hours o Create
more...