Oracle Sql and Pl/Sql Overview Course
Course
In Nagpur
Description
-
Type
Course
-
Location
Nagpur
Facilities
Location
Start date
Start date
Reviews
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)
Oracle Sql and Pl/Sql Overview Course