Online Data Retrieval eLearning
Data Retrieval Training Provider? - Tell us about your Training!
From 123-CBT Computer Based Training
SQL Functions in Oracle Database 10g

SQL Functions in Oracle Database 10g Oracle
To describe how to use SQL functions for data retrieval
more...
SQL Functions in Oracle Database 10g
Creating Implementing Database Objects in SQL Server 2008

...d indexes to optimize the performance of the database for data retrieval. This course identifies each of these database objects and demonstrates the steps required to administer them within the SQL Server 2008 Management Studio tool. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-433 TS: Microsoft SQL Server 2008, Database
more...
Oracle SQL Specifics Retrieving and Formatting Data

...ow subqueries and correlated subqueries can help to solve data retrieval problems. Finally, participants will learn how to retrieve data based on a hierarchical relationship between rows.
L earn To:
Define relational database concepts and object relational database concepts.
Use the Oracle SELECT statement.
Implement functions, including single row, conversion, and group
more...
Oracle SQL Tuning Tuning SQL and the Optimizer

Course Overview
This course is the second in a two-part series on SQL Statement Tuning. This course will help application developers to design SQL statements that can reuse parsing and influence the optimizer to improve performance.
L earn To:
Identify the factors that affect network traffic.
Identify the factors that affect parsing.
Identify the guidelines for the reuse
more...
Oracle8 Certified Database Administrator Curriculum

...Oracle SQL: Basic SELECT Statements (ID#378) Oracle SQL: Data Retrieval Techniques (ID#379) Oracle SQL: DML & DDL (ID#380) Oracle SQL: PL/SQL: Basics (ID#322) Oracle8 Database Administration - Manage an Instance (ID#421) Oracle8 Database Administration - Create Databases (ID#426) Oracle8 Database Administration - Manage Data Storage Structures (ID#430) Oracle8 Database Administration -
more...
Oracle Form Builder R6 Forms Fundamentals

... Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Oracle Developer: Form Builder Duration: 2 - 3 Hour(s)
more...
Oracle Form Builder R6 Enhancing the User Interface

... Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). In addition, learners should have taken the first part of the Oracle Developer series, Oracle Developer: Forms Fundamentals
more...
Oracle Form Builder R6 Writing and Debugging Code

... Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). In addition, learners should have taken the first two parts of the Oracle Developer series: Oracle Developer: Forms Fundamentals
more...
Oracle Form Builder R6 Project Builder and Menu Modules

... Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). In addition, learners should have taken the first three parts of the Oracle Developer series: Oracle Developer: Forms Fundamentals
more...
Oracle Form Builder R6 Controlling the User Interface Programmatically

... Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). In addition, learners should have taken the first four parts of the Oracle Developer series: Oracle Developer: Forms Fundamentals
more...
Oracle Form Builder R6 Including Reusable Oracle Components

... Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). In addition, learners should have taken the first five parts of the Oracle Developer series: Oracle Developer: Forms Fundamentals
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...
SQL and PL SQL DML and DDL

...L: Basic SELECT Statements (course 61110) and Oracle SQL: Data Retrieval Techniques (61111). This course will help candidates prepare for test 1Z0-001, which applies towards the following Oracle Certified Professional (OCP) Program certification tracks: Oracle7.3 Certified Database Administrator, Oracle8 Certified Database Administrator, and Oracle Certified Application Developer, Release 2.
more...
Oracle8i Database Admin Create Databases

...Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113), Oracle8i Database Administration: Manage an Instance (63311). This course will help candidates prepare for the Oracle8i Certified DBA Architecture and Administration exam 1Z0-023. T otal Learning Time 6 - 8 Hour(s)
more...
Oracle8i Database Admin Manage Storage Structures

...Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113), Oracle8i Database Administration: Manage an Instance (63311) and Oracle8i Database Administration: Create a Database (63312). This course will help candidates prepare for the Oracle8i Certified DBA Architecture and
more...
Oracle8i Database Admin Manage Data Storage

...Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113), Oracle8i Database Administration: Manage an Instance (63311) and Oracle8i Database Administration: Create a Database (63312) and Oracle8i Database Administration: Manage Storage Structures (63313). This course will help
more...
Oracle8i Database Admin Manage Security

...Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113), Oracle8i Database Administration: Manage an Instance (63311) and Oracle8i Database Administration: Create a Database (63312). This course will help candidates prepare for the Oracle8i Certified DBA Architecture and
more...
OCDBA8i Curriculum

