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...
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...
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 of
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...