CiiT Makes technology simple
Central Institute of Information Technology ®
Plot No.2, Near Jerryl Lawns, RPTS Road, Opp. ICAD Build., Laxminagar, Nagpur - 440022
Email: ciit_nagpur@yahoo.com        Mobile: 9011501192
|    Home     |    Our Courses     |    Projects     |    Tips/Faq     |    Interview Questions     |    Jobs     |    About Us     |    Contact Us    |

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)
© Central Institute of Information Technology - 2009