Home Study Online Training
and Exam Prep
Sale Ends Soon.
Order Today!

ORDER ONLINE AND GET FREE   SHIPPING* except diagnostics

training on DVD-ROM and online  trainingplanet.com

"I did it and so can you. Self-Study can and does work"

Ask a Question

TRAINING PLANET HOME


IT TRAINING CATEGORIES:
 

MICROSOFT SPECIFIC
MCSE Server Admin FREE CLOUD
MCTS Windows 7 Certification Training
Microsoft Project
Microsoft Exchange Server
Microsoft Office 2013 2010
Microsoft Sharepoint

Who is affected by
DoD Directive 8570
?

PC DIAGNOSTICS
Micro 2000 Microscope
PC Check by Eurosoft

DOD 8570.1 Dept. of Defense
A+
Network+
Security+
CISSP
CEH
SSCP

COMPTIA ENTRY LEVELS
A+ Certification PC Repair and Support UPDATED!
CDIA+ Document Imaging
Network+
Linux+
Security+
Project+

CISCO
Cisco CCNA Training
Cisco Wireless
Cisco VOIP Training
CCNA Voice Certification

Cisco CCNA Security Training
CCNP Certification
CCIE Certification
CCNA Voice over IP Training

SECURITY
Security+ Get DoD Certified!
Cisco CCNA Security Training
Certified Ethical Hacker (CEH) FREE LINUX+ DoD
CISSP Exam Training - Shon Harris DoD
Penetration Testing (LPT / ECSA) -
Certified Security Analyst - DoD
Computer Forensics CHFI
FREE SECURITY+ 
ENSA Network Security Administrator
SSCP Systems Security Certified Practitioner - DoD

OFFICE AND PAPER FLOW
Microsoft Office MOS Certification
Document Imaging 101 Fundamentals Training Course
CDIA+ Document Imaging
Microsoft Sharepoint

PROJECT / WORKFLOW MANAGEMENT
Microsoft Project
ITIL Orientation Basics
ITIL Foundations Training
Introduction to Project Management
CAPM Certified Associate in Project Management
PMP Project Management Professional

NETWORKING
Linux Training
VMWare Vsphere Training 5.0 Certified Virtualization Expert (CVE)
MCSE 2012 Windows Server
Cisco Wireless Networking
ENSA Network Security Administrator

BEGINNER
IT Beginner Basic Training
A+ Certification PC Help Desk and Support
Network+
Security+
EC-Council ENSA Network Security Administrator
Microsoft Office
Help Desk / Job Getter Bundle
Document Imaging 101 Fundamentals Training Course


AUTOCAD
Autocad Training 2006 FREE 3D
 


LIVE BOOT CAMP CLASSES

NETWORKED / ONLINE & SITE LICENSE VERSIONS

EXAM SIMULATORS

EXAM TAKING FAQ

FINANCING

IT JOBS IN YOUR AREA

IT JOB SALARY SURVEYS

- PURCHASE ORDERS


CONTACT US

POLICIES

PRIVACY


 

Ask a Question

From Interactive Online Training to Boot Camp Classes...
      at Training Planet it's all about choice.™

training course classes boot camps online cd dvd

 

OUR ENTIRE PRODUCT LINE ON SALE!

Oracle 11g Certification Training Course:
OCA  Oracle Certified Associate

 


The Oracle Database 11g Administrator Certification (OCA 11g) from QuickCert ensures that database professionals you have a strong foundation and expertise in the industry's most advanced database management system, Oracle 11g.


QuickCert's 11g OCA training package covers includes the following exam courses needed for Oracle OCA certification:
1Z0-047: Oracle Database SQL Expert
1Z0-052: Oracle Database 11g: Administration I


QuickCert's training course will teach students how to install and maintain an Oracle database, how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. Students will also learn skills required for working with SQL, including how to use the advanced features of SQL in order to query and manipulate data within the database, control privileges at the object and system level, and use advanced querying and reporting techniques.

After completing QuickCert's Oracle OCA 11g course, students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another.
Oracle DBA's manage the industry's most advanced information systems and command some of the highest salaries. By earning your Oracle Certification from QuickCert, you will be one step closer to gaining access to better career opportunities.




