|
Training Classes
| Learning and Development Resources
| Training Directory
| New Training Seminars
| New Training Providers
| Site Map
| Promote Training Seminars
|
Training Keywords
| Training Seminars
| Training Providers
| Regions
|
| Advertise Training Seminars
| Login
|
||||||||||
Data From Training Seminars and Classes
From Online Training Directory
Excel 97 Level 3
    This advanced level course introduces the accomplished Excel user to the most powerful aspects of Excel. Some topics that will be covered include adjusting default settings; creating views and custom toolbars; protecting worksheets and applying passwords; and importing data from other applications. more...Microsoft Excel 2002 Expert
In this expert-level course, students will learn about summarizing list data with outlining and subtotals; creating and removing custom filters; implementing techniques for working with shared workbooks; tracking and reviewing changes; and merging and consolidating data from worksheets. They will also learn how to customize the Excel working screen with custom toolbars, menus, and macros. more...Microsoft PowerPoint 2002 Level 3
This course is designed to familiarize students with the advanced features of Microsoft PowerPoint 2002. Students will learn how to apply advanced techniques to PowerPoint presentations, such as importing data from other Microsoft applications, adding video and sound clips, and modifying charts and tables in presentations. more...
From Serebra Learning Corporation
Microsoft Excel 2000 Expert User
This course provides participants the knowledge to use the advanced features of Microsoft Excel 2000. At the completion of this course, students will learn how to create and use templates; retrieve, sort and manipulate data from a list; create and modify shared workbooks; and analyze data by using Data Map, Pivot Table, Data Table Scenario and Data Analysis tools. more...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...Designing and Implementing Desktop Applications with Microsoft Visual Basic 6.0 - Part 1
This is the first course in a five part series that will provide students with the knowledge to write a Microsoft Visual Basic-based application that accesses data from a database. In this course, students will be introduced to the Visual Basic environment and its main options and characteristics. Students will also learn the strategy for Universal Data Access and the visual data access tools that more...Designing and Implementing Desktop Applications with Microsoft Visual Basic 6.0 - Part 2
This is the second course in a five part series that will provide students with the skills to write a Microsoft Visual Basic-based application that accesses data from a database. In this course, students will learn to use class modules to define and create an instance of a component. Students will also be provided with the basic instruction on the ActiveX Controls feature of Visual Basic 6.0. more...Designing and Implementing Desktop Applications with Microsoft Visual Basic 6.0 - Part 3
This is the third course in a five part series that will provide students with the knowledge to write a Microsoft Visual Basic-based application that accesses data from a database. In this course, students will learn to use ActiveX Data Objects to access and manipulate data sources. This course also addresses advanced database issues, such as data integrity and referential integrity. more...Designing and Implementing Desktop Applications with Microsoft Visual Basic 6.0 - Part 4
This is the fourth course in a five part series that will provide students with the knowledge to write a Microsoft Visual Basic-based application that accesses data from a database. In this course, students will learn to use ActiveX Data Objects to access and manipulate data sources. This course also addresses advanced database issues, such as data integrity and referential integrity. more...Designing and Implementing Desktop Applications with Microsoft Visual Basic 6.0 - Part 5
This is the final course in a five part series that will provide students with the knowledge to write a Microsoft Visual Basic-based application that accesses data from a database. In this course, students will learn to use ActiveX Data Objects to access and manipulate data sources. This course also addresses advanced database issues, such as data integrity and referential integrity. more...Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 4
This is the fourth course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the methods of aggregating and accessing data from relational data structures; identify the methods of data access from more...Win2000 Professional Recovering Data and Systems
...miliar with the procedure for creating backups, restoring data from backups, and repairing disks using Emergency Repair Disk (ERD), as well as troubleshooting system errors with the help of the Recovery Console. Finally, the course deals with the concepts of Safe mode and various options included in it, as well as with Stop errors and configuring the system for responding to Stop errors.Related 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...Data Warehousing
This course will provide an overview of Data Warehousing, an emerging technique for storage and retrieval of data from distributed heterogeneous sources. Students will be given an overview of Data Warehousing, study the various components of Data Warehousing Systems, and learn how to build, use and maintain a Data Warehousing System. Information systems managers, database administrators and other more...Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g
To demonstrate how to retrieve data from multiple tables using joins and how to use set operators in Oracle 10g databases Database administrators, application developers, and database operators 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 - Intro to RDBMS and SQL *Plus
The course aims to familiarize you with the basic concepts of database design. The course also provides a brief overview of relational database model since the Oracle database is based on this model. The course familiarizes you with the use of SQL and SQL *PLUS commands. The course will enable you to construct queries using SELECT statement with clauses such as WHERE ORDER BY and DISTINCT. You 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...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...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...MS Office 2000: Access for Professionals I
This course teaches the student how to create a database and add tables and records to the database. The student will also learn how to retrieve data from a database using filters. more...Mastering MS PowerPoint 97
This course teaches the student the advanced features of PowerPoint, how to effectively create professional presentations using charts, ClipArts, drawings, and data from other Office applications. more...Microsoft Access 2000 Designing and Implementing Database Applications Part 2 - Handling Data
This is the second course in a five-part series that will provide IT professionals with the knowledge and skills necessary to design and implement database solutions using Microsoft Access 2000. At the completion of this course students will learn to retrieve data from an Access 2000 database; customize forms use forms to accept validated data and navigate between controls and records in a form; 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...Oracle SQL Specifics: Retrieving and Formatting Data
This course is the first in a two-part series on Oracle SQL Specifics that will teach participants how to use commands functions and operators supported by Oracle as extensions to standard SQL. Students will be introduced to the Oracle implementation of the relational database management system (RDBMS) and the object-relational database management system (ORDBMS). Users will learn how SQL 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...SQL Server 2000 Design Implement Databases Part 5 Dist Data Locks
This is the final course in a five part series that teaches how to manage SQL Server 2000 transactions and locks. This course will cover how to import and export data, and how to transform data with DTS. Additionally, users will learn how to manage distributed queries and linked servers, create transactions, manage locks, and how to troubleshoot transactions and locking. Learn To: o Identify 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--Administration
Course Overview This course will provide database administrators with the specific skills and knowledge needed to be successful with DB2 Universal Database (UDB) V6.1 database administration in a UNIX, Windows, or OS/2 environment. This course will teach students the critical skills needed for designing a new DB2 implementation and maintaining an existing database. L earn To: Implement more...IBM DB2 Universal Database V6 1--Administration
Course Overview This course will provide database administrators with the specific skills and knowledge needed to be successful with DB2 Universal Database (UDB) V6.1 database administration in a UNIX, Windows, or OS/2 environment. This course will teach students the critical skills needed for designing a new DB2 implementation and maintaining an existing database. L earn To: Implement 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...Windows 2000 Network Infrastructure Admin --Part 1 DHCP DNS WINS
...ard disk by using the Backup Wizard. Restore DHCP server data from a hard disk by using the Restore Wizard. Sequence the steps to back up a DHCP database on a DHCP server. Sequence the steps to restore a DHCP database from a DHCP server. Update the statistics of a DHCP server by using the Action menu. Enable address conflict detection on a DHCP server by using the Action menu. Sequence more...Windows 2000 Network Infrastructure Admin --Part 1 DHCP DNS WINS
...ard disk by using the Backup Wizard. Restore DHCP server data from a hard disk by using the Restore Wizard. Sequence the steps to back up a DHCP database on a DHCP server. Sequence the steps to restore a DHCP database from a DHCP server. Update the statistics of a DHCP server by using the Action menu. Enable address conflict detection on a DHCP server by using the Action menu. Sequence 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...Windows NT 4 0 Administration Fundamentals - Part 2
...monitor the server resources. Make backups and restore data from a tape. C ontent Emphasis Skills-Based A udience This course is inteneded for IT Professionals who perform post-installation administration of Windows NT Server and Windows NT Workstation, including management of accounts, account policies, disk resources, printers, servers, backups, configurations and more...Windows NT 4 0 Administration Fundamentals - Part 2
... monitor the server resources. Make backups and restore data from a tape. C ontent Emphasis Skills-Based A udience This course is inteneded for IT Professionals who perform post-installation administration of Windows NT Server and Windows NT Workstation, including management of accounts, account policies, disk resources, printers, servers, backups, configurations and more...Windows NT 4 0 Administration Curriculum
Course Overview
This course series presents the prerequisite knowledge for individuals seeking MCSE certification. To become a Microsoft Certified Systems Engineer you are required to pass four operating systems exams and two elective exams that provide a valid and reliable measure of technical proficiency and expertise.
L earn To:
Microsoft Class - 803 Administering Microsoft Windows more...Windows NT 4 0 Administration Curriculum
Course Overview
This course series presents the prerequisite knowledge for individuals seeking MCSE certification. To become a Microsoft Certified Systems Engineer you are required to pass four operating systems exams and two elective exams that provide a valid and reliable measure of technical proficiency and expertise.
L earn To:
Microsoft Class - 803 Administering Microsoft Windows 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...Working with SAP R 3 v4 x
...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 Primary Audience: Business Users of all SAP R/3 applications Secondary Audience: IS Support staff and SAP Project Team members needing training in use of the basic SAP system functions. more...Frontpage 2000 Expert User
C ourse Overview This course prepares IT Professionals to create, organize and manage a Web using FrontPage 2000. L earn To: Import and modify an existing Web. Customize a FrontPage Web. Client-server interaction. C ontent Emphasis Skills-Based A udience This course is intended for end users using Microsoft FrontPage 2000. Participants should have a basic more...Frontpage 2000 Expert User
Course Overview This course prepares IT Professionals to create, organize and manage a Web using FrontPage 2000. L earn To: Import and modify an existing Web. Customize a FrontPage Web. Client-server interaction. C ontent Emphasis Skills-Based A udience This course is intended for end users using Microsoft FrontPage 2000. Participants should have a basic more...SQL Server 7 0 Designing and Implementing Data Warehouses - Part 4
...earn to identify the methods of aggregating and accessing data from relational data structures; identify the methods of data access from multidimensional data structures; identify the features and functionality of Pivot Table Service, Local Cubes, Client/Server Cache; identify the features of MS English Query; and create and deploy an English Query application. L earn To: Identify the more...SQL Server 7 0 Designing and Implementing Data Warehouses - Part 3
... a Data Transformation Services (DTS) package to transfer data from a Microsoft SQL Server 7.0 database to a data warehouse database. Unit 2: Replication Duration: 1 - 2 Hour(s) Create a publication in a SQL Server 7.0 database by using the Enterprise Manager. Create a Microsoft Access data mart for subscribing to a publication by using the Program Manager. Set up a Microsoft 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 C 6 0 Designing Implementing Distributed Applications - Part 3
...tegrity and import data. Write SQL statements to access data from tables and manipulate the data. Implement data access in applications through stored procedure model and cursors. Create transactions and implement locking strategies. C ontent Emphasis Skills-Based A udience This course is designed for programmers looking to develop applications using MFC library and more...Visual C 6 0 Designing Implementing Desktop Applications - Part 5
...ment environment. L earn To: Store and retrieve data from a file and registry by using MFC. Implement remote communication by using the Socket and Serial connection. Create applications using MFC classes to access and manipulate a database by adding records, deleting records and editing records. Create ADO database applications for accessing and manipulating a database in the more...Visual Basic 6 0 Designing Implementing Distributed Applications - Part 3
...ements in SQL. Identify the query command that retrieves data from joined tables. Add a Data Environment to a Visual Basic Project using the Add Data Environment command. Establish a connection to a SQL Server database using the Data Link Properties dialog box. Display the structure of a SQL Server database. Create a SQL Stored Procedure. Display the T-SQL Debugger for debugging a SQL more...Visual Basic 6 0 Designing Implementing Desktop Applications - Part 5
... a Microsoft Visual Basic-based application that accesses data from a database. In this course, students will learn to use ActiveX Data Objects to access and manipulate data sources. This course also addresses advanced database issues, such as data integrity and referential integrity. L earn To: Optimize the usability and performance of an application. Use the tools provided with more...Visual Basic 6 0 Designing Implementing Desktop Applications - Part 4
... a Microsoft Visual Basic-based application that accesses data from a database. In this course, students will learn to use ActiveX Data Objects to access and manipulate data sources. This course also addresses advanced database issues, such as data integrity and referential integrity. L earn To: Use external COM components to extend the functionality of a Visual Basic 6.0 application. more...Visual Basic 6 0 Designing Implementing Desktop Applications - Part 3
... a Microsoft Visual Basic-based application that accesses data from a database. In this course, students will learn to use ActiveX Data Objects to access and manipulate data sources. This course also addresses advanced database issues, such as data integrity and referential integrity. L earn To: Use ActiveX Data Objects to access and manipulate data sources. Understand SQL Server more...Visual Basic 6 0 Designing Implementing Desktop Applications - Part 2
... a Microsoft Visual Basic-based application that accesses data from a database. In this course, students will learn to use class modules to define and create an instance of a component. Students will also be provided with the basic instruction on the ActiveX Controls feature of Visual Basic 6.0. L earn To: Create a COM component that exposes properties, methods and events. Create more...Visual Basic 6 0 Designing Implementing Desktop Applications - Part 1
... a Microsoft Visual Basic-based application that accesses data from a database. In this course, students will be introduced to the Visual Basic environment and its main options and characteristics. Students will also learn the strategy for Universal Data Access and the visual data access tools that make it easy for Visual Basic programmers to create data access applications. L earn To: more...Visual InterDev 6 0 Accessing Remote Data
...ing Data Services
Duration: 1 - 2 Hour(s)
Retrieve data from a database by using Microsoft ISQL_w of Microsoft SQL Server 6.5.
Add a record to a database table by using Microsoft ISQL_w of Microsoft SQL Server 6.5.
Update a record from a database table by using Microsoft ISQL_w of Microsoft SQL Server 6.5.
Delete a record from a database table by using Microsoft ISQL_w of Microsoft more...Visual InterDev 6 0 Accessing Remote Data
...ing Data Services
Duration: 1 - 2 Hour(s)
Retrieve data from a database by using Microsoft ISQL_w of Microsoft SQL Server 6.5.
Add a record to a database table by using Microsoft ISQL_w of Microsoft SQL Server 6.5.
Update a record from a database table by using Microsoft ISQL_w of Microsoft SQL Server 6.5.
Delete a record from a database table by using Microsoft ISQL_w of Microsoft 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 Visio 2003 Expert User
...perties of layers in Microsoft Visio 2003.
Export shape data from a Microsoft Visio 2003 drawing to an existing Open Database Connectivity (ODBC)-compliant database.
Link a shape in Microsoft Visio 2003 to a record in an existing database table.
Create new master shapes from each record in a database table using the Database Wizard.
Audience:
This course is intended for personnel 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...Excel 2000 Expert User
...o create and use templates; retrieve, sort and manipulate data from a list; create and modify shared workbooks; and analyze data by using Data Map, Pivot Table, Data Table Scenario and Data Analysis tools. L earn To: Create and use templates. Retrieve, sort and manipulate data from a list. Create and modify shared workbooks. Analyze data by using Data Map, Pivot Table, Data 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 System Administration - Part 4
...uration: 2 - 3 Hour(s)
Identify the steps for copying data from one environment to another.
Select the tasks that are done when transforming data.
Match data transfer tool names with uses.
Identify the features of Data Transformation Services (DTS).
Identify data source and data destination types provided in SQL Server.
Match each Data Transformation Services (DTS) tool with its 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...XML Building XML-Based Web Applications Part 1
...49; Identify advantages of using XML data islands to send data from a Web server to a client computer. • Identify features of binding XML data to HTML elements. • Identify features of binding XML data to an HTML table. • Identify features of the Document Object Model (DOM). • Identify common DOM objects. • Identify the syntax to access an XML data island by more...XML Building XML-Based Web Applications Part 2
...ript in an ASP page. • Identify ways of submitting data from HTML forms. • Identify features of the Request object. • Identify features of the Response object. • Identify features of the maintenance of state in ASP. • Create and use an ASP. • Identify features of the ActiveX Data Objects (ADO) interface. • Identify features of the Connection more...Crystal Reports 8 5 Introductory Report Design Part 2
...eate a report alert by using the Report menu. • Add data from a database to a report by using the menu bar. • Link database tables by using the Visual Linking Expert window. • Create a dictionary by using the Crystal Reports Tools menu. • Create a SQL query by using the Create SQL Expert dialog box. Unit 2: Sections and Cross-Tab Objects 2 - 3 hours • Insert more...SAP R 3 PP Production Planning SOP
The Computer Based Training (CBT) SAP R/3 PP: Production Planning and SOP describes the production planning process and explains how it works. The learner is introduced to the various planning levels in the R/3 System as well as learning how to plan in the Sales and Operation Planning and Material Requirement Planning levels. Furthermore, the trainer will be shown the functions of standard SOP and more...SAP R 3 PP Program Planning MP MRP
...assembly Planning. o Selected Functions of MP: - Copying Data from SOP. - Version Management. - Additional Functions in MP. o Long-Term Planning: - Long-Term Planning. - The Planning Run in Long-Term Planning. - Interactive Requirement Evaluations. - Long-Term Planning Functions. Unit 2: Results and Functions in MRP 1.5 - 2 hours o Planning Results at the MRP Level: - Results at the MRP 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...Visual Basic NET-Distributed Applications Part 3
...efits of ADO.NET. a To sequence the steps to read data from a database in a connected environment. a To identify features of DataSets. a To identify the syntax for creating a DataSet programmatically. a To identify the syntax for saving a DataSet. a To identify features of XML Schema Definition (XSD). a To generate an XML Schema Definition (XSD). more...Windows 2000 Implementing Security Part 5
... • Identify methods for protecting data from viruses. • Match network communication risks with their descriptions. • Identify risks to a physical network. • Identify costs of network encryption. Unit 3: Troubleshooting and Security Incidents (2 hours) • Identify more...XML Building XML-Based Web Applications Part 4 ...r features. • Identify properties used to retrieve data from a node. • Identify features of the XML parser. • Identify ways of accessing XML data in a DOM document. Unit 2: Manipulating and Displaying XML Data 2 - 3 hours • Identify ways of searching for element nodes in the DOM tree. • Identify syntax for accessing the content o | ||||||||||
