Login to Course Campus | Call Us: 1-877-797-2799  

 

Everything IT

Oracle Database Systems


Oracle Database 11g: New Features For Administrators

In this course you will learn:
  • Oracle Database 11g: Installation and Upgrade Enhancements
  • Oracle Database 11g: Storage Enhancements
  • Oracle Database 11g: Change Management Overview and SQL Plan Management
  • Oracle Database 11g: Database Replay and Automatic SQL Tuning
  • Oracle Database 11g: Intelligent Infrastructure Enhancements
  • Oracle Database 11g: Performance Enhancements
  • Oracle Database 11g: Partitioning and Storage-Related Enhancements
  • Oracle Database 11g: Using RMAN Enhancements, Flashback and LogMiner
  • Oracle Database 11g: Diagnostic Enhancements and Using the Data Recovery Advisor
  • Oracle Database 11g: New Security Features
  • Oracle Database 11g: SecureFiles and Miscellaneous New Features
Duration: 22.40 hrs
Oracle Database 11g: Administration Workshop I

In this course you will learn:
  • Oracle Database 11g: Database Architecture and Installation
  • Oracle Database 11g: Database Creation, Instance Management, and Connectivity
  • Oracle Database 11g: Storage Structures and User Security
  • Oracle Database 11g: Managing the Schema, Data, and Concurrency
  • Oracle Database 11g: Managing Undo Data, Database Security, and Maintenance
  • Oracle Database 11g: Performance Monitoring, Recovery Concepts and Backup
  • Oracle Database 11g: Recovering, Moving, and Enhancing the Oracle Database
Duration: 16.00 hrs
Oracle Database 11g: Administration Workshop II

In this course you will learn:
  • Oracle Database 11g: Database Architecture and ASM
  • Oracle Database 11g: Configuring for Recovery
  • Oracle Database 11g: Configuring for Backups
  • Oracle Database 11g: Using RMAN for Recovery
  • Oracle Database 11g: Supporting RMAN and Using Flashback Technology
  • Oracle Database 11g: Diagnosing the Database and Managing Memory
  • Oracle Database 11g: Database Performance and Space Management
  • Oracle Database 11g: Managing Resources and Task Automation
  • Oracle Database 11g: Globalization
Duration: 18.20 hrs
Oracle Database 11g: SQL and PL/SQL New Features

In this course you will learn:
  • Oracle Database 11g: Getting Started with SQL and PL/SQL New Features
  • Oracle Database 11g: Using Dynamic SQL and Implementing Performance Improvements
  • Oracle Database 11g: Using Trigger, Data Warehousing, and Pivoting Enhancements
  • Oracle Database 11g: Using the PL/SQL Debugger, Collections and Data Warehousing
Duration: 6.00 hrs
Oracle Database 11g: SQL Fundamentals I

In this course you will learn:
  • Oracle Database 11g: Using SQL to Query Your Database
  • Oracle Database 11g: Conversion Functions, Group Functions, and Joins
  • Oracle Database 11g: Subqueries, Set Operators, and Data Manipulation
  • Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms
Duration: 8.30 hrs
Oracle Database 11g: SQL Fundamentals II

In this course you will learn:
  • Oracle Database 11g: Controlling User Access and Managing Schema Objects
  • Oracle Database 11g: Data Dictionary Views and Large Data Sets
  • Oracle Database 11g: Managing Data in Different Time Zones
  • Oracle Database 11g: Using Subqueries and Regular Expressions
Duration: 7.00 hrs
Oracle Database 11g: PL/SQL Fundamentals

In this course you will learn:
  • Oracle Database 11g: PL/SQL Variables, Attributes, and Executable Statements
  • Oracle Database 11g: Using DML, DDL, Cursors, Control Structures, and Loops
  • Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors in PL/SQL
  • Oracle Database 11g: Working with Exceptions, Subprograms, JDeveloper, and REF Cursors
Duration: 7.30 hrs
Oracle Database 11g: Develop PL/SQL Program Units

In this course you will learn:
  • Oracle Database 11g: Subprograms, Packages, and Exception Handling in PL/SQL
  • Oracle Database 11g: Packages, Dynamic SQL, and Coding Considerations in PL/SQL
  • Oracle Database 11g: Using Triggers, the PL/SQL Compiler, and Managing Code
  • Oracle Database 11g: Managing PL/SQL Code and Dependencies
