Oracle Sql and Pl/Sql Overview Course

Oracle : Sql (Structured Query Language) Overview in Java Course for JDBC purpose

* Dbms and Rdbms Concept
* Data Definition Language (DDL) (Create, Alter, Drop, Rename ,Truncate)
* Table, View, Synonyms
* Key Constraint: (Primary, Foreign, Unique)
* Data Manipulation Language (DML) (Insert, Update, Delete)
* Transaction Control Statement(TCS) (Commit, Rollback, Savepoint, Set Transaction)
* Query Language (QL) (Select, From, Where, Group By, Having, Order by)
* Data Retrival from Single and Multiple Table
* Cartesian product/Cross Product
* Sub-Query, Scalar SubQuery in Select,
* Logical (All, And, Any, Between, Exits, In, Not In, Like, Or, Some,)
* Comparison/Relational ((), =, !=, <>, >, >=, <, <=)
* Aggregate Functions
* Sum(), Avg(), Min(), Max(), Count()
* Merge Statement

Oracle : Pl/Sql (Procedural Language) Overview in Java Course for JDBC purpose

* Introduction TO PLSQL
* PLSQL block Structure/Architecture
* Data Types
* Declaring Variables
* Control Structures
* Conditional Control Statements
If ...Then
If ...Then ...Else
If ...Then ...ElsIf
* Iterative Statements
For(...Range...)Loop .. End Loop
While(...condition...)Loop ... End Loop
Loop ... End Loop --Explicite Exit Statement
* Exit Statement
* GoTo Statement
* Null Statement
* Into Statement
* Explicit Cursor
* Implicit Cursors (Dml/Select Into)
Attributes(SQL%Found, SQL%NotFound, SQL%RowCounts, SQL%IsOpen)
* Exceptions Handling
* Sub-Programs (Procedures and Functions)
* Stored Programs (Procedures and Functions)