Pluralsight com Oracle PL SQL Fundamentals Part | D60683650E205EEA45E8FC5086F5EB7D6BD2E105

Pluralsight com Oracle PL SQL Fundamentals Part

Name	[pluralsight.com] Oracle PL_SQL Fundamentals - Part 2	DOWNLOAD Copy Link
Total Size	676.9 MB
Total Files	172
Hash	D60683650E205EEA45E8FC5086F5EB7D6BD2E105

/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
/07. Package Body/
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_09-Demo Compiling & Executing Packages.mp4	39.3 MB
07_10-Demo Stateful & Stateless Packages.mp4	17.6 MB
07_11-Summary.mp4	1.6 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/
1-oracle-plsql-part2-m1-slides.pdf	114.9 KB
2-oracle-plsql-part2-m2-slides.pdf	165.9 KB
3-oracle-plsql-part2-m3-slides.pdf	160.8 KB
4-oracle-plsql-part2-m4-slides.pdf	203.7 KB
5-oracle-plsql-part2-m5-slides.pdf	178.1 KB
6-oracle-plsql-part2-m6-slides.pdf	172.8 KB
7-oracle-plsql-part2-m7-slides.pdf	211.6 KB
8-oracle-plsql-part2-m8-slides.pdf	203.8 KB
9-oracle-plsql-part2-m9-slides.pdf	188.8 KB
/.../2-oracle-plsql-part2-m2-exercise-files/After/
oracle-plsql-fundamentals-m5-cursors-drop.txt	0.0 KB
/.../2-oracle-plsql-part2-m2-exercise-files/Before/
oracle-plsql-fundamentals-m2-create.txt	1.0 KB
/.../2-oracle-plsql-part2-m2-exercise-files/
oracle-plsql-fundamentals2-module2-procedure-demo1-1.sql	0.4 KB
oracle-plsql-fundamentals2-module2-procedure-demo1-2.sql	0.3 KB
oracle-plsql-fundamentals2-module2-procedure-demo1-3.sql	0.2 KB
oracle-plsql-fundamentals2-module2-procedure-demo2_execute-1.sql	0.4 KB
oracle-plsql-fundamentals2-module2-procedure-demo2_execute-2.sql	0.1 KB
Setup.txt	0.3 KB
/.../3-oracle-plsql-part2-m3-exercise-files/After/
oracle-plsql-fundamentals-m5-cursors-drop.txt	0.0 KB
/.../3-oracle-plsql-part2-m3-exercise-files/Before/
oracle-plsql-fundamentals-m2-create.txt	1.0 KB
/.../3-oracle-plsql-part2-m3-exercise-files/
oracle-plsql-fundamentals-part2-functiondemo.txt	0.6 KB
oracle-plsql-fundamentals-part2-functiondemo2.txt	0.2 KB
Setup.txt	0.3 KB
/.../4-oracle-plsql-part2-m4-exercise-files/After/
drop.txt	0.1 KB
/.../4-oracle-plsql-part2-m4-exercise-files/Before/
create.txt	1.0 KB
/.../4-oracle-plsql-part2-m4-exercise-files/
oracle-plsql-fundamentals-m4-parameters-demo1-1.txt	1.0 KB
oracle-plsql-fundamentals-m4-parameters-demo1-2.txt	0.7 KB
oracle-plsql-fundamentals-m4-parameters-demo2-1.txt	0.9 KB
oracle-plsql-fundamentals-m4-parameters-demo2-2.txt	0.1 KB
oracle-plsql-fundamentals-m4-parameters-demo2-3.txt	0.2 KB
oracle-plsql-fundamentals-m4-parameters-demo2-4.txt	0.1 KB
oracle-plsql-fundamentals-m4-parameters-demo2-5.txt	0.2 KB
Setup.txt	0.3 KB
/.../5-oracle-plsql-part2-m5-exercise-files/After/
drop.txt	0.1 KB
/.../5-oracle-plsql-part2-m5-exercise-files/Before/
create.txt	1.0 KB
/.../5-oracle-plsql-part2-m5-exercise-files/
oracle-plsql-fundamentals-m5-localsubprogram_exception_scope_visibility-demo2-1.txt	0.9 KB
oracle-plsql-fundamentals-m5-localsubprogram_exception_scope_visibility-demo2-2.txt	0.0 KB
oracle-plsql-fundamentals-m5-localsubprogrma_demo1-1.txt	0.8 KB
oracle-plsql-fundamentals-m5-localsubprogrma_demo1-2.txt	0.0 KB
Setup.txt	0.3 KB
/.../6-oracle-plsql-part2-m6-exercise-files/After/
drop.txt	0.0 KB
/.../6-oracle-plsql-part2-m6-exercise-files/Before/
create.txt	1.0 KB
/.../6-oracle-plsql-part2-m6-exercise-files/
oracle-plsql-fundamentals-part2-m6-demo1-1.txt	0.6 KB
oracle-plsql-fundamentals-part2-m6-demo1-2.txt	0.3 KB
oracle-plsql-fundamentals-part2-m6-demo1-3.txt	0.6 KB
oracle-plsql-fundamentals-part2-m6-demo1-4.txt	0.0 KB
Setup.txt	0.3 KB
/.../7-oracle-plsql-part2-m7-exercise-files/After/
drop.txt	0.0 KB
/.../7-oracle-plsql-part2-m7-exercise-files/Before/
create.txt	1.0 KB
/.../7-oracle-plsql-part2-m7-exercise-files/
oracle-plsql-fundamentals-part2-m7-packagesbody-demo1-1.txt	3.2 KB
oracle-plsql-fundamentals-part2-m7-packagesbody-demo1-2.txt	0.5 KB
oracle-plsql-fundamentals-part2-m7-packagesbody-demo1-3.txt	2.5 KB
oracle-plsql-fundamentals-part2-m7-packagesbody-demo1-4.txt	0.2 KB
oracle-plsql-fundamentals-part2-m7-packagesbody-demo1-5.txt	0.4 KB
oracle-plsql-fundamentals-part2-m7-packagesbody-demo1-6.txt	0.5 KB
oracle-plsql-fundamentals-part2-m7-packagesbody-demo1-7.txt	0.5 KB
oracle-plsql-fundamentals-part2-m7-packagesbody-demo1-8.txt	2.4 KB
oracle-plsql-fundamentals-part2-m7-packagesbody-demo1-9.txt	0.1 KB
Setup.txt	0.3 KB
/.../8-oracle-plsql-part2-m8-exercise-files/After/
.DS_Store	6.1 KB
drop.txt	0.1 KB
/.../8-oracle-plsql-part2-m8-exercise-files/Before/
create.txt	1.0 KB
/.../8-oracle-plsql-part2-m8-exercise-files/
oracle-plsql-fundamentals-part2-m8-demo1-1.txt	0.6 KB
oracle-plsql-fundamentals-part2-m8-demo1-2.txt	0.0 KB
oracle-plsql-fundamentals-part2-m8-demo1-3.txt	0.1 KB
oracle-plsql-fundamentals-part2-m8-demo1-4.txt	0.2 KB
oracle-plsql-fundamentals-part2-m8-demo1-5.txt	0.6 KB
oracle-plsql-fundamentals-part2-m8-demo1-6.txt	0.9 KB
oracle-plsql-fundamentals-part2-m8-demo2-1.txt	0.6 KB
oracle-plsql-fundamentals-part2-m8-demo2-2.txt	0.6 KB
oracle-plsql-fundamentals-part2-m8-demo2-3.txt	0.8 KB
Setup.txt	0.3 KB
/.../9-oracle-plsql-part2-m9-exercise-files/After/
.DS_Store	6.1 KB
drop.txt	0.3 KB
/.../9-oracle-plsql-part2-m9-exercise-files/Before/
create.txt	1.0 KB
/.../9-oracle-plsql-part2-m9-exercise-files/
oracle-plsql-fundamentals-part2-m9-demo1-1.txt	0.5 KB
oracle-plsql-fundamentals-part2-m9-demo1-2.txt	0.3 KB
oracle-plsql-fundamentals-part2-m9-demo1-3.txt	0.1 KB
oracle-plsql-fundamentals-part2-m9-demo1-4.txt	0.2 KB
oracle-plsql-fundamentals-part2-m9-demo1-5.txt	0.2 KB
oracle-plsql-fundamentals-part2-m9-demo2-1.txt	1.0 KB
oracle-plsql-fundamentals-part2-m9-demo2-10.txt	1.0 KB
oracle-plsql-fundamentals-part2-m9-demo2-11.txt	0.2 KB
oracle-plsql-fundamentals-part2-m9-demo2-2.txt	0.3 KB
oracle-plsql-fundamentals-part2-m9-demo2-3a.txt	1.0 KB
oracle-plsql-fundamentals-part2-m9-demo2-3b.txt	0.4 KB
oracle-plsql-fundamentals-part2-m9-demo2-4.txt	0.2 KB
oracle-plsql-fundamentals-part2-m9-demo2-5.txt	0.4 KB
oracle-plsql-fundamentals-part2-m9-demo2-6.txt	0.2 KB
oracle-plsql-fundamentals-part2-m9-demo2-7.txt	0.2 KB
oracle-plsql-fundamentals-part2-m9-demo2-8.txt	0.7 KB
oracle-plsql-fundamentals-part2-m9-demo2-9.txt	0.2 KB
oracle-plsql-fundamentals-part2-m9-demo3-1.txt	0.2 KB
oracle-plsql-fundamentals-part2-m9-demo3-2.txt	0.7 KB
oracle-plsql-fundamentals-part2-m9-demo3-3.txt	0.1 KB
oracle-plsql-fundamentals-part2-m9-demo3-4.txt	0.2 KB
oracle-plsql-fundamentals-part2-m9-demo3-5.txt	0.1 KB
oracle-plsql-fundamentals-part2-m9-demo3-6.txt	0.1 KB
Setup.txt	0.3 KB
Total files 172