Online Stored eLearning

Cryogenic Safety ...ures, cryogenic materials can be hazardous if handled and stored incorrectly. Any employees handling cryogenic materials must wear personal protective equipment. If employees are exposed to the extreme cold of cryogenic materials they should receive treatment immediately to prevent permanent injury. In the event that an individual inhales cryogenic materials, he should seek immediate attention  more...

Creating Stored Procedures and Functions Creating Stored Procedures and Functions Oracle To create and execute a stored function and call, and remove and view stored functions in PL/SQL  more...

Record Retention Record Retention Does your company have a formal policy for how to retain and dispose of its records? Do you know what records you need to retain, how long you should retain them for, and which disposal techniques you should use? Following the Arthur Andersen case, many companies are reexamining what documents they keep and how long they must keep them. Having a carefully planned and  more...

IT Project Management Essentials Testing Deliverables Closing IT Projects IT Project Management Essentials: Testing Deliverables & Closing IT Projects Because it's a significant point in an IT project, the closing phase has its own set of processes and activities. When a project manager carries out those activities and processes, he or she can demonstrate that the project goal has been met and provide the team with a sense of accomplishment. In addition, carrying  more...

Oracle Database 11g R2 The RMAN Catalog Creataing Backups ...alog to store metadata about Oracle databases, and allows stored scripts to be used to run sequences of RMAN commands stored in the catalog. When administering an Oracle Database, it is important to be familiar with what a backup is, how the process of creating a backup is completed, and the various types of backups available. This knowledge allows you to make an informed decision on the best  more...

SAP BusinessObjects Overview ...enterprise can possess is data - information acquired and stored in the process of carrying out everyday business activities. This includes data regarding customers and potential customers, employee-related information, data gathered concerning competitors, and information pertaining to products. In order to take full advantage of its information assets, an enterprise must be able to store and  more...

SAP Product Lifecycle Management SAP Product Lifecycle Management SAP SAP Product Lifecycle Management (PLM) provides a comprehensive solution for managing all product-related information required in support of processes including planning, innovation, design, quality management, and engineering. As an integrated solution to SAP's enterprise resource planning (ERP) system, all information stored and maintained using the PLM  more...

SAP BusinessObjects Crystal Reports ... Business data comes from a variety of sources and is stored in various formats. The volume and variety of business data presents immense potential for understanding and responding to customer requirements and business process optimization. In order to realize this potential, SAP provides the Crystal Reports reporting tool. Crystal Reports has supplanted the BusinessExplorer report designer  more...

Microsoft Office 2007 Collaborating with Groove and Communicator ...oove brings small teams together in virtual 'workspaces', stored on each team member's desktop. All the files the team needs for collaboration are stored in these workspaces and are updated after each change whether the team member is online or offline. Office Communicator extends these capabilities by enabling those in different locations and time zones to communicate easily and quickly with a  more...

Managing ADO NET Connections Commands with VB 2008 ...sing connection pools and configuration files, as well as stored procedures, and using generic data-access code to establish a connection. Specific topics covered include optimizing ADO.NET connections and commands, ADO.NET transactions, and working with Multiple Active Result Sets (MARS) and asynchronous commands. This course is one of a series in the SkillSoft learning path that covers the  more...

SQL Server 2008 Data Management ...provides table and index partitioning to allow data to be stored across multiple filegroups within a database. This makes tables and indexes that contain large amounts of data more manageable. Partitions in the database may 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  more...

Creating Modifying Table Index Partitions in SQL Server 2008 ...must be contained within a single filegroup. Data that is stored within partitions is treated as a logical entity, and the partitioned tables and indexes support the same properties as a standard table. SQL 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  more...

Performing Advanced Query Techniques in SQL Server 2008 ...atures that manage international concerns with regards to stored data, such as the collation and sort order. This course demonstrates how to perform advanced query techniques to manipulate data. It also identifies how to work with the COLLATE clause to manage international considerations when working with data. This course is one of a series in the SkillSoft learning path that covers the  more...

