Online Retrieve eLearning Training

Oracle SQL PL SQL Using Procedure Builder Curriculum ...how to create and maintain database objects and to store, retrieve, and manipulate data. In addition, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. This curriculum consists of four Skill Builder courses: Course 61110 Oracle SQL: Basic SELECT Statements Course 61111 Oracle SQL: Data Retrieval Techniques  more...

HTML 4 Part 2 Advanced Topics ...tify the server information variables that can be used to retrieve the specified information. • Identify the client information variables that can be used to retrieve the specified information. • Identify the script information variables that can be used to retrieve the specified information. • Identify the output header used in a CGI script. • Match the status codes  more...

HTML 4 Part 2 Advanced Topics Course Overview This is the second course in a two part series that teaches advanced topics in HTML 4.01. The course covers enhancing web pages, introduces interactivity in web pages, and DHTML and CSS. Learn To • Identify the guidelines for designing and developing a Web site. • Identify the types of image maps used to link images both at the client-side and server-side.  more...

Oracle9i Database Admin Manage Data Storage ...and truncate a table, and deallocate free apace. • Retrieve the table, extent and row location information from data dictionary. • Identify the features of index-organized tables and alter tables. • Identify the various types of database triggers and the methods to disable and enable the triggers. • Identify the guidelines for implementing constraints and create the  more...

Oracle9i Database Admin Manage Storage Structures ...Identify the block space utilization parameters. • Retrieve storage structure information. • Identify the purposes and the types of rollback segments. • Explain the processes that rollback segments follow for transactions. • Plan, create, and acquire rollback segments. • Modify and remove rollback segments. • Retrieve rollback segment information from  more...

Oracle9i Database Admin Create a Database ...y structure, identify the data dictionary categories, and retrieve data dictionary information. • Execute catproc.sql and identify the uses of administrative 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,  more...

Oracle9i Database Admin Manage an Instance ...eters, and the way to control the sort sequence. • Retrieve the data dictionary information about the character sets and the NLS settings. Audience The intended audience for this course include Database administrators, System administrators, Network administrators, and Technical support professionals. Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110),  more...

Oracle9i SQL Data Retrieval Techniques ...ore than one table. o Identify a Cartesian product. o Retrieve rows from two tables by using an equijoin. o Identify the features of a group function. o Write SQL statements that contain common group functions. o Manage null values when using group functions in a SQL statement. o Identify the requirements for using subqueries. o Identify the characteristics of each subquery type.  more...

ASP NET Part 2 ADO NET Partitioning Tracing ...ce by using ADO.NET. • Identify the syntax used to retrieve data by using the ADO.NET DataSet object. • Identify the syntax used to store multiple tables in a DataSet. • Identify the functions of the DataView object. • Match the templates used by the Repeater and DataList controls with their functions. • Identify syntax used to display data on the client by  more...

ASP NET Part 2 ADO NET Partitioning Tracing Course Overview The is the second course in a three part series that provides the learner with instruction on using ADO.NET to access data, on separating code from content, and on using the ASP.NET trace 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  more...

SQL Server 2000 Querying with Transact SQL Part 1 Manipulating Data ...e. Identify the guidelines for using the WHERE clause to retrieve rows in a table. Retrieve specific columns from a table. Identify the characteristics of aggregate functions. Identify the considerations for using the GROUP BY clause. Identify the guidelines for using the GROUP BY clause with the HAVING clause Audience Candidates for this course operate in medium to very large  more...

SQL Server 2000 Design Implement Databases Part 4 Managing Indexes ...indexes. Identify the features of nonclustered indexes. Retrieve information from the sysindexes table. Identify guidelines for creating indexes. Identify the considerations for creating unique indexes. Identify the considerations for creating composite indexes. Identify the functions of the query optimizer. Identify the features of cost-based optimization. Sequence the steps for  more...

IBM DB2 Universal Database V6 1--App Development ...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 functions. Create different levels of aggregation data using GROUPING SETS operations. Identify characteristics of STAR  more...

IBM DB2 Universal Database V6 1--App Development ...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 functions. Create different levels of aggregation data using GROUPING SETS operations. Identify characteristics of STAR  more...

IBM DB2 Universal Database V6 1--Fundamentals ...isplay data using a SELECT statement. Specify rows to be retrieved from a table given certain requirements. Apply DB2 functions 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  more...

