Online Retrieve eLearning Training
From Gucons
SAP Training in Hyderabad - ABAP Course

...AP Tables
Here the student begins to understand how to retrieve data from database tables and some performance considerations.
There will also be some consideration given to what a logical database is.
* Version Management
In this section the student is exposed to change control and navigation of the tools to facilitate that activity.
Areas of focus will be release and transport
more...
From Serebra Learning Corporation
Microsoft Excel 2000 Expert User
This course provides participants the knowledge to use the advanced features of Microsoft Excel 2000. At the completion of this course, students will learn how to create and use templates; retrieve, sort and manipulate data from a list; create and modify shared workbooks; and analyze data by using Data Map, Pivot Table, Data Table Scenario and Data Analysis tools.
more...
Microsoft Visual InterDev 6.0: Accessing Remote Data
This is the fourth course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-152, Designing and Implementing Web Solutions with Microsoft Visual InterDev 6.0. At the completion of this course, students will learn to work with database records and identify the methods of managing recordset size; identify the components of Remote Data Services
more...
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 4
This is the fourth course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the methods of aggregating and accessing data from relational data structures; identify the methods of data access from
more...
JDBC Application Development Part 4: The 2.0 Core and Optional APIs
This final course in the series teaches how to use the new features in the JDBC 2.0 core API. It also covers using the optional API, which includes the ability to connect to a database with datasource objects that work with JNDI, and using rowsets.
more...
Microsoft Excel 97 Intermediate
This highly interactive CBT contains six units that cover intermediate Excel skills. Through step-by-step instruction within a realistic simulation of Microsoft Excel 97, students learn how to work with formulas and functions, automate tasks, use and analyze list data, enhance charts and worksheets, and work with Excel and the Internet. Performance-based Pre- and Post-Assessments create a custom
more...
Visual Basic 6 0 Database Access Part I
... explains how databases are organized, how information is retrieved and manipulated in databases, and what technologies are available to ensure cross-platform and uniform access to database information. This course describes the fundamentals of viewing and modifying information in databases using the industry standard Structured Query Language (SQL). It explains how SQL is used with client
more...
Enhancing ColdFusion MX Applications
To describe how to enhance ColdFusion MX applications by adding error-handling, search, and data-exchange functionalities to them Existing ColdFusion 5 users wishing to gain experience in advanced ColdFusion MX development; web and enterprise application developers who have had an introduction to ColdFusion development and wish to learn advanced development techniques
more...
Visual Basic 6 0 Advanced
This course covers techniques that Visual Basic programmers can use to enhance the interface, functionality and performance of their applications. Students will learn to create menus and toolbars. The course also introduces the student to ActiveX programming and the Common Dialog control. The course also shows students how to create and load documents using the File Access features of Visual
more...
Visual Basic 6 0 Using the Win32 API Part II
This course describes how to use some of the more common Win32 API drawing functions, it explains how to obtain and release a device context and how to draw dots, lines, and rectangles on a form or control. It also describes how to change pen and brush styles by using stock objects and by creating customized pens and brushes. In addition, it explains how to place a text string on a control or form
more...
C 2005 Diagnostics and Management
To manage application configuration and the custom installation of components, event logs, system processes and information, and use debugging and tracing to measure application performance Employees, consultants, and students that are preparing for the Technology Specialist: Microsoft .NET Framework 2.0 - Application Development Foundation Certification Exam (70-536)
more...
Visual Basic 2005 Diagnostics and Management
To manage application configuration and the custom installation of components, event logs, system processes and information, and use debugging and tracing to measure application performance Employees, Consultants, and Students that are preparing for the Technology Specialist: Microsoft .NET Framework 2.0 - Application Development Foundation Certification Exam (70-536)
more...
Web-application Deployment Optimization and Customization with C 2005 and ASP NET 2 0
To deploy, optimize, and customize web applications Individuals who wish to use the .NET Framework 2.0 with Visual Studio 2005, C# 2005, and ASP.NET 2.0 to develop web-based client applications; individuals preparing for the Microsoft .NET Framework 2.0 Web-Based Client Development (70-528) exam
more...
Web-application Deployment Optimization and Customization with Visual Basic 2005 and ASP NET 2 0
To deploy, optimize, and customize web applications Individuals who wish to use the .NET Framework 2.0 with Visual Studio 2005, Visual Basic 2005, and ASP.NET 2.0 to develop web-based client applications; individuals preparing for the Microsoft .NET Framework 2.0 Web-Based Client Development (70-528) exam
more...
Building ADO NET DataSets
To describe how to use ADO.NET's disconnected DataSet object model, including DataSets, DataAdapters, DataTables, DataRelations, DataRows, and DataColumns Visual Basic .NET programmers and candidates for the Microsoft MCSD and MCAD certification paths
more...
XML Data Access in VB NET
To use the .NET Framework to manage XML data All Microsoft VB.NET developers wanting to write enterprise applications with serviced components, Windows Services, or .NET Remoting, or studying for the 70-310 exam Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework
more...
UNIX Shell Programming
The UNIX Shell Programming course is designed to give students an idea of what can be accomplished with shell scripts and how to write them. This course teaches the features of the shell such as I/O redirection, filename shorthand, looping constructs, variables, and signal handling. The course introduces the concept of shell programming, how and when to create shell programs, and how to run shell
more...
The Linux Operating System
This course covers the origin and history of the Linux operating system and its relation with other Unix family systems. It examines various ""distributions"" of Linux , its value as a reliable business solution, and its various components, and it addresses issues surrounding its use, administration, and development. The course highlights those aspects that make Linux an innovative operating
more...
DB2 Application Programming I Rel 4 x
This course teaches students how to use embedded SQL in their applications to retrieve and update information contained in DB2. Application developers.
more...
DB2 Application Programming II Rel 4 x
This course teaches students how to use embedded SQL in their applications to retrieve and update information contained in DB2. Application developers
more...
SNMP MIBs and RMON
To identify the methods by which data is collected and distributed for network management and the form that those messages take Network managers, administrators, and technical support personnel who require an insight into the protocols most widely used in network management
more...
SQL Functions in Oracle 9i
To describe how to use SQL functions for data retrieval Junior database administrators, application developers, and database operators
more...
Managing Dependencies
To manage dependencies and recompile PL/SQL units Database administrators, application developers, and database operators
more...
Using PL SQL with an Oracle Server
To write lexical units in their correct format in a PL/SQL block, perform data conversion in PL/SQL, write PL/SQL anonymous blocks, and recognize the correct structure of a PL/SQL program block Database administrators, application developers, and database operators
more...
Explicit Cursors and Exception Errors
To use the FOR UPDATE and WHERE CURRENT OF clauses to lock and modify rows, process data using records and cursors, and outline how each of the PL/SQL exception types are raised and handled Database administrators, application developers, and database operators
more...
Introduction to Oracle and SQL in Oracle Database 10g
To introduce Oracle as a relational database management system (RDBMS) and to demonstrate how to use basic SQL statements Database administrators, application developers, and database operators
more...
Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g
To demonstrate how to retrieve data from multiple tables using joins and how to use set operators in Oracle 10g databases Database administrators, application developers, and database operators
more...
Group and Datetime Functions in Oracle Database 10g
To demonstrate how to use group and datetime functions in Oracle 10g Database administrators, application developers, and database operators
more...
Managing Data using Works 6 0
The Managing Data using Works 6.0 course is the first course in the Works Suite 2002 curriculum. This course acquaints the users with the applications of the Works Suite and the different components of the Works application. It teaches the users to use the Task Launcher to start various tasks in Works and complete them using different wizards and templates. Additionally, it explains the different
more...
Analyzing Data in Excel 2007
...le report data. Using Goal Seek and Solver enables you to retrieve required results from formulas by determining the data the formula requires. You can also use additional what-if analysis components, data tables and scenarios, to view how value changes in formulas affect the formula results and to forecast worksheet outcome models respectively. This course covers advanced data analysis
more...
Exchanging Data with Excel 2007
...for importing text files and creating database queries to retrieve data from a variety of databases. Other applications, such as Access, Word, and Outlook, can also import Excel data. Using XML in conjunction with Excel enables you to further manage and customize workbooks. This course explores creating links, importing text files, and creating database and web queries. Importing Excel 2007
more...
Microsoft Excel 2000 Intermediate
This highly interactive CBT contains six units that cover intermediate Excel skills. Through step-by-step instruction within a realistic simulation of Microsoft Excel 2000, students learn how to manage workbooks, automate tasks, use and analyze list data, enhance charts and worksheets, and work with Excel and the Internet. Performance-based Pre- and Post-Assessments create a custom course path for
more...
Navigating Oracle Applications 11i
This series teaches learners how to access and navigate within Oracle Applications release 11i. The course covers Oracle Applications 11i Interface navigation tips manipulating data using Find mode and Query mode and also accessing online help. Learners are taught to enter data retrieve information in the form of a query maintain data use flexfields and access online help. Additionally this
more...
Oracle 8i PL/SQL - Intro to RDBMS and SQL *Plus
The course aims to familiarize you with the basic concepts of database design. The course also provides a brief overview of relational database model since the Oracle database is based on this model. The course familiarizes you with the use of SQL and SQL *PLUS commands. The course will enable you to construct queries using SELECT statement with clauses such as WHERE ORDER BY and DISTINCT. You
more...
Oracle9i SQL: Data Retrieval Techniques


