|
||||
|
||
|
||
| Introduction to RDBMS and SQL *Plus | ||
| Functions, Tables, and Groups | ||
| Advanced SQL, SQL*Plus & Data Dictionary | ||
| DML and DDL Statements | ||
| Database Objects and Security | ||
| Oracle PL/SQL Basic Operations | ||
|
||
| Introducing Procedure Builder | ||
| Oracle Server and Database Architecture | ||
| Oracle Instance, the Start-up and Shutdown Procedure | ||
| Data Dictionary and Database Files | ||
| Oracle Storage Architecture | ||
| Understanding Storage Allocation | ||
| Indexes and Constraints | ||
| Managing Oracle Database Security | ||
| SQL*Loader, Oracle Export and Import, and NLS | ||
| VIEW DEMO To view a demo please visit our website link. To view a demo you need to visit our website and click the link. If you do not have a shockwave player it will ask you to download it. You only need the shockwave player for the online demos only, although they are the same as the product for web purposes we have configured them to play in shockwave. Shockwave is similar to a flash player and can be downloaded free from Macromedia shockwave.com | ||
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
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