Oracle8i Network Administration Net8 Additional Config Troubleshooting ... that occur when an Oracle Names client uses its cache to retrieve Names server information. Unit 2: Oracle Names Usage and Configuration Duration: 1.5 - 2 Hour(s) Identify two approaches to configuring an Oracle Names server. Create a Names server by using the No Region Database option in Net8 Assistant. Start a Names server by using Net8 Assistant. Configure a region database  more...

Oracle8i Database Admin Manage Data Storage ...g a table. Drop a table by using Oracle Schema Manager. Retrieve table information by using Oracle SQL*Plus Worksheet. Retrieve the extent information from DBA_EXTENTS by using Oracle SQL*Plus Worksheet. Obtain the physical location of the rows in a table by using Oracle SQL*Plus Worksheet. Unit 2: Maintaining Data Integrity Duration: 1 - 2 Hour(s) Identify the features of  more...

Oracle8i Database Admin Manage Storage Structures ...used by the Oracle Server to manage data within a block. Retrieve the information to check the current number of extents and blocks allocated to a segment by using Oracle SQL*Plus Worksheet. Retrieve the information to view the extents for a given segment by using Oracle SQL*Plus Worksheet. Write a query to check the extents for a given segment by using Oracle SQL*Plus Worksheet. Unit 2:  more...

Oracle8i Database Admin Create Databases ...dictionary views. Identify the data dictionary views to retrieve information. Identify the scripts to set up the PL/SQL environment. Identify control files Identify redo log files Identify tablespaces and data files. C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, Technical Support Professionals.  more...

Access 2000 Fundamentals Course Overview This course is intended for end users who are looking to use the fundamental capabilities of Microsoft Access 2000. Participants will learn to identify the basic features of Access 2000; create and maintain tables; and work with Access 2000 data. L earn To: Identify the concepts related to databases and the features of Access 2000. Create and maintain tables and  more...

Oracle Form Builder R6 Writing and Debugging Code ...by using system variables in the code. Write the code to retrieve information about the current application by using the GET_APPLICATION_PROPERTY built-in. Write the code to modify the properties of an item in the current application by using the SET_ITEM_PROPERTY built-in. Identify the benefits of referencing objects by using their Object IDs. Reference an object within the initial PL/SQL  more...

Oracle8 Database Administration - Manage Data ...ous tables and datatypes. Create and manage tables. Retrieve table information from the data dictionary. Identify the characteristics and types of triggers and constraints. Implement and maintain data integrity. Retrieve information from the data dictionary. Implement clusters and index-organized tables (IOTs). Load and reorganize data in tables. C ontent Emphasis  more...

Oracle8 Database Administration - Manage Storage Structures ...used by the Oracle Server to manage data within a block. Retrieve the information to check the current number of extents and blocks allocated to a segment by using Oracle SQL Worksheet. Retrieve the information to view the extents for a given segment by using Oracle SQL Worksheet. Write a query to check the extents for a given segment by using Oracle SQL Worksheet. Unit 2: Managing  more...

Oracle8 Database Administration - Create Databases ... data dictionary view. Use the data dictionary view to retrieve information. 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  more...

Oracle8 Database Administration - Manage an Instance Course Overview This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support. L earn To:  more...

Introduction to the Internet and World Wide Web ...tion type and Internet Service Provider (ISP), locate and retrieve information on the Web, and communicate with others via the Internet. An overview of the Internet and its services, business uses of the Internet, and Internet security concerns will be covered. In addition, participants will learn how to browse the Web, send and receive e-mail, post messages to newsgroups, and perform Web  more...

Outlook 2000 Expert User ...oft Exchange Server. Download message headers remotely. Retrieve specific messages remotely. Unit 4: Integrating Outlook 2000 Components Duration: 2 Hour(s) Import task information from Excel. Export Calendar data to Access. Identify the options in the Import and Export Wizard for transferring data between Outlook 2000 and other messaging systems. Manage Favorite Web pages using  more...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 4 ...Relational Data Structures Duration: 1 - 2 Hour(s) Retrieve data by using the SELECT statement with a WHERE clause. Aggregate data by using the aggregation functions. Group the aggregated data by using the GROUP BY keyword. Retrieve specific groups of the aggregated data by using the HAVING keyword. Calculate totals and subtotals of the groups in the aggregated data by using the  more...

Visual C 6 0 Designing Implementing Desktop Applications - Part 5 ...6 development 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  more...

