From Serebra Learning Corporation
Microsoft PowerPoint 2000 Expert User 
This course provides participants with the advanced features of
Microsoft PowerPoint 2000 to create powerful presentations. At the completion of this course, students will learn how to create and modify charts and tables; import data from other sources; prepare support elements for a presentation; and broadcast a presentation on the
Web.
more...
OS 390 Managing DB2 Data Warehouse 
...g a data warehouse. Included are discussions of inflowing data from a variety 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
more...
Getting Started with Word 2002 
The
Getting Started with
Word 2002 WBT is the first course in the
Office XP:
Word 2002 curriculum. This course introduces the basic features and functionality of Word 2002 in the Office XP suite of products. It acquaints users with the interface of Word 2002 and introduces simple concepts, such as opening, creating, editing, and saving a file. It also teaches users to navigate
Word documents and
more...
Exchanging Data with Excel 2007 
...ting text files and creating database queries to retrieve data from a variety of databases. Other applications, such as
Access,
Word, and
Outlook, can also import
Excel data. Using
XML in conjunction with Excel enables you to further manage and customize workbooks. This course explores creating links, importing text files, and creating database and web queries. Importing
Excel 2007 data into
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...
SQL Server 7.0 Developing SQL Client/Server Part I 
...architecture interfaces available strategies in accessing data from the client side through queries and tools available with
SQL Server 7.0 to improve and enhance the query process. The student will learn to create a multi-tiered client/server structure and to use OLE DB ActiveX ODBCDirect Microsoft English Query Query Analyzer and to create and evaluate queries. In a corporate setting the
more...
SQL Server 7.0 Developing SQL Client/Server Part II 
...architecture interfaces available strategies in accessing data from the client side through queries and tools available with
SQL Server 7.0 to improve and enhance the query process. The student will learn to create a multi-tiered client/server structure and to use OLE DB ActiveX ODBCDirect Microsoft English Query Query Analyzer and to create and evaluate queries. In a corporate setting the
more...
Oracle 8i PL/SQL - Functions, Tables, and Groups 
This course covers the concepts of single row functions that enable the manipulation of data. The course essentially focuses on three single row functions: character functions number functions and date functions. The course also covers the concept of conversion that enables the conversion of a value from one datatype to another. The concept of retrieving data from more than one table by using
more...
Introduction to ASP.NET Part 2: ADO.NET, Partitioning, and Tracing 


...ce feature. The course will cover using
ADO.NET to access data from various data sources and allows the learner to practice displaying and customizing data display. The course then describes the different methods of separating code from content. Learners will understand how to create code-behind classes, add user controls to
ASP.NET pages, and use components in ASP.NET applications.
more...
Introduction to ASP.NET Part 2: ADO.NET, Partitioning, and Tracing 
...ce feature. The course will cover using
ADO.NET to access data from various data sources and allows the learner to practice displaying and customizing data display. The course then describes the different methods of separating code from content. Learners will understand how to create code-behind classes add user controls to
ASP.NET pages and use components in ASP.NET applications. Additionally
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...
Oracle SQL for End Users Part 2 
...acle:
SQL and PL/SQL. In this course the learner displays data from multiple tables by using equijoins non-equijoins and self joins. In addition this course introduces the use of group functions in a SQL statement to display information about groups of rows in the database. This course also covers how to embed subqueries in SQL statements. Finally the learner creates interactive reports by
more...
Oracle SQL: Data Retrieval Techniques 
...acle:
SQL and PL/SQL. This course describes how to access data from more than one table using joins and aggregating data using group functions. This course also describes how to embed a SQL statement in a clause of another SQL statement to enhance the power of SQL queries. In addition how to use SQL*Plus commands to build on basic SQL statements and create customized queries that retrieve the
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...
Advanced Features of Flash 4.0 
One of the most important features of
Macromedia's
Flash 4.0 is its programming capabilities. Flash enables the student to create movies that are dynamic have machine-calculated properties and can respond to user input. Movies can be used to send raw data to the server side applications and scripts and receive data from them. Flash 4.0 provides tools that help create truly advanced movies and
more...
Advanced Features of Acrobat 4.0 - I 
The
Advanced Features of
Acrobat 4.0 WBT is designed to acquaint students with the advanced features of Acrobat 4.0. It enables students to make their
PDF files user-friendly by adding navigational structures and annotations. It also enables them to create and work with interactive PDF forms which can be used for collecting data from the users.
more...
SQL Queries 


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 SQL Data Retrieval Techniques 

...s. 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. Learn To: o
Identify the four
Oracle join types used to display data from more than one table. o Identify a
Cartesian product. o
Retrieve rows from two tables by using an
more...
ASP NET Part 2 ADO NET Partitioning Tracing 

...ce feature. The course will cover using
ADO.NET to access data from various data sources and allows the learner to practice displaying and customizing data display. The course then describes the different methods of separating code from content. Learners will understand how to create code-behind classes, add user controls to
ASP.NET pages, and use components in ASP.NET applications.
more...
ASP NET Part 2 ADO NET Partitioning Tracing 