...Oracle SQL: Basic SELECT Statements (ID#378) Oracle SQL: Data Retrieval Techniques (ID#379) Oracle SQL: DML & DDL (ID#380) Oracle SQL: PL/SQL: Basics(ID#322) Oracle 8i Backup and Recovery: Strategies & Backups(ID#7486) Oracle 8i Backup and Recovery: Troubleshooting & Recovery(ID#7487) Oracle 8i Database Admin.: Manage an Instance(ID#7476) Oracle 8i Database Admin.: Create
more...
Oracle Designer 6i Curriculum

The Complete Oracle Designer 6i Curriculum includes the following courses: Oracle SQL: Basic SELECT Statements Oracle SQL: Data Retrieval Techniques Oracle SQL: DML & DDL Oracle SQL: PL/SQL: Basics Oracle Designer 6i First Class: Analysis Oracle Designer 6i First Class: Design & Generation To review individual course descriptions, please return to the previous page and select the
more...
Oracle9i SQL Curriculum

The Introduction to Oracle9i: SQL Curriculum includes the following courses: Oracle9i SQL: Basic SELECT Statements Oracle9i SQL: Data Retrieval Techniques Oracle9i SQL: DML and DDL To review individual course descriptions, please return to the previous page and select the desired title(s).
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. Learn To: o Identify the four Oracle join types used to display data from more than one table. o
more...
Oracle9i SQL DML and DDL

...le9i SQL: Basic SELECT Statements 61130 and Oracle9i SQL: Data Retrieval Techniques 61131. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English, Brazilian Portuguese, German, Spanish Total Learning Time 6 to 8 hours 61132 Objectives Unit 1: Creating Tables and Constraints 0.5 - 1
more...
Oracle9i Database Admin Manage an Instance

Course Overview The Oracle9i Database Administration: Manage An Instance course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle9i. This course introduces the participants to the concepts and procedures associated with Oracle architectural components. The participants learn the various tasks of a database administrator that are
more...
Oracle9i Database Admin Manage Storage Structures

... Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL: Procedures, Functions, and Packages (61114), Oracle PL/SQL: Database Programming (61115). Content Emphasis Conceptual Deployment Options Accreditation NASBA credits: 4 CPE Credits Language Options
more...
Oracle9i Database Admin Manage Data Storage

... Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL: Procedures, Functions, and Packages (61114), Oracle PL/SQL: Database Programming (61115). Content Emphasis Conceptual Deployment Options Accreditation NASBA credits: 4 CPE Credits Language Options
more...
Oracle9i Database Admin Manage Security

... Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL: Procedures, Functions, and Packages (61114), Oracle PL/SQL: Database Programming (61115). Content Emphasis Conceptual Deployment Options Accreditation NASBA credits: 4 CPE Credits Language Options
more...
Oracle SQL PL SQL Using Procedure Builder Curriculum

...cle SQL: Basic SELECT Statements Course 61111 Oracle SQL: Data Retrieval Techniques Course 61112 Oracle SQL: DML and DDL Course 61113 Oracle PL/SQL: Basics Certification: This curriculum will help candidates prepare for test 1Z0-001, which applies towards the following Oracle Certified Professional (OCP) Program certification tracks: Oracle8i Certified Database Administrator, Oracle8 Certified
more...
SAP Strategic Enterprise Management SEM

SAP Strategic Enterprise Management (SEM) shows what SAP SEM is, which business processes it covers, and which companies use it. The student will be introduced to the components of the SAP SEM System and their functions. Learn To: o Overview of SAP SEM. o Integration and Components. o Data Basis and Implementation Scenarios. o Components of the SAP SEM System. o SEM BIC and SRM. o
more...
Oracle8i Database Admin Manage an Instance

...Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113). This course will help candidates prepare for the Oracle8i Certified DBA Architecture and Administration exam 1Z0-023. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Oracle Architecture Components
more...
Oracle Internet App Dev Track for Forms Developer R6 6i Curriculum

... Oracle SQL: Basic SELECT Statements(ID#378) Oracle SQL: Data Retrieval Techniques(ID#379 Oracle SQL: DML and DDL(ID#380) Oracle PL/SQL: Basics(ID#322) Oracle PL/SQL: Procedures, Functions and Packages(ID#7745) Oracle PL/SQL: Database Programming(ID#7746) Oracle Developer: Forms Fundamentals(ID#470) Oracle Developer: Enhancing the User Interface(ID#471) Oracle Developer: Writing and
more...
From Serebra Learning Corporation
Data Retrieval and Manipulation in Macromedia ColdFusion MX
To introduce and demonstrate data retrieval and manipulation in ColdFusion MX Web professionals and developers that want to create dynamic web sites using ColdFusion
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...
SQL Functions in Oracle Database 10g
To describe how to use SQL functions for data retrieval Database administrators, application developers, and database operators
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...
Building XML-Based Web Applications Part 2: Validation and Dynamic Data Retrieval
This is the second course in a five part series that presents an introduction to the treatment of validation technologies within XML. DTDs are covered presenting detail on DTD elements and attributes and entities. XML Schemas are then introduced emphasizing the advantages of schemas over DTDs and then covering data types and namespaces within XML Schemas. The course then covers the treatment of
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...
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...
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...
MS SQL Server 6.5: Design & Management


In this course, students will learn to implement a database design on Microsoft SQL Server 6.5. Specific topics include: SQL Server implementor roles and responsibilities; data modeling and data definition concepts; database object creation, such as tables; and basic data retrieval, manipulation, and modification. This course, together with MS SQL Server 6.5 DB Design Il, prepares students for
more...
From PDHengineer. com-Decatur Professional Development, LLC
Wind Energy Assessment
...hlights data issues related to in-field raw data storage, data retrieval and protection, retrieval frequency, and documentation. The student is expected to read and review the material contained in Wind Resource Assessment Handbook, AWS Scientific, Inc., NREL Subconract No. TAT-5-15283-01. The student must take a multiple-choice quiz consisting of thirty (30) questions at the end of this
more...
Introduction to Solar Engineering
... examples are included to illustrate the calculations and data retrieval methods presented. This course is intended for mechanical, electrical and energy engineers. Students will gain basic knowledge about solar electromagnetic radiation, become familiar with fundamental solar parameters, learn to obtain or calculate values for those parameters and use them in calculations. A multiple-choice
more...
Passive Solar Heating Basics
... specified size at a specified location is presented. The data retrieval and calculations are illustrated with numerous examples.
The student must take a multiple-choice quiz consisting of thirty (30) questions at the end of the course to obtain PDH credits.
Specific Knowledge or Skill Obtained
This course teaches the following specific knowledge and skills:
?The six
more...
