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
Keyword
Course #
State

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


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


Description: 

Benefits

  • 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

Notes

  • 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
     
Prerequisite: 

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

Audience

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

View Printer Friendly Page

 


To Inquire About Future Classes

Request a class date

if one is not scheduled.