NEW Oracle PLSQL-An Ultimate Bootcamp-21c

[0dayddl]

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

RapidGator

Contenido oculto. Ha de estar registrado, y pulsar el botón "Gracias" para visualizar sus enlaces de descarga.
Si trás registrarse todavía no visualiza el botón de "gracias", pulse la tecla F5, para refrescar la página.

NitroFlare

Contenido oculto. Ha de estar registrado, y pulsar el botón "Gracias" para visualizar sus enlaces de descarga.
Si trás registrarse todavía no visualiza el botón de "gracias", pulse la tecla F5, para refrescar la página.