Learning segments
Oracle OCA Exam 1Z0-152:
Database Architecture
Architectural Components of the Oracle Database
Memory Structures
Server Processes and Background Processes
Logical and Physical Storage Structures
Module Summary
Review Quiz
Installing the Oracle Software
Database Administrator Tasks and Tools
Planning a Oracle Database Installation
Using Optimal Flexible Architecture
Installing the Oracle Software using OUI
Module Summary
Review Quiz
Creating an Oracle Database
Planning for Database Creation
Configuring the Listener
Creating a Database
Module Summary
Review Quiz
The Oracle Instance
Starting and Stopping the Oracle Database
Using the Oracle Enterprise Manager
Access a Database with SQL*Plus
Modify Database Initialization Parameters
Database Startup
Database Shutdown
Viewing the Alert Log and Dynamic Performance Views
Module Summary
Review Quiz
Oracle Network Environment
Creating and Configuring Additional Listeners
Creating Oracle Net Service Aliases
When to Use Shared and Dedicated Servers
Module Summary
Review Quiz
Database Storage Structures
Describe Table Row Data and Define Tablespaces
Creating and Managing Tablespaces
Automatic Storage Management
Module Summary
Review Quiz
User Security
Create and Manage User Accounts
Grant and Revoke Privileges
Create and Manage Roles
Create and Manage Profiles
Module Summary
Review Quiz
Schema Objects
Defining Schema Objects and Data Types
Creating and Modifying Tables
Defining Constraints
Viewing Columns and Contents of a Table
Creating Indexes
Creating Views
Creating Sequences
Using Temporary Tables
Module Summary
Review Quiz
Data and Concurrency
Managing data Using SQL
Identifying and Administering PL/SQL Objects
Monitoring and Resolving Locking Conflicts
Module Summary
Review Quiz
Undo Data
Implementing Undo Data
Working with Undo Data
Module Summary
Review Quiz
Security
DBA Security and Privileges
Enabling Auditing
Audit Options and Information
Fine Grained Auditing
Auditing the DBA and Maintaining the Audit Trail
Module Summary
Review Quiz
Maintenance
Managing Optimizer Statistics
Managing Automatic Workload Repository
Using the Automatic Database Diagnostic Monitor
Setting Alerts and Thresholds
Module Summary
Review Quiz
Oracle Performance
Performance Monitoring with the Enterprise Manager
Using Automatic Memory Management
Viewing Performance Related Dynamic Views
Troubleshooting invalid and Unusable Objects
Module Summary
Review Quiz
Backup and Recovery
Types of Database Failure
Checkpoints, Redo Log Files, and Archive Log Files
Instance Recovery
Configuring for Recoverability
Configuring Archive Log Mode
Module Summary
Review Quiz
Database Backups
Backup Solutions Overview
Configuring Backup Settings
Scheduling Backups
Backing up Control Files to a Trace File
Managing Backups and the Flash Recovery Area
Using the RMAN Command Line
Module Summary
Review Quiz
Recovery
Recovering From a Lost Control File
Recovering Redo Log Files
Recovering Non Critical and Critical Data Files
Using the Data Recovery Advisor
Module Summary
Review Quiz
Moving Data
Moving Data and Creating Directory Objects
Loading Data with the SQL Loader
Creating and Reading External Tables
Using Oracle Data Pump Export and Import
Data Pump Performance and Monitoring
Module Summary
Review Quiz
Database Maintenance
Using the Enterprise Manager Support Workbench
Metalink Integration and Managing Patches
Module Summary
Review Quiz
Course Review

Oracle Database/ SQL Expert: Exam 1Z0-147

Introduction to Oracle SQL
Relational Database Systems
Examining SQL
SQL Developer and SQL Plus
Examining the Database and Schema
Module Summary
Review Quiz
Select Statements
Basic Select Statements
Selecting Columns and Using Arithmetic Operators
Operator Precedence
Concatenation Operator
Displaying the Table Structure
Module Summary
Review Quiz
Where and Order By Clauses
Implementing the Where Clause
Comparison Operators
Logical Operators
Rules of Precedence
Substitution Variables
Module Summary
Review Quiz
Single Row Functions
Types of Single Row Functions
Working with Dates
Module Summary
Review Quiz
Group Functions
Types of Group Functions
Creating Groups of Data
Multi Column Grouping
Module Summary
Review Quiz
Joins
Natural Joins
Nonequijoins and Outer Joins
Cartesian Joins
Module Summary
Review Quiz
Sub-Queries
Single Row Subqueries
Multiple Row Subqueries
Null Values
Module Summary
Review Quiz
Set Operators
Union and Union All Operators
Intersect and Minus Operators
Select Statements and the Order By Clause
Module Summary
Review Quiz
Data Manipulation Language
Insert Statements
Update Statement
Delete Statement
Database Transactions
Module Summary
Review Quiz
Data Definition Language
Creating Tables
Data Types and Constraints
Altering a Table Statement
Module Summary
Review Quiz
Schema Objects
Views
Sequences
Indexes
Synonyms
Module Summary
Review Quiz
User Privileges
Creating a User
System Privileges
Role and Object Privileges
Granting and Revoking Privileges
Module Summary
Review Quiz
Schema Objects
Altering a Table
Adding Constraints
Dropping Constraints
Indexes
Dropping Tables and Flashback Table
Create and Use External Tables
Module Summary
Review Quiz
Oracle Data Dictionary Views
Using the Oracle Data Dictionary
Types of Views and Querying the Data Dictionary
View Information
Module Summary
Review Quiz
Large Data Sets
Using Subqueries
Default values and Copying Rows
Multi Table Insert
Merge Statement
Flash Back Version Query
Module Summary
Review Quiz
Time Zones
Time Zone Functions
Time Stamp Data Types
Interval Data Types
Available Functions
Module Summary
Review Quiz
Advanced Sub-Queries
Pairwise and Nonpairwise Comparison Queries
Scalar Subquery
Correlated Subquery
Exist Operator and With Clause
Module Summary
Review Quiz
Regular Expressions
Using Regular Expressions
Using Subexpressions and Check Constraint Expressions
Module Summary
Review Quiz
Course Review
 

 

 