Creating Implementing Programming Objects in SQL Server 2008 ...ects within a database. These programming objects include stored procedures, functions, and triggers (based on either DML or DDL statements). SQL Server 2008 provides integration with Common-runtime language (CLR). This enables a developer to create programming objects using any of the Microsoft .NET Framework languages and then deploy them within SQL Server using assemblies. This course  more...

Querying Managing XML Data inSQL Server 2008 ...n integrated into SQL Server 2008 so that XML data can be stored within databases using the XML data type. You can query this data using the XQuery language within the XML data type methods. SQL Server 2008 also 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  more...

Querying Cubes Working with Data Mining in SSAS ...ndicators (KPI), Actions, Perspectives, Translations, and Stored Procedures. In addition, this course introduces data mining. It looks at the logical and physical architecture of data mining including data mining structures, models, and algorithms. Tools related to data mining such as the Data Mining Wizard, Data Mining Designer, and SQL Server Management Studio will also be discussed in this  more...

Oracle Database 11g Using Exceptions Subprograms JDeveloper REF Cursors Oracle Database 11g: Using Exceptions, Subprograms, JDeveloper & REF Cursors Oracle To recognize ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables.  more...

Oracle Database 11g Optimizer Statistics Hints Cursor Sharing ...et results in many versions of almost identical SQL to be stored in the library cache. If, instead of issuing different statements for each literal, you use a bind variable, then in theory that extra parse activity is eliminated. Listing the benefits of using bind variables, as well as using bind peeking and adaptive cursor sharing are examined in this course. Optimizer hints enable you to  more...

Oracle Database 11g R2 Oracle Partioning Security Features ...ion enhancements, which includes support for loading data stored in compressed files, new parameters for simplified parallelism implementation, and new partitioning methods. It also covers the security and networking enhancements, including how to use SecureFiles, the password file, default auditing, and tablespace encryption, as well as network support for IPv6 and configuring fine-grained  more...

Managing ADO NET 4 Connections Commands with C 2010 ...sing connection pools and configuration files, as well as stored procedures, and using generic data-access code to establish a connection. Specific topics covered include optimizing ADO.NET connections and commands, ADO.NET transactions, and working with Multiple Active Result Sets (MARS) and asynchronous commands. This course is one of a series in the SkillSoft learning path that covers the  more...

Enterprise Data Cloud Interaction ...number of advantages over traditional data storage. Cloud-stored data is available from any location that has Internet access. However, depending on the type of business and data, some organizations need to carefully evaluate if and what types of regulations and compliance standards may apply to their data. This course presents the importance of classifying your type of data, what type of  more...

Administering Microsoft ® SQL Server 2000 (SQL) This course will provide student with the knowledge and skills required to install, manage and administer Microsoft SQL Server 2000 (SQL) databases. This course is design to help students master the concept of administering Microsoft? SQL Server 2000 (SQL) databases effectively. When a student completes this course he/she will be able to plan and complete a successful installation or upgrade,  more...

Control of Hazardous Energy (Lockout/Tagout) ...ourse Persons who are exposed to the potential release of stored energy from machines and equipment while performing their routine work functions need to receive training. This includes: -industrial and manufacturing engineers, -supervisors, and workers -construction engineers, supervisors, and workers -safety compliance managers and safety committee members -maintenance engineers, supervisors  more...

Cisco CCNA Router Configuration Basics ...es you to the internal components of routers, information stored, LAN and WAN Interfaces, Router initialization, configuration, and management. This course is one of twelve necessary to be able to pass the qualification exams to gain the IT industry certification Cisco Certified Network Associate. (CCNA) This unit introduces you to the internal components of routers. You will learn about the  more...

ADO NET Connections and Commands To introduce ADO.NET and to describe how to make connections to databases and run stored procedures and SQL statements in a connected design  more...

