Video Lectures

32x32

Chapter 1 : Overview of PLSQL
Topic : Overview of PLSQL
Content : Advantages of PL/SQL, Main Features of PL/SQL, Architecture of PL/SQL 21 MB ,12:24 MIN , THEORY


32x32

Chapter 2 : Fundamentals of PL/SQL
Topic : Identifiers and Keywords
Content : Identifiers and Keywords 14 MB ,7:7 MIN , THEORY + PRACTICAL


32x32

Chapter 2 : Fundamentals of PL/SQL
Topic : Fundamentals of PL/SQL
Content : Declarations, References to Identifiers, Scope and Visibility of Identifiers, Assigning Values to Variables, Data Types 40 MB ,22:5 MIN , THEORY + PRACTICAL


32x32

Chapter 2 : Fundamentals of PL/SQL
Topic : Basic PL/SQL Block
Content : Basic PL/SQL Block 23 MB ,12:18 MIN , THEORY + PRACTICAL


32x32

Chapter 3 : Control statements
Topic : Control Statements
Content : Conditional Selection Statements IF-Else. Case statement 34 MB ,16:29 MIN , THEORY + PRACTICAL


32x32

Chapter 3 : Control statements
Topic : LOOP Statements
Content : Loops : Simple loop, while loop, Do-while loop 18 MB ,9:23 MIN , THEORY + PRACTICAL


32x32

Chapter 4 : Sequences:
Topic : Sequences
Content : creating sequences, referencing, altering, and dropping a sequence. MB , MIN , THEORY + PRACTICAL


32x32

Chapter 4 : Sequences
Topic : Sequences
Content : creating sequences, referencing, altering, and dropping a sequence 34 MB ,19:7 MIN , THEORY + PRACTICAL


32x32

Chapter 5 : Stored Procedures and Functions
Topic : Stored Procedures and Functions
Content : Stored Procedures and Functions 36 MB ,19:47 MIN , THEORY + PRACTICAL


32x32

Chapter 1 : Collections and Records
Topic : Varray
Content : Defining Varray, using it in PLSQL block, assigning the value, using varray at schema level, Collection Constructors, Assigning Values to Collection Variables 33 MB ,18:9 MIN , THEORY + PRACTICAL


32x32

Chapter 1 : Collections and Records
Topic : Nested table
Content : Defining Nested table, using it in PLSQL block, assigning the value, using Nested table at schema level, Collection Constructors, Assigning Values to Collection Variables 19 MB ,9:59 MIN , THEORY + PRACTICAL


32x32

Chapter 1 : Collections and Records
Topic : Collection and Records
Content : Varrays, using varray in PL/SQL block, using VARRAY at schema level 33 MB ,18:9 MIN , THEORY + PRACTICAL


32x32

Chapter 1 : Collections and Records
Topic : Associative Array
Content : Defining Associative Array, using it in PLSQL block, Assigning Values to Collection Variables 7 MB ,4:53 MIN , THEORY + PRACTICAL


32x32

Chapter 1 : Collections and Records
Topic : Collection Methods
Content : Collection Methods - Extend, trim, delete, prior, next, exists, count, limit, first and Last 49 MB ,26:11 MIN , THEORY + PRACTICAL


32x32

Chapter 1 : Collections and Records
Topic : Records
Content : Using Record type in PL/SQL, Record Variables, Assigning Values to Record Variables. 6 MB ,3:49 MIN , THEORY + PRACTICAL


32x32

Chapter 2 : Error Handling
Topic : Error Handling - Exception Handling
Content : Compile-Time Warnings, Overview of Exception Handling, Internally Defined Exceptions, Predefined Exceptions, User-Defined Exceptions, Redeclared Predefined Exceptions, Raising Exceptions Explicitly, Exception Propagation, Unhandled Exceptions, Error-Reporting Functions - SQLCODE, SQLERRM 71 MB ,39:15 MIN , THEORY + PRACTICAL


32x32

Chapter 2 : Error Handling
Topic : Error Handling
Content : Re-raising the exception 0 MB ,0:26 MIN , THEORY + PRACTICAL


32x32

Chapter 4 : Static and Dynamic SQL
Topic : Static SQL - Introduction
Content : Static SQL - Introduction 13 MB ,7:0 MIN , THEORY


32x32

Chapter 4 : Static and Dynamic SQL
Topic : Static SQL - Cursors
Content : Static SQL - Cursors, Introduction & Attributes 11 MB ,6:49 MIN , THEORY + PRACTICAL


32x32

