From Serebra Learning Corporation
Oracle9i SQL: DML and DDL 


...Oracle
SQL DML and
DDL course is the third in a three-part series covering the
Data Manipulation and
Data Definition language statements supported by
Oracle9i. This course introduces the participants to various objects in a database. The participants learn to create, update, and delete the database objects. The participants also learn to add rows, update, and delete existing rows from a table.
more...
Oracle SQL for End Users Part 1 
...Oracle
SQL and SQL*Plus are powerful components of
Oracle's relational and object relational database management systems. This course is designed for end users 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
more...
Oracle SQL for End Users Part 2 
This course is the second in a two-part
SQL for
End Users series that is based on
Introduction to
Oracle: SQL and PL/SQL. In this course the learner displays data from multiple tables by using equijoins non-equijoins and self joins. In addition this course introduces the use of group functions in a SQL statement to display information about groups of rows in the database. This course also covers
more...
Oracle SQL: Basic SELECT Statements 
...Oracle
SQL series that is based on the
ILT course
Introduction to
Oracle: SQL and PL/SQL. This course introduces the learner to Oracle relational database concepts and the use of SQL for storing retrieving and manipulating data in a relational database. This course covers relational database principles and Oracle concepts; writing basic SQL statements; restricting and sorting data; and using
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: DML and DDL 
...Oracle
SQL DML and
DDL course is the third in a three-part series covering the
Data Manipulation and
Data Definition language statements supported by
Oracle9i. This course introduces the participants to various objects in a database. The participants learn to create update and delete the database objects. The participants also learn to add rows update and delete existing rows from a table. The
more...
Oracle SQL and SQL*Plus: SQL*Plus and Reporting 
...Oracle
SQL Specifics that will teach participants how to use commands functions and operators supported by
Oracle as extensions to standard
SQL. Users will learn how to create and manage tables build integrity constraints and use the
COMMIT and
ROLLBACK statements to control transactions. Learners will create and maintain views sequences indexes and synonyms. Additionally users will learn how
more...
Oracle SQL Tuning: Diagnostics and Tuning the Schema 
This course is the first in a two-part series on
SQL Statement Tuning. This course will help experienced application developers to learn a tuning methodology they can use to maximize database performance with minimal effort. Participants will gain experience creating optimal access paths such as partitioned views
B-tree indexes bitmapped indexes index clusters and hash clusters. Participants will
more...
From 123-CBT Computer Based Training
Oracle9i Database Admin Manage Data Storage 

...relationship information and trigger information by using
Oracle SQL*Plus
Worksheet. Load data by using direct-load inserts, identify the concepts associated with
SQL*Loader, and use SQL*Loader to load data into tables. Identify the uses of the export and import utilities, the export modes, and the export paths. Reorganize data using export and import, identify the
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 SQL DML and DDL 

...Oracle
SQL DML and
DDL course is the third in a three-part series covering the
Data Manipulation and
Data Definition language statements supported by
Oracle9i. This course introduces the participants to various objects in a database. The participants learn to create, update, and delete the database objects. The participants also learn to add rows, update, and delete existing rows from a table.
more...
Oracle PL SQL Database Programming 

...nt to the computer based training (
CBT) courses entitled:
Oracle SQL and
SQL *Plus:
Basic SELECT Statements (course 61110), Oracle SQL and SQL *Plus:
DML and DDL (course 61112), Oracle PL/SQL: Basics (course 61113) and Oracle PL/SQL: Procedures, Functions and Packages (course 61114). T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Developing Program Units Duration: 1
more...
Oracle PL SQL Procedures Functions Packages 

...nt to the computer based training (
CBT) courses entitled:
Oracle SQL and
SQL*Plus:
Basic SELECT Statements (course 61110), Oracle SQL and SQL*Plus:
DML and DDL (61112). T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Subprograms: Procedures Duration: 2 - 3 Hour(s) Match the various sections of a subprogram with their contents. Identify the components of
more...
Oracle Reports R6 Control Reports 