This course covers joins, group functions, subqueries, and the iSQL*Plus report variables. Additionally, this course shows students how to access data from multiple table using joins, aggregate data using group functions, create subqueries, and use iSQL*Plus commands to create customized queries.
more...
Oracle9i Database Administration: Create a Database


The Oracle9i Database Administration: Create a Database course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle9i. Participants learn about the concepts associated with storage structure components, management of rollback segments, temporary segments, and indexes. In addition, this course discusses how to create and maintain
more...
Oracle9i Database Administration: Manage Storage Structures


The Oracle 9i Database Administration: Manage Storage Structures course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course, participants learn the concepts associated with storage structure components. In addition, this course teaches users the procedures for managing segment free space, undo space, temporary
more...
MS Office 2000: Access for Professionals I


This course teaches the student how to create a database and add tables and records to the database. The student will also learn how to retrieve data from a database using filters.
more...
Introduction to the Internet and World Wide Web
This course provides Internet and Web users with the knowledge and skills required to select an Internet connection type and Internet Service Provider (ISP) locate and retrieve information on the Web and communicate with others via the Internet.
more...
Microsoft Access 2000 Designing and Implementing Database Applications Part 2 - Handling Data
This is the second course in a five-part series that will provide IT professionals with the knowledge and skills necessary to design and implement database solutions using Microsoft Access 2000. At the completion of this course students will learn to retrieve data from an Access 2000 database; customize forms use forms to accept validated data and navigate between controls and records in a form;
more...
Oracle SQL for End Users Part 1
...s who want to learn how to write SQL SELECT statements to retrieve data from a database. This course identifies relational database properties introduces the Oracle server and indicates how SQL and SQL*Plus are used in the Oracle product 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
more...
Oracle SQL: Data Retrieval Techniques
This course is the second in a three-part Oracle series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course describes how to access data from more than one table using joins and aggregating data using group functions. This course also describes how to embed a SQL statement in a clause of another SQL statement to enhance the power of SQL queries. In addition how to
more...
Oracle SQL Specifics: Retrieving and Formatting Data
This course is the first in a two-part series on Oracle SQL Specifics that will teach participants how to use commands functions and operators supported by Oracle as extensions to standard SQL. Students will be introduced to the Oracle implementation of the relational database management system (RDBMS) and the object-relational database management system (ORDBMS). Users will learn how SQL
more...
Lotus Domino R5 Development Part 5: Advanced Application Development
This is the fifth course in a nine part series for webmasters application developers and graphic designers that will introduce Notes/Domino features web-specific tasks and basic system administration tasks to be up on the web quickly and to use Domino to create Web sites and Web applications. At the completion of this course students will learn how to identify the functions of Groupware and the
more...
DB2 Application Programming (COBOL) (Rel 2.3)


This course teaches students how to use embedded SQL in their applications to retrieve and update information contained in DB2.
more...
DB2 Application Programming (PL/1) (Rel 2.3)


This course teaches students how to use embedded SQL in their applications to retrieve and update information contained in DB2.
more...
DB2 Application Programming (ver 3.1)


This course teaches students how to use embedded SQL in their applications to retrieve and update information contained in DB2.
more...
Basic SQL Programming
This course introduces the student to the basics of T-SQL. It also covers the skills required to retrieve and modify data using T-SQL. The Implementing SQL Server curriculum prepares the student for the Microsoft Exam 70-029.
more...
From 123-CBT Computer Based 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