ADO NET Connections and Commands To introduce ADO.NET and to describe how to make connections to databases and run stored procedures and SQL statements in a connected design  more...

Dreamweaver MX Web Applications ...dexes MS SQL Server 2000 Upsizing to MS SQL 2000 What are Stored Procedures What are Views SQL What is SQL Select Statements Using Where & Order By Retrieving Data Using LIKE Connecting to Databases Web & Application Servers Types of Application Servers Installing Personal Web Server Configuring PWS Configuring IIS Interfacing with Databases Database Drivers Setting up a DSN Connecting to an MS  more...

SQL Server 2000 Programming Business Logic To demonstrate how to implement views, stored procedures, triggers and user-defined functions as means for programming business logic  more...

Defining and Manipulating Data in Oracle9i To describe how to define database objects and manipulate the data stored within them in an Oracle9i database  more...

Visual InterDev 6 0 Active Server Pages and Data Access ... a Web server. Set the access permissions for the files stored on an NTFS partition. Unit 3: Accessing Data 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  more...

Visual InterDev 6 0 Accessing Remote Data ...dset size. Manipulate database records by using SQL, stored procedures, data access models and cursors. Implement business rules by using triggers. Identify the components of Remote Data Services (RDS). Identify the methods of navigating and manipulating data by using the components of Remote Data Services (RDS). Identify the benefits of using COM components.  more...

Oracle Database 10g PL SQL Fundamentals Part 1 ... 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. Identify features of PL/SQL blocks. Audience: The target course audience is Data Administrators,  more...

Oracle Database Administration Workshop I Part 2 ...integrity constraints used to impose restrictions on data stored in columns. Identify actions that you can perform on a table using Enterprise Manager. Identify features of views. Identify features of sequences. Identify features of SQL statements used in data manipulation. Identify tasks for exporting data using the Data Pump utility. Identify features of data import using  more...

C Programming - Part 3 ...d for reading a file. Identify the contents that will be stored in a disk file, on executing specified code. Identify the offset position of a file pointer in bytes after a set of statements are executed. Complete the code to move a file. Identify the code to perform I/O operations from standard devices by using disk file I/O functions. Enter the command line statement to execute the C  more...

C Programming - Part 3 ...ur(s) Match the storage areas with the variable types stored in them. Identify the benefits of memory management operators. Identify the code to overload the memory management operators in a specified situation. Match the methods for releasing the memory space of unreferenced objects with their descriptions. Complete the code to control memory allocation for objects by using the new  more...

Oracle Form Builder Including Reusable Oracle Components ...perty Palette. Write the code to base a data block on a stored procedure that returns a Ref cursor. Write the code to base a data block on a stored procedure that returns a table of records. Identify the properties of a data block based on a stored procedure. Identify the performance implications specific to database calls using a particular data access mechanism. Identify the  more...

Oracle8 Database Administration - Manage an Instance ...ures of the System Global Area (SGA) with the information stored by them. Match the mandatory background processes with their functions. Match the different types of files existing in a database with the information stored in them. Match the non-database files with the information stored in them. Sequence the stages in processing a query. Identify the combinations of the shared pool  more...

Oracle8 Database Administration - Create Databases ...ation. Identify the properties and benefits of using stored procedures and packages. Plan for the creation of redo log files. Plan for the maintenance of redo log groups. Redo log members. Control files. Identify the process of log switches and checkpoints. Manage tablespaces and data files. C ontent Emphasis Skills-Based A udience Database  more...

Oracle Form Builder R6 Including Reusable Oracle Components ...k on a FROM clause query. Create a data block based on a stored procedure that returns a REF cursor by using the Data Block Wizard. Create a data block based on the stored procedure that returns a table of records by using the Data Block Wizard. Identify the properties of a data block based on a stored procedure. Identify the performance implications of using stored procedures. Identify  more...