Chapter 4 : Static and Dynamic SQL
Topic : Static SQL - Cursor Variables
Content : Static SQL - Cursor Variables, Fetching data with Cursor variables 7 MB ,4:40 MIN , THEORY + PRACTICAL


32x32

Chapter 4 : Static and Dynamic SQL
Topic : Static SQL - Cursor Expressions
Content : Static SQL - Cursor Expressions 9 MB ,4:16 MIN , THEORY + PRACTICAL


32x32

Chapter 4 : Static and Dynamic SQL
Topic : Static SQL - Transaction Processing and Control
Content : Transaction Processing and Control, Commit, Rollback and Save-point 19 MB ,10:31 MIN , THEORY + PRACTICAL


32x32

Chapter 4 : Static and Dynamic SQL
Topic : Static SQL - Autonomous Transactions
Content : Autonomous Transactions 32 MB ,18:4 MIN , THEORY + PRACTICAL


32x32

Chapter 4 : Static and Dynamic SQL
Topic : Static SQL - Processing Query Result Sets
Content : Static SQL - Processing Query Result Sets 15 MB ,8:49 MIN , THEORY


32x32

Chapter 3 : Cursors
Topic : Cursors
Content : Overview of Cursor, Types of cursors, Invalid cursor Exception 43 MB ,24:22 MIN , THEORY + PRACTICAL


32x32

Chapter 1 : Triggers
Topic : Triggers
Content : Overview of Triggers, implementing triggers ?¢?? creating triggers, Insert, delete, and update triggers, viewing, deleting, and modifying triggers 46 MB ,26:3 MIN , THEORY + PRACTICAL


32x32

Chapter 3 : Transaction Management
Topic : Transaction Management - Two-phase Commit Protocol
Content : Two-phase Commit Protocol 13 MB ,7:25 MIN , THEORY


32x32

Chapter 3 : Transaction Management
Topic : Transaction Management - ACID properties
Content : Transaction Management - ACID properties 18 MB ,10:28 MIN , THEORY


32x32

Chapter 3 : Transaction Management
Topic : Transaction Management - Lost Update Problem
Content : Transaction Management - Lost Update Problem 6 MB ,3:58 MIN , THEORY


32x32

Chapter 3 : Transaction Management
Topic : Concurrency Control
Content : Concurrency Control 14 MB ,7:51 MIN , THEORY


32x32

Chapter 3 : Transaction Management
Topic : Transaction Management - ACID properties
Content : Transaction Management - ACID properties 18 MB ,10:28 MIN , THEORY


32x32

Chapter 3 : Transaction Management
Topic : Lock Management - Lock Based Protocols
Content : Lock Management - Lock Based Protocols, Locking methods Lock Granularity Lock Type - Binary Locking, Shared and Exclusive Locking, Lock based Protocol, Two phase Locking protocol Deadlock 30 MB ,15:31 MIN , THEORY


32x32

Chapter 3 : Transaction Management
Topic : Deadlocks Handling
Content : Deadlocks Handling 18 MB ,10:27 MIN , THEORY


32x32

Chapter 3 : Transaction Management
Topic : Two Phase Locking protocol
Content : Two Phase Locking protocol 20 MB ,11:57 MIN , THEORY


32x32

Chapter 4 : Crash recovery
Topic : Crash Recovery
Content : Crash Recovery, Recovery and atomicity, Log Based Recovery, Recovery with Concurrent transactions 35 MB ,18:24 MIN , THEORY


32x32

Chapter 4 : Crash recovery
Topic : Crash Recovery - ARIES algorithm
Content : Crash Recovery - ARIES algorithm 45 MB ,26:41 MIN , THEORY


32x32

Chapter 4 : Crash recovery
Topic : Crash Recovery - recovery related structures like transaction and dirty page table
Content : recovery related structures like transaction and dirty page table 22 MB ,12:28 MIN , THEORY


32x32

Chapter 4 : Crash recovery
Topic : Write-ahead log protocol
Content : Write-ahead log protocol 11 MB ,6:8 MIN , THEORY


32x32

Chapter 4 : Crash recovery
Topic : Data Recovery
Content : Crash Recovery, Failure Classification, Recovery and Atomicity, Log-based Recovery, Recovery with Concurrent Transactions, Check points, Recovery 31 MB ,18:24 MIN , THEORY


32x32

Chapter 2 : Packages
Topic : Packages
Content : Overview of a Package. Need of Packages, Package Specification, Package Body, Package Instantiation and Initialization. 68 MB ,38:36 MIN , THEORY


The Shikshak App

The Shikshak App is an honest attempt to provide quality education.

https://play.google.com/store/apps/details?id=com.weit.theshikshak&hl=en_IN