This comprehensive reference will help you learn the entire spectrum of SQL - from Views to Cube and Roll Up; from Case Expressions to Variances and Corelation - and PL/SQL - from Collections to ObjectTypes; from error handling to Triggers; from Object views to Rollback segments; from UNDO tablespace to Expression filter and many more.
· Introduction to SQL
· Set Operations
· SQL Operators
· Aggregate Functions and Group by Clause
· Updating and Deleting Data in Existing Table (DML)
·Assignment - I · Assignment - II
· Advanced Queries
· Integrity Constraints
· Analytical Queries
· Understanding ROLLUP and CUBE
· Scalar Subqueries
· Case Expressions
· Multitable Insert and Merge
· Regular Expression
· Statistical Functions
· Model Queries
· SQL Quiz
· PL/SQL Program Features
· PL/SQL Datatypes
Understanding Control Structure
· Interaction with Oracle
· Collections and Records
· LOB, BFILE and DBMS_LOB
Objects and Objects Types · Sample Programs - I · Sample Programs - II
· Error Handling
· Subprograms in PL/SQL
· Package · Trigger (Database)
· Autonomous Transaction
· Important PL/SQL Packages
Object Views
· Transaction Processing in Oracle
· Locking in Oracle
· Rollback Segments
· UNDO Tablespace
· Invoker Rights and NOCOPY Clause
· Dependency Tracking in Oracle
· FalshBack Queries
· Sequence
· PL/SQL Wrapper
· Oracle Expression Filter
· Server Model for Billing Entry System
· Security and Auditing
