From Serebra Learning Corporation
Managing Data using Works 6 0 
...Data using
Works 6.0 course is the first course in the
Works Suite 2002 curriculum. This course acquaints the users with the applications of the
Works Suite and the different components of the Works application. It teaches the users to use the
Task Launcher to start various tasks in Works and complete them using different wizards and templates. Additionally, it explains the different components
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...
Exchanging Data with Excel 2007 
In
Excel 2007, there are a number of options for importing data and sharing data with other applications. Excel 2007 includes built-in functionality for importing 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
more...
Oracle SQL: Data Retrieval Techniques 
This course is the second in a three-part
Oracle series that is based on the
ILT course
Introduction to Oracle:
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
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...
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...
Computer Basics 
During the
1980a s
PCs were used independently as stand-alone computers. However businesses soon felt the need to share the information stored on one computer with other computers within the organization. To make it possible for computers to share information computers were connected together to form computer networks. When a computer is connected to a network several users have access to the
more...
Intermediate Java Programming 
This course gives an overview of the intermediate programming constructs in
Java. It teaches how to code simple programs using the java.lang and java.util packages, handle exceptions in a program, input and output data using the java.io package, and use multiple threads in a program. In addition, it prepares students to take the Sun Certified Java Programming Examination for
JDK 1.1.
more...
From 123-CBT Computer Based Training
Oracle9i Database Admin Manage Data Storage 

...e export modes, and the export paths. Reorganize data using export and import, identify the features and process of transportable tablespaces and the restrictions while using them. Audience The intended audience for this course include
Database administrators,
System administrators,
Network administrators, and
Technical support professionals. Additionally, learners should have
more...
Oracle9i SQL Data Retrieval Techniques 

...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 equijoin. o Identify the features of a group function.
more...
IBM DB2 Universal Database V6 1--App Development 

... 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 for table design and index design. Code combined
SQL statements using compound SQL. Create a local temporary table that can be
more...
IBM DB2 Universal Database V6 1--App Development 

... 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 for table design and index design. Code combined
SQL statements using compound SQL. Create a local temporary table that can be
more...
Oracle8i Performance Tuning Optimizing Sorts Minimizing Contention 

...ther, view and edit the input data, analyze the collected data using rules, review tuning recommendations and implement tuning recommendations. L earn To:
Determine the appropriate data block size. Optimize space usage within blocks. Detect and resolve row migration. Monitor and tune indexes. Recognize, diagnose, and resolve performance problems associated with sorts.
more...
Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention 

...ther, view and edit the input data, analyze the collected data using rules, review tuning recommendations and implement tuning recommendations.
L earn To:
Determine an appropriate block size, optimize space usage within blocks, detect and resolve row migration and monitor and tune indexes.
Identify the
SQL operations that require sorts, ensure that sorting is done in memory where
more...
Visual Basic 6 0 Designing Implementing Desktop Applications - Part 3 

...rds. 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 performance of batch updates. Create a dynamic recordset. Unit 2:
more...
Oracle Database 10g PL SQL Fundamentals Part 1 

...s, programming guidelines, and accessing and manipulating data using PL/
SQL. Additionally, the learner will also learn how to write and use PL/SQL program units, such as stored functions, stored procedures, and packages along with some standard
Oracle supplied packages and exception handling techniques in PL/SQL.
Learn To:
Identify features of PL/SQL.
Identify benefits of PL/SQL.
more...
Oracle Database Administration Workshop I Part 2 

Oracle
Database 10g is the first database designed for enterprise grid computing, the most flexible and cost-effective way to manage enterprise information. This course covers salient aspects of
Oracle Database 10g such as user and data management. The basic aspects of database management such as database integrity constraints, transferring data, and defining tables and schemas has been discussed
more...
Data Modeling - Develop Depth to Your Models 

...torical data.
Create an ER model to represent historical data using a business scenario.
Identify the characteristics of a
Data Warehouse.
Identify a
Fan trap within an ER Model.
Identify a resolution for a Fan trap.
Identify a chasm trap within an ER model.
Identify a resolution for a chasm trap.
Identify the problems caused by too much convergence in an ER model.
Identify the problems
more...
SQL Server 7 0 - Implementing a Database - Part 2 

...ndex. Sequence the steps
SQL Server takes when accessing data using a nonclustered index on a clustered index. Sequence the steps SQL Server takes to retrieve a range of information contained in a heap. Identify how SQL Server accesses a range of data using clustering keys. Select the guidelines which apply when using the
CREATE INDEX statement. Perform the steps to create a unique index.
more...
SQL and PL SQL Data Retrieval Techniques 

