Saturday, July 28, 2007

Tutorials to Learn Oracle

Below are links to some articles that I have written on IT Toolbox that will help you learn Oracle. The most common question I get is, "How do I learn Oracle?" I am going to start a series this weekend that will guide people in their quest to master the Oracle database and Oracle programming. The links below will help get you started: Learn Oracle: General Learn Oracle - What is Oracle? (8/22/2005) What is the difference between Oracle, SQL and PL/SQL? (5/30/2006) Accessing Multiple XE Databases from a single machine (12/8/2005) Database Links: A Definition in Plain English (12/21/2005) Oracle Security: A Definition in Plain English, Part 1 (4/4/2005) Oracle Security: A Definition in Plain English, Part 2 (4/7/2005) Oracle Security: A Definition in Plain English, Part 3 (4/17/2005) Oracle Security: A Definition in Plain English, Part 4 (4/28/2005) Advanced Queues and Streams: A Definition in Plain English (3/30/2005) Oracle Advanced Replication: A Definition in Plain English (3/24/2005) Cryptography in the Database (12/16/2005) Learn Oracle: SQL Introduction to Basic SQL, Part 1 (8/24/2005) Introduction to Basic SQL, Part 2 - Joins (6/6/2006) Introduction to Basic SQL, Part 3 - Complex Joins and Sub-queries (6/8/2006) Merge (AKA Upsert) - A Definition in Plain English (8/3/2005) Learn Oracle: Datatypes for SQL and PL/SQL, Numbers Learn Oracle: Datatypes for SQL and PL/SQL, Strings Learn Oracle: Datatypes for SQL and PL/SQL, Dates Learn Oracle: Datatypes for SQL and PL/SQL, Boolean and Large Objects (LOB) Learn Oracle: PL/SQL Learn PL/SQL: Structure and Comments (7/7/2006) Learn PL/SQL: Declaring Variables, Named vs Anonymous Blocks (7/14/2006) Learn Oracle: Datatypes for SQL and PL/SQL, Numbers Learn Oracle: Datatypes for SQL and PL/SQL, Strings Learn Oracle: Datatypes for SQL and PL/SQL, Dates Learn Oracle: Datatypes for SQL and PL/SQL, Boolean and Large Objects (LOB) Learn Oracle: Procedures and Functions Overloading Procedures in PL/SQL Oracle Collections: A Definition in Plain English Part 1 (9/27/2005) Oracle Collections: A Definition in Plain English Part 2 (10/4/2005) Oracle Collections: A Definition in Plain English Part 3 (10/11/2005) The Sorcerer of OO (Object Oriented Programming), Part 1 (5/5/2005) The Sorcerer of OO (Object Oriented Programming), Part 2 (5/14/2005) The Sorcerer of OO (Object Oriented Programming), Part 3 (5/26/2005) The Sorcerer of OO (Object Oriented Programming), Part 4 (7/19/2005) XML and OO in Oracle, A Scenario (11/17/2005) Oracle and XML In Action - A Real World Example (8/10/2005)