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

 

Everything IT

Oracle 11g


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: 9: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