...ce feature. The course will cover using
ADO.NET to access data from various data sources and allows the learner to practice displaying and customizing data display. The course then describes the different methods of separating code from content. Learners will understand how to create code-behind classes, add user controls to
ASP.NET pages, and use components in ASP.NET applications.
more...
IBM DB2 Universal Database V6 1--App Development 

...cation
Development Duration: 1 - 2 Hour(s) Combine data from two or more tables using a join. Combine two queries into 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
more...
IBM DB2 Universal Database V6 1--App Development 

...cation
Development Duration: 1 - 2 Hour(s) Combine data from two or more tables using a join. Combine two queries into 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
more...
IBM DB2 Universal Database V6 1--Fundamentals 

... to groups within a table for a given scenario. Retrieve data from multiple tables given a scenario. Enter data into a table using an
INSERT statement. Modify data in a table using an
UPDATE statement. Remove data from a table using a
DELETE statement. Identify considerations in embedding
SQL in applications for
DB2. Sequence the steps to prepare to run an application program. Unit 4:
more...
Access 2000 Proficient User 

...) Import data into a new
Access 2000 table. Link the data from an
Excel spreadsheet to an Access 2000 table. Add a hyperlink to a file by using the
Datasheet view. Copy database objects to Excel by using the drag and drop method. Export a database object to a
Web page. Back up a database by using the
Backup utility. Restore a database from a backup copy by using the Backup utility.
more...
C Programming - Part 2 

...n functions. Identify the conversion function to convert data from a fundamental data type to a user-defined data type for a specified scenario. Identify the appropriate conversion function to convert a user-defined data type to a fundamental data type for a specified scenario. Identify the code to convert an object of user-defined type to an object of another user-defined type for a
more...
SQL Server 7 0 Designing Implementing Data Warehouses - Part 1 

... 2 - 3 Hour(s) Identify the techniques used to gather data from users. Identify the tasks involved in the shadowing technique to gather data. Identify the tasks involved when interviewing users for the purpose of data collection. Identify the tasks involved in gathering data during facilitated sessions. Identify the tasks involved in interviewing focus groups to gather data. Identify
more...
Visual InterDev 6 0 Active Server Pages and Data Access 

...
Duration: 2 Hour(s)
Sequence the steps to display data from a database in an
ASP page.
Identify the functions of the data environment.
Identify the features of a data source name.
Sequence the steps involved in the login authentication process for connecting to a
SQL Server database.
Add the connection information for connecting to a SQL Server database.
Add a data connection to a
more...
Microsoft FrontPage 2003 Expert User 

This course covers higher-level skills of working with
FrontPage, including web components and style sheets, advanced forms and data driven pages, and non-HTML technologies and
Share Point Services.
Learn To:
Create a table of contents for a
Web page.
Insert a photo gallery into a Web page.
Identify features of advanced controls that can be inserted in a Web page.
Identify features
more...
Oracle Database 10g SQL Fundamentals I Part 1 

... System (
RDBMS).
Identify the
SQL statement to retrieve data from tables.
Identify arithmetic expressions used to perform operations on data.
Identify operators used to format results in SQL statements.
Identify features of single-row functions.
Match the character functions with their uses.
Match the number functions with their purpose.
Identify the use of natural joins to
more...
SAP R 3 3 0 

...ame procedures multiple times, handle various data, print data from the system, and automatically transfer large volumes of data into the R/3 System.
C ontent
Emphasis
Skills-Based
A udience
Business users who will work with any of the modules in the
SAP R/3 System. Experience working with one or more
Windows-based applications.
T otal
Learning Time
7 - 10 Hour(s)
Course
more...
SAP R 3 Working with v3 0 

...ame procedures multiple times, handle various data, print data from the system, and automatically transfer large volumes of data into the R/3 System.
C ontent
Emphasis
Skills-Based
A udience
This course is designed for
Business Users of all
SAP R/3 applications. The course is also directed to IS Support staff and
SAP Project Team members needing training in use of the basic SAP
more...
Data Modeling - Develop Depth to Your Models 

....
Create a
UNF data group.
Identify the rule for moving data from unnormalized into first normal form (
FNF).
Identify the additional steps necessary to place all the data groups in first normal form.
Create a
FNFdata group.
Identify the rule for moving data from first into second normal form (
SNF).
Identify the additional steps necessary to place all the groups in second normal form.
more...
Oracle SQL Specifics Retrieving and Formatting Data 

...functions can be used in
SQL SELECT statements to extract data from the database and how
SET operators can be used to combine multiple queries into a single query. Users will also learn how subqueries and correlated subqueries can help to solve data retrieval problems. Finally, participants will learn how to retrieve data based on a hierarchical relationship between rows.
L earn To:
more...
Word 2000 Proficient User 

