Session Intro Rev

Introduction to Database and SQL Writing Basic SQL SELECT Statements. Creating and managing Tables with Constraints Aggregating data using group functions Manipulating Data(DML) and DDL Restricting and Sorting data

Single row functions Displaying Data from multiple Tables Aggregating data using group functions Subqueries and Co-related Subqueries Producing Readable output with iSQL*plus Creating views and other dbase objects.

 Controlling user access  Using SET operators (Union, Union All, Intersect, Minus)  Date Time Functions (Almost all date time related functions in SQL will be covered)  Advanced Subqueries

 Introduction to PL/SQL  PL/SQL Basics  Using SQL with PL/SQL  Records(PL/SQL Table, Types)  Collections  Error (Exception) Handling  Cursors (Explicit and Implicit) in detail  Creating Procedures, Functions and Packages

Using Procedure , Functions and Packages Database Triggers Advanced PL/SQL Features Introduction to Oracle Database Built-in Pkgs Introduction to Performance Tuning Introduction to Software Development Life Cycle (SDLC)

Illustration Using Real-time Scenarios & Example Front-End Connecty. using ASP.NET & C#.NET Assignments based on Real-time practices. IT Industry Coding Standards. Real-time PL/SQL Code Debugging tricks and Techniques Using third party S/w like TOAD. Real-time Problems and their Possible Solutions. Mini and Mega Project.