SQL

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