...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 information and display it in a format specified by the
more...
SQL and PL SQL DML and DDL 

...cts. Learners also learn how to insert, update and delete data using
SQL's
Data Manipulation Language, and learn to control database transactions. Finally, the course teaches how to control both user and object level security in an
Oracle database. L earn To:
Create tables and integrity constraints. Manipulate data using
DML. Alter tables and constraints. Create sequences.
more...
Access XP Expert User 

...is course covers the more complex aspects of working with data using
Access 2002. Assuming the learner is already proficient in
Access, the course covers advanced features of database queries, and enhancing forms and reports. Learn To Create an update query. Create a delete query. Create an append query. Create a form in
Design view. Modify
more...
Visual Basic NET-Web Based Development Part 3 

... 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. Unit 2: ADO.NET Data Access (3 - 4 hours) o Identify features of SQL Server security authentication.
more...
Navigating Oracle Applications 11i 

...Applications
11i Interface, navigation tips, manipulating data using
Find mode and
Query mode, and also accessing online help. Learners are taught to enter data, retrieve information in the form of a query, maintain data, use flexfields, and access online help. Additionally, this course covers concurrent processing and standard report submission.
Learn To:
Identify tasks to be
more...
Excel 2003 Fundamentals 

...er. Identify options for filtering data using
AutoFilter. Enter a basic formula. Identify methods for revising formulas. Identify types of cell referencing in formulas. Match
AutoSum menu commands with their descriptions. Identify categories in the
Insert more...
From Teach Me IT
Advanced PL/SQL Programming 

...sing PL/
SQL triggers
Apply database triggers
Manipulate data using cursors
Declare a cursor variable
Integrate transactions with database
Restrict database access by applying locks
Control user access
Define dynamic SQL
Use
DBMS_SQL to execute non-query
DDL and
DML statements
Use the DBMS_SQL package to execute queries
Identify the different types of exceptions
Handle user-defined
more...
Retrieving Data in SQL Server 2000 

...able to:
Insert and modify data in a database
Retrieve data using a simple
SELECT statement and with a
JOIN clause
Retrieve data based on conditions
Retrieve data using subqueries
Define, create, and modify views
Modify data through views
List the types of indexes
Create and manage indexes
Perform full-text search
List the types of stored procedures
Create, program, and execute
more...
Managing SQL Server 7.0 

...Identify the parts of a database
Create a database
Load data using
INSERT and
SELECT INTO statements
Load data using
SQL services
Describe the process of automated administration
Define jobs, operators, and alerts
Plan the security requirements for linked servers and databases
Manage security with linked servers
Design a replication model
Select a replication type
Configure the
more...
Managing Data using Works 6.0 

...Data using
Works 6.0 course is the first course in the
Works Suite 2002 curriculum. This course acquaints the users with the applications of the
Works Suite and the different components of the Works application. It teaches the users to use the
Task Launcher to start various tasks in Works and complete them using different wizards and templates. Additionally, it explains the different components
more...
Integrating Databases with ASP 3.0 

...s, methods, and collections of the
Command object
Access data using the Command object
Identify the properties of the
Recordset object
Identify the methods and collections of the Recordset object
Manipulate data in a Recordset object
List the properties and methods of
Record object
List the properties and methods of
Stream object
Identify the properties, method, and collection of
more...
Data Storage Manipulation in C 

Data
Storage Manipulation in C is the fourth course in the C Programming curriculum that consists of four courses. The course provides necessary skills that enable you to store data in the form of linked lists, binary trees, stacks, and queues. It also enables the students to perform bit-level operations.
Perform advanced memory operations in C
Identify the concept of linked lists
Store data
more...
Data Management in Excel 2000 

...orm calculations, and sorting, summarizing, and analyzing data using
Excel. After completing this course, the student will be able to:
Format cells in a worksheet
Format data in a worksheet
Format data with styles
Perform simple calculations on data
Write custom formulas
Use financial functions to perform calculations
Use date and time functions to perform calculations
Perform advanced
more...
Intermediate Java Programming 

...ackages, handle exceptions in a program, input and output data using the java.io package, and use multiple threads in a program. In addition, it prepares students to take the Sun Certified Java Programmer Examination for
JDK 1.1. After completing this course, the student will be able to:
Write programs using the java.lang package
Use exception handling in a program
Write the code for
more...
Creating Queries & Forms with Access 2002 

...ly, this course guides users in efficient presentation of data using
PivotTables and
PivotCharts. After completing this course, the user will be able to:
Create simple queries
Perform calculations in queries
Specify selection criteria
Create special purpose and action queries
Create
SQL specific queries
Identify the components of a form design window
Create a form and add data controls,
more...