|
SQL
and PL/SQL
Build
your schema to work on iSelfSchooling's Hands-On
In order
to practice the iSelfSchooling's case studies, you need to create a
user named iself with all its necessary tables. There is a script
named "create_tables.sql." If you want you can click here
to download the script on to your c:\ directory. Then sign on to
system/manager user and run the script. ex: SQL> start
c:\create_tables.sql
This
script will create a user named "iself" with password
"schooling" and all its tables. Don't forget that after
downloading any file from anywhere, virus check the file. Good
luck with your setup. --iSelfSchooling.com
SELF-How to Build your "ISELF" Schema
ISELF Schema
Script here
Hands-On Oracle Installation and SQL
SQL001-Important Installation Notes
SQL002-How to create an Oracle Service Name
SQL003-Basic Important Database Notes
SQL004-Basic Important SQL Notes
SQL005-Selecting Data from Oracle
SQL006-Advanced Data Selection in Oracle
SQL007-Creating Oracle Database Objects
SQL008-Creating Other Oracle Database Objects
SQL009-SQL and PL/SQL Command editors
SQL010-SQL and PL/SQL Notepad editor
SQL011-Oracle9i and up SQL New Features
SQL012-WITH SUMMARY AS and MERGE statements
SQL013-Materialized views - the view that stores data
SQL014-The BREAK ON clause
SQL015-Troubleshooting - UNION,
INTERSET, and MINUS statements
SQL016-Troubleshooting Deleting duplicated records
SQL017-Data Partitioning
SQL018-Data Warehousing and use of ROLLUP and CUBE functions
SQL019-How to use Native Dynamic SQL
SQL020-How to use JAVA Stream
SQL021-Defining Objects and Collection Types |
Hands-On Oracle Training PL/SQL
|
PLS001-PL/SQL Introduction
PLS002-Basic PL/SQL
PLS003-Explicit Cursor Handling
PLS004-Controlling Process Flow
PLS005-Populating table using PL/SQL
PLS006-Cursor Parameter
PLS007-EXECPTION
PLS008-Advanced PL/SQL Introduction
Section 1: Creating PL/SQL
PLS009-Create PL/SQL to populate table using Notepad
PLS010-Create PL/SQL to add department row using Procedure Builder
PLS011-Create PL/SQL to remove department row
PLS012-Create PL/SQL to concatenate customer's name
PLS013-Create PL/SQL to return department name
Section 2: Debugging PL/SQL
PLS014-Debugging PL/SQL
Section 3: Dependency
PLS015-Granting Objects Privileges
PLS016-Managing Objects Dependency
Section 4: Package
PLS017-Creating PL/SQL Package
Section 5: Developing and using Database Triggers
PLS018-Developing and using Database Triggers |
|