SQL and SQL PLUS Basics

Table Of Contents :

MODULE I

• Intro to SQL and SQL*Plus
• Running SQL and SQL*Plus in Oracle
• Getting Help
  

MODULE II

• Running Simple Queries in SQL
• Datatypes and Metadata
• Structuring Queries
  
• Saving Queries & Running Saved-Queries
• Operators
• Comparison Operators
• Arithmetic Operators
• Common Aggregate Functions
  

MODULE III

• Working with Dates & Date Functions

MODULE IV

• GROUP BY Clause
• ORDER BY Clause
• HAVING Clause
• Joining Tables

MODULE V

• Creating Tables
• Dropping and Altering Tables
• Creating Tables from Subqueries
• Creating Demo Tables
• Creating Views
• Inserting, Updating & Deleting Records
• Committing Changes
• Indexing Tables

MODULE VI

• Creating Sequences
• Creating Triggers
• Using MS-Access as a Front End
• SQL Loader
• SQLPlus Worksheet

click here to download