Self Study, Tutorial Video on CD - DVD. The tutor guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. It works on both PC and Mac.
These Oracle Database Admin tutorials are a perfect all-in-one solution for understanding the complexities and capabilities of Oracle and are ideally suited to people wishing to sit the Oracle 1Z0 - 031 exam. This training course offers the user a real alterative to reading page upon page of complex text from a manual or reference book. Expert author Gavin Powell brings a high degree of visual clarity and easy to follow step-by-step guidance on the subject, users will benefit greatly from Gavin's expertise and informative teaching style. This Oracle training course should be considered by any user that wishes to get up to speed quickly and take the Oracle certification exam. Related topics All Certification Tutorials .
Oracle 1Z0-031 Tutorial CD / DVD
Create the best self-paced learning environmentright on your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.
Learn for FREE - NOW. To help you evaluate this training CD / DVD the first 3 chapters are available for free, click on any of the links below for a FREE DEMO.

- Professional Tuition from an Expert
- Free Certificate with Each Tutorial
- Works on PC or Mac

Welcome
Database Administration
Oracle Database Administration Tools
- What are the Tools?

- SQL*Plus

- SQL*Plus Worksheet

- iSQL*Plus

- All the Other Oracle Tools

- Database Configuration Assistant Tutorials 1

- Database Configuration Assistant 2

- Oracle Enterprise Manager Console 1

- Oracle Enterprise Manager Console 2

- The Management Server and the Agent

- Net Configuration Assistant and Net Manager

- Oracle Enterprise Manager Console 3

- Oracle Enterprise Manager Console 4

The Architecture of Oracle
- Oracle Database Architecture
- Memory Structures
- Processes
- Datafiles/Tablespaces/Objects
- Control Files/Logging/Archiving/Recovery
- COMMIT vs ROLLBACK
- Oracle Rollback and Undo
- Temporary Sort Space
- How it all Fits Together
- Oracle Managed Files
- Partitioning
Installing Oracle and Creating a Database
- The Oracle Installer Tutorials 1
- The Oracle Installer 2
- The Oracle Installer 3
- Configuration Parameter Files 1
- Configuration Parameter Files 2
- SQL*Net Configuration Files
- Oracle Optimal Flexible Architecture
- Windows Specifics 1
- Windows Specifics 2
- Creating a Database with a Script Tutorials 1
- Creating a Database with a Script 2
Starting Up and Shutting Down a Database
- Connecting to a Database
- STARTUP Command 1
- STARTUP Command 2
- SHUTDOWN Command 1
- SHUTDOWN Command 2
- Combining STARTUP and ALTER DATABASE
- The Oracle Enterprise Manager Console
Configuration Parameters
- What is the Parameter File?
- Looking at Oracle Parameters
- The Parameters and What They Do Tutorials 1
- The Parameters and What They Do 2
- The Parameters and What They Do 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 1
- Logfiles and Archives 2
- The ALTER SYSTEM Command 1
- The ALTER SYSTEM Command 2
- Automated Undo/Manual Rollback 1
- Automated Undo/Manual Rollback 2
- Metadata Views
DDL and the Logical Database
- What is the Logical Database?
- Oracle Tablespace Management Tutorials 1
- Tablespace Management 2
- Tablespace Management 3
- Metadata Views
Expanding Database Objects
- Tables in Oracle Tutorials 1
- Tables 2
- Tables 3
- Indexes 1
- Indexes 2
- Clusters
- Index Organized Tables
- Sequences
- UNDROP, PURGE and the Recycle Bin
- Partitioning
- Metadata Views 1
- Metadata Views 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
About this Oracle 1Z0-031 Training CD
| Title : | Oracle 1Z0-031 |
|---|---|
| Tutor : | Gavin Powell
Other tutorials by Gavin Powell |
| Videos : | 99 Lessons- Video run time: 8 Hours |
| Availability : | Immediate Dispatch |
| Compatibility: | Vista, 2000, XP, Windows 7, Mac OS, OSX |
| Released | 2003 |
| Price US / Canadian Sales | $99.95 |
672 In Stock

- Learn Oracle 1Z0-031 from an accredited expert in days.
- Ideal for beginners, these easy to follow videos offer visual clarity.
- Master a full application for a fraction of the cost of classroom based training, and faster than with a manual.
- Unique teaching method that offers accelerated learning and high retention.
- Used by many large companies, schools, universities,
click to see some of our customers. - Learn from your own desk at a speed that suits you.
- It's Cost effective tuition from leading expert tutors.
- Learn at your own pace; training can be stopped, rewound or fast forwarded as required.
- These High Quality Tutorial Videos are on CD / DVD or Online and PC / Mac Compatible. It's Simply the best tuition at an affordable price
Want to hear what our customers say about our products?
PHP | Ruby on Rails | XML | MySQL | Programming Java | Crystal Reports
Not sure which training CD titles to purchase? Why not join our Online University and have unlimited access to all our tutorial videos for one low price of $30 per month.
You can have access to every title we list on this site for just $30 per month. When you sign up, you get instant access with absolutely no restrictions or limits. Log on from any location and learn as much as you like.



