|
Training Classes
| Learning and Development Resources
| Training Directory
| New Training Seminars
| New Training Providers
| Site Map
| Promote Training Seminars
|
Training Keywords
| Training Seminars
| Training Providers
| Regions
|
| Advertise Training Seminars
| Login
|
||||||||||||||||||||||||
Retrieve Data Training Seminars and Classes
From Serebra Learning Corporation
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...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...SQL Functions in Oracle 9i
To describe how to use SQL functions for data retrieval Junior 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...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...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...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...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 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...
From 123-CBT Computer Based Training
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...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...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
...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 considerations in embedding SQL in applications for DB2. Sequence the steps to prepare to run an application program. 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 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 InterDev 6 0 Accessing Remote Data
...2: Creating 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...Visual InterDev 6 0 Accessing Remote Data
... 2: Creating 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...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...SQL and PL SQL PL SQL Basics
Course Overview This course introduces the learner to the basics of PL/SQL. The course builds the necessary skills for using Oracle PL/SQL. It will help the learner acquire the expertise to design, develop, and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming. more...SQL and PL SQL Data Retrieval Techniques
Course Overview 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. more...IBM DB2 Universal Database V6 1--Fundamentals
...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 considerations in embedding SQL in applications for DB2. Sequence the steps to prepare to run an application program. more...IBM DB2 Universal Database V6 1--Fundamentals
...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 considerations in embedding SQL in applications for DB2. Sequence the steps to prepare to run an application program. 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 for End Users--Part 2
...eturn one row in the WHERE clause of a SELECT statement. Retrieve data that is dependent upon the value of a group function in a single-row subquery. Identify two common errors that occur when using single-row subqueries. Identify the guidelines for using multiple-row subqueries. Retrieve data that is dependent upon the value of a group function in a multiple-row subquery. Unit 4: more...Database Technologies Introduction to SQL
...hat SQL is, 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. more...XML Building XML-Based Web Applications Part 4
...with their 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 more...
From Teach Me IT
Retrieving Data in SQL Server 2000
...how to insert data in a SQL Server table and use views to retrieve data. It also introduces users to indexes and teaches them how to implement full-text search. Additionally, the users will learn to create stored procedures and cursors. After completing this course, the user will be able to:
Insert and modify data in a database
Retrieve data using a simple SELECT statement and with a JOIN more...SQL Server 7.0 - Basic Programming
SQL Server 7.0 - Basic Programming course is the second course of the three courses in the Implementing SQL Server curriculum. The Implementing SQL Server curriculum prepares the students for the Microsoft Certification exam Implementing and Designing Databases with Microsoft SQL Server7.0 (70-029). This course introduces students to the basics of T-SQL. It also covers the skills required to more...VB 6.0 Database Basics
VB 6.0 Database Basics course is the first course of the three courses in the VB Databases curriculum. This curriculum prepares the students for the Microsoft Certified Professional Designing and Implementing Desktop Applications with Microsoft Visual Basic6.0 (70-176) exam. This course teaches students database basics and database creation through a VB application. Also, this course teaches the more...
From Skillspride Online Training
CLAIT Level 1 - Electronic Communication with Internet Explorer 6
This course is designed to help you to obtain the skills and knowledge required for CLAIT Level 1 Unit 3 " Communication. You will learn to use Internet Explorer 6 to browse web pages, use search engines, and retrieve data. You will also learn to use the Outlook Express mail client to create, send, read, and manage internet email messages. Electronic more...ECDL 4 Information and Communication with Internet Explorer 6 and Outlook 2003
This course is designed to help you to obtain the skills and knowledge required for ECDL Module 7 " and Communication (Syllabus 4.0). You will learn to use Internet Explorer to browse web pages, use search engines, and retrieve data. You will also learn to use the Outlook mail client to create, send, read, and manage internet and workgroup email messages. Information more...ECDL 4 Information and Communication with Internet Explorer 5 and Outlook 2000
This course is designed to help you to obtain the skills and knowledge required for ECDL Module 7 " and Communication (Syllabus 4.0). You will learn to use Internet Explorer to browse web pages, use search engines, and retrieve data. You will also learn to use the Outlook mail client to create, send, read, and manage internet and workgroup email messages. Information more...
| ||||||||||||||||||||||||
|
| ||||||||||||||||||||||||
| Training Directory | New Training Seminars | New Training Providers | | Site Map | Promote Training | Login | Links | ||
|
| ||
| Training-Classes.com by Skillbox® 07/24/08 Copyright 1998-2008 skillbox, inc. All rights reserved |
 |
|
| Are you a Retrieve Data training provider? |
| You could be on this page today - for FREE! |
