SQL

1) Introduction

2) Comments

3) SubLanguages

1. a) DDL
2. b) DML
3. c) DQL/DRL
4. d) DCL
5. e) TCL

4) sql operators

1. a) relational operators
2. b) Logical operatiors
3. c) set Operator
4. d) special operators

5) sql predefine functions

       a) singlerow Function

       b) multirow Function

6) Gruopby Functions

1. a) GroupBy
2. b) having
3. c) orderby

7) Constrains

1. a) not Null
2. b) Unique
3. c) primary key
4. d) foreign key or referential integrity Constrains
5. e) check

8) views in SQL

9)  indexs in SQL

10)  sequences in SQL

11) joins and subjoins

12) users and previlizers

13) Sub querys

1. a) Single row subquery
2. b) multirrow subquery
3. c) multiple column subquery

13) other topics

PL_SQL

1) introduction of plsql

2) explain about programing

3) %type and %row functions

4) CURD query executions

5) control statement

1. a) simple loop
2. b) while loop
3. c) for loop

4) rectivifation exceptions

1. a) implicit exceptions
2. b) userdefine exceptions

5) cursors

1. a) Implicit cursor
2. b) explicit cursor

6) functions

7) triggers

8) packages

1. a) package Head
2. b) package body

9) procedures

1. a) in
2. b) out
3. c) in out