SQL Certified Expert

This course is the bundle of Oracle Database: Introduction to SQL and SQL Fundamentals II courses; and is 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