SQL

Users and Schemas

• • Introduction to Users and Schemas

  • Definitions and Client Tools

  • SQL Developer Login

  • Creating An Application Schema

  • SQL COMMANDS

SQL command

• TCL --- Transaction control language

• DML --- Data manipulation  language

• DCL --- Data control language

• DDL ---- Data definition language

DDL command

• create statement

• alter

• truncate

• comment

• drop

DCL command

• grant

• revoke

DML command

• select

• insert

• update

• delete

TCL command

• savepoint

• commit

• rollback

Subqueries

• Correlated Subqueries

• Scalar Subquery

• all any operator

Join 

• natural join

• self join

• cross

• inner join

• left join

• right join

operators

• and

• or

• > ,<,>=,<=,<>,=

• between

• like

• in , not in

• not

• having clause

• order by

• group by

Set Operators

• Set Operators Defined

• Relationship to Mathematical Set Theory

• Restrictions on Set Operators

Conditional processing

• • The DECODE Function

  • The Case Expression

SQL Function

• What Are SQL Functions?

• Character Functions

• CONCAT

• LENGTH

• INSTR

• REPLACE

• UPPER

• LOWER

• LPAD

• RPAD

• TRIM

• TO_CHAR

• LEFT , RIGHT

• MID

• SUBSTRING

SQL Functions (Non-Character)

• Numeric Functions

• Date/Time Functions

• Arithmetic Functions

• Null Value Functions