Online Ddl To eLearning
Ddl To Training Provider? - Tell us about your Training!
From 123-CBT Computer Based Training
Oracle Database 11g Using DML DDL Cursors Control Structures and Loops

Oracle Database 11g: Using DML, DDL, Cursors, Control Structures, and Loops Oracle
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 Database 11g Using DML DDL Cursors Control Structures and Loops
Oracle Database 11g Using DDL Views Sequences Indexes and Synonyms

Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms Oracle
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...
Creating Implementing Programming Objects in SQL Server 2008

Creating & Implementing Programming Objects in SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433)
In SQL Server 2008 you can use Transact-SQL statements to access data in the databases. Transact-SQL statements can be grouped together in a number of ways to create more complex queries when one Transact-SQL statement will not
more...
Oracle Database 11g Using DDL Views Schema Objects

Oracle Database 11g: Using DDL, Views & Schema Objects Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert
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 Loops Control Structures

Oracle Database 11g: Using DML, DDL, Cursors, Loops & Control Structures Oracle
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 Database 11g Database Auditing

Oracle Database 11g: Database Auditing Oracle
Monitoring or auditing should be an integral part of your security procedures. Oracle Database 11g includes auditing tools for database, user, and fine-grained auditing. This course explores how to implement basic database auditing, privileged user auditing, DML and DDL auditing, and how to send audit records to the operating system files.
more...
Oracle Cert App Developer Track for Developer 2000 R2 Curriculum

NETg is Oracle's partner in offering interactive TBT preparation courses for this important certification program. Each of these TBT courses has been co-developed by Oracle Education and NETg to offer step-by-step instruction and hands-on practice in key topic areas. The Complete Oracle Certified Application Developer Track for Developer/2000 Release 2 consists of the following courses:
more...
Oracle8 Certified Database Administrator Curriculum

NETg is Oracle's partner in offering interactive TBT preparation courses for this important certification program. Each of these TBT courses has been co-developed by Oracle Education and NETg to offer step-by-step instruction and hands-on practice in key topic areas. The Complete Oracle8 Certified Database Administrator Curriculum consists of the following courses: Oracle SQL: Basic SELECT
more...
Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention

Course Overview
This course is the third in a three-part Oracle8 Performance Tuning series. This course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts, ensure that sorting is done in memory where possible, use direct writes for large sorts and allocate temporary space appropriately. The student
more...
Oracle Form Builder R6 Forms Fundamentals

Course Overview This course is the first in a six-part Oracle Developer series that is based on Oracle Developer Release 6. This course introduces the learner to the key features, components, and capabilities of Oracle Developer. In addition, this course helps learners to run, create, and customize a form module. L earn To: Identify the key features, components and capabilities of
more...
Oracle Form Builder R6 Enhancing the User Interface

Course Overview This course is the second in a six-part Oracle Developer series based on Oracle Developer Release 6. This course describes how to create input and non-input items, how to create lists of values (LOVs) and editors to support text items, and how to create forms using multiple windows and a variety of canvas styles. Additionally, this course covers ways to add functionality to
more...
Oracle Form Builder R6 Writing and Debugging Code

Course Overview This course is the third in a six-part Oracle Developer series that is based on Oracle Developer Release 6. In this course learners will create and control alerts, debug PL/SQL code, and process queries in form modules. In addition, the course will cover transaction processing, Form Builder application customization, and writing flexible code. L earn To: Identify the
more...
Oracle Form Builder R6 Project Builder and Menu Modules

Course Overview This course is the fourth in a six-part Oracle Developer series based on Oracle Developer Release 6. This course describes the features and benefits of Oracle Project Builder, how to create and deliver projects, and how to create new file types. In addition, the course describes how to create and manipulate menu modules, and how to manage menu modules. L earn To:
more...
Oracle Form Builder R6 Controlling the User Interface Programmatically

Course Overview This course is the fifth in a six-part Oracle Developer series based on Oracle Developer Release 6. This course enables learners to create Key triggers, to write code that responds to mouse events, to manage windows and canvases, and to use the Object Navigator. In addition, learners work with multiple form applications, record groups, and list items. L earn To:
more...
Oracle Form Builder R6 Including Reusable Oracle Components

Course Overview This course is the sixth in a six-part Oracle Developer series that is based on Oracle Developer Release 6. This course will enable learners to implement methods to use additional data sources, to work with Oracle8 objects, and to integrate charts, reports, and timers in form modules. In addition, the course covers the procedures to reuse components, objects, and code and to
more...
Oracle Reports R6 Report Fundamentals

Course Overview This course is the first in a three-part Oracle Report Builder series that is based on Oracle Reports Release 6. This course introduces the learner to, the key features of Report Builder, steps involved in building a standard tabular report and report layout styles. In addition, this course will help participants learn how to use the Live Previewer, store reports, and migrate
more...
Oracle Reports R6 Enhance Reports

Course Overview This course is the second in a three-part Oracle Reports series that is based on Oracle Reports Release 6. The goal of this course is to enable developers to construct complex reports and charts using Oracle Reports. This course introduces the learner to the key features of the Data Model editor, Layout Model objects and their properties. The course also enables the learner to
more...
Oracle Reports R6 Control Reports

