Oracle 11g Certification Training

oracle.jpg
oracle.jpg

Oracle 11g Certification Training

59.95

Product Details


Learning Oracle 11g Certification Training CBT Library Suite is easy with instructor-led Video Training

Oracle 11g is the latest version of Oracle's database management system offering over 500 new features. Don't wait until the software is installed to learn how to use it, get the training you need now. If you're a DBA, Oracle developer, or Oracle programmer, you owe it to yourself to explore these new features and find out they will impact your systems. 

The self-paced Oracle 11g CBT is an excellent tool to learn about the new features and how they relate to 11g availability, development, and performance tuning. Instead of enrolling in a traditional class, you'll get the instruction delivered directly to your desktop. 

If you've never tried a computer based training format before, get ready to be wowed. The Oracle 11g DBA training CD features full motion video segments featuring an expert, certified instructor who gives you a thorough tour of Oracle 11g. In addition to the Oracle 11g training videos, you also get hands-on exercises and activities using realistic simulations. Interactive content, animations, and step-by-step demos round out the curriculum making for a comprehensive and engaging learning environment. 

Use the self-paced Oracle 11g DBA CBT to explore the changes and get up to speed with Oracle 11g. This course is also an ideal starting point for new database administrators who want to start a career as an Oracle professional. Simply install the Oracle 11g training CD and begin learning the ins and outs of Oracle 11g - even without a copy of the software installed. The high-quality videos and hands-on simulations give you a front seat and realistic preview of Oracle 11g in action. 

Instead of reading books or sitting through hour after hour of classroom lectures, you simply watch Oracle 11g DBA training videos and participate in interactive activities. You can take your learning at a pace that is the best match for your learning needs and time schedule. With regular classes, you're out of luck if you miss a lecture. This format puts you back in charge. You can even re-watch the videos as often as you want. 

New and existing Oracle administrators will benefit by using the Oracle 11g DBA training CD. 

Oracle 11g CBT Training Titles by Module:

  • Oracle 11g Introduction to SQL
  • Oracle 11g Database Administration I
  • Oracle 11g Database Administration II
  • Oracle 11g PL/SQL Fundamentals
  • Oracle 11g PL/SQL Develop Program Units

 

 

Oracle 11g PL/SQL Program Units Training Video CBT Features:

  

 

Training Videos: An instructor introduces each learning module and gives you a preview of the topics that are covered. Instead of relying on reading written introductions, simply click on the video presentations for an interesting, informative summary of the concepts that you will be learning next. You will be learning these topics directly from an expert instructor who really knows the material.

 

Hands-On Labs: Interactive hands-on lab scenarios are included for you to practice your skills. In fact, you don't even need the software on your computer in order to receive this hands-on training. Simulations are critical to the learning process. By modeling a real system and letting you perform the same tasks you would perform on the real system, you are reinforcing your knowledge.

 

Player Controls: You can navigate freely with the player controls. You can play, pause, rewind, forward, and stop any video topic. The controls are familiar and easy to use. Simply click the control that matches the functions you want. If you are interrupted during your studies, click the pause button so that you won’t miss a single minute of the video training.

 

Course Map: Choosing which topic you want to learn is easy with the convenient course map. Advanced users may skip ahead or repeat users can pick up where they left off. The course map allows you to pick and choose the topics that interest you and tailor the learning. You can even use it as a quick launch for reviewing specific topics.

 

Search Function: Find the topics you need instantly. Just type in the word that describes your topic and view the search results. Don't waste countless minutes trying to find something you need now. The Search function is fast, accurate, and easy to use. Relevant search results and fast hyperlinks will jump you to your desired topic in a blink of an eye.

 

Note Taking: Put away your notebook and pencil. Instead, jot down notes or questions for later reference by using the useful notepad feature. If an idea comes to mind or if you need to remind yourself of something important while studying, click on the notepad directly from the course interface and type out your thoughts without ever having to lift a pencil.

 

Bookmarking: Self-paced study is designed to take place over several sessions which makes bookmarking extremely useful. You can exit your training and quickly reference areas of study you wish to revisit later by using bookmarks. If you want to pay special attention to a particular topic, simply use the bookmark feature so that you can spend extra time mastering the concept.

 

Print: Do you need a hard copy? Sometimes, it’s just not practical to log on to your computer when you have a quick question or want to review. The print function lets you print out a hard copy for those times when you need to study offline. Anything that you see on the screen can be printed out for future reference.

 

