|
||||
|
||
|
||
| 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 | ||
Oracle 8i DBA - Data Dictionary and Database Files
The course is aimed at familiarizing the student with the Data Dictionary views and database files. You will learn to manage log and control files, and obtain information from control files. The planning, use, and troubleshooting of redo log files will be explained. The course provides a list of Data Dictionary views and you will type in commands to perform administrative tasks. You will also learn to administer stored procedures and packages.
Data Dictionary and Database Files training covers such topics as:
The Oracle Data Dictionary
Standard Packages and Objects
Control Files
Log Files Concepts
Working with Log Files
Oracle 8i DBA - Oracle Storage Architecture
This course is designed to give an Oracle DBA the necessary knowledge and skills to manage data storage. It will provide detailed information about logical structures such as tablespaces, segments, extents, and Oracle data blocks. The creation and management of rollback segments will also be covered. The course also provides a list of data dictionary views that help in managing these logical structures.
Oracle Storage Architecture training covers such topics as:
Tablespaces
Datafiles
Logical Structures
Rollback Segment Concepts
Working with Rollback Segments
This course covers the various aspects of optimizing database objects. It discusses tables, clusters, and index-organized tables. This course explains the different types of tables supported by Oracle 8i, the structure of a row, the different data types supported by Oracle 8i, and guidelines for creating a table. The course teaches you how to create a cluster, a cluster index, and the tables in the cluster. The course also explains how to create and manage the index-organized tables.
Understanding Storage Allocation training covers such topics as:
Tables
Managing Tablespaces
Deleting Tables
Clusters And Index Organized Tables
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