Online Ddl eLearning - Training Resources
Ddl Training Provider? - Tell us about your Training!
 online course |
 instructor-led class |
 learn at home |
 group study |
 self-directed study |
 cd-based training |
 DVD video training |
 printed book |
 e-book digital book |
 workshop seminar |
 train the trainer |
 computer-based learning |
 discount pricing |
 online tutorial |
From 123-CBT Computer Based Training
Oracle Database 11g Using DDL Views Sequences Indexes and Synonyms
To recognize the steps for creating, defining, and dropping tables , manipulating how their data can be viewed, and using schema objects to generate integers, improve queries, and rename tables.
more...
Oracle Database 11g Using DDL Views Sequences Indexes and Synonyms
To recognize the steps for creating, defining, and dropping tables , manipulating how their data can be viewed, and using schema objects to generate integers, improve queries, and rename tables.
more...
Oracle Database 11g Using DML DDL Cursors Control Structures and Loops
To identify the steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures.
more...
To identify the steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures.
more...
Oracle SQL PL SQL Using Procedure Builder Curriculum
...ata 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 Database Administrator, and Oracle Certified Application
more...
...ata 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 Database Administrator, and Oracle Certified Application
more...
Oracle9i Performance Tuning Optimizing Sorts Minimizing Contention
...tics. o Select the statements that characterize DML and DDL locks. o Identify the DML lock characteristics. o Sequence the process steps of the Oracle shared server configuration. o Identify the characteristics of the Oracle shared server. o Query a dispatcher process to determine the process status using the V$DISPATCHER view. Audience The intended audience for this course
more...
...tics. o Select the statements that characterize DML and DDL locks. o Identify the DML lock characteristics. o Sequence the process steps of the Oracle shared server configuration. o Identify the characteristics of the Oracle shared server. o Query a dispatcher process to determine the process status using the V$DISPATCHER view. Audience The intended audience for this course
more...
Oracle9i Database Admin Manage Security
...L: 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 American English Total Learning Time 6 to 8
more...
...L: 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 American English Total Learning Time 6 to 8
more...
Oracle9i Database Admin Manage Data Storage
Course Overview This course is the fourth in the series covering the database administration strategies and procedures provided in Oracle9. This course covers the concepts associated with tables, maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data. Learn To • Identify the row storage method used by the various tables and the
more...
Course Overview This course is the fourth in the series covering the database administration strategies and procedures provided in Oracle9. This course covers the concepts associated with tables, maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data. Learn To • Identify the row storage method used by the various tables and the
more...
Oracle9i Database Admin Manage Storage Structures
...L: 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 American English Total Learning Time 6 to 8
more...
...L: 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 American English Total Learning Time 6 to 8
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...
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
...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 course also
more...
...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 course also
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...
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...
SQL Server 2000 Querying with Transact SQL Part 1 Manipulating Data
...QL). Identify the functions of Data Definition Language (DDL) statements. Identify the functions of Data Control Language (DCL) statements. Identify the guidelines for selecting columns within a table. Identify the guidelines for using the WHERE clause to retrieve rows in a table. Retrieve specific columns from a table. Identify the characteristics of aggregate functions. Identify the
more...
...QL). Identify the functions of Data Definition Language (DDL) statements. Identify the functions of Data Control Language (DCL) statements. Identify the guidelines for selecting columns within a table. Identify the guidelines for using the WHERE clause to retrieve rows in a table. Retrieve specific columns from a table. Identify the characteristics of aggregate functions. Identify the
more...
SQL Server 2000 Design Implement Databases Part 1 Intro to SQL Server
...ons. Identify the functions of Data Definition Language (DDL) statements. Identify the types of SQL Server 2000 databases. Identify the features of the SQL Server 2000 object-naming standard. Identify the methods for retrieving metadata information. Audience The audience for this course includes database designers, database managers, and technical managers. Candidates for Exam 70-229
more...
...ons. Identify the functions of Data Definition Language (DDL) statements. Identify the types of SQL Server 2000 databases. Identify the features of the SQL Server 2000 object-naming standard. Identify the methods for retrieving metadata information. Audience The audience for this course includes database designers, database managers, and technical managers. Candidates for Exam 70-229
more...
Oracle Internet App Dev Track for Forms Developer R6 6i Curriculum
...QL: 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 Debugging Code(ID#472) Oracle Developer: Project Builder
more...
...QL: 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 Debugging Code(ID#472) Oracle Developer: Project Builder
more...
Oracle PL SQL Database Programming
...tements (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 - 2 Hour(s) Select the processes involved in creating a stored procedure and a stored function
more...
...tements (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 - 2 Hour(s) Select the processes involved in creating a stored procedure and a stored function
more...
Oracle PL SQL Procedures Functions Packages
...atements (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 developing environments. Identify the steps to create a subprogram. Identify the features of the
more...
...atements (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 developing environments. Identify the steps to create a subprogram. Identify the features of the
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...
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...
OCDBA8i Curriculum
...QL: 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) Oracle 8i Database Admin.: Manage Storage
more...
...QL: 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) Oracle 8i Database Admin.: Manage Storage
more...
Oracle8i Database Admin Manage Security
...eval 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 exam 1Z0-023. T otal Learning Time 6 - 8 Hour(s) Course
more...
...eval 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 exam 1Z0-023. T otal Learning Time 6 - 8 Hour(s) Course
more...
Oracle8i Database Admin Manage Data Storage
...eval 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 candidates prepare for the Oracle8i Certified DBA Architecture and
more...
...eval 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 candidates prepare for the Oracle8i Certified DBA Architecture and
more...
Oracle8i Database Admin Manage Storage Structures
...eval 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 exam 1Z0-023. T otal Learning Time 6 - 8 Hour(s) Course
more...
...eval 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 exam 1Z0-023. T otal Learning Time 6 - 8 Hour(s) Course
more...
Oracle8i Database Admin Create Databases
...eval 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) Course Contents Unit 1: Creating a Database: Procedure Duration:
more...
...eval 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) Course Contents Unit 1: Creating a Database: Procedure Duration:
more...
Oracle8i Database Admin Manage an Instance
...eval 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 Duration: 1 - 2 Hour(s) Identify the tasks of a database
more...
...eval 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 Duration: 1 - 2 Hour(s) Identify the tasks of a database
more...
Oracle Reports R6 Control Reports
...atements (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 parts in this series: Oracle Reports: Reports Fundamentals (course 62221); and, Oracle Reports:
more...
...atements (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 parts in this series: Oracle Reports: Reports Fundamentals (course 62221); and, Oracle Reports:
more...
Oracle Reports R6 Enhance Reports
...atements (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 this series Oracle Reports: Reports Fundamentals (course 62221). T otal Learning Time 6 -
more...
...atements (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 this series Oracle Reports: Reports Fundamentals (course 62221). T otal Learning Time 6 -
more...
Oracle Reports R6 Report Fundamentals
...atements (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 Unit 1: Oracle Developer Report Builder Duration: 1.5 - 2 Hour(s) Match the components
more...
...atements (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 Unit 1: Oracle Developer Report Builder Duration: 1.5 - 2 Hour(s) Match the components
more...
Oracle Form Builder R6 Including Reusable Oracle Components
...L: 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 (62211); Oracle Developer: Enhancing the User Interface
more...
...L: 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 (62211); Oracle Developer: Enhancing the User Interface
more...
Oracle Form Builder R6 Controlling the User Interface Programmatically
...L: 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 (62211); Oracle Developer: Enhancing the User Interface
more...
...L: 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 (62211); Oracle Developer: Enhancing the User Interface
more...
Oracle Form Builder R6 Project Builder and Menu Modules
...L: 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 (62211); Oracle Developer: Enhancing the User Interface
more...
...L: 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 (62211); Oracle Developer: Enhancing the User Interface
more...
Oracle Form Builder R6 Writing and Debugging Code
...L: 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 (62211) and Oracle Developer: Enhancing the User
more...
...L: 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 (62211) and Oracle Developer: Enhancing the User
more...
Oracle Form Builder R6 Enhancing the User Interface
...L: 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 (62211). T otal Learning Time 6 - 8 Hour(s) Course
more...
...L: 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 (62211). T otal Learning Time 6 - 8 Hour(s) Course
more...
Oracle Form Builder R6 Forms Fundamentals
...L: 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) Identify the features of Oracle Developer. Match
more...
...L: 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) Identify the features of Oracle Developer. Match
more...
Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention
...utes.
Label the list of characteristics as either DML or DDL lock attributes.
Identify DML lock characteristics.
Label the list of characteristics as either Row Exclusive or Row Share table lock modes.
Lock a table.
Identify table partition lock attributes.
Match DDL locks with the correct definition.
Identify situations that contribute to lock contention.
View the name of locked
more...
...utes.
Label the list of characteristics as either DML or DDL lock attributes.
Identify DML lock characteristics.
Label the list of characteristics as either Row Exclusive or Row Share table lock modes.
Lock a table.
Identify table partition lock attributes.
Match DDL locks with the correct definition.
Identify situations that contribute to lock contention.
View the name of locked
more...
Oracle8 Database Administration - Manage Data
....
Identify the factors to be considered while performing DDL on the tables referenced by a foreign key.
Identify the factors to be considered while performing DML on the FK-PK related tables.
Identify the various types of triggers with the situations under which they are executed.
Disable triggers by using Oracle SQL Worksheet.
Enable triggers by using Oracle SQL Worksheet.
Create an
more...
....
Identify the factors to be considered while performing DDL on the tables referenced by a foreign key.
Identify the factors to be considered while performing DML on the FK-PK related tables.
Identify the various types of triggers with the situations under which they are executed.
Disable triggers by using Oracle SQL Worksheet.
Enable triggers by using Oracle SQL Worksheet.
Create an
more...
Oracle8 Certified Database Administrator Curriculum
...QL: 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 - Manage Data Storage (ID#434) Oracle8 Database
more...
...QL: 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 - Manage Data Storage (ID#434) Oracle8 Database
more...
Oracle Cert App Developer Track for Developer 2000 R2 Curriculum
...QL: Data Retreival Techniques (ID#379) Oracle SQL: DML & DDL (ID#380) Oracle SQL: PL/SQL: Basics (ID#322) Oracle PL/SQL: Procedures, Functions and Packages (ID#7745) Oracle PL/SQL: Database Programming (ID#7746) Oracle Form Builder: Form Fundamentals (ID#381) Oracle Form Builder: Enhancing the User Interface (ID#387) Oracle Form Builder: Writing and Debugging Code (ID#389) Oracle Form
more...
...QL: Data Retreival Techniques (ID#379) Oracle SQL: DML & DDL (ID#380) Oracle SQL: PL/SQL: Basics (ID#322) Oracle PL/SQL: Procedures, Functions and Packages (ID#7745) Oracle PL/SQL: Database Programming (ID#7746) Oracle Form Builder: Form Fundamentals (ID#381) Oracle Form Builder: Enhancing the User Interface (ID#387) Oracle Form Builder: Writing and Debugging Code (ID#389) Oracle Form
more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 4
...atch the ADO MD objects with their properties. Match the DDL statements provided in OLE DB for OLAP specifications with their functions. Connect to an OLAP database by using ADO MD. Read the definition of a cube by using ADO MD. Retrieve data from a cube by using ADO MD. Display the cube data by using a graph. Identify the features of OLE DB for data access. Create a DSN for data access
more...
...atch the ADO MD objects with their properties. Match the DDL statements provided in OLE DB for OLAP specifications with their functions. Connect to an OLAP database by using ADO MD. Read the definition of a cube by using ADO MD. Retrieve data from a cube by using ADO MD. Display the cube data by using a graph. Identify the features of OLE DB for data access. Create a DSN for data access
more...
SQL and PL SQL PL SQL Basics
...atements (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 actions by which a PL/SQL engine processes a block of code. Identify the features of the sections of a
more...
...atements (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 actions by which a PL/SQL engine processes a block of code. Identify the features of the sections of a
more...
SQL and PL SQL DML and DDL
Course 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...
Course 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...
Database Technologies Introduction to SQL
...on in two basic aspects of SQL: Data Definition Language (DDL - creating databases and tables) and Data Manipulation Language (DML - adding, altering, and querying data). Learn To: o Identify what 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
more...
...on in two basic aspects of SQL: Data Definition Language (DDL - creating databases and tables) and Data Manipulation Language (DML - adding, altering, and querying data). Learn To: o Identify what 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
more...
CIW Database Specialist Part 2 Logical Physical Design
.... o Identify keywords used in data definition language (DDL). Audience The intended audiences for this course include individuals who design, implement, and maintain database schemas; design and develop database client applications and components; and perform database administration and maintenance, database developers, enterprise developers, application developers, software engineers,
more...
.... o Identify keywords used in data definition language (DDL). Audience The intended audiences for this course include individuals who design, implement, and maintain database schemas; design and develop database client applications and components; and perform database administration and maintenance, database developers, enterprise developers, application developers, software engineers,
more...
CIW Database Specialist Part 3 Database Interaction JDBC
..., and an introduction to the JDBC. This course covers SQL DDL commands, inserting, updating, and querying with DML statements, granting and revoking privileges with DCL statements. The course also teaches about relational algebra concepts, to include joins, transactions and database security, and using JDBC drivers and executing SQL statements. Learn To: o Identify features of Structured
more...
..., and an introduction to the JDBC. This course covers SQL DDL commands, inserting, updating, and querying with DML statements, granting and revoking privileges with DCL statements. The course also teaches about relational algebra concepts, to include joins, transactions and database security, and using JDBC drivers and executing SQL statements. Learn To: o Identify features of Structured
more...
Oracle Database 10g PL SQL Fundamentals Part 2
This course introduces learners to PL/SQL and helps them understand the benefits of this programming language. Students learn to create anonymous PL/SQL blocks. They learn to declare variables and trapping exceptions, develop stored procedures, functions, packages and database triggers.
Learn To:
Identify features of PL/SQL blocks within a subprogram.
Match types of PL/SQL named blocks
more...
This course introduces learners to PL/SQL and helps them understand the benefits of this programming language. Students learn to create anonymous PL/SQL blocks. They learn to declare variables and trapping exceptions, develop stored procedures, functions, packages and database triggers.
Learn To:
Identify features of PL/SQL blocks within a subprogram.
Match types of PL/SQL named blocks
more...
From Serebra Learning Corporation
Relational Database Concepts Structured Query Language
This course introduces the Structured Query Language (SQL), which is the most widely used language for the development and manipulation of relational databases. The course focuses on Relational Database Management Systems (RDBMS) query language technology and will identify and explain the details of the Structured Query Language (SQL). This course is designed to help individuals who want to
more...
This course introduces the Structured Query Language (SQL), which is the most widely used language for the development and manipulation of relational databases. The course focuses on Relational Database Management Systems (RDBMS) query language technology and will identify and explain the details of the Structured Query Language (SQL). This course is designed to help individuals who want to
more...
PL SQL Triggers
To create and manage triggers Database administrators, application developers, and database operators
more...
To create and manage triggers Database administrators, application developers, and database operators
more...
Dynamic SQL and Metadata
To write dynamic SQL and use the DBMS_METADATA package Database administrators, application developers, and database operators
more...
To write dynamic SQL and use the DBMS_METADATA package Database administrators, application developers, and database operators
more...
JDBC Application Development Part 2: Creating Database Programs
This second course in the series teaches how to use the JDBC API to create database programs. It provides more detailed information about types of JDBC drivers and how to use them with Java programs. It also covers basic features of using data definition language and data manipulation language commands to create and query tables and databases.
more...
This second course in the series teaches how to use the JDBC API to create database programs. It provides more detailed information about types of JDBC drivers and how to use them with Java programs. It also covers basic features of using data definition language and data manipulation language commands to create and query tables and databases.
more...
IBM DB2 UDB Essentials Part 3 - SQL Fundamentals
This course introduces the learner to the fundamental elements of the SQL language. Simple query running is covered before moving on to more complex procedures such as retrieving data from multiple tables and creating single reports from multiple queries. Scalar and column functions are covered. Coverage is also given to running subqueries and maintaining data. On completion of the course the
more...
This course introduces the learner to the fundamental elements of the SQL language. Simple query running is covered before moving on to more complex procedures such as retrieving data from multiple tables and creating single reports from multiple queries. Scalar and column functions are covered. Coverage is also given to running subqueries and maintaining data. On completion of the course the
more...
Oracle 8i PL/SQL - DML and DDL Statements
...DDL and DML statements. It explains the concept of creation of tables and views. It also covers the various commands for manipulating a database. In addition the course explains the transaction processing features. It highlights the concept of altering a table definition in a database dropping a table adding comments to a table and renaming a table. It describes the various methods of managing
more...
...DDL and DML statements. It explains the concept of creation of tables and views. It also covers the various commands for manipulating a database. In addition the course explains the transaction processing features. It highlights the concept of altering a table definition in a database dropping a table adding comments to a table and renaming a table. It describes the various methods of managing
more...
Oracle9i SQL: DML and DDL
...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 course also
more...
...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 course also
more...
CIW Database Specialist Part 3: Database Interaction and JDBC
This is the third course in a four part series that teaches students about SQL relational algebra transactions and database security and an introduction to the JDBC. This course covers SQL DDL commands inserting updating and querying with DML statements granting and revoking privileges with DCL statements. The course also teaches about relational algebra concepts to include joins transactions and
more...
This is the third course in a four part series that teaches students about SQL relational algebra transactions and database security and an introduction to the JDBC. This course covers SQL DDL commands inserting updating and querying with DML statements granting and revoking privileges with DCL statements. The course also teaches about relational algebra concepts to include joins transactions and
more...
Oracle SQL: DML and DDL
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 these data objects.
more...
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 these data objects.
more...
Oracle9i SQL: DML and DDL
...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 course also
more...
...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 course also
more...
Database Technologies Part 2: Introduction to SQL
The second in a two-part series this course will teach students the fundamental skills and knowledge needed to acquire a foundation-level understanding of SQL. Building on the basic relational database skills and knowledge acquired in the first course this course teaches students the essential SQL statements and associated variations needed to perform fundamental data access and manipulation on a
more...
The second in a two-part series this course will teach students the fundamental skills and knowledge needed to acquire a foundation-level understanding of SQL. Building on the basic relational database skills and knowledge acquired in the first course this course teaches students the essential SQL statements and associated variations needed to perform fundamental data access and manipulation on a
more...
From Teach Me IT
Advanced PL/SQL Programming
The Advanced PL/SQL Programming WBT is the third course in this curriculum. This course will enable users to create functions, packages, database objects, collections, and triggers. Additionally, it will enable users to create transactions, apply locks, and use dynamic SQL. After completing this course, the student will be able to:
Create PL/SQL packages
Manage PL/SQL packages
Identify various
more...
The Advanced PL/SQL Programming WBT is the third course in this curriculum. This course will enable users to create functions, packages, database objects, collections, and triggers. Additionally, it will enable users to create transactions, apply locks, and use dynamic SQL. After completing this course, the student will be able to:
Create PL/SQL packages
Manage PL/SQL packages
Identify various
more...
online course |
instructor-led class |
learn at home |
group study |
self-directed study |
cd-based training |
DVD video training |
printed book |
e-book digital book |
workshop seminar |
train the trainer |
computer-based learning |
discount pricing |
online tutorial |
