Oracle Sql and Pl/Sql Overview Course

Central Institute of Information Technology
In Nagpur

Price on request
You can also call the Study Centre
09011... More
Compare this course with other similar courses
See all

Important information

  • Course
  • Nagpur

Important information

Where and when

Starts Location
On request
Plot No.2, Near RPTS Road, Opp. ICAD, Laxminagar, 440022, Maharashtra, India
See map

Course programme

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)

Achievements for this centre

Compare this course with other similar courses
See all