Duration: 8.30 hrs
Oracle Database 11g: Introduction to SQL

In this course you will learn:
  • Oracle Database 11g: Querying a Database with SQL
  • Oracle Database 11g: Conversion Functions, Conditional Expressions, Group Functions, and Joins
  • Oracle Database 11g: Manipulating Queries and Data
  • Oracle Database 11g: Using DDL, Views, and Schema Objects
  • Oracle Database 11g: Controlling User Access and Managing Objects
  • Oracle Database 11g: Managing Data Dictionary Views and Large Data Sets
  • Oracle Database 11g: Managing Time Zones and Datetime Functions
  • Oracle Database 11g: Subqueries and Regular Expressions
Duration: 14.50 hrs
Oracle Database 11g: Program with PL/SQL

In this course you will learn:
  • Oracle Database 11g: Getting Started With PL/SQL
  • Oracle Database 11g: Using DML, DDL, Cursors, Loops, and Control Structures
  • Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors
  • Oracle Database 11g: Using Exceptions, Subprograms, JDeveloper, and REF Cursors
  • Oracle Database 11g: Subprograms, Packages, and Exception Handling
  • Oracle Database 11g: Packages, Dynamic SQL, and Coding Considerations
  • Oracle Database 11g: Using Triggers and the PL/SQL Compiler
  • Oracle Database 11g: PL/SQL Code and Dependency Management
Duration: 15.20 hrs
Oracle Database 10g: Administration Workshop II

In this course you will learn:
  • Using Flashback Technology in Oracle 10g
  • Performing and Managing Backups in Oracle 10g
  • Advanced Database Recovery and Repair in Oracle 10g
  • Controlling the Oracle Listener and Enabling Distributed Transactions in Oracle 10g
  • Using Globalization Support in Oracle 10g
  • Optimizing Database Performance in Oracle 10g
  • Managing Storage and System Resources in Oracle 10g
  • Using the Scheduler to Automate Tasks in Oracle 10g
  • Using Advanced Features in Oracle 10g
Duration: 19.20 hrs
Oracle Database 10g: SQL Fundamentals I and II

In this course you will learn:
  • Introduction to Oracle and SQL in Oracle Database 10g
  • SQL Functions in Oracle Database 10g
  • Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g
  • Group and Datetime Functions in Oracle Database 10g
  • Subqueries and Hierarchical Queries in Oracle Database 10g
  • Regular Expressions and User Access in Oracle Database 10g
  • Creating and Managing Tables and Constraints in Oracle Database 10g
  • Database Objects in Oracle Database 10g
  • Managing Database Objects in Oracle Database 10g
  • Manipulating Data in Oracle Database 10g
Duration: 24.30 hrs
Oracle Database 10g: Programming with PL/SQL I

In this course you will learn:
  • Introduction to PL/SQL
  • Using PL/SQL with an Oracle Server
  • Using Control Structures
  • Using Composite Data Types
  • Explicit Cursors and Exception Errors
  • Creating Stored Procedures and Functions
Duration: 14.00 hrs
Oracle Database 10g: Developing PL/SQL Program Units

In this course you will learn:
  • PL/SQL Packages
  • Oracle-Supplied Packages and DBMS_SCHEDULER
  • Managing Dependencies
  • Manipulating Large Objects in PL/SQL
  • PL/SQL Triggers
  • Dynamic SQL and Metadata
Duration: 15.30 hrs
Oracle Database 10g: New Features

In this course you will learn:
  • Oracle Database 10g: New Installation and Configuration Features
  • Oracle Database 10g: New Data Loading Features
  • Oracle Database 10g: New Automatic Management Features
  • Oracle Database 10g: New Resource, Scheduling, and Task-Management Features
  • Oracle Database 10g: New Space Management Features
  • Oracle Database 10g: New Storage Features
  • Oracle Database 10g: New Tuning, Performance-monitoring, and Analysis Features
  • Oracle Database 10g: New Backup and Recovery Features
  • Oracle Database 10g: Using Flashback
  • Oracle Database 10g: New Features in Security and Software Maintenance
  • Oracle Database 10g: New Features in VLDB Support
  • Oracle Database 10g: Miscellaneous New Features
Duration: 31.00 hrs
Oracle Database 10g: Administration Workshop I Release 2

