INTRODUCTION TO ORACLE

• Software Install:
  • Oracle Database Express Edition 11g Release 2: (Click Here)
  • Oracle Application Express 4.2: (Click Here)
• Chapter 01: Introduction to Databases and Oracle: (YouTube Video)
• Chapter 02: Introduction to Oracle: Install and Start Using Oracle 11g Express Edition : (YouTube Video)
• Chapter 03
  • Installing Support Files: (YouTube Video)
  • Setting Up Application Express: (YouTube Video)
  • Access Database Data with SQL: (YouTube Video)
• Chapter 04, Part 1
  • Installing Support Files and Creating PL/SQL Scripts: (YouTube Video)
  • 4.1: Declaring Variables and Constants: (YouTube Video)
  • 4.2: Assigning Values to Variables: (YouTube Video)
  • 4.3a: LOOP Statement: (YouTube Video)
  • 4.3b: WHILE Statement: (YouTube Video)
  • 4.3b: FOR Statement: (YouTube Video)
  • 4.4: IF ... ELSIF ... ELSE Statement: (YouTube Video)
  • 4.5: Manipulating Table Data with DML Statements: (YouTube Video)
  • 4.6: Assigning a Value to a Variable with a Query: (YouTube Video)
  • 4.7: Declaring and Using a Procedure: (YouTube Video)
  • 4.8: Declaring and Using a Function: (YouTube Video)
• Chapter 04, Part 2
  • Table Creation: (YouTube Video)
  • PL/SQL: Table Manipulation: (YouTube Video)
• Chapter 05
  • Basic Relational Schema: (YouTube Video)
  • Administration of Workspaces: (YouTube Video)