Oracle Database 11g: SQL Fundamentals II
About This Course
This course is offered as an e-Learning course and is comprised
of four (4) modules.
Target Audience
Database Administrators, Database Designers, Developer Support
Engineers, and Technical Administrators.
Module 1: Oracle Database 11g: Controlling User Access
and Managing Schema Objects
Overview/Description
To recognize the steps for controlling user access to objects
and also for maintaining these objects by dropping columns and
adding constraints and indexes.
Lesson Objectives
Oracle Database 11g: Controlling User Access and
Managing Schema Objects
- dentify the steps for granting and revoking system and object
privileges.
- grant privileges to users in a given scenario.
- recognize the steps for altering a table by adding, modifying,
and dropping columns.
- recognize the steps for adding and manipulating constraints and
for creating indexes.
- identify the steps for recovering your database using
flashback, and for manipulating external data.
- alter a table by dropping columns and adding constraints and
indexes.
Module 2: Oracle Database 11g: Data Dictionary Views and
Large Data Sets
Overview/Description
To recognize the steps for querying data dictionary views to
views schema objects, and for performing operations on large
amounts of data, such as inserting data into multiple tables and
merging table rows.
Lesson Objectives
Oracle Database 11g: Data Dictionary Views and Large
Data Sets
- identify the steps for using data dictionary views to find
information about tables, constraints, views, sequences, and
synonyms.
- query the appropriate dictionary views to find information
about schema objects in a given scenario.
- recognize the steps for manipulating data using subqueries and
explicit default values.
- identify the steps for inserting into multiple tables, merging
rows in tables, and tracking changes in data.
- manipulate large data sets using multitable INSERT and MERGE
operations.
Module 3: Oracle Database 11g: Managing Data in
Different Time Zones
Overview/Description
To identify the steps for managing data in different time zones
in Oracle Database 11g, for managing time intervals, and for using
datetime functions.
Lesson Objectives
Oracle Database 11g: Managing Data in Different Time
Zones
- recognize the steps for managing time zones and time
intervals.
- recognize the steps for using datetime functions to manage
dates and time in Oracle Database 11g.
- display time zone offsets in a given scenario.
- extract and return the value of a datetime field in a given
scenario
Module 4: Oracle Database 11g: Using Subqueries and
Regular Expressions
Overview/Description
To recognize the steps for retrieving data using subqueries and
using regular expressions to search for, match, and replace
strings.
Lesson Objectives
Oracle Database 11g: Using Subqueries and Regular
Expressions
- identify the steps for writing multiple-column and scalar
subqueries.
- recognize the steps for solving problems by using correlated
subqueries and the WITH clause.
- write multiple-column, correlated, and scalar subqueries in a
given scenario and solve a problem using the WITH clause.
- recognize the benefits of implementing complex match logic in
the database, using regular expressions.
- identify the steps for using regular expressions functions and
for accessing subexpressions.
- use regular expression functions to search for, replace, and
manipulate data, and also add a CHECK constraint to a column