MCSEClasses Certification Training Boot Camp

MCSE MCSD MCDBA Cisco CIW Linux Oracle Java Security

Oracle OCA Certification Training

Oracle11g OCA & 10g SQL Certification Training Course

Course Length:	7 days
Certifications:	OCA Oracle 10g SQL Expert
Number of Exams:	2

Class Schedule

03/31/12 - 04/06/12		Info/Enroll
06/02/12 - 06/08/12		Info/Enroll
07/28/12 - 08/03/12		Info/Enroll
09/08/12 - 09/14/12		Info/Enroll
10/20/12 - 10/26/12		Info/Enroll
12/01/12 - 12/07/12		Info/Enroll

Includes roundtrip airfare and lodging (for boot camps held in Georgia and Florida only)
Hands-on instruction by a certified instructor
Includes all course materials and practice exams
Includes all certification exams
Onsite Testing
Breakfast and Lunch provided each day

Oracle Database 11g, building on Oracle's unique ability to deliver Grid Computing, gives Oracle customers the agility to respond faster to changing business conditions, gain competitive advantage through technology innovation, and reduce costs.

With Oracle Database 11g you can:

Adopt new technology faster with Real Application Testing
Manage more data for less with advanced compression and partitioning
Simplify systems by storing all your data in the Oracle Database with Oracle Secure Files
Maximize the ROI of disaster recovery resources with Oracle Active Data Guard
Free critical personnel for strategic tasks with management automation

Oracle Database SQL Certified Experts demonstrate the complete set of skills required for working with the powerful SQL programming language and have mastered the key concepts of a relational database. SQL Experts understand 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. They are able to manipulate large data sets and understand storing and retrieving dates according to different time zones. They are also knowledgeable about the concepts of controlling access and privileges for schema objects.

Oracle11g™ OCA

Course Outline

This course includes exam 1Z0-052.

Describing the Oracle Architecture

Oracle Server
SGA
Datafiles
Background Processes

Creating an Oracle Database

Database Configuration Assistance
Database Templates

Managing an Oracle Instance

Oracle Enterprise Manager

Database Storage Structures

Tablespaces
Datafiles
Tempfiles

Database Security

System Accounts
Application Accounts
Database Roles

Schema Objects

Tables
Indexes
Views
Synonyms

Data Manipulation Language

Insert
Update
Delete
Database Packages
Database Procedures

Undo Data

Flashback Query

Database Maintenance

Automatic Workload Repository
Automatic Database Diagnostic Monitor

Database Performance

Memory Advisors

Database Backup

RMAN
Open database Backup
Closed database Backup

Database Recovery

Open Database Recovery
Closed Database Recovery

Moving Data

Data Pump
SQL*Loader

[ back to top ]

Oracle SQL Expert

Course Outline

This course includes exam 1Z0-047.

SELECT Statements

Define projection, selection, and join terminology
Select all columns using a wildcard notation from a table
Write a query containing the arithmetic operators
Create a character expression with the concatenation operator
Using the iSQL*Plus Environment
SQL statements versus iSQL*Plus commands

Restricting and Sorting Data

Limit rows using a selection
Using the WHERE clause to retrieve specific rows
Using the comparison conditions in the WHERE clause
Use the LIKE condition to compare literal values
List the logical conditions AND, OR, NOT
Describe the rules of precedence for the conditions
Sort rows with the ORDER BY clause

Single-Row Functions

Show the differences between single row and multiple row SQL functions
Categorize the character functions into case manipulation and character manipulation types
Use the character manipulation functions in the SELECT and WHERE clauses
Explain and use the DATE and numeric functions

Aggregate Functions

Describe and categorize the group functions
Use the group functions
Utilize the DISTINCT keyword with the group functions
Describe how nulls are handled with the group functions
Create groups of data with the GROUP BY clause
Group data by more than one column
Avoid illegal queries with the group functions
Exclude groups of data with the HAVING clause

Joining Tables

Identify Types of Joins
Retrieve Records with Natural Joins
Use Table Aliases to write shorter code and explicitly identify columns from multiple tables
Create a Join with the USING clause to identify specific columns between tables
Use the ON clause to specify arbitrary conditions or specify columns to Join
List the Types of Outer Joins LEFT, RIGHT, and FULL
Generating a Cartesian Product

Using Sub queries

List the syntax for sub queries in a SELECT statements WHERE clause
List the guidelines for using sub queries
Describe the types of sub queries
Execute single row sub queries and use the group functions in a sub query
Identify illegal statements with sub queries
Execute multiple row sub queries

Manipulating Data

Write INSERT statements to add rows to a table
Copy rows from another table
Create UPDATE statements to change data in a table
Generate DELETE statements to remove rows from a table
Use a script to manipulate data
Save and discard changes to a table through transaction processing
Show how read consistency works
Describe the TRUNCATE statement

Creating Tables

List the main database objects and describe the naming rules for database objects
Explain the different types of constraints
Show resulting exceptions when constraints are violated with DML statements
Create a table with a sub query
Describe the ALTER TABLE functionality
Remove a table with the DROP statement and Rename a table

Creating Objects

Categorize simple and complex views and compare them
Create a view
Retrieve data from a view
Explain a read-only view
List the rules for performing DML on complex views
Create a sequence
List the basic rules for when to create and not create an index
Create a synonym

Security

Controlling User Access
System versus Objects Privileges
Using Roles to define user groups
Changing Your Password
Granting Object Privileges
Confirming Privileges Granted
Revoking Object Privileges

Schema Objects

Using the ALTER TABLE statement
Adding a Column
Modifying a Column
Dropping a Column, Set Column UNUSED
Adding, Enabling and Disabling Constraints
Creating Function-Based Indexes
Performing FLASHBACK operations
External Tables

Advanced DML Operations

Using the MERGE Statement
Performing DML with Sub queries
Performing DML with a RETURNING Clause
Tracking Changes in DML

Time Zone Changes

Using date and time functions
Identifying TIMESTAMP Data Types
Differentiating between DATE and TIMESTAMP
Performing Conversion Operations

Advanced Sub queries

Sub query Overview
Using a Sub query
Comparing several columns using Multiple-Column Sub queries
Defining a Data source Using a Sub query in the FROM Clause
Returning one Value using Scalar Sub query Expressions
Performing ROW by-row processing with Correlated Sub queries
Reusing query blocks using the WITH Clause

Regular Expression

Describing simple and complex patterns for searching and manipulating data

[ back to top ]

CED Solutions is not associated with or authorized by Oracle Corporation. Oracle is a registered trademark, and Oracle9i and Oracle10g are trademarks or registered trademarks of Oracle Corporation. The content of this website is the copyrighted property of CED Solutions, LLC.

MCSEClasses.com is your best choice for Oracle 11g OCA, Oracle 11g OCA training, Oracle 11g OCA certification, Oracle 11g OCA certification boot camp, Oracle 11g OCA boot camp, Oracle 11g OCA certification training, Oracle 11g OCA boot camp training, Oracle 11g OCA boot camp certification, Oracle 11g OCA certification course, Oracle 11g OCA course, training Oracle 11g OCA, certification Oracle 11g OCA, boot camp Oracle 11g OCA, certification Oracle 11g OCA boot camp, certification Oracle 11g OCA training, boot camp Oracle 11g OCA training, certification Oracle 11g OCA course.