SQL Server 7 0 System Administration - Part 5 ...the replication system components with appropriate system stored procedures. Use the replication monitor to view agent histories. Use the SQL Server Query Analyzer to test connectivity. Identify the ODBC driver requirements for SQL Server replication. Use replication wizards to publish data to heterogeneous subscribers. Identify features of the SQL-DMO object structure. Perform the  more...

SQL Server 7 0 - Implementing a Database - Part 2 ...dexes Duration: 3 - 4 Hour(s) Identify how data is stored by SQL Server 7.0. Select the methods SQL Server uses to access data. Identify when it is useful to create an index. Select the columns to index. Select the characteristics of a clustered index. Sequence the steps SQL Server goes through to access data. Select the architectural features of nonclustered indexes. Identify the  more...

SQL Server 7 0 System Administration - Part 2 ...g security for linked databases. Identify how views and stored procedures can be used to simplify security. Distinguish between application roles and other roles. Perform the steps for creating an application role for users/logins within SQL Server Enterprise Manager. Perform the steps for activating an application role for users/logins using Transact-SQL. Identify the recommended  more...

SQL Server 7 0 - Implementing a Database - Part 3 Course Overview This is the third course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0. L earn To: Query multiple tables using Transact-SQL statements. Retrieve and modify data using advanced query techniques. C ontent Emphasis Skills-Based A udience This course is designed for IT  more...

SQL Server 7 0 - Implementing a Database - Part 5 ...Server 7.0. L earn To: Access data by using the Stored Procedure model. Access data using triggers. Set up a distributed environment to access, modify and manage remote data. C ontent Emphasis Skills-Based A udience This course is designed for IT professionals responsible for implementing a database solution with Microsoft SQL Server 7.0. Participants should have  more...

Visual InterDev 6 0 Accessing Remote Data ...dset size. Manipulate database records by using SQL, stored procedures, data access models and cursors. Implement business rules by using triggers. Identify the components of Remote Data Services (RDS). Identify the methods of navigating and manipulating data by using the components of Remote Data Services (RDS). Identify the benefits of using COM components.  more...

Visual C 6 0 Designing Implementing Distributed Applications - Part 3 ...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 Microsoft Visual C++. Participants should have completed the first seven courses in this series.  more...

IIS 4 0 Creating Configuring a Web Server - Part 3 ...t Analyzer with their functions. Create a WebMap from a stored file by using Content Analyzer. Determine the cause for a missing image by using Content Analyzer. Determine the cause for a non functioning link by using Content Analyzer. Determine why it takes very long to download a page by using Content Analyzer. Match the common tasks performed in managing links with their  more...

NetWare Service and Support Upgrade - Part 1 ...cessing Novell Internet services. Access information stored in the Micro House Technical Library (MHTL). Troubleshoot a network problem by using the Novell Internet service site and the SupportSource CD. Identify the steps to install and troubleshoot network boards and cables for Ethernet and Token Ring networks. C ontent Emphasis Skills-Based A udience  more...

SQL and PL SQL DML and DDL ... a check constraint to ensure that appropriate values are stored in the table. Create a table within the SQL*Plus environment. Create a table using the rows from an existing table. Display the structure of a table, using the DESCRIBE command. Unit 2: Manipulating Data Duration: 0.5 - 1 Hour(s) Identify the DML functions and the transaction control commands. Insert new rows in a  more...

Oracle8i Database Admin Create Databases ...tion: 1 - 2 Hour(s) Identify the types of information stored in the data dictionary. Identify the features of the data dictionary components. Create a data dictionary view for a specific database by executing the appropriate script. Identify the contents of the data dictionary view categories. Retrieve specific information by querying the Dictionary view. Create PL/SQL functionality  more...

Oracle8i Database Admin Manage Data Storage ...od for various types of tables. Identify the information stored in the components of the Oracle row structure. Identify the features of the Oracle built-in scalar datatypes. Identify the differences between the two large object datatypes. Identify the features of ROWID. Identify the components in a ROWID format. Identify the characteristics that distinguish the two collection datatypes.  more...

