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