Log In / Register

Virtual University of Pakistan

Find Course


Featured Courses


CS405 : Database Programming using Oracle 11g

I like this Course

Course Info

Course Category

 Computer Science/Information Technology

Course Level

 Undergraduate

Credit Hours

 3

Pre-requisites

 CS403

Instructor

 Sheraz Pervaiz
MS
Stuttgart University of Applied Sciences, Germany

Course Contents

Concept of ERD Components of ERD Entity and Attributes Relationships Optionality Cardinality One-to-Many Relationship Many-to-Many Relationship One-to-One Relationship Implementing ERD using Scenario What is cloud Registering on cloud Login creation Select Statement Implementing Select Statement SQL and Where Clause Implementing Where Clause-I Wild Cards Implementing Wild Card Single Row Functions Group Functions Implementing Group Functions Group by Clause Implementing Group By Clause Having Clause Implementing Having Clause Order By Clause What are Joins Implementing Joins Self Join Implementing Self Join Subqueries Implementing Subqueries What is PL/SQL Why PL/SQL How PL/SQL Work PL/SQL Blocks PL/SQL Executable Declaration of variable in PL/SQL Manipulating variable in Blocks Scope of variable in nested blocks SQL in PL/SQL Select INTO Syntax Implementing Select INTO DML in PL/SQL Implementing DML in PL/SQL-I Implementing DML and SQL in PL/SQL PL/SQL and Sequence What is Commit Implementing PL/SQL and Commit What is Rollback Implementing PL/SQL and RollBack What is SavePoint Implementing PL/SQL and SavePoint Conditional Control-I Implementing IF-THEN statement IF-THEN –ELSE Statement Implementing IF-THEN-ELSE Statement ELSIF statements Implementing ELSIF Statement Nested IF statements Implementing Nested IF statements Case Statements Case Statements Syntax Implementing CASE statement Searched Case Statements Searched Case Statements Syntax Implementing Searched CASE statement Iterative Control-I Simple Loop Syntax Implementing Simple Loops Implementing Simple Loops with SQL While Loop While Loop Syntax Implementing While Loop Implementing While Loop and SQL Do – While Loop Implementing Do-While Loop Numeric For Loop Numeric For Loop Syntax Implementing Numeric For Loop For Loop with Reverse Option Implementing Numeric Reverse For Loop Implementing Reverse For Loop with SQL Iterative Control Implementing CONTINUE statement using Basic Loop CONTINUE WHEN Condition Implementing CONTINUE WHEN statement using Loop Implementing CONTINUE WHEN statement using For Loop Nested Loops Nested Loop syntax Implementing Nested Loop Cursor Introduction Cursor and SQL Cursor Types Steps to Process Cursor Cursor Attributes Cursor Syntax Processing implicit cursor Processing Explicit Cursor Processing Explicit Cursor Using For Loop Processing Explicit Cursor with SQL Error Handling and Exceptions Need for Exception Handling Handling exceptions How Exception Handling work Type of Exceptions Formation of Built-in Exception Syntax of Exception Scope of Exception Implementing Built-in Exception Implementing Built-in Exception and SQL Implementing Nested Exceptions User Defined Exceptions Syntax of User Defined Exceptions Implementing User Defined Exception Advanced exceptions Raise vs raise application error Syntax of raise application error Implementing raise application error What is exception init pragma Syntax of exception init pragma Implementing exception init pragma Records Types of record Implementing table based record Cursor based records Implementing cursor based record User defined records Syntax of User Defined Records Implementing user defined record Collection PL/SQL table or associative array Syntax of PL/SQL table Implementing PL/SQL table PL/SQL table and its attributes Syntax of using PL/SQL table with attributes PL/SQL table and first and next attribute PL/SQL table and Count Attribute PL/SQL table and Exist Attribute PL/SQL table and Delete Attribute Implementing PL/SQL Table Implementing PL/SQL Table and SQL What is Sub Program What is Procedure Details of Procedure Syntax of Creating PL/SQL Procedure Creating First Procedure Debugging the Procedure Implementing Procedure Procedure and Parameters Procedure and IN Parameters Procedure and OUT Parameters Implementing IN/ OUT Parameter Dropping a Procedure Implementing IN/ OUT Parameter Implementing Procedure with Parameter Implementing Procedure with Multiple Return Values Functions Details of Function Function vs Procedure Syntax of Creating PL/SQL Function Creating First Function Debugging the Function Dropping a Function Function and Parameters Function and IN OUT Implementing Function Using IN Parameter-I Implementing Function Using IN and OUT Parameter Using Function and Procedure Together What is Trigger Trigger and Views Rationale for Trigger Trigger Type: Row and Statement Level Trigger Type: Before and After Flow of Trigger Execution Syntax of Creating Trigger in PL/SQL Creating First Trigger in PL/SQL Implementing Trigger in PL/SQL Enabling and Disabling the Triggers Dropping the Triggers Package Parts of Package
facebook        facebook        facebook
  

© 2011 Virtual University of Pakistan.
Developed by IT Department, Virtual University of Pakistan.