YOUR TRAINING PACKAGE INCLUDES:
Instructor-Led Training on Video
Demos and Lab Learning
Multi-Media Presentations
Practice Exams and Test Simulators
Self-Paced Navigation
DVD/CD-ROM Delivery

 

 



ORACLE DEMO
 
SALE EXTENDED TO OUT OF STOCK UNAVAILABLE
WHILE SUPPLIES LAST

 

 

.
Most training is in online format at this point.

Online Certification Training
5/5 stars
" A comprehensive collection of exam prep and training materials"
Ask a Question

certification training classes boot camp bootcamp

 Training Planet, Inc. / Certification City
 
An International Computer Support Training and Certification Services Company
Purchase Order Info Click Here
FREE SHIPPING on online orders*  except diagnostics
- U.S. and Canada Orders Only - Government APO/FPO OK

Ask a Question

FINANCING Available.

WE ACCEPT PURCHASE ORDERS



 

 


 

LIVE CLASSES ALSO OFFERED IN MOST CITIES.     
Albany, New York Albuquerque, New Mexico Alexandria, Virginia and Anchorage, Alaska.  Atlanta, Georgia Austin, Texas Baltimore, Maryland Birmingham, Alabama Bismark, North Dakota Boise, Idaho Boston, Massachusets Charlotte, North Carolina and Cheyenne, Wyoming. Chicago, Illinois Cincinnati, Ohio Cleveland, Ohio Columbus, Ohio Concord, New Hampshire Dallas, Texas Denver, Colorado. Des Moines, Iowa.
Detroit, Michigan Ft. Lauderdale, Florida. Ft. Wayne, Indiana Honolulu, Hawaii Houston, Texas Huntsville, Alabama Indianapolis, Indiana Jackson, Mississippi and Jackson, Wyoming Jacksonville, Florida Lexington, Kentucky Lincoln, Nebraska Los Angeles, California Las Vegas, Nevada. Miami, Florida Milwaukee, Wisconsin Minneapolis, Minnesota Montpelier, Vermont Nashville, Tennessee New Orleans, Louisiana New York City Norfolk, Virginia. Cisco Dallas Todd Lammle.
Oklahoma City, Oklahoma and Omaha, Nebraska Orlando, Florida Philadelphia, Pennsylvania Phoenix, Arizona Pierre, South Dakota Pittsburgh, Pennsylvania and Portland, Maine. Portland, Oregon Providence, Rhode Island.
Raleigh-Durham, North Carolina Richmond, Virginia.
Rockford, Illinois Sacramento, California. St. Louis, Missouri and Salt Lake City, Utah San Antonio, Texas San Diego, California and San Francisco, California San Jose, California Sandestin, Florida. Seattle, Washington Tulsa, Oklahoma Wichita, Kansas and Wilmington, Delaware Canada Ontario British Columbia Vancouver. Toronto Montreal Calgary and Winnipeg Quebec City Ottawa Edmunton.
 training planet blog certification city blog news



 



GET CERTIFIED
IN DAYS WITH
NATIONWIDE

mcse certification training cisco classes

MCSE Boot Camps
Cisco Boot Camp
PMP Boot Camp
CISSP Class
A+ / Network+

free training review
free course training reviews

>Watch short video instead



LIKE US
AND WIN!

 

THIS MONTHS MOST POPULAR COURSES ARE NOW ALL ON SALE!

 HUGE SPECIAL SALE!

TOP IT CERTIFICATIONS 2017

PC Diagnostics Microscope

 PMP Exam Prep

Microsoft Project

CAPM Certified Associate in Project Management

Certified Hacking Forensic Investigator
FREE Security+ training

CDIA+ Document Imaging

CISSP Certification

 

EVERTHING YOU NEED TO WORK
AND SUPPORT WITH CONFIDENCE!

 HUGE SPECIAL SALE!

 NEW to IT Bundle
Big Savings
Employability course package!

This bundle consists of:
CompTIA A+ Certification
Network+ Certification
Security+ Certifications

Each of the CompTIA program contains:
- Instructor led training delivered on interactive video 1 year Online Training Access
- E-Study guides
- Practice Quizzes


PROMO $795

MORE INFO 

Train your entire company or school with any of our titles for one low price!
Check out

Site License
Online Training
and
Networkable Solutions
Details

 

 

TRAINING PLANET BLOG REAL JOB RELATED NEWS.

FACEBOOK PAGE

GOOGLE +

COMPUTER TRAINING CHANNEL

LINKEDIN

TWITTER

signup