title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Oracle Database 11g: SQL Fundamentals II
Duration
3 Days
Course
DBOR-916
Available Formats
Classroom Training, Online Training
Course Description
Overview
This Oracle Database 11g: SQL Fundamentals II course will prepare students for the Oracle certification exams (OCP).Objectives
Upon completion of the Oracle Database 11g: SQL Fundamentals II course, students will be able to:
- Learn to use the SQL99 join syntax and learn about the full range of join operations available, such as natural join, inner join, cross join, outer joins and others.
- Perform advanced SQL queries using techniques such as CASE structures, rollup and cube operations.
- Move beyond basic table definitions, learn to define the full range of database objects, such as advanced table definitions and the creation of indexes, sequences, views and others.
- Use the powerful set of built-in SQL functions. These functions provide sophisticated manipulation of character, numeric and date data elements.
- Take advantage of the latest features found within the Oracle release, such as the handling and tolerating DML errors without application interruption, newly added functions, and other topics.
- Obtain database object metadata from the data dictionary.
- Understand basic database security and object privileges.
- Protect database integrity and extend the conceptual data model using declarative constraints.
- Use SQL Developer and other available SQL interfaces.
- Develop complex SQL*Plus reports and reusable SQL*Plus scripts, as well as control the SQL*Plus environment.
Audience
- The target audience for this training course is all Oracle professionals, both business and systems professionals, who wish to pass the Oracle certification exams and need a 'how to' guide to acquire the knowledge of SQL.
- Further, this course is well suited for non-Oracle professionals already experienced in the SQL but who wish to become acquainted with the unique and advanced features of Oracle SQL. Among the specific groups for whom this course will be helpful are application developers and database administrators.
Prerequisites
- DBOR-915 ORACLE DATABASE 11G: SQL FUNDAMENTALS I
Related Courses
-
Oracle Database 11g: SQL Fundamentals I
DBOR-915- Duration: 3 Days
- Delivery Format: Classroom Training, Online Training
- Price: 2,100.00 USD
-
Oracle Database 11g R2 SQL Complete
DBOR-917- Duration: 5 Days
- Delivery Format: Classroom Training, Online Training
- Price: 3,500.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
??spvc-wbt-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart