|
|
|
Oracle DBA Fundamentals I CD Training (CBT) (Prices exclude VAT)
|
|
|
[to previous page]
[other products in "Programming And Development"]
|
|
|
| Product: |
Oracle DBA Fundamentals I CD Training (CBT)
|
| Price: |
|
|
|
| Details: |
Duration: 8 hrs This Oracle training course tutorial is aimed at preparing the user for the Oracle Certification Exam # 1Z0-031.
This tutorial will teach Oracle database administration fundamentals; creating databases, installing Oracle, managing objects in the database and much more.
Welcome Welcome Prerequisites About Technet Database Administration Manuals Database Admin Oracle Database Administration? part 1 Oracle Database Administration? part 2 The Basic Architecture of Oracle Oracle Database Administration Tools What are the Tools? SQL*Plus SQL*Plus Worksheet iSQL*Plus All the Other Oracle Tools Database Configuration Assistant part 1 Database Configuration Assistant part 2 Oracle Enterprise Manager Console part 1 Oracle Enterprise Manager Console part 2 The Management Server and the Agent Net Configuration Assistant and Net Manager Oracle Enterprise Manager Console part 3 Oracle Enterprise Manager Console part 4 The Architecture Oracle Database Architecture Memory Structures Processes Datafiles/Tablespaces/Objects Control Files/Logging/Archiving/Recovery COMMIT vs ROLLBACK Rollback and Undo Temporary Sort Space How it all Fits Together Oracle Managed Files Partitioning in Oracle Installation of Oracle and Creating a Database The Oracle Installer part 1 The Oracle Installer part 2 The Oracle Installer part 3 Configuration Parameter Files part 1 Configuration Parameter Files part 2 SQL*Net Configuration Files Oracle Optimal Flexible Architecture Windows Specifics part 1 Windows Specifics part 2 Creating a Database with a Script part 1 Creating a Database with a Script part 2 Starting Up and Shutting Down a Database Connecting to a Database STARTUP Command part 1 STARTUP Command part 2 SHUTDOWN Command part 1 SHUTDOWN Command part 2 Combining STARTUP and ALTER DATABASE The Oracle Enterprise Manager Console Configuration Parameters What is the Parameter File? Looking at Parameters The Parameters and What They Do part 1 The Parameters and What They Do part 2 The Parameters and What They Do part 3 DDL and the Physical Database DDL and the Physical Database? The ALTER DATABASE Command Looking at the Database Changing Datafiles Sizing of Datafiles Datafiles and Tempfiles Control Files Logfiles and Archives part 1 Logfiles and Archives part 2 The ALTER SYSTEM Command part 1 The ALTER SYSTEM Command part 2 Automated Undo/Manual Rollback part 1 Automated Undo/Manual Rollback part 2 Metadata Views DDL and the Logical Database What is the Logical Database? Tablespace Management part 1 Tablespace Management part 2 Tablespace Management part 3 Metadata Views Expanding Database Objects Tables part 1 Tables part 2 Tables part 3 Indexes part 1 Indexes part 2 Clusters Index Organised Tables Sequences UNDROP, PURGE and the Recycle Bin Partitioning Metadata Views part 1 Metadata Views part 2 Expanding Security for Database Administration Types of Users Grants and Revokes Create and Alter User Syntax Administration Users Database Auditing Scheduling The DBMS_JOB Package Job Scheduling in Oracle Scheduling/Executing Jobs in Windows and Unix Utilities Export Import SQL*Loader ORAPWD and ORADIM Built-In Packages Supplied Packages Scripting for Automation Some Example Scripts |