Visual C 6 0 Designing Implementing Desktop Applications - Part 4 Course Overview This is the fourth course in an eight part series for programmers. This series provides the C++ programmers the necessary skills to develop applications using MFC library and the Microsoft Visual C++ 6 development environment. L earn To: Identify the types of help techniques and implement a help system for an application. Identify the exception handling architecture  more...

Visual Basic 6 0 Designing Implementing Distributed Applications - Part 5 ...a server by using the Response object. Write the code to retrieve data by using the Request object. Execute an IIS application by using the Project Explorer window. Sequence the events in the WebClass Instancing process along with the steps that precede their firing. Create an HTML template event by using the Designer window. Connect the items in an HTML template WebItem to a Custom  more...

Visual Basic 6 0 Designing Implementing Distributed Applications - Part 3 ...ntrol statements 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  more...

Visual Basic 6 0 Designing Implementing Desktop Applications - Part 5 ...save application settings to the Registry. Write code to retrieve application settings from the Registry. Add the VB Resource Editor to the Tools menu. Create a resource file. Identify the resource functions used to load information from a resource file at run time. Identify techniques to optimize the speed of an application. Identify techniques to reclaim memory from an application.  more...

Visual Basic 6 0 Designing Implementing Desktop Applications - Part 2 ... ways of adding methods to an ActiveX control. Store and retrieve property values. Identify the code used to expose named constants. Raise control events. Test the user interface of a control. Identify considerations for testing a control programmatically. Identify the features of the Property Page Wizard. Create the property page interface manually. Implement Property Page behaviors.  more...

Visual Basic 6 0 Designing Implementing Desktop Applications - Part 1 ...w window. Create a command object to define what data to retrieve from a connection. Identify the code to access the results returned by a Command object. Group similar records within a Command object. Relate Command objects to create a hierarchical relationship of data. Calculate values returned in a recordset using the aggregates function. Create data-bound controls on a form. Add  more...

Visual InterDev 6 0 Accessing Remote Data ...a source by using a Connection object. Write the code to retrieve records from a database by using the Open method of the Recordset object. Write the code to retrieve records from a database by using the Execute method of the Command object. Write the code to execute a stored procedure that accepts parameters by using the Execute method of the Command object. Write the code to create a  more...

Visual InterDev 6 0 Accessing Remote Data ...a source by using a Connection object. Write the code to retrieve records from a database by using the Open method of the Recordset object. Write the code to retrieve records from a database by using the Execute method of the Command object. Write the code to execute a stored procedure that accepts parameters by using the Execute method of the Command object. Write the code to create a  more...

Oracle Database 10g SQL Fundamentals I Part 1 ...anagement 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  more...

Oracle SQL Specifics Retrieving and Formatting Data ...trieval problems. Finally, participants will learn how to retrieve data based on a hierarchical relationship between rows. L earn To: Define relational database concepts and object relational database concepts. Use the Oracle SELECT statement. Implement functions, including single row, conversion, and group functions. Use SET operators. Use subqueries. Retrieve  more...

Excel 2000 Expert User ...rse, 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. L earn To: Create and use templates. Retrieve, sort and manipulate data from a list. Create and modify shared workbooks. Analyze data by using  more...

SQL Server 7 0 - Implementing a Database - Part 2 ... clustered index. Sequence the steps SQL Server takes to retrieve a range of information contained in a heap. Identify how SQL Server accesses a range of data using clustering keys. Select the guidelines which apply when using the CREATE INDEX statement. Perform the steps to create a unique index. Perform the steps to create a composite index. Identify the methods used to view existing  more...

SQL Server 7 0 - Implementing a Database - Part 3 ... 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 professionals responsible for implementing a database solution with Microsoft SQL Server 7.0. Participants should have completed Microsoft SQL Server 7.0: System Administration (Course Series  more...

Site Server 3 0 Implementation - Part 1 ...e steps to add metadata to content. Perform the steps to retrieve content. Identify the functions of the Content Management feature. Perform the steps to set up a content store. Select the components necessary to create a new Content Management Web site. Perform the steps to upload documents to a Web site. Perform the steps to secure Web site content. Unit 3: Deploying Content  more...

SQL and PL SQL PL SQL Basics ...iables and identify the PL/SQL programming conventions. Retrieve and manipulate data from the database by using PL/SQL commands Identify features an