From Serebra Learning Corporation
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...
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...
MS SQL Server 6.5: Advanced Retrieval Structures 


In this course, students will learn to implement a database design on
Microsoft SQL Server 6.5. Specific topics include: summarizing and modifying data; database object creation, such as stored procedures and triggers; data referential integrity; the implementation of distributed data in a client/server environment; and the extensibility of
SQL Server. This course, together with MS SQL Server
more...
From 123-CBT Computer Based Training
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 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...
OCDBA8i Curriculum 

...e
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 Databases(ID#7477)
more...
Oracle8i Database Admin Manage Security 

... 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 Administration
more...
Oracle8 Database Administration - Manage Data 

...nformation about clusters.
Identify the data storage and retrieval features of an index-organized table.
Identify the features of an index-organized table that distinguish it from a regular table.
Create an index-organized table with an overflow area in a specified tablespace.
Identify the contents of the data dictionary views for index-organized tables.
Unit 4:
Loading and
Reorganizing more...
Oracle SQL Specifics Retrieving and Formatting Data 

...bqueries 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 functions.
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 of
more...
SQL and PL SQL Basic SELECT 

...ify comparison operators that can be used in defining row retrieval restrictions. Identify logical operators that can be used to define row retrieval restrictions. Sort rows retrieved by a query. Describe the types of
SQL funcitons, in order to define single-row functions. Demonstrate the use of four character functions; LOWER,
UPPER,
INITCAP, and
LENGH. Demonstrate the use of three
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...
XML Building XML-Based Web Applications Part 2 

... (
DTDs) to an
XML document. Identify features of retrieval and mapping of XML data. Identify benefits of XML to
Web applications. Identify the procedure used by Web applications to communicate between the browser and the server. Audience The intended audience for this course include individuals who operate a software development environment using
Microsoft more...
XML Building XML-Based Web Applications Part 2 

... (
DTDs) to an
XML document. Identify features of retrieval and mapping of XML data. Identify benefits of XML to
Web applications. Identify the procedure used by Web applications to communicate between the browser and the server. Audience The intended audience for this course include individuals who operate a software development environment using
Microsoft more...