KT-3089 Oracle Database 10g: Introduction to SQL Prep for Oracle OCA Exam 1Z0-047 Oracle Database SQL Expert Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University


Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training



 Course Search
Course #

 Training Delivery
Training Delivery
Custom Curriculum
Course List
 Main Menu
View Courses
Site Index

Oracle Database 10g: Introduction to SQL Prep for Oracle OCA Exam 1Z0-047 Oracle Database SQL Expert



  • Become Oracle (OCA) Certified!
  • Pass Oracle Exam 1Z0-047, guaranteed 1
  • Less expensive than Oracle University!
  • Prepare better, score higher and take the exam with more confidence
  • Add Oracle Database to your resume
  • Tips and Best Practices from an Industry Expert
  • One-to-one communication with your instructor, even before class starts!
  • Hands-on workshops for all lessons
  • Free practice exam
  • Money-back satisfaction guarantee 2

What You Will Learn

  • Learn how to query an Oracle Database with the SQL programming language
  • Relational database concepts
  • Code SQL queries including joins, sub-queries, compound queries and hierarchical
  • queries
  • Search for data with operators such as LIKE, IN, BETWEEN, ANY and ALL
  • Use Oracle functions like substring and search data with Unix-like regular expressions
  • Aggregating data with the GROUP BY clause and Oracle SQL functions like MIN,
  • MAX and AVG
  • Update data stored in an Oracle database with data manipulation (DML) statements
  • Create your own tables and other Oracle objects
  • Learn to grant and revoke Oracle object and system security privileges
  • Use Oracle tools like iSQL*Plus, SQL*Plus and SQL Developer

What You Will Receive

  • Printed and online versions of a detailed, 200+ page course book
  • All sample scripts and workshop solutions
  • Hands-on access to all required hardware and software (high-speed internet connection required)
  • Download a completely free version of Oracle Database to install on your workstation or laptop
  • Personal, one-to-one communication with your instructor
  • Answers to all your Oracle SQL questions
  • A printed course completion certificate


  • 1. Students who have passed the pre-course prerequisite quiz can retake the course at no cost up to 4 times or until successfully passing the Oracle exam. Exam must be retaken after each course.
  • 2. Students can drop-out of the course during the 1st 7 hours of instruction and receive a 100% refund. Course materials must be returned prior to receiving refund.

Click here to view the Course Outline

Familiarity with information technology concepts. Experience with another programming language is helpful but not required. 


  • Application Developers
  • Business Intelligence Developers
  • Database Administrators
  • End Users
  • Forms Developers
  • APEX Developers
  • PL/SQL Developers
  • Portal Developers
  • Migrating from MS SQL Server
5 Days  

View Printer Friendly Page


To Inquire About Future Classes

Request a class date

if one is not scheduled.