In this course you will learn:
  • Oracle Database 10g: Installing Oracle Database 10g Release 2
  • Oracle Database 10g: Creating Databases Release 2
  • Oracle Database 10g: Database Interfaces Release 2
  • Oracle Database 10g: Database Control and Storage Structures Release 2
  • Oracle Database 10g: Users and Security Release 2
  • Oracle Database 10g: Managing Schema Objects and Data Release 2
  • Oracle Database 10g: The SQL*Loader and PL/SQL Release 2
  • Oracle Database 10g: Oracle Net Services and Shared Servers Release 2
  • Oracle Database 10g: Monitoring and Maintenance Release 2
  • Oracle Database 10g: Managing Undo Data and Lock Conflicts Release 2
  • Oracle Database 10g: Managing Backup and Recovery Release 2
Duration: 29.50 hrs
Oracle9i Database Fundamentals: Architecture and Management

In this course you will learn:
  • Architecture and Administration Tools in Oracle9i
  • Database and Instance Management in Oracle9i
  • Database Structures in Oracle9i
Duration: 7.30 hrs
Oracle9i Database Fundamentals: Backup and Recovery

In this course you will learn:
  • Backup and Recovery Overview and Configuration in Oracle9i
  • User-Managed and RMAN Backup and Recovery in Oracle9i
  • Recovery Manager Maintenance in Oracle9i
  • Transporting and Loading Data in Oracle9
Duration: 16.20 hrs
Oracle9i Database Fundamentals: Managing Data Storage

In this course you will learn:
  • Data Storage in Oracle9i
  • Tables and Indexes in Oracle9i
  • Data Integrity in Oracle9i
Duration: 7.50 hrs
Oracle9i Database Fundamentals: Managing Database Access

In this course you will learn:
  • Users and Profiles in Oracle9i
  • Privileges and Roles in Oracle9i
  • Globalization and Auditing in Oracle9i
Duration: 7.30 hrs
Oracle9i Database Fundamentals: Network Administration

In this course you will learn:
  • Networking Overview for Oracle9i Administrators
  • Oracle Network Configuration in Oracle9i
Duration: 6.30 hrs
Oracle9i Database: Introduction to SQL

In this course you will learn:
  • Introduction to Oracle and SQL in Oracle 9i
  • SQL Functions in Oracle 9i
  • Subqueries, Reporting, and User-Access Control in Oracle 9i
  • Defining and Manipulating Data in Oracle 9i
Duration: 15.00 hrs
Oracle9i Database: New Features I

In this course you will learn:
  • Introducing Oracle9i Database
  • Manageability Enhancements in Oracle9i
Duration: 8.00 hrs
Oracle9i Database: New Features II

In this course you will learn:
  • Availability Features in Oracle9i
  • Scalability and Performance in Oracle9i
  • Development Platform in Oracle9i
  • Security Overview for Oracle9i Administrators
Duration: 13.40 hrs
Oracle9i Database: Performance Tuning

In this course you will learn:
  • Performance Tuning Methodology and Tools in Oracle9i
  • Tuning Memory Structures in Oracle9i
  • Tuning Database Structures in Oracle9i
  • Tuning Systems and Applications in Oracle9i
Duration: 11.10 hrs
Oracle Database 10g

In this course you will learn:
  • Oracle Database 10g R2: SQL Tuning Course 1
  • Oracle Database 10g R2: SQL Tuning Course 2
  • Oracle Database 10g R2: SQL Tuning Course 3
  • Oracle Database 10g R2: SQL Tuning Course 4
  • Oracle Database 10g R2: SQL Tuning Course 5
  • Oracle Database 10g Performance Tuning: Tools and Techniques
  • Oracle Database 10g Performance Tuning: Tuning Data
  • Oracle Database 10g Performance Tuning: Tuning Infrastructure
  • Oracle Database 10g Performance Tuning: Instance Tuning
  • Oracle Database 10g Performance Tuning: Memory Management
  • Oracle Database 10g Performance Tuning: Performance Management
Duration: 41.20 hrs
Oracle Database Server 10g

In this course you will learn:
  • Migrating to Oracle DB 10g: Oracle Database Architectural Framework
  • Migrating to Oracle DB 10g: Schema Objects and Planning Migration
  • Migrating to Oracle DB 10g: Performing Migrations with OMWB
  • Migrating to Oracle DB 10g: Migrating and Testing Oracle Database
  • Migrating to Oracle DB 10g: Securing and Managing Oracle Database
  • Migrating to Oracle DB 10g: Oracle Database Backup and Recovery
Duration: 24.00 hrs