Online Data From eLearning

Excel 2002 Advanced ...Introduction Lesson Objectives Opening Excel Importing Data From A Web Page The New Web Query Dialog Box Selecting A Table Navigating Pages Web Query Options Saving A Web Query Placing Data The External Data Toolbar Editing A Query Data Range Properties Refreshing Data Running A Saved Query Full Screen View Sorting Data Then By Sorting Using AutoFilter Using Custom AutoFilter  more...

Data Classification and Collection in Six Sigma ...tep in any Six Sigma improvement journey. As such, sample data from existing processes needs to be identified, collected, presented, and analyzed. Collecting data that is correct and useful is one of the first steps in the measurement process. Various types of data exist, and they all need appropriate treatment during the collection, presentation, and analysis stages. You also need to be  more...

Discover Access 2007 Level 3 ...se Table Working With Linked Tables Export Data From Access Exporting Data Export Data QUIZ 3. MANAGE AN ACCESS DATABASE File Formats & Compatibility New Access 2007 File Format Saving An Access 2007 Database In An Earlier Version Converting A Database to Access 2007 Format Database Security  more...

Discover Excel 2007 Level 3 Discover Excel 2007: Level 3 Microsoft Discover Excel 2007 from Technology Skills is a rich, multimedia learning tool for users of Microsoft Excel 2007. Excel 2007 builds on the spreadsheet capabilities of previous versions of the software program to provide powerful tools for creating and sharing professional worksheets through a fresh and efficient new look. Topics cover basic spreadsheet  more...

Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g Oracle To demonstrate how to retrieve data from multiple tables using joins and how to use set operators in Oracle 10g databases  more...

Oracle Database 11g Conversion Functions Group Functions and Joins Oracle Database 11g: Conversion Functions, Group Functions, and Joins Oracle To recognize the steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return values from more than one table.  more...

Outlook XP Proficient Expert Outlook XP Proficient & Expert Microsoft DiscoverWare's Discover Outlook XP is an interactive productivity tool for users of Microsoft Outlook XP. Outlook XP is a desktop information management program that combines e-mail, scheduling features, task management, and contact management. Outlook XP also contains collaboration tools, so information can be shared more effectively. Outlook XP /  more...

Excel XP Proficient Expert ...ort & Export Data - Use The Office Clipboard - Import Data From Text Files - Get Data From A Web Page - Use Data From Other Applications - Publish A Worksheet - Export To Other Applications Work With Multiple Workbooks - Use A Workspace - Data Consolidation - Consolidate Data - Link Consolidated Data - Consolidate Data From Multiple Workbooks Format Worksheets  more...

Access XP Proficient Expert ...o Access - Importing Data - Into A New Table Export Data From Access - Exporting Data - Export Data Publish A Database To The World Wide Web - Access & The World Wide Web - Data Access Pages - Create A Data Access Page Access XP / 2002 (Expert) Build & Modify Databases Build A Relational Database - Defining Relationships - Establish A One-To-Many Relationship -  more...

Creating Business Intelligence Solutions with MOSS 2007 ...xcel Services, create trusted workbook locations, process data from Windows SharePoint Services, and how to utilize reporting and key performance indicators in MOSS 2007. This course is one of a series in the SkillSoft learning path that covers the objectives for the Technology Specialist (TS): Microsoft Office SharePoint Server 2007 Application Development 70-542. Passing this exam will earn  more...

Integrating Business Data Using MOSS 2007 ...g the Business Data Catalog BDC, how to display and index data from external sources using the BDC, and how to use the BDC to interact with entities. This course is one of a series in the SkillSoft learning path that covers the objectives for the Technology Specialist (TS): Microsoft Office SharePoint Server 2007 Application Development 70-542. Passing this exam will earn the learner the MCTS:  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...

WPF Databinding with VB 2008 ...s Presentation Foundation (WPF) allows you to incorporate data from multiple sources into the user interface. This course details how WPF not only binds controls to data, but also converts, validates, and formats data in a variety of ways. Specific areas covered include binding to elements, using multiple bindings, utilizing ADO.NET data objects, formatting the display of data, and also data  more...

