7.11 GB | 29min 53s | mp4 | 1280X720 | 16:9
Genre:eLearning |Language:English

Files Included :
1 PLSQL Overview.mp4 (23.82 MB)
2 Course Structure and How to Maximize Its Benefits.mp4 (36.35 MB)
3 Message From Trainer.mp4 (25 MB)
1 Understand Stored Procedures and Functions.mp4 (27.55 MB)
10 Recap.mp4 (9.5 MB)
2 Create a Simple Procedure.mp4 (29.05 MB)
3 Execute a Simple Procedure.mp4 (27.36 MB)
4 Create a Simple Procedure with IN parameter.mp4 (76.53 MB)
5 Create a Simple Function.mp4 (35.38 MB)
6 Execute a Simple Function.mp4 (42.57 MB)
7 Create a Simple Function with IN parameter.mp4 (62.35 MB)
8 Demo & Assignment - 08.mp4 (10.81 MB)
9 Solution - 08.mp4 (38.6 MB)
1 Procedure Parameters Modes (IN OUT IN OUT).mp4 (84.97 MB)
2 Create a Modularized and Layered Subprogram Design.mp4 (116.78 MB)
3 DROP and CREATE OR REPLACE Command.mp4 (67.4 MB)
4 View Procedures Information Using the Data Dictionary Views.mp4 (140.52 MB)
5 Lab & Assignment - 09.mp4 (7.38 MB)
6 Solution - 09.mp4 (28.13 MB)
7 Recap - 09.mp4 (9.97 MB)
1 DROP Stored Function Using Commands.mp4 (7.68 MB)
2 Context switch in User-Defined Functions in SQL Statements.mp4 (14.52 MB)
3 Restrictions when calling Functions from SQL statements.mp4 (63.63 MB)
4 View Functions Information.mp4 (37.63 MB)
5 Assignments - 10.mp4 (5.17 MB)
6 Solution - 10.mp4 (36.81 MB)
7 Recap.mp4 (8.72 MB)
1 Describe Packages.mp4 (21.26 MB)
10 Recap.mp4 (9.66 MB)
2 List the components of a Package.mp4 (26.3 MB)
3 Develop a Package.mp4 (48.61 MB)
4 Scope of Package Constructs.mp4 (99.91 MB)
5 Invoke Package Constructs.mp4 (17.71 MB)
6 View PLSQL Source Code Using the Data Dictionary.mp4 (89.02 MB)
7 Identity the advantages of Packages.mp4 (49.27 MB)
8 Assignment - 11.mp4 (11.94 MB)
9 Solution - 11.mp4 (35.83 MB)
1 What are Oracle-Supplied Packages.mp4 (24.44 MB)
2 DBMS OUTPUT Package to write to buffer.mp4 (8.72 MB)
3 UTL FILE Package to Interact With Operating System Files.mp4 (74.6 MB)
4 UTL CRYPTO Package to encrypt & decrypt data.mp4 (49.43 MB)
5 UTL MAIL Package to send mail.mp4 (46.04 MB)
6 Assignments - 12.mp4 (12.08 MB)
7 Solution - 12.mp4 (46.88 MB)
8 Recap.mp4 (3.37 MB)
1 Describe Triggers.mp4 (10.87 MB)
10 Create a Database Trigger.mp4 (43.22 MB)
11 How to Manage, Test, disable and Remove Triggers.mp4 (100.74 MB)
12 Business Application Scenarios for Implementing Triggers.mp4 (41.08 MB)
13 Assignment - 13.mp4 (6.11 MB)
14 Solution - 13.mp4 (29.17 MB)
15 Recap.mp4 (6.96 MB)
2 Create a DML Trigger.mp4 (50.45 MB)
3 Triggers classification based upon Events.mp4 (17.61 MB)
4 Conditional Predicates (INSERTING DELETING UPDATING).mp4 (64.77 MB)
5 Row Level & Statement level Triggers.mp4 (34.82 MB)
6 Before and After Triggers.mp4 (32.84 MB)
7 Correlation Names and Pseudorecords (NEW and OLD).mp4 (74.51 MB)
8 Create Instead of Triggers.mp4 (56.41 MB)
9 Create a DDL Trigger.mp4 (84.69 MB)
1 Execution Order in Triggers - Follow Clause.mp4 (36.62 MB)
2 Compound Triggers.mp4 (35.1 MB)
3 Compound Trigger to Resolve the Mutating Table Error.mp4 (104.38 MB)
4 System Privileges Required to Manage Triggers.mp4 (10.55 MB)
5 Assignment - 14.mp4 (13.38 MB)
6 Solution - 14.mp4 (68.11 MB)
7 Recap.mp4 (12.34 MB)
1 Use PLSQL Records.mp4 (49.35 MB)
10 Recap.mp4 (11.59 MB)
2 The %ROWTYPE Attribute.mp4 (19.3 MB)
3 Insert and Update with PLSQL Records.mp4 (60.1 MB)
4 Collection - A composite data types.mp4 (56.48 MB)
5 Associative Arrays (INDEX BY Tables).mp4 (51.96 MB)
6 Nested Tables Collections.mp4 (61.18 MB)
7 Varray Collections.mp4 (29.02 MB)
8 Assignment - 15.mp4 (14.81 MB)
9 Solution - 15.mp4 (55.76 MB)
1 The Execution Flow of SQL.mp4 (29.86 MB)
10 Recap.mp4 (6.35 MB)
2 What is Dynamic SQL.mp4 (31.6 MB)
3 Declare Cursor Variables.mp4 (34.48 MB)
4 Dynamically executing a PLSQL Block.mp4 (26.26 MB)
5 Native Dynamic SQL to Compile PLSQL Code.mp4 (36.54 MB)
6 Invoke DBMS SQL Package.mp4 (38.12 MB)
7 Implement DBMS SQL with a Parameterized DML Statement.mp4 (30.05 MB)
8 Assignment - 16.mp4 (9.33 MB)
9 Solution - 16.mp4 (24.91 MB)
1 Overloading Subprograms in PLSQL.mp4 (62.93 MB)
2 Use Forward Declarations to Solve illegal Procedure Reference.mp4 (41.54 MB)
3 Persistent State of Packages Variables.mp4 (113.33 MB)
4 Persistent State of a Package Cursor.mp4 (22.65 MB)
5 Assignment - 17.mp4 (4.19 MB)
6 Solution - 17.mp4 (25.49 MB)
7 Recap.mp4 (3.07 MB)
1 Live SQL cloud account creation, demo data setup.mp4 (68.9 MB)
2 Oracle 21c - XE Installation.mp4 (90.18 MB)
3 Multitenant Architecture overview.mp4 (90.32 MB)
4 Create PDB, Schema user, Connect to 21C from Oracle SQL Developer.mp4 (173.64 MB)
1 Overview of Schema Object Dependencies.mp4 (24.26 MB)
10 Recap.mp4 (10.43 MB)
2 Object Dependencies using the USER DEPENDENCIES View.mp4 (42.08 MB)
3 Query an Object's Status.mp4 (36.73 MB)
4 Invalidation of Dependent Objects.mp4 (59.2 MB)
5 Display the Direct and Indirect Dependencies.mp4 (61.86 MB)
6 Understand Remote Dependencies.mp4 (64.31 MB)
7 Recompile a PLSQL Program Unit.mp4 (79.16 MB)
8 Assignment - 18.mp4 (6.29 MB)
9 Solution - 18.mp4 (45.17 MB)
1 What is a Table function.mp4 (30.38 MB)
2 What is pipeline function.mp4 (19.65 MB)
3 Create a pipeline function.mp4 (22.14 MB)
4 Check PGA memory consumption pipeline functions.mp4 (60.09 MB)
5 Error handling in pipeline functions.mp4 (16 MB)
6 Assignment - 19.mp4 (3.47 MB)
7 Solution - 19.mp4 (33.35 MB)
8 Recap.mp4 (12.63 MB)
1 Create a Simple Anonymous Block.mp4 (37.87 MB)
2 Overview of the Types of PLSQL blocks.mp4 (6.79 MB)
3 Generate Output from a PLSQL Block.mp4 (32.73 MB)
4 Lab & Assignment - 01.mp4 (47.19 MB)
5 Solution - 01.mp4 (39.42 MB)
6 Recap.mp4 (10.39 MB)
1 List the different Types of Identifiers in a PLSQL subprogram.mp4 (56.86 MB)
10 Recap.mp4 (21.88 MB)
2 Usage of the Declarative Section to define Identifiers.mp4 (21.59 MB)
3 Use variables to store data.mp4 (41.2 MB)
4 Identify Scalar Data Types.mp4 (31.68 MB)
5 The %TYPE and %ROWTYPE Attribute.mp4 (56.73 MB)
6 What are Bind Variables.mp4 (39.01 MB)
7 Sequences in PLSQL Expressions.mp4 (17.85 MB)
8 Lab & Assignment - 02.mp4 (70.51 MB)
9 Solution - 02.mp4 (50.26 MB)
1 Describe Basic PLSQL Block Syntax Guidelines.mp4 (21.98 MB)
2 Comment Code.mp4 (19.65 MB)
3 Deployment of SQL Functions in PLSQL.mp4 (40.23 MB)
4 How to convert Data Types.mp4 (33.81 MB)
5 Nested Blocks.mp4 (14.33 MB)
6 Identify the Operators in PLSQL.mp4 (66.15 MB)
7 Assignment - 03.mp4 (5.28 MB)
8 Solution - 03.mp4 (27.65 MB)
9 Recap.mp4 (12.69 MB)
1 Invoke SELECT Statements in PLSQL to Retrieve data.mp4 (15.88 MB)
2 Data Manipulation in the Server Using PLSQL.mp4 (48.91 MB)
3 SQL Cursor concept.mp4 (20.22 MB)
4 Usage of SQL Cursor Attributes to Obtain Feedback on DML.mp4 (63.87 MB)
5 Save and Discard Transactions.mp4 (47.24 MB)
6 Assignment - 04.mp4 (8.19 MB)
7 Solution - 04.mp4 (31.06 MB)
8 Recap.mp4 (16.91 MB)
1 Conditional processing Using IF Statements.mp4 (67.06 MB)
10 Assignment - 05.mp4 (5.74 MB)
11 Solution - 05.mp4 (33.88 MB)
12 Recap.mp4 (12.31 MB)
2 Conditional processing Using CASE Statements.mp4 (29.78 MB)
3 Use simple Loop Statement.mp4 (24.59 MB)
4 Use While Loop Statement.mp4 (17.66 MB)
5 Use For Loop - Part I.mp4 (20.39 MB)
6 Use For Loop - Part II.mp4 (44.36 MB)
7 Describe the Continue Statement.mp4 (19.56 MB)
8 GO TO statement.mp4 (51.3 MB)
9 NULL Statement.mp4 (47.84 MB)
1 What are Explicit Cursors.mp4 (43.62 MB)
2 Open the Cursor, Fetch a Cursor data, Close a Cursor.mp4 (102.8 MB)
3 Cursor FOR loop.mp4 (30.34 MB)
4 Explicit Cursor Attributes.mp4 (125.26 MB)
5 FOR UPDATE Clause and WHERE CURRENT Clause.mp4 (113.49 MB)
6 Assignment - 06.mp4 (10.72 MB)
7 Solution - 06.mp4 (52.13 MB)
8 Recap.mp4 (18.43 MB)
1 Understand Exceptions.mp4 (19.33 MB)
10 Solution - 07.mp4 (40.84 MB)
11 Recap.mp4 (27.59 MB)
2 Handle Exceptions with PLSQL.mp4 (66.83 MB)
3 Trap Predefined Oracle Server Errors.mp4 (42.13 MB)
4 Trap Non-Predefined Oracle Server Errors.mp4 (111.1 MB)
5 User-Defined Exceptions - Part I.mp4 (76.17 MB)
6 User-Defined Exceptions - Part II (RAISE APPLICATION ERROR).mp4 (68.44 MB)
7 Propagate Exceptions.mp4 (69.79 MB)
8 Demo - Live Project.mp4 (119.15 MB)
9 Assignment - 07.mp4 (6.24 MB)]
Screenshot