| Oracle
8i PL/SQL - DML and DDL Statements
This course introduces the DDL and DML statements. It explains
how to create tables and views. It covers the various commands
for manipulating a database and explains transaction processing
features. It highlights the concept of altering a table definition
in a database, and dropping, adding comments to and renaming a
table. It describes the various methods of managing constraints
related to a table.
DML and DDL Statements training covers such topics as:
Creating Tables and Views
Manipulating Data
Altering Tables
Altering Constraints
Oracle 8i PL/SQL - Database Objects and Security
This course is aimed at familiarizing the learner with the inbuilt
objects and security options in Oracle. The course includes creating
and managing sequences, indexes, and users. It also introduces
PL/SQL block, PL/SQL records and tables, PL/SQL variables and datatypes.
Database Objects and Security training covers such topics as:
Sequences
Indexes
Controlling User Access
PL/SQL An Introduction
Datatypes and Variables
Oracle 8i PL/SQL - Oracle PL/SQL Basic Operations
The course is aimed at familiarizing the learner with the basic
concepts of PL/SQL. It describes the different data types and variables
available with PL/SQL. The course provides an overview of PL/SQL
records and tables, and explains how to access a database from
PL/SQL. It describes how to write conditional constructs and controlling
structures in PL/SQL along with different types of explicit cursors
and their controlling parameters. You will also learn to identify
exceptions, trap those exceptions, and handle the unhandled exceptions
Oracle PL/SQL Basic Operations training covers such topics as:
Accessing Databases Using PL/SQL
Controlling Structures in PL/SQL
Working with Cursors
Handling Exceptions in a PL/SQL Block
The course addresses the training needs of IT Professionals who
use Oracle 8i. This course also addresses the needs of IT professionals
who want to become
certified under the Oracle8i Certified Database Administrator (DBA) Track.
Completion of this course and the other course titles from this
curriculum prepares the learner for Oracle Exam #1Z0-001: Introduction
to Oracle: SQL and PL/SQL |
