|
||||
|
||
|
||
| 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 - Introducing Procedure Builder
This course aims to introduce you to the various components of Procedure Builder. It explains the features of the Procedure Builder components, such as the Object Navigator, the PL/SQL Interpreter, the Program Unit Editor, the Stored Program Unit Editor, and the Database Trigger Editor. It describes how you can use the components of Procedure Builder to create, debug, and execute program units.
Introducing Procedure Builder training covers such topics as:
Procedure Builder Fundamentals
Subprograms
Debugging Program Units
Oracle 8i DBA - Oracle Server and Database Architecture
This course familiarizes you with the basics of Oracle 8i Architecture and Oracle Enterprise Manager. This course will introduce you to Oracle instances and SGA components. You will learn to identify the memory structures and processes involved with an Oracle instance. You will be introduced to the Oracle Universal Installer and be able to explain the Optimal Flexible Architecture. You will be able to implement a database server, with user validations and user database accounts. You will become familiar with the components of the Oracle Enterprise Manager, the Configuration Assistant, and the tools of the DBA management pack. You will learn how to connect to an Oracle database and to identify the different stages of the SELECT query, DML, and COMMIT statements.
Oracle Server and Database Architecture training covers such topics as:
Oracle Architecture
Implementing the Database Server
Oracle Enterprise Manager
Interacting with the Database
Oracle 8i DBA - Oracle Instance, the Start-up and Shutdown Procedure
The course familiarizes you with the Oracle instance. It teaches you about the startup and shutdown processes and the different stages of startup and shutdown. The course also provides a list of data dictionary views that help in performing administrative tasks. The course initiates the learner into hands-on learning by helping you type in the commands used to perform administrative tasks.
Oracle Instance, the Start-up and Shutdown Procedure training covers such topics as:
Oracle Instances
Controlling Oracle at Runtime
Creating Databases
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