Oracle PL SQL Database Programming ...n a series of three titles, and discusses the features of stored subprograms and packages. This course explains how to create and execute stored procedures and functions as well as how to create stored packages. This course also discusses built-in server-side packages and their use in debugging stored subprograms. This course covers how to manage stored subprograms and packages. It also  more...

SQL Server 2000 Design Implement Databases Part 3 Managing Objects ...jects. Students will learn how to create and manage view, stored procedures, user-defined functions, and triggers. Learn To Identify the features of views. Identify the considerations for creating views. Create a view by using Transact-SQL. Match the different user-defined functions with their characteristics. Create a user-defined function by using Transact-SQL. Identify  more...

SQL Server 2000 Querying with Transact SQL Part 2 Working with Queries ... work with queries. The course will also introduce views, stored procedures, triggers, and user-defined functions. Learn To Identify advantages of using aliases for table names. Identify the guidelines for using joins. Identify the considerations for using inner joins. Identify considerations for using subqueries. Create a derived table by using a subquery. Create a single-value  more...

Oracle9i Database Admin Manage an Instance ...tify the memory structures of the SGA and the information stored in the database and nondatabase files. • Identify the connection procedures and the processes generated during database connection. • Identify the stages in processing a query and the memory structures used in query processing. • Identify the steps of DML processing and the memory structures involved in DML  more...

Oracle9i Database Admin Create a Database ...e scripts categories. • Identify the properties of stored procedures and packages, the benefits of using stored program units, and the functions of Oracle-supplied packages. • Retrieve information about stored objects, identify the common situations when dependent objects may have an INVALID status, and the functions of the control file with the types of information stored.  more...

Oracle9i Peformance Tuning Managing Memory and Disk I O ...h their description. o Identify the methods of creating stored outlines. o Identify the three major areas of the Shared Pool. o Identify the parameters used to tune the Shared Pool. o Identify the goals for tuning the Library Cache. o Identify the descriptions of redo entries. o Match the statistics used to diagnose disk I/O contention with their descriptions. o Identify the two  more...

MS Win XP Install Admin Part 4 Remote Mobile Computing ... of Windows XP Professional. o Identify features of the Stored User Names and Passwords feature of Windows XP Professional. o Identify features of the Stored User Names and Passwords feature of Windows XP Professional. Unit 2: Configuring Windows XP for Mobile Users 2 - 3 hours o Create a hardware profile for a mobile user in Windows XP Professional. o Create a hardware profile for  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-Web Based Development Part 5 This course teaches the configuration and deployment of Web applications in Visual Basic .NET. The implementation of accessibility, online user assistance, and globalization are covered. Web Application security features including Windows-based authentication, form-based authentication, Microsoft Passport authentication, and XML Web service security are also taught. Learn To: o To identify  more...

Windows 2000 Implementing Security Part 1 ...e process used by Encrypting File System (EFS) to encrypt stored data. • Identify features of protocols used to encrypt transmitted data. • Identify components of a Public Key Infrastructure (PKI). • Identify elements of a digital certificate. • Identify features of a certification  more...

Visual Basic 6 0 Designing Implementing Desktop Applications - Part 3 Course Overview 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  more...

Visual Basic 6 0 Designing Implementing Distributed Applications - Part 3 ...mand, navigating recordsets, modifying data and executing stored procedures. C ontent Emphasis Skills-Based A udience This course is designed for programmers using Visual Basic 6.0 and are currently building desktop applications and accessing corporate databases. Participants should have completed the first two courses in this series. T otal Learning Time 6 - 8 Hour(s)  more...

Oracle8 Database Administration - Manage Data ...d for various types of tables. Identify the information stored in the components of the Oracle row structure. Identify the features of the Oracle built-in scalar datatypes. Identify the differences between the two large object datatypes. Identify the features of ROWID. Identify the components in a ROWID format. Identify the characteristics that distinguish the two collection  more...

