Oracle Database Administration Fundamentals I |
 |
| Author:Gavin Powell | |
| Language:english | |
| Category:Programming,Databases,Certification, | |
| Lessons:0 | 0 hrs | |
| Buy Now or get more information about Oracle Database Administration Fundamentals I | |
Oracle Database Administration Fundamentals IOracle Database Administration Fundamentals I: This is the second in a series of courses, aimed at preparing the user for Oracle Certification Exam # 1Z0-031. This course will teach Oracle database administration fundamentals; installing Oracle, creating databases, managing objects in the database and more. This course expands on the first course offered by Virtual Training (Introduction to Oracle SQL and PL/SQL). Following courses will include: Oracle Database Administration Fundamentals II and Oracle Database Performance Tuning. To get started, click one of the movie topics below. Listed below are all of the chapter and lesson contents for the Oracle Database Administration Fundamentals I Try For Free Right Now To help you evaluate our training, we have made some of the tutorials for Oracle Database Administration Fundamentals I freely available. Click on any of the linked lesson listings below to preview Free! Oracle Database Administration Fundamentals I
First 3 Lessons Free Online (Press the links below to open up the free lessons. The lessons will open in a popup window from this screen and play in Quicktime):
Oracle Database Administration Fundamentals I
Welcome
WelcomePrerequisites for this Course
About this Course
Technet Database Administration Manuals
Database Administration
Oracle Database Administration? pt. 1Oracle Database Administration? pt. 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 pt. 1
Database Configuration Assistant pt. 2
Oracle Enterprise Manager Console pt. 1
Oracle Enterprise Manager Console pt. 2
The Management Server and the Agent
Net Configuration Assistant and Net Manager
Oracle Enterprise Manager Console pt. 3
Oracle Enterprise Manager Console pt. 4
The Architecture of Oracle
Oracle Database ArchitectureMemory 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
Installing Oracle and Creating a Database
The Oracle Installer pt. 1The Oracle Installer pt. 2
The Oracle Installer pt. 3
Configuration Parameter Files pt. 1
Configuration Parameter Files pt. 2
SQL*Net Configuration Files
Oracle Optimal Flexible Architecture
Windows Specifics pt. 1
Windows Specifics pt. 2
Creating a Database with a Script pt. 1
Creating a Database with a Script pt. 2
Starting Up and Shutting Down a Database
Connecting to a DatabaseSTARTUP Command pt. 1
STARTUP Command pt. 2
SHUTDOWN Command pt. 1
SHUTDOWN Command pt. 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 pt. 1
The Parameters and What They Do pt. 2
The Parameters and What They Do pt. 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 pt. 1
Logfiles and Archives pt. 2
The ALTER SYSTEM Command pt. 1
The ALTER SYSTEM Command pt. 2
Automated Undo/Manual Rollback pt. 1
Automated Undo/Manual Rollback pt. 2
Metadata Views
DDL and the Logical Database
What is the Logical Database?Tablespace Management pt. 1
Tablespace Management pt. 2
Tablespace Management pt. 3
Metadata Views
Expanding Database Objects
Tables pt. 1Tables pt. 2
Tables pt. 3
Indexes pt. 1
Indexes pt. 2
Clusters
Index Organized Tables
Sequences
UNDROP, PURGE and the Recycle Bin
Partitioning
Metadata Views pt. 1
Metadata Views pt. 2
Expanding Security for Database Administration
Types of UsersGrants and Revokes
Create and Alter User Syntax
Administration Users
Database Auditing
Scheduling
The DBMS_JOB PackageJob Scheduling in Oracle
Scheduling/Executing Jobs in Windows and Unix
Utilities
ExportImport
SQL*Loader
ORAPWD and ORADIM
Built-In Packages
Supplied PackagesScripting for Automation
Some Example Scripts01 Welcome
0101 Welcome
0102 Prerequisites for this Course
0103 About this Course
0104 Technet Database Administration Manuals
02 Database Administration
0201 Oracle Database Administration? pt. 1
0202 Oracle Database Administration? pt. 2
0203 The Basic Architecture of Oracle
03 Oracle Database Administration Tools
0301 What are the Tools?
0302 SQL*Plus
0303 SQL*Plus Worksheet
0304 iSQL*Plus
0305 All the Other Oracle Tools
0306 Database Configuration Assistant pt. 1
0307 Database Configuration Assistant pt. 2
0308 Oracle Enterprise Manager Console pt. 1
0309 Oracle Enterprise Manager Console pt. 2
0310 The Management Server and the Agent
0311 Net Configuration Assistant and Net Manager
0312 Oracle Enterprise Manager Console pt. 3
0313 Oracle Enterprise Manager Console pt. 4
04 The Architecture of Oracle
0401 Oracle Database Architecture
0402 Memory Structures
0403 Processes
0404 Datafiles/Tablespaces/Objects
0405 Control Files/Logging/Archiving/Recovery
0406 COMMIT vs ROLLBACK
0407 Rollback and Undo
0408 Temporary Sort Space
0409 How it all Fits Together
0410 Oracle Managed Files
0411 Partitioning
05 Installing Oracle and Creating a Database
0501 The Oracle Installer pt. 1
0502 The Oracle Installer pt. 2
0503 The Oracle Installer pt. 3
0504 Configuration Parameter Files pt. 1
0505 Configuration Parameter Files pt. 2
0506 SQL*Net Configuration Files
0507 Oracle Optimal Flexible Architecture
0508 Windows Specifics pt. 1
0509 Windows Specifics pt. 2
0510 Creating a Database with a Script pt. 1
0511 Creating a Database with a Script pt. 2
06 Starting Up and Shutting Down a Database
0601 Connecting to a Database
0602 STARTUP Command pt. 1
0603 STARTUP Command pt. 2
0604 SHUTDOWN Command pt. 1
0605 SHUTDOWN Command pt. 2
0606 Combining STARTUP and ALTER DATABASE
0607 The Oracle Enterprise Manager Console
07 Configuration Parameters
0701 What is the Parameter File?
0702 Looking at Parameters
0703 The Parameters and What They Do pt. 1
0704 The Parameters and What They Do pt. 2
0705 The Parameters and What They Do pt. 3
08 DDL and the Physical Database
0801 DDL and the Physical Database?
0802 The ALTER DATABASE Command
0803 Looking at the Database
0804 Changing Datafiles
0805 Sizing of Datafiles
0806 Datafiles and Tempfiles
0807 Control Files
0808 Logfiles and Archives pt. 1
0809 Logfiles and Archives pt. 2
0810 The ALTER SYSTEM Command pt. 1
0811 The ALTER SYSTEM Command pt. 2
0812 Automated Undo/Manual Rollback pt. 1
0813 Automated Undo/Manual Rollback pt. 2
0814 Metadata Views
09 DDL and the Logical Database
0901 What is the Logical Database?
0902 Tablespace Management pt. 1
0903 Tablespace Management pt. 2
0904 Tablespace Management pt. 3
0905 Metadata Views
10 Expanding Database Objects
1001 Tables pt. 1
1002 Tables pt. 2
1003 Tables pt. 3
1004 Indexes pt. 1
1005 Indexes pt. 2
1006 Clusters
1007 Index Organized Tables
1008 Sequences
1009 UNDROP, PURGE and the Recycle Bin
1010 Partitioning
1011 Metadata Views pt. 1
1012 Metadata Views pt. 2
11 Expanding Security for Database Administration
1101 Types of Users
1102 Grants and Revokes
1103 Create and Alter User Syntax
1104 Administration Users
1105 Database Auditing
12 Scheduling
1201 The DBMS_JOB Package
1202 Job Scheduling in Oracle
1203 Scheduling/Executing Jobs in Windows and Unix
13 Utilities
1301 Export
1302 Import
1303 SQL*Loader
1304 ORAPWD and ORADIM
14 Built-In Packages
1401 Supplied Packages
15 Scripting for Automation
1501 Some Example Scripts
