** Special Offer valid until 31-May-2008. ** 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)
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)
