Introduction to SQL

• Database Models
• Some Introductory Terminology
• DBO
• Table
• Views
• Query DDL
• DML
• DQL
• DCL Concepts

Variable and Datatype

• Data Types
• Variable Names Categories of SQL
• Statements Oracle Datatypes
• The CREATE Statement
• The DROP Command
• The ALTER Command
• , Modifying Table to Use Constraints Working with Arrays

Contents -2 (SQL)

• Date Editing
• DML Statements
• The SELECT Statement
• The INSERT Statement
• The DELETE Statement

• The UPDATE Statement
• More SQL*Plus Commands

Contents -4 (SQL)

SQL FUNCTIONS

• The DISTINCT
• Keyword Mathematical
• Functions String
• Functions Date
• Functions
• Conversion Functions

Contents -5 (SQL)

Joining Tables

• Joining Basics
• Cartesian Product
• Inner Joins and Outer Join
• Equi-Join Non-Equi
• Join Right & Left Outer Join
• Full Outer Join Set Operator
• Union & Union All
• Intersect SQL Subqueries

Contents -6 SQL

Groups

• SQL Statements
• GROUP BY Clause

• HAVING Clause
• Order of a SELECT Statement

Reports

• Reporting Concept
• The SET Command The COLUMN Command
• The BREAK Command
• The COMPUTE Command

Contents -7 SQL

Looping

• Loop Concept
• For LOOP Dual
• For Loop While Loop

Triggers

• Triggers and database events
• Defining a trigger
• Timing a trigger Enabling and disabling a trigger.

Contents -8 (SQL)

• Procedures
• functions and Views
• Basics of procedures
• Basics of functions & Packages Package forward declaration
• Package dependency Package overloading Listing package information
• Error Handling
• Errors in Programs Run Time Exceptions