Oracle8 Backup and Recovery - Strategies and Backups ...he archive log backup process. Perform a backup using a stored script. Identify the features of a stored script. Identify the command to create a script and make a backup. Identify the characteristics of an incremental backup. Identify the characteristics of a cumulative backup. Identify the constraints in performing a backup when using the Recovery Manager. Identify the memory  more...

Windows NT Server 4 0 Troubleshooting in the Enterprise ...components with the way in which they use the information stored in the registry. Match the registry subtrees with the information they store. Display a registry subkey content using the Registry Editor. Set up an interactive session to troubleshoot through a remote Windows NT server registry, using the remote command service. Match the HKEY_LOCAL_MACHINE subtree to the information they  more...

Oracle8i Database Admin Manage an Instance ...ures of the System Global Area (SGA) with the information stored by them. Match the mandatory background processes with their functions. Match the different types of files existing in a database with the information stored in them. Match the non-database files with the information stored in them. Sequence the stages in processing a query. Identify the combinations of the shared pool  more...

IBM DB2 Universal Database V6 1 App Devel Curriculum ...ts such as schemas, user-defined types and functions, and stored procedures, as well as using embedded and dynamic SQL within an application. This curriculum consists of 2 Skill Builder courses: Course 13431 IBM DB2 Universal Database V6.1 Fundamentals Course 13433 IBM DB2 Universal Database V6.1 Application Development Certification: This curriculum will help candidates prepare for the ILT  more...

IBM DB2 Universal Database V6 1 App Devel Curriculum ...ts such as schemas, user-defined types and functions, and stored procedures, as well as using embedded and dynamic SQL within an application. This curriculum consists of 2 Skill Builder courses: Course 13431 IBM DB2 Universal Database V6.1 Fundamentals Course 13433 IBM DB2 Universal Database V6.1 Application Development Certification: This curriculum will help candidates prepare for the ILT  more...

IBM DB2 Universal Database V6 1--App Development ...s schema, user-defined types, user-defined functions, and stored procedures. Use SQL within an application. Use dynamic SQL within an application. C ontent Emphasis Skills-Based A udience This course is intended for application developers. Students should have a fundamental understanding of relational database technology, including concepts of databases, tables, rows/columns,  more...

IBM DB2 Universal Database V6 1--App Development ...s schema, user-defined types, user-defined functions, and stored procedures. Use SQL within an application. Use dynamic SQL within an application. C ontent Emphasis Skills-Based A udience This course is intended for application developers. Students should have a fundamental understanding of relational database technology, including concepts of databases, tables, rows/columns,  more...

ASP NET Part 2 ADO NET Partitioning Tracing ...trol. • Identify the syntax used to call an action stored procedure. • Identify the syntax used to retrieve data from a database using DataReader objects. • Identify the syntax used to create a parameter for a stored procedure. • Identify the syntax used to call a stored procedure. • Identify the syntax used to read data from a DataReader by using the Read  more...

Dreamweaver UltraDev 4 Course Overview This is the final course in a three part curriculum about Macromedia products that can be used for Web design. This course teaches students how to use Dreamweaver UltraDev 4. Additionally, this course covers the basic skills needed to create database-driven Web sites using Dreamweaver UltraDev and ASP, ColdFusion, or JSP. Learn To • Identify the features of UltraDev,  more...

CIW Security Professional Security Auditing Attack Techniques ...y key aspects of phases of control. Discover passwords stored on a Windows 2000 computer. Identify the steps to discover passwords stored on a Linux computer. Audience: This course is intended for CIW Security Professionals who are responsible for the implementation of e-business security policies and technologies. The target audience for these courses are network server  more...

Oracle Database 10g PL SQL Fundamentals Part 2 ...arn to declare variables and trapping exceptions, develop stored procedures, functions, packages and database triggers. Learn To: Identify features of PL/SQL blocks within a subprogram. Match types of PL/SQL named blocks with their descriptions. Match types of PL/SQL environments with their descriptions. Identify features of PL/SQL packages. Sequence steps for  more...