THIS COURSE IS BEST FIT FOR AN INDIVIDUAL WHO IS ASPIRING TO BECOME A GOOD DATABASE PROGRAMMER.ENTIRE STRUCTURE CONCENTRATES ON TECHNICAL ASPECT OF DATABASE AND ITS SCHEME.
This course is best fit for an individual who is aspiring to become a good database programmer. Every concept is presented with adequate details. Entire structure concentrates on technical aspect of database and its schema.
Introduction to Oracle, Oracle products, Oracle Components, Oracle as an Object Relational Database. Introduction to SQL *Plus – What is SQL, PL/SQL and SQL *PLUS. Working with SQL *PLUS Environment. Data Types and Data Conversion. Data Retrieval Using SQL – Select Queries, Single Row functions, Multi table Queries. Data Manipulation Language – Altering Tables or Modifying Tables. Transaction Processing in Oracle. Data Definition Language – Creating and Managing Tables. Oracle Database Objects – Views, Synonyms and Sequences. Indexing and Clustering. Introduction to PL/SQL, PL/SQL Control Structures and Composite Datatypes. Explicit Cursors – Type of Cursors, Parameterized Cursors and Cursors Variables. Packages, Database Triggers. Exception Handling – Predefined Exceptions, User Defined Exception, Handling Exception and RAISE_APPLICATION_ ERROR Procedure.
Knowledge of any object oriented programming language.
Jyotsna Nitin Binjwe
Has a teaching & working experience of 10+ years. She has also handled many software development projects