Course Overview This course is the third in a three-part Oracle Reports series that is based on Oracle Reports Release 6. This course introduces the learner to features of Oracle Reports that can be used to control report output. This course covers developing templates, creating and using parameters, coding PL/SQL triggers, exporing built-in package procedures, using the Reports Server, and
more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 4

Course Overview This is the fourth course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the methods of aggregating and accessing data from relational data structures; identify the methods of data
more...
SQL and PL SQL PL SQL Basics

Course Overview This course introduces the learner to the basics of PL/SQL. The course builds the necessary skills for using Oracle PL/SQL. It will help the learner acquire the expertise to design, develop, and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming.
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...
Oracle8i Database Admin Create Databases

Course Overview This course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts associated with storage structure components, managing rollback segments, temporary segments, and indexes. In addition, creating and maintaining databases will be covered. L earn To:
more...
Oracle8i Database Admin Manage Storage Structures

Course Overview This course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn the concepts associated with storage structure components. In addition, this course will teach users how to create and maintain rollback segments, temporary segments and indexes. L earn To: Identify
more...
Oracle8i Database Admin Manage Data Storage

Course Overview This course is the fourth in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts associated with tables. In addition, this course will teach users about maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data. L
more...
Oracle8i Database Admin Manage Security

Course Overview This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts and tasks associated with managing security. L earn To: Define and maintain the security domains for users in a given environment. Define and maintain a named set of resources and
more...
OCDBA8i Curriculum

The Complete OCDBA8i Curriculum includes the following courses: 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
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...
Oracle PL SQL Procedures Functions Packages

61114 Course Overview This course is the second in a series of three titles. It introduces the learner to the basics of PL/SQL subprograms. This course covers the building and invoking of procedures and functions. Additionally, this course introduces the basics of creating and using packages. L earn To: Identify the types and components of a subprogram. Create a subprogram. Create
more...
Oracle PL SQL Database Programming

Course Overview This course is the third in a series of three titles, and discusses the features of stored subprograms and packages. This course explains how to create and execute stored procedures and functions as well as how to create stored packages. This course also discusses built-in server-side packages and their use in debugging stored subprograms. This course covers how to manage stored
more...
SQL Server 2000 Design Implement Databases Part 1 Intro to SQL Server

Course Overview This is the first course in a five part series that presents students with both theoretical and practical instruction in the areas of an overview to SQL Server, the Transact-SQL language, and SQL Server Databases. Learn To Identify the features and functions of SQL Server 2000. Match the components of the client-server communication process with their features. Identify
more...
SQL Server 2000 Querying with Transact SQL Part 1 Manipulating Data

Course Overview This course presents students with both theoretical and practical instruction in the subject of manipulating data with Transact-SQL. Learn To Identify the basic types of statements used in Transact-Structured Query Language (SQL). Identify the functions of Data Definition Language (DDL) statements. Identify the functions of Data Control Language (DCL) statements.
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 DML and DDL

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

Course Overview The Oracle 9i Database Administration: Manage Storage Structures course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course, participants learn the concepts associated with storage structure components. In addition, this course teaches users the procedures for managing segment free space, undo
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...
Oracle9i Database Admin Manage Security

Course Overview This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course you will learn the concepts and methods associated with implementing security and resource consumption in an Oracle9i database. Learn To Define and maintain the five components of the security domain of a user in a given
more...
Oracle9i Performance Tuning Optimizing Sorts Minimizing Contention

The content of this course includes details about each component of an Oracle database instance, such as data blocks, disks, memory, CPU, and dynamic views. Students learn about migration and chaining, reorganizing indexes, optimizing sort operations, tuning rollback segments, managing automatic undo, monitoring activities, implementing the Oracle shared server, and troubleshooting. Learn To:
more...
Oracle SQL PL SQL Using Procedure Builder Curriculum

The courses in this curriculum cover the concepts of relational databases and the SQL and PL/SQL programming languages. Students learn how to create and maintain database objects and to store, retrieve, and manipulate data. In addition, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. This curriculum
more...
Database Technologies 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
more...
Oracle8 Database Administration - Manage Data

Course Overview
This course is the fourth in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts associated with tables. In addition, this course will teach users about maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data.
L
more...
Oracle8i Database Admin Manage an Instance

Course Overview This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support. L earn To:
more...
Oracle Internet App Dev Track for Forms Developer R6 6i Curriculum

The Complete Oracle Internet App. Dev. Track for Forms Developer R6/6i Curriculum includes the following courses: 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:
more...
CIW Database Specialist Part 2 Logical Physical Design

This is the second course in a four part series that teaches students about normalization, and logical and physical database design. This course will cover the normalization about the first, second, and third normal forms, and also about Boyce-Codd Normal Form, logical database design resolving relationships, creating a logical data model, and the various integrity constraints, physical database
more...
CIW Database Specialist Part 3 Database Interaction 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,
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
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...
PL SQL Triggers
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...
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...
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...
Oracle 8i PL/SQL - DML and DDL Statements
This course introduces the 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
more...
Oracle9i SQL: DML and DDL


The 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...
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...
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...
Oracle9i SQL: DML and DDL
The 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...
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...
