|
|
Oracle Database 11g : SQL Certified Expert
Take advantage of our intensive personal training and mentoring by Oracle Certified expert as you retool and reposition yourself or organization for opportunities in the IT market.
Our expert-level instructors teach to accommodate every student's learning needs through individualized instruction, hands-on labs, and exercises, independent study, self-testing, question and answer drills.
This course is the bundle of Oracle Database: Inroduction to SQL and SQL Fundamentals II courses; and appropriate for a 10g and 11g audience. There are minor changes between 10g and 11g features.
This course covers creating indexes and constraints, and altering existing schema objects. Additionally, participants learn how to create and query external tables. In order to query and manipulate data within
the database, to use the dictionary views to retrieve metadata and create reports about their schema objects,
participants get to understand the advanced features of SQL. Some of the date-time functions available in the
Oracle Database are also covered. This course also discusses how to use the regular expression support in SQL.
Prerequisite
Basic knowledge of Data Processing concepts
Training Format
Instructor Led Sessions with Intensive Hands-on Training, utilizing our (Lecture | Lab | Review) Delivery.
Comprehensive Study Materials and Pre/Post-Class Mentoring and Practice Test.
Oracle 11g Enterprise Edition installed on your PC (Laptop preferred)
Bonus : Exposure to Basic Analytical SQL, TOAD, SFTP
Certification
Though our training places more emphasis on a comprehensive understanding of Oracle technologies, students are also adequately
prepared to take applicable Oracle certification exams to earn Oracle SQL Certified Expert. Our student’s exam success rate is excellent
Schedule/Next Session
5-Weeks Every Saturday 9am -5pm :
Starting: September 10th, 2011
Price :
US$2,500
This training combines and covers materials from the following courses:
|
|
PT-OR1101 - Oracle Database 11g: Introduction to SQL
Structured Query Language forms the cornerstone of all relational database operations.
Taking full advantage of its power requires an in-depth understanding of the language. In this course, you learn to use the full potential of SQL to write complex queries for Oracle databases.
|
|
|
PT-OR1105 - Oracle Database 11g: SQL Fundamentals II
This course introduces the advanced features available in the SQL programming language. The topics
covered will expand the student's knowledge of the language and enhanced their SQL programming skills.
|
Enroll→
|
|
|
|
|
