Thursday, December 10, 2009

Oracle/SQL Tutorial

Contents
1. SQL – Structured Query Language
1.1. Tables
1.2. Queries (Part I)
1.3. Data Definition in SQL
1.4. Data Modifications in SQL
1.5. Queries (Part II)
1.6. Views
2. SQL*Plus (Minimal User Guide, Editor Commands, Help System)
3. Oracle Data Dictionary
4. Application Programming
4.1. PL/SQL
4.1.1 Introduction
4.1.2 Structure of PL/SQL Blocks
4.1.3 Declarations
4.1.4 Language Elements
4.1.5 Exception Handling
4.1.6 Procedures and Functions
4.1.7 Packages
4.1.8 Programming in PL/SQL
4.2. Embedded SQL and Pro*C
5. Integrity Constraints and Triggers
5.1. Integrity Constraints
5.1.1 Check Constraints
5.1.2 Foreign Key Constraints
5.1.3 More About Column- and Table Constraints
5.2. Triggers
5.2.1 Overview
5.2.2 Structure of Triggers
5.2.3 Example Triggers
5.2.4 Programming Triggers
6. System Architecture
6.1. Storage Management and Processes
6.2. Logical Database Structures
6.3. Physical Database Structures
6.4. Steps in Processing an SQL Statement
6.5. Creating Database Objects

This Oracle/SQL tutorial provides a detailed introduction to the SQL query language and the
Oracle Relational Database Management System.

For Download:


 


For sql server cheat sheet:



0 comments:

Flag counter

free counters