Certificate of Completion: Each interactive course comes with a certificate of completion. After you have finished the course, you just type in your name and print. It's that simple. Get recognized of your accomplishments with our courses.

 

Multi-User Licensing: The best single and multi-user licensing agreement in the industry. Our licensing agreements accommodate individual students as well as companies with large training requirements. Single user licenses, single PCs licenses, multiple-user (non-concurrent) licenses, and unlimited corporate server site licenses are all available. This level of flexible licensing can’t be beat. No matter what you need, we have a license.

Outline

Training Level: Basic to Advance

Table of contents

Oracle 11g Introduction to SQL Essential: 

Lesson 1: Introduction
Lesson 2: Retrieving Data Using SQL Select Statements
Lesson 3: Restricting and Sorting Data
Lesson 4: Using Single-Row Functions to Customize Output
Lesson 5: Using Conversion Functions and Conditional Expressions
Lesson 6: Reporting Aggregated Data Using the Group Functions
Lesson 7: Displaying Data from Multiple Tables
Lesson 8: Using Subqueries to Solve Queries
Lesson 9: Using the Set Operators
Lesson 10: Manipulating Data
Lesson 11: Using DDL Statements to Create and Manage Tables
Lesson 12: Creating Other Schema Objects


Oracle 11g Database Administration I: 

Lesson 1: Oracle Database Architecture
Lesson 2: Installing Oracle Software
Lesson 3: Create an Oracle Database
Lesson 4: Managing the Oracle Instance
Lesson 5: Oracle Network
Lesson 6: Tablespaces and Tables
Lesson 7: Administering Users
Lesson 8: Schema Objects
Lesson 9: Concurrency
Lesson 10: Managing Undo Data
Lesson 11: Database Security
Lesson 12: Database Maintenance
Lesson 13: Performance Management
Lesson 14: Backup and Recovery
Lesson 15: Database Backups
Lesson 16: Database Recovery
Lesson 17: SQL*LOADER and DATAPUMP
Lesson 18: Enhancing Database Capabilities


Oracle 11g Database Administration II: 

Lesson 1: Database Architecture and ASM
Lesson 2: Configuring for Recoverability
Lesson 3: RMAN Recovery Catalog
Lesson 4: Configuring Backup Specifications
Lesson 5: Using RMAN to Create Backups
Lesson 6: User-Managed Backup and Recovery
Lesson 7: Using RMAN to Perform Recovery
Lesson 8: RMAN to Duplicate a Database
Lesson 9: Tablespace Point-in-Time Recovery
Lesson 10: Undo Data
Lesson 10.1 Introduction
Lesson 11: Flashback Technology
Lesson 12: Additional Flashback Operations
Lesson 13: Diagnosing the Database
Lesson 14: Memory
Lesson 15: Database Performance
Lesson 16: Space Management
Lesson 17: Globalization


Oracle 11g PL/SQL Fundamentals: 

Lesson 1: Introduction
Lesson 2: Introduction to PL/SQL
Lesson 3: PL/SQL Variables
Lesson 4: Executable Statements
Lesson 5: Interacting with the Oracle Database Server
Lesson 6: Control Structures
Lesson 7: Composite Data Types
Lesson 8: Explicit Cursors
Lesson 9: Exceptions
Lesson 10: Stored Procedures and Functions


Oracle 11g PL/SQL Program Units: 

Lesson 1: Introduction
Lesson 2: Procedures
Lesson 3: Working with Functions
Lesson 4: Working with Packages
Lesson 5: Advanced Packages
Lesson 6: Oracle Supplied Packages
Lesson 7: Dynamic SQL
Lesson 8: Design Considerations for PL/SQL Code
Lesson 9: Triggers
Lesson 10: Compound Triggers, DDL Triggers and Event Database Triggers
Lesson 11: PL/SQL Compiler
Lesson 12: PL/SQL Code
Lesson 13: Managing Dependencies

Specs and Support


Content: CD-ROM disc (sealed in a DVD-case) 

System Requirements: 
Platform:  Windows Vista / XP / 2000 / 9x / NT
Processor: Pentium 133 Mhz or higher
RAM: 32MB
Hard drive space: 10MB
CD-ROM Drive speed: 24X

Technical Support: support@amazingelearning.com

Return to top

 

Add To Cart