Pluralsight Oracle PL SQL Fundamentals Part | AAFCC710D68E575A419F4807D159C653CA7905A8

Pluralsight Oracle PL SQL Fundamentals Part

Name	Pluralsight Oracle PL-SQL Fundamentals Part 2	DOWNLOAD Copy Link
Total Size	676.7 MB
Total Files	75
Hash	AAFCC710D68E575A419F4807D159C653CA7905A8

/07. Package Body/
07_09-Demo Compiling & Executing Packages.mp4	39.3 MB
07_01-Introduction.mp4	1.3 MB
07_02-Defining Package Body.mp4	19.3 MB
07_03-Package Initialization.mp4	5.8 MB
07_04-Compiling & Executing Package Body.mp4	4.6 MB
07_05-Order of Subprograms & Forward Declaration.mp4	3.4 MB
07_06-Stateful & Stateless Packages.mp4	6.5 MB
07_07-Overloading Subprograms.mp4	16.7 MB
07_08-Overloading Considerations.mp4	8.4 MB
07_10-Demo Stateful & Stateless Packages.mp4	17.6 MB
07_11-Summary.mp4	1.6 MB
/01. Overview/
01_01-Overview.mp4	3.8 MB
01_02-Benefits of Named Program Units.mp4	2.6 MB
01_03-Prerequisites.mp4	1.1 MB
01_04-Audience.mp4	1.3 MB
01_05-Tools.mp4	2.1 MB
/02. Procedures/
02_01-What is a Procedure.mp4	4.8 MB
02_02-Defining Procedures.mp4	7.4 MB
02_03-Compiling Procedures & Native Compilation.mp4	5.5 MB
02_04-PLSQL_OPTIMIZE_LEVEL & Compile for Debug.mp4	5.6 MB
02_05-Errors and Warnings.mp4	10.5 MB
02_06-Demo Creating & Compiling Procedures, Errors and Warnings.mp4	32.9 MB
02_07-Executing Dropping & Terminating Procedures.mp4	3.9 MB
02_08-Demo Executing Dropping & Terminating Procedures.mp4	12.3 MB
02_09-Summary.mp4	1.5 MB
/03. Functions/
03_01-What is a Function.mp4	2.8 MB
03_02-Oracle Provided Functions.mp4	5.7 MB
03_03-Defining Functions.mp4	9.6 MB
03_04-Compiling & Executing Functions.mp4	12.7 MB
03_05-Dropping & Terminating Functions.mp4	7.4 MB
03_06-Demo.mp4	29.4 MB
03_07-Summary.mp4	1.0 MB
/04. Parameters in Procedures & Functions/
04_01-Introduction.mp4	2.4 MB
04_02-Formal vs. Actual Parameters.mp4	9.1 MB
04_03-Parameter Modes.mp4	19.5 MB
04_04-Passing by Reference & Value.mp4	10.2 MB
04_05-NOCOPY hint.mp4	6.3 MB
04_06-DemoParameter Modes & NOCOPY.mp4	22.6 MB
04_07-Positional, Named & Mixed Notation.mp4	8.6 MB
04_08-Default Values & Constraints on Formal Parameters.mp4	3.0 MB
04_09-Demo Default Values, Positional & Named Notations.mp4	13.1 MB
04_10-Summary.mp4	1.8 MB
/05. Local Subprograms/
05_01-Introduction.mp4	4.9 MB
05_02-Defining Local Subprograms.mp4	6.9 MB
05_03-Demo Local Subprograms.mp4	7.6 MB
05_04-Exceptions, Scope & Visibility of Variables.mp4	11.7 MB
05_05-Demo Exceptions, Scope & Visibility of Variables.mp4	14.8 MB
05_06-Summary.mp4	858.5 KB
/06. Package Specification/
06_01-Introduction.mp4	2.5 MB
06_02-Why Use Package Specifications.mp4	6.2 MB
06_03-Package Structure & Contents.mp4	3.9 MB
06_04-Defining Package Specification.mp4	10.9 MB
06_05-Compiling Package Specification.mp4	4.3 MB
06_06-Executing & Dropping Package Specification.mp4	5.5 MB
06_07-Global Variables & Session State.mp4	2.2 MB
06_08-Demo.mp4	24.9 MB
06_09-Summary.mp4	1.2 MB
/08. Calling Functions from SQL/
08_01-Where Can They Be Called.mp4	6.0 MB
08_02-Restrictions.mp4	9.8 MB
08_03-Demo Functions in SQL Statements.mp4	20.5 MB
08_04-Deterministic.mp4	9.8 MB
08_05-Parallel Enable.mp4	5.7 MB
08_06-Demo Deterministic Functions.mp4	9.6 MB
08_07-Pragma Restrict References.mp4	5.0 MB
08_08-Summary.mp4	1.7 MB
/09. Roles & Privileges With Subprograms/
09_01-Subprogram Resolution.mp4	9.0 MB
09_02-Demo Subprogram Resolution.mp4	11.4 MB
09_03-AUTHID DEFINER.mp4	14.2 MB
09_04-AUTHID CURRENT_USER.mp4	17.1 MB
09_05-Execution Flow Between Invoker & Executor.mp4	12.6 MB
09_06-Demo AUTHID Clause & Execution Flow.mp4	32.3 MB
09_07-Direct Grants vs. Roles.mp4	16.1 MB
09_08-Demo Direct Grants vs. Roles.mp4	330.9 KB
09_09-Summary.mp4	1.3 MB
/Exercise files/
oracle-plsql-fundamentals-part2.zip	1.4 MB
Total files 75