Learn how to run the script to create a
user named "iself" with password "schooling" and all its tables.
Learn
the new Oracle ANSI SQL standard statement and compare it with the original non-ANSI Oracle SQL.
Introduction
02 ("A Must to know" Oracle9i: SQL New Features)
Learn
more about some Oracle9i: SQL New Features such as the “MERGE” and
“WITH summary_name AS” statements.
Hands-On
01 (Materialized Views – The view that stores data)
Learn how to pre-compute
database information into a summary data aggregated to be easily understood. Learn
how to write simple SQL statement using the “ROLLUP” operator to create salary subtotals for
each type of job per year. Also, you should use the CUBE operator to enable a simple statement to
calculate all possible combinations of the types of jobs and year for the research department only.
Hands-On
02(The break on clause)
Learn how to write
a simple report to create a control break on columns.
Hands-On
03 (Troubleshooting – UNION, INTERSET, and MINUS statements)
Learn how to check
the contents of a table with an another table.
Hands-On
04 (Troubleshooting Deleting duplicated records)
Learn how to eliminate records
duplication from a table.
Hands-On
05 (Data Partitioning)
Learn how to partition
a table and how to run a query against a partition segment.
Hands-On
06 (Data Warehousing – The ROLLUP and CUBE function)
Learn how to to
write simple SQL statement using the “ROLLUP” operator to create salary subtotals for each type
of job per year. Also, hot to use the CUBE operator to enable a simple statement to calculate all
possible combinations of the types of jobs and year for the research department only.
Hands-On
07 (Using Native Dynamic SQL)
Learn how to write
a stored procedure to pass the table name and get back the number of records that table contains.
The SELECT statement must be created a dynamically, since you don’t know what table you are
getting statistics from. You should write your function so that your client can display all of the
tables’ name, plus the number of records contained each table.
Hands-On
08 (JAVA Stream)
Learn how to write
a simple java program to identify a special problem that can be classified by iselfschooling’s
problems only.
Hands-On
09 (Defining Objects and Collection Types)
Learn how to use the nested object
tables for a table. Learn how to use the “CONSTRUCTOR” operator to refer to the nested table
with the “THE” syntax.
Hands-On
10 (Inserting employees’ picture into the EMP table using BLOB / CLOB)
Learn how to add
pictures into a table using a stored procedure.
Hands-On
11 (Viewing a picture using BLOB datatype)
Learn how to develop an application
form to display all of the employee information plus their picture.
Hands-On
12 (What is a REF CURSOR)
Learn
how to complete the process for basing a block on a stored procedure for “single block operations
and create a package called "managers_pkg.".
Hands-On
13 (FORM BLOCK and TRANSACTIONAL TRIGGERS)
Learn
how to use the “managers_pkg” package from previous Hands-On that
you created to insert, delete, update, lock, and count a record.