...eate 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 Duration: 2 Hour(s) Create
more...
Excel 2000 Fundamentals 

...Modify the range accessed by a formula. Copy a specified data from one location to another. Copy specified attributes of data on the clipboard. Paste selected text in a worksheet. Move specified data item from a given location to another. Clear the specified attributes of a cell. Manipulate the cell positions. Spell-check a worksheet. Replace a text string with another string. Select
more...
Excel 2000 Proficient User 

...:
Data Manipulation Duration: 1 - 2 Hour(s) Import data from a text file. Import tables from an
HTML file. Import data from other applications. Export data to other application. Match the different methods of consolidating data with their uses. Create validation criteria for entering data in a cell range by using a list. Create a message to prompt the user to enter valid data in
more...
PowerPoint 2000 Expert User 

... learn how to create and modify charts and tables; import data from other sources; prepare support elements for a presentation; and broadcast a presentation on the
Web. L earn To:
Create and modify a chart. Create and modify an organization chart. Create and modify a table. Import data from other sources. Prepare support elements for a presentation. Broadcast a presentation
more...
SQL Server 7 0 - Implementing a Database - Part 3 

...t that combines table data. Perform the steps to combine data from more than two tables. Select the statement that joins a table to itself. Identify the characteristics of the
UNION operator. Perform the steps to create a single result set from multiple queries. Identify the characteristics of the
SELECT INTO statement. Perform the steps to create a temporary table. Unit 2:
Advanced more...
SQL and PL SQL PL SQL Basics 

...PL/
SQL programming conventions. Retrieve and manipulate data from the database by using PL/SQL commands
Identify features and attributes of SQL cursors, and manage transactions. Use the
IF-THEN-ELSE and
IF-THEN-ELSIF conditional constructs and the
Basic loop,
FOR LOOP, and WHILE LOOP looping constructs to control flow in PL/SQL code. Declare and reference PL/SQL records and PL/SQL
more...
SQL and PL SQL Basic SELECT 

...QL SELECT queries. Customize
SQL queries when selecting data from a table. Identify SQL*Plus environment, features, and commands. Restrict rows retrieved by a query. Identify comparison operators that can be used in defining row retrieval restrictions. Identify logical operators that can be used to define row retrieval restrictions. Sort rows retrieved by a query. Describe the
more...
SQL and PL SQL Data Retrieval Techniques 

...acle:
SQL and PL/SQL. This course describes how to access data from more than one table using joins and aggregating data using group functions. This course also describes how to embed a SQL statement in a clause of another SQL statement to enhance the power of SQL queries. In addition, how to use SQL*Plus commands to build on basic SQL statements and create customized queries that retrieve the
more...
IBM DB2 Universal Database V6 1--Fundamentals 

... to groups within a table for a given scenario. Retrieve data from multiple tables given a scenario. Enter data into a table using an
INSERT statement. Modify data in a table using an
UPDATE statement. Remove data from a table using a
DELETE statement. Identify considerations in embedding
SQL in applications for
DB2. Sequence the steps to prepare to run an application program. Unit 4:
more...
IBM DB2 Universal Database V6 1--Fundamentals 

... to groups within a table for a given scenario. Retrieve data from multiple tables given a scenario. Enter data into a table using an
INSERT statement. Modify data in a table using an
UPDATE statement. Remove data from a table using a
DELETE statement. Identify considerations in embedding
SQL in applications for
DB2. Sequence the steps to prepare to run an application program. Unit 4:
more...
Oracle SQL for End Users--Part 1 

...t 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 set. In this course, the learner creates basic SQL SELECT statements and customizes these queries to restrict and sort the results. In addition, the learner writes
more...
Oracle SQL for End Users--Part 2 

...cle:
SQL and PL/SQL. In this course, the learner displays data from multiple tables by using equijoins, non-equijoins, and self joins. In addition, this course introduces the use of group functions in a SQL statement to display information about groups of rows in the database. This course also covers how to embed subqueries in SQL statements. Finally, the learner creates interactive reports by
more...
Excel XP Expert User 

...k. Import a delimited text file. Import data from a fixed-width text file. Import data from a database. Audience The intended audiences for this course are
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 duties. They may be involved in working with
more...
Database Technologies Introduction to SQL 

...s, why and where it is used. o
Identify how to retrieve data from a database. o Identify how to order, limit, and group their query results using various
SQL clauses, keywords, and operators. o Identify how to use arithmetic operators, single row functions, and group functions to manipulate query data. o Identify how to retrieve database information using subqueries and joins. o
more...
Visual Basic NET-Web Based Development Part 3 

Assuming that the learner is now familiar with the basics of
Web forms and controls, this course introduces
ADO .NET and guides the learner through database connections and data access. Learn To: o To identify features of ADO.NET. o To ientify the syntax for importing ADO.NET namespaces. o To ientify features of the ADO.NET object model. o To identify features of
SQL Server security
more...