ORACLE 11g

SQL

  • Chapter 1: Database Design
  • Database Models
  • Beginnings
  • Some Introductory Terminology
  • Normalization
  • First Normal Form
  • Second Normal Form
  • Third Normal Form
  • BC Normal Form
  • Chapter 2: Data Definition Language
    • Categories of SQL Statements
    • Oracle Datatypes
    • The CREATE Statement
    • The DROP Command
    • The ALTER Command
  • Chapter 3: Data Manipulation Language
  • DML Statements
  • The SELECT Statement
  • The INSERT Statement
  • The DELETE Statement
  • The UPDATE Statement
  • More SQL*Plus Commands
  • Chapter 4: Transaction Control
    • Transactions
    • Command Classification
    • Savepoints
    • The SET TRANSACTION Command
  • Chapter 5: SQL Operators
    • Simple Selects
    • Comparison Operators
    • IN and NOT IN Operators
    • BETWEEN Operator
    • The LIKE Operator
    • Logical Operators
    • IS NULL and IS NOT NULL
    • ANY
    • ALL
  • Chapter 6: SQL FUNCTIONS
    • Introduction
    • The DISTINCT Keyword
    • Aliases
    • Miscellaneous Functions
    • Mathematical Functions
    • String Functions
    • Date Functions
    • Conversion Functions
    • Pseudo Columns
  • CHAPTER 7 :CONSTRAINTS
  • Not Null constraint
  • Primary key constraint
  • Foreign key constraint
  • Unique constraint
  • Check constraint
  • Ref constraint
  • Chapter 8: Joining Tables
  • Joins
  • Cartesian Product
  • Equi-Join
  • Table Aliases
  • Non-Equi Join
  • Self Join
  • Outer Joins
  • Right Outer Join
  • Left Outer Join
  • Full Outer Join
  • Chapter 9: Set Operators
    • Introduction
    • Selection Criteria
    • Union
    • Union All
    • Intersect
    • Minus
  • Chapter 10: SQL Sub queries
    • Introduction
    • Using a Sub query with a DML Statement
    • Typical Sub queries
    • Sub query Operators
    • Standard vs. Correlated Sub queries
    • Correlated Sub query Example
    • Predicate Operators
  • Chapter 11: Groups
  • SQL Statements
  • GROUP BY Clause
  • HAVING Clause
  • Order of a SELECT Statement
  • Chapter 12: More Database Objects
    • More Database Objects
    • Relational Views
    • Updating a View
    • Create or Replace
    • Forcing a View
    • The Data Dictionary Revisited

PL/SQL

  • Chapter 1: Introduction
    • SQL vs. PL/SQL
    • A Few Simple Examples
    • Saving Procedures
    • A More Complete Picture
    • Comments
    • Variable Substitution
    • Simple Exception Handling
    • Advantages of PL/SQL
    • Assignments
  • Chapter 2: Declarations and Data Types
    • Declarations
    • Standard Data Types
    • Initialization
    • Variable Names
    • Specialized Data Types – %TYPE
    • Specialized Data Types – %ROWTYPE
    • Building Your Own Data Types – Records
    • A Quick look at Loops
    • Arrays
    • Tables
    • Nested Blocks
  • Chapter 3: Language Components
    • Introduction
    • Assignments
    • Decision Making Statements
    • Simple Loops
    • Loops – for
    • Loops – indefinite
    • Loops – while
    • Simple Loops
    • Nested Loops
    • Boolean Variables
    • PL/SQL Relational Operators
    • PL/SQL Logical Operators
    • The CASE Construct
  • Chapter 4: Cursors
    • Introduction
    • Cursor Manipulation
    • Using the Cursor
    • For Loops Cursors
    • Cursor Attributes
    • Cursor Parameters
    • Nested Cursors
    • Cursor Exceptions
  • Chapter 5: Exceptions
    • Errors in Programs
    • Run Time Exceptions
    • Oracle Built In Exceptions
    • Unnamed Exceptions
    • Built in Exception Functions
    • Creating Your Own Exceptions
    • Building Non Terminating Exceptions
  • Chapter 6: Functions and Procedures
    • Introduction
    • Creating a Procedure
    • Example Procedure
    • Using Parameters
    • Functions
    • Procedures and Exceptions
  • CHAPTER 7 : TRIGGERS
    • Row Triggers
    • Statement Level triggers

 

Leave a reply

required