...hould have knowledge equivalent to the following courses:
Oracle SQL and
SQL*Plus:
Basic SELECT Statements (course 61111); Oracle SQL and SQL*Plus:
DML and
DDL (course 61112); Oracle PL/SQL: Basics (course 60113); Oracle PL/SQL: Procedures, Functions and Packages (course 60114); and Oracle PL/SQL: Database Programming (course 60131). In addition, participants should have taken the first two
more...
Oracle Reports R6 Enhance Reports 

...hould have knowledge equivalent to the following courses:
Oracle SQL and
SQL*Plus:
Basic SELECT Statements (course 61111); Oracle SQL and SQL*Plus:
DML and
DDL (course 61112); Oracle PL/SQL: Basics (course 60113); Oracle PL/SQL: Procedures, Functions and Packages (course 60114); and Oracle PL/SQL: Database Programming (course 60131). In addition, participants should have taken the first part in
more...
Oracle Reports R6 Report Fundamentals 

...hould have knowledge equivalent to the following courses:
Oracle SQL and
SQL*Plus:
Basic SELECT Statements (course 61111); Oracle SQL and SQL*Plus:
DML and
DDL (course 61112); Oracle PL/SQL: Basics (course 60113); Oracle PL/SQL: Procedures, Functions and Packages (course 60114); and Oracle PL/SQL: Database Programming (course 60131). T otal Learning Time 6 - 8 Hour(s) Course Contents
more...
Oracle8 Database Administration - Manage Data 

...racle
Schema Manager.
Manually allocate extents by using
Oracle SQL Worksheet.
Identify the characteristics of the high water mark.
Validate a table structure by using Oracle SQL Worksheet.
Execute the command used to detect row migration in a table by using Oracle SQL Worksheet.
De-allocate the unused space in a table by using Oracle SQL Worksheet.
Truncate a table by using
Oracle SQL more...
Oracle SQL Tuning Diagnostics and Tuning Schema 

Course Overview
This course is the first in a two-part series on
SQL Statement Tuning. This course will help experienced application developers to learn a tuning methodology they can use to maximize database performance with minimal effort. Participants will gain experience creating optimal access paths, such as partitioned views,
B-tree indexes, bitmapped indexes, index clusters, and hash
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 PL SQL Basics 

...nt to the computer based training (
CBT) courses entitled:
Oracle SQL and
SQL*Plus:
Basic SELECT Statements (course 61110), Oracle SQL and SQL*Plus:
DML and DDL (61112) and Oracle 8i. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: PL/SQL: An Introduction Duration: 0.5 - 2 Hour(s) Identify the features of PL/SQL. Identify the benefits of PL/SQL. Select the
more...
SQL and PL SQL Basic SELECT 

...ourse
Overview This course is the first in a three-part
Oracle SQL series that is based on the
ILT course
Introduction to
Oracle:
SQL and PL/SQL. This course introduces the learner to Oracle relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database. This course covers relational database principles and Oracle concepts; writing
more...
SQL and PL SQL DML and DDL 

...ourse
Overview This course is the third in a three-part
Oracle SQL series that is based on the
Oracle ILT course,
Introduction to
Oracle:
SQL and PL/SQL. Using the Oracle SQL*Plus environment, this computer-based training course uses Structured Query Language (SQL) to create and populate Oracle database tables. Learners create tables and other database objects and learn to maintain and modify
more...
Oracle SQL for End Users--Part 1 

...Oracle
SQL and SQL*Plus are powerful components of
Oracle's relational and object relational database management systems. This course is designed for end users 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
more...
Oracle SQL for End Users--Part 2 

Course
Overview This course is the second in a two-part
SQL for
End Users series that is based on
Introduction to
Oracle: SQL and PL/SQL. In this course, the learner displays data from multiple tables by using equijoins, non-equijoins, and self joins. In addition, this course introduces the use of group functions in a SQL statement to display information about groups of rows in the database.
more...