SQL Server 2008 Data Management ... need to be split to allow for more data to be stored, or data from one partition may need to be moved to another partition. SQL Server 2008 provides Transact-SQL statements to ensure that administrators can perform these tasks to manage the table partitions. SQL Server also provides data compression at the table row and page level. Indexes can be created to allow for the quick retrieval of  more...

Creating Modifying Table Index Partitions in SQL Server 2008 ...L Server 2008 allows views to be partitioned, which joins data from multiple tables from one or more servers. The data is returned as one set of information, making it appear as if it were from one table within one database. When partitioned views are used to access multiple tables from various servers they are known as distributed partitioned views. These are used to gather data from  more...

Running Queries Manipulating Data in SQL Server 2008 ...Management Studio tool. Using Transact-SQL you can select data from a database s tables and filter the results to include only the data that you require. Transact-SQL statements also allow you to update, change, and remove data from tables. This course identifies the basic T-SQL statements that can be used to retrieve and modify data within SQL Server databases. This course is one of a series  more...

Querying Managing XML Data inSQL Server 2008 ... provides support for using FOR XML to extract relational data from a database in XML format and the use of OPENXML to generate relational views from XML. This course demonstrates how to use the xml data type, XML schema collations, and how to create XML indexes. It also explores how to retrieve data using FOR XML, process XML data using OPENXML, and how to query data using the XQuery language.  more...

Oracle 11g Conversion Funct Conditional Expressions Group Funct Joins Oracle 11g: Conversion Funct., Conditional Expressions, Group Funct. & Joins Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To recognize the steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return values from more than one table.  more...

Excel 2002 This course introduces students to basic spreadsheet features and acquaints them with the tools used in Microsoft Excel 2002. As the course becomes more advanced, students will learn how to customize workbooks by changing worksheet attributes, use lists to store and organize data, use functions in financial and logical formulas, and format worksheets using AutoFormat and predefined styles.  more...

Excel 2002 MOUS This comprehensive course teaches students the basic and intermediate features of Excel 2002 so they can easily create and modify spreadsheets. Some skills users will acquire include learning to manage workbooks, working with cells and cell data, formatting and printing worksheets, creating and revising formulas, creating charts from worksheet data, learning about objects and their roles in  more...

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 ...king 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. This course teaches students a set of expert-level spreadsheet features through real-life scenarios and projects. Students will learn about summarizing list data with outlining and subtotals; creating and  more...

Microsoft Excel 2002 Level 3 This course teaches students a set of expert-level spreadsheet features. Some skills students will acquire are summarizing list data with outlining and subtotals; customizing the Excel working screen with custom toolbars, menus, and macros; and creating and removing custom filters. This course teaches students a set of expert-level spreadsheet features. Students will learn about summarizing list  more...

Microsoft PowerPoint 2002 Comprehensive ...ges and drawing tools to enhance presentations, importing data from other Microsoft applications such as Word or Excel, adding video and sound clips, and modifying charts and tables in PowerPoint presentations. Students will also learn how to customize PowerPoint to maximize its potential for the type of work they do, such as customizing toolbars, color schemes, and indent settings. Finally,  more...

Microsoft PowerPoint 2002 Level 3 ...techniques to PowerPoint presentations, such as importing data from other Microsoft applications, adding video and sound clips, and modifying charts and tables in presentations. This course is designed to familiarize students with the advanced features of Microsoft PowerPoint 2002. Generally, students will learn how to apply advanced techniques to PowerPoint presentations, such as importing  more...

Office XP (2002) Advanced This advanced course introduces students to some new features of Microsoft Office XP. It covers the major features that apply to all of the applications. This includes Microsoft Word, Microsoft PowerPoint, Microsoft Excel, Microsoft Access, Microsoft Outlook, as well as a special course on time management. The goal of this advanced course is to broaden and develop the intermediate skills that the  more...

PowerPoint 2002 This course begins by introducing students to the basic features of PowerPoint 2002. They will learn how to design PowerPoint presentations on their computers how to use clip art images and drawing tools to enhance their presentations. Finally, students will learn advanced presentation skills including how to create a custom show, an agenda, and summary slides. This course introduces students to  more...

Cisco CCNA Configuring Frame Relay and ISDN ...with bandwidth. It examines the process for transmitting data from the source to the destination over a Frame Relay network. Frame Relay terms, such as virtual circuits and Data Link Connection Identifier (DLCI) are introduced, and the format of a Frame Relay frame is explained. This unit also discusses the mechanisms of controlling congestion in a Frame Relay network. This unit introduces two  more...

Java 2 -- Applets & Imaging This course contains 4 units: Applets, Advanced Applets, 2d Graphics and Printing in Java, and Imaging. Each unit covers detail the elements of Java necessary to implement these features and functions as you program in the Java language. The first unit defines an applet and lists the features of an applet. You will learn about the Applet class, its hierarchy, and its methods. You will also  more...

Flash MX ActionScript ...rking with Arrays pt. 1 Working with Arrays pt. 2 Getting Data From an Array Modifying An Object With ActionScript Creating a Movie Clip Creating Movie Clip Instances Using the Set Property Action Changing an Object's Properties pt. 1 Changing an Object's Properties pt. 2 Getting an Object's Properties Using ActionScript with Text Creating Input Text Blocks Creating Dynamic Text Blocks Loading  more...

PowerPoint 2000 Advanced ...rounds 1.2 Applying Diagonal Borders to a Table 2.0 Using Data from other Sources (20 Minutes) 2.1 Exporting an Outline to Word 2.2 Importing an Outline from Word 2.3 Adding a Table from Word 2.4 Inserting an Excel Chart 2.5 Adding Sound 2.6 Adding Video 3.0 Creating Output (12 Minutes) 3.1 Saving a Slide as a Graphic 3.2 Generate Meeting Notes 3.3 Changing the output format ( Page Setup ) 3.4  more...

PowerPoint 2000 Set of 3 ...rounds 1.2 Applying Diagonal Borders to a Table 2.0 Using Data from other Sources (20 Minutes) 2.1 Exporting an Outline to Word 2.2 Importing an Outline from Word 2.3 Adding a Table from Word 2.4 Inserting an Excel Chart 2.5 Adding Sound 2.6 Adding Video 3.0 Creating Output (12 Minutes) 3.1 Saving a Slide as a Graphic 3.2 Generate Meeting Notes 3.3 Changing the output format ( Page Setup ) 3.4  more...

Microsoft Visio 2003 Expert User ...erties 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  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  more...

Visual InterDev 6 0 Accessing Remote Data ... 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  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...

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  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...

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  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)  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  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...

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...

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 ...ation: 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...

Visual InterDev 6 0 Accessing Remote Data ... 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 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 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 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...

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...

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 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...

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...

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...

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...

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...

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...

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...

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...

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 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 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 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 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...

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  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 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...

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--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--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...

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 of an element in the DOM  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...

CIW Fundamentals of CGI Using Perl Part 2 Advanced Features Course Overview This is the second course in a two part series that presents students with both theoretical and practical instruction on managing files and databases. This course will cover manipulating files, databases, and CGI security issues. Learn To • Identify the syntax used to save form data by using the param method. • Identify characteristics of the save method.  more...

CIW Dynamic Server Pages Part 3 ...orrect sequence of events that occur when a user accesses data from a data source. • Identify the code that uses the appropriate properties and methods of the Connection object for a specified scenario. • Identify the code that uses the appropriate properties and methods of the RecordSet object for a specified scenario. • Identify the code that uses the appropriate properties,  more...

SAP R 3 Structure Operation This course describes the structure of the R/3 System and how it works. The SAP R/3 System explains what SAP R/3 means, and describes the kinds of companies in which it can be used, as well as the system architecture on which it is based. Additionally, it will describe how the trainee will be introduced to R/3 as an integrated system, as well as its organizational structure, and components. The  more...

Excel 2003 Expert Part 1 ...mport data to Excel. To export data from Excel. To group, outline, and consolidate data from two or more worksheets in Excel. Audience The target audience will range from new users to power users. It is expected that the vast majority of learners will have at least had some exposure to previous versions of Excel. Fundamental PC and  more...

Oracle Database 10g PL SQL Fundamentals Part 3 ... Binary Files (BFILEs). Identify features of migrating data from the LONG data type to the Large Object (LOB) data type. Identify features of the DBMS_LOB package. Identify the code to work with Large Object (LOB) values. Identify methods of selecting Character Large Object (CLOB) values. Identify features of temporary Large Objects (LOBs). Unit 2: PL/SQL Design  more...