United States
Oracle 10g Tutorials
Online Contents For This Course
We have made some of the video tutorials for Oracle 10g freely available to help you evaluate our training.
Click on any of the linked lesson listings below to preview FREE!
Course Description
Oracle 10g is a database that runs on Linux, Unix and Windows servers. Oracle Database 10g can be used to automate administrative tasks, providing security and regulatory compliance features, and enabling the highest availability with Real Application Clusters. In this VTC tutorial you will install and configure an Oracle 10g database, as well as review several programming choices to work with your database. To begin learning today simply click the links.
Choose your media type:
|
Welcome
|
|||
| Introduction | (00:55) | ||
| Evolution of Oracle Database | (01:02) | ||
| Introducing Oracle 10g | (00:59) | ||
| What the Course is About | (00:42) | ||
|
Overview
|
|||
| Features of Oracle 10g | (01:26) | ||
| Performance & Scalability | (01:26) | ||
| Availability | (00:31) | ||
| Security | (00:37) | ||
| Grid Computing | (02:45) | ||
| Automatic Storage Management | (00:41) | ||
| Data Warehousing | (01:58) | ||
| Management of Records | (00:55) | ||
| Oracle Application Builder | (00:27) | ||
| Choice of Development Tools | (00:52) | ||
| Different Versions of 10g | (00:40) | ||
|
Getting Started
|
|||
| Preinstallation Checks | (03:23) | ||
| Installation | (05:36) | ||
| Post Installation Tasks | (01:41) | ||
| Upgrading an Existing Oracle Database | (01:46) | ||
| Creating a New Administration Account | (02:19) | ||
| Creating a New Database User Account Pt.1 | (04:11) | ||
| Creating a New Database User Account Pt.2 | (03:46) | ||
| Loading Data | (06:21) | ||
|
Creating Database Objects
|
|||
| Overview | (00:41) | ||
| Tables Creation | (04:29) | ||
| Tables Modification | (03:32) | ||
| Dealing with Constraints Pt.1 | (04:37) | ||
| Dealing with Constraints Pt.2 | (06:19) | ||
| Removing Tables | (04:02) | ||
|
Retrieving & Manipulating Data
|
|||
| Overview | (00:46) | ||
| Basic Query Construction | (03:51) | ||
| Joining Tables | (05:06) | ||
| Report Customization | (04:22) | ||
| Handling Groups of Data | (03:06) | ||
| Data Addition/Modification & Removal | (04:40) | ||
| Saving & Discarding Data | (04:44) | ||
|
Administering & Monitoring Database
|
|||
| Managing Database Settings | (02:43) | ||
| Managing Memory | (01:27) | ||
| Oracle Shutdown & Start Up | (03:33) | ||
| Managing Tablespaces | (03:01) | ||
| Freeing Space | (02:06) | ||
| Managing Database User Accounts | (01:26) | ||
| Schemas/Roles & Privileges | (03:37) | ||
| Altering a Password for a User | (01:31) | ||
| Dropping a User | (01:05) | ||
| Monitoring the Database | (03:25) | ||
| Monitoring Performance Issues | (02:11) | ||
| Viewing Top SQL | (02:40) | ||
| Monitoring Sessions | (02:02) | ||
| Viewing System Statistic | (01:44) | ||
|
Service Availability in 10g EE
|
|||
| Transparent Application Failover in RAC | (01:07) | ||
| Recovery from Error Using Flashback | (04:26) | ||
| Using Oracle Secure Backup | (03:29) | ||
| Database Backups & Recovery | (02:25) | ||
| Rebuilding Database Objects Online | (02:38) | ||
|
Security in 10g EE
|
|||
| Transparent Data Encryption Feature | (04:14) | ||
| Using Secure Application Roles | (02:15) | ||
| Using Oracle Label Security | (01:33) | ||
| Use of Virtual Private Database | (03:11) | ||
| Using Fine Grained Auditing | (02:00) | ||
|
Data Manageability
|
|||
| Management of Large Database | (00:55) | ||
| Exploring Cluster Database | (03:06) | ||
| Automatic Memory Management Feature | (03:36) | ||
| Automatically Managing Undo | (04:26) | ||
| Managing ASM Disk Groups | (02:40) | ||
| Using the Segment Advisor | (04:09) | ||
| Resolving Performance Issues Using ADDM | (02:55) | ||
| SQL Tuning & Access Advisor | (03:10) | ||
| Using Oracle Data Pump | (05:18) | ||
| Advanced Scheduling | (05:13) | ||
| Information Lifecycle Management | (01:32) | ||
| Managing Enterprise Manager Policies | (02:41) | ||
|
Data Warehousing
|
|||
| Oracle Warehouse Builder | (01:32) | ||
| Working with Flat File Data | (01:53) | ||
| Designing Relational Target Warehouse | (02:20) | ||
| Designing ETL Data Flow Mappings | (01:01) | ||
| Deploying Objects in Target Warehouse | (01:17) | ||
| Inter-Row Calculations | (01:02) | ||
| Filling Gaps in Sparse Data | (00:51) | ||
| High Speed Data Loading | (01:03) | ||
| ETL Infrastructure | (01:35) | ||
| Using Basic Warehousing Functionality | (01:08) | ||
| Using Materialized Views | (00:45) | ||
|
Application Development
|
|||
| Using Oracle Application Express | (04:30) | ||
| Adding PL/SQL Functionality | (03:05) | ||
| Creating a .NET Application | (01:54) | ||
| Creating an Application Using PHP | (00:56) | ||
Email this Page
Send us FeedbackCourse Information
| Course: | Oracle 10g |
| Author: | EI Design |
| SKU: | 33761 |
| ISBN: | 1-933736-83-6 |
| Release Date: | 2007-04-26 |
| Duration: | 3.5 hrs / 87 tutorials |
| Captions: | No |
Subscription / Purchase Information
This course is just part of the entire VTC collection of over 650 courses, 70,000 video tutorials (14,250+ free), available to you for just $30 a month.
View All Courses Subscribe Learn More