FreeCourseLab com Udemy The Complete PLSQL Bootcamp Beginner to Advanced PLSQL

FreeCourseLab com Udemy The Complete PLSQL Bootcamp Beginner to Advanced PLSQL

Name	[FreeCourseLab.com] Udemy - The Complete PLSQL Bootcamp Beginner to Advanced PLSQL	DOWNLOAD Copy Link
Total Size	5.9 GB
Total Files	272
Hash	4065082689BBCABFC2B22A5022C26B39B8298E08

/1. What is PLSQL/
1. Course Introductory Video.mp4	12.2 MB
1. Course Introductory Video.vtt	4.4 KB
2. UDEMY 101 How to Use Udemy +Some Useful Tips.mp4	53.1 MB
2. UDEMY 101 How to Use Udemy +Some Useful Tips.vtt	5.5 KB
3. What is PLSQL and Why to Use.mp4	10.9 MB
3. What is PLSQL and Why to Use.vtt	7.5 KB
4. PLSQL Architecture.mp4	39.1 MB
4. PLSQL Architecture.vtt	39.1 MB
5. The Sample (HR) Schema Used in This Course.mp4	78.1 MB
5. The Sample (HR) Schema Used in This Course.vtt	8.2 KB
6. Bonus Materials Course Material & PLSQL Cheatsheet.html	1.1 KB
6.1 PL SQL Cheatsheet.pdf.pdf	59.8 KB
6.2 PL&SQL.pdf.pdf	5.5 MB
7. Quiz 1.html	0.2 KB
/10. PLSQL Functions & Procedures/
1. What are Functions & Procedures and Why We Use.mp4	105.5 MB
1. What are Functions & Procedures and Why We Use.vtt	20.2 KB
10. Creating and Using Functions (Part 2).mp4	83.8 MB
10. Creating and Using Functions (Part 2).vtt	17.8 KB
11. Creating and Using PLSQL Functions (Code Samples).html	0.9 KB
12. Local Subprograms.mp4	120.6 MB
12. Local Subprograms.vtt	27.3 KB
13. Local Subprograms (Code Samples).html	2.1 KB
14. Overloading the Subprograms.mp4	140.0 MB
14. Overloading the Subprograms.vtt	26.3 KB
15. Overloading the Subprograms (Code Samples).html	2.0 KB
16. Handling the Exceptions in Subprograms.mp4	128.0 MB
16. Handling the Exceptions in Subprograms.vtt	36.0 KB
17. Handling the Exceptions in Subprograms (Code Samples).html	2.1 KB
18. Finding & Removing the Subprograms.mp4	82.6 MB
18. Finding & Removing the Subprograms.vtt	20.9 KB
19. Regular & Pipelined Table Functions.mp4	100.3 MB
19. Regular & Pipelined Table Functions.vtt	32.7 KB
2. What are Functions & Procedures and Why We Use (Code Samples).html	1.7 KB
20. Regular & Pipelined Table Functions (Code Samples).html	1.3 KB
3. Creating and Using Stored Procedures.mp4	165.5 MB
3. Creating and Using Stored Procedures.vtt	34.9 KB
4. Creating and Using Stored Procedures (Code Samples).html	2.2 KB
5. Using IN & OUT Parameters.mp4	91.6 MB
5. Using IN & OUT Parameters.vtt	25.4 KB
6. Using IN & OUT Parameters (Code Samples).html	2.7 KB
7. Named & Mixed Notations and Default Option.mp4	105.4 MB
7. Named & Mixed Notations and Default Option.vtt	30.3 KB
8. Named & Mixed Notations and Default Option (Code Samples).html	1.3 KB
9. Creating and Using Functions (Part 1).mp4	134.0 MB
9. Creating and Using Functions (Part 1).vtt	33.0 KB
/11. PLSQL Packages/
1. What Are Packages.mp4	121.5 MB
1. What Are Packages.vtt	19.4 KB
10. Persistent State of Packages (Code Samples).html	1.5 KB
11. Using Collections in Packages - Part 1.mp4	169.9 MB
11. Using Collections in Packages - Part 1.vtt	43.8 KB
12. Using Collections in Packages - Part 2.mp4	84.2 MB
12. Using Collections in Packages - Part 2.vtt	15.0 KB
13. Using Collections in Packages (Code Samples).html	3.9 KB
14. How Can I Find the Packages.mp4	50.9 MB
14. How Can I Find the Packages.vtt	13.6 KB
2. Creating & Using & Modifying & Removing the Packages.mp4	235.5 MB
2. Creating & Using & Modifying & Removing the Packages.vtt	48.4 KB
3. Creating & Using & Modifying & Removing the Packages (Code Samples).html	1.4 KB
4. Visibility of Package Objects.mp4	98.3 MB
4. Visibility of Package Objects.vtt	20.4 KB
5. Visibility of Package Objects (Code Samples).html	2.0 KB
6. Illegal Object Reference & Forward Declaration.mp4	54.5 MB
6. Illegal Object Reference & Forward Declaration.vtt	14.1 KB
7. Package Initialization.mp4	66.4 MB
7. Package Initialization.vtt	13.7 KB
8. Persistent State of Packages - Part 1.mp4	169.9 MB
8. Persistent State of Packages - Part 1.vtt	35.2 KB
9. Persistent State of Packages - Part 2.mp4	96.8 MB
9. Persistent State of Packages - Part 2.vtt	23.5 KB
/12. PLSQL Triggers/
1. What are Triggers & Trigger Types.mp4	115.7 MB
1. What are Triggers & Trigger Types.vtt	21.2 KB
10. Using Conditional Predicates (Code Samples).html	1.0 KB
11. Using RAISE_APPLICATION_ERROR Procedure in Triggers.mp4	31.6 MB
11. Using RAISE_APPLICATION_ERROR Procedure in Triggers.vtt	8.3 KB
12. Using RAISE_APPLICATION_ERROR Procedure in Triggers (Code Samples).html	1.2 KB
13. Using Update Of Event in Triggers.mp4	34.6 MB
13. Using Update Of Event in Triggers.vtt	11.8 KB
14. Using Update Of Event in Triggers (Code Samples).html	0.5 KB
15. Using WHEN Clause in Triggers.mp4	33.7 MB
15. Using WHEN Clause in Triggers.vtt	13.4 KB
16. Using When Clause in Triggers (Code Samples).html	0.5 KB
17. INSTEAD OF Triggers.mp4	135.2 MB
17. INSTEAD OF Triggers.vtt	33.7 KB
18. Instead of Triggers (Code Samples).html	1.5 KB
19. Exploring & Managing the Triggers.mp4	77.7 MB
19. Exploring & Managing the Triggers.vtt	17.1 KB
2. Understanding DML Triggers.mp4	135.5 MB
2. Understanding DML Triggers.vtt	24.7 KB
20. Creating Disabled Triggers.mp4	29.6 MB
20. Creating Disabled Triggers.vtt	11.6 KB
21. Creating Disabled Triggers (Code Samples).html	0.6 KB
22. Additional Real-World Examples for DML Triggers.mp4	87.4 MB
22. Additional Real-World Examples for DML Triggers.vtt	34.7 KB
23. Additional Real-World Examples for DML Triggers (Code Samples).html	2.0 KB
24. Compound Triggers.mp4	228.6 MB
24. Compound Triggers.vtt	49.7 KB
25. Compound Triggers (Code Samples).html	2.4 KB
26. Handling Mutating Table Errors.mp4	180.4 MB
26. Handling Mutating Table Errors.vtt	37.0 KB
27. Handling Mutating Table Errors (Code Samples).html	3.1 KB
3. Specifying the Timing of Triggers.mp4	146.8 MB
3. Specifying the Timing of Triggers.vtt	38.0 KB
4. Specifying the Timing of Triggers (Code Samples).html	0.7 KB
5. Statement & Row Level Triggers.mp4	85.0 MB
5. Statement & Row Level Triggers.vtt	26.3 KB
6. Statement & Row Level Triggers (Code Samples).html	1.5 KB
7. Using New & Old Qualifiers in Triggers.mp4	162.6 MB
7. Using New & Old Qualifiers in Triggers.vtt	34.4 KB
8. Using New & Old Qualifiers in Triggers (Code Samples).html	0.7 KB
9. Using Conditional Predicates.mp4	66.6 MB
9. Using Conditional Predicates.vtt	19.6 KB
/13. Debugging Your Code/
1. For Your Attention!...html	1.5 KB
2. On Production.html	0.0 KB
/14. Using PLSQL Objects/
1. On Production.html	0.0 KB
/15. Using PLSQL Compiler/
1. On Production.html	0.0 KB
/16. Using Large Objects(LOB) in PLSQL/
1. Thank you for your understanding...html	0.0 KB
/17. PLSQL Performance & Tuning/
1. On Production.html	0.0 KB
/18. Bonus (+) Section/
1. Bonus (+) Lecture Special Discounts for Our Students!.html	2.3 KB
1.1 Special Discounts For Our Students.xlsx.xlsx	36.1 KB
/2. Software Installation/
1. About the Installation.mp4	52.5 MB
1. About the Installation.vtt	4.7 KB
2. Which Option to Have a Database.mp4	88.2 MB
2. Which Option to Have a Database.vtt	12.1 KB
3. Option 1 Having The Database with Oracle VirtualBox.mp4	52.5 MB
3. Option 1 Having The Database with Oracle VirtualBox.vtt	11.6 KB
3.1 Step 2 Download Virtual Machine Image Link.html	0.1 KB
3.2 Linux Username and Password.txt.txt	0.2 KB
3.3 Step 1 Download Oracle Virtual Box.html	0.1 KB
3.4 (Optional) Download Oracle's Virtual Machine (12c Release 2).html	0.1 KB
4. Option 2 Downloading and Installing Oracle Database.mp4	20.8 MB
4. Option 2 Downloading and Installing Oracle Database.vtt	14.4 KB
4.1 Oracle's Official Website.html	0.1 KB
5. Configuring and Using SQL Developer.mp4	28.2 MB
5. Configuring and Using SQL Developer.vtt	10.1 KB
6. How to Unlock HR Schema in Oracle.html	3.0 KB
7. Option 3 Using Oracle Live SQL.mp4	45.0 MB
7. Option 3 Using Oracle Live SQL.vtt	7.6 KB
/3. Let's Start Coding!/
1. Anonymous Blocks.mp4	31.2 MB
1. Anonymous Blocks.vtt	14.8 KB
2. PLSQL Outputs.mp4	19.3 MB
2. PLSQL Outputs.vtt	8.4 KB
3. Quiz 2.html	0.2 KB
/4. PLSQL Variables/
1. What are Variables and Why to Use Them.mp4	22.6 MB
1. What are Variables and Why to Use Them.vtt	9.1 KB
10. PL SQL Variable Scope.mp4	23.2 MB
10. PL SQL Variable Scope.vtt	9.1 KB
11. PL SQL Variable Scope (Code Samples).html	0.8 KB
12. Using Bind Variables.mp4	21.1 MB
12. Using Bind Variables.vtt	8.7 KB
13. Using Bind Variables (Code Samples).html	0.6 KB
14. Quiz 3 - Variables.html	0.2 KB
2. Naming Rules & Naming Conventions.mp4	11.4 MB
2. Naming Rules & Naming Conventions.vtt	5.2 KB
3. Declaring & Initializing & Using Variables - Part 1.mp4	21.1 MB
3. Declaring & Initializing & Using Variables - Part 1.vtt	10.9 KB
4. Declaring & Initializing & Using Variables - Part 2.mp4	19.4 MB
4. Declaring & Initializing & Using Variables - Part 2.vtt	9.5 KB
5. Declaring & Initializing & Using Variables (Code Samples).html	1.3 KB
6. Using %TYPE Attribute.mp4	11.1 MB
6. Using %TYPE Attribute.vtt	11.1 MB
7. Using %Type Attribute (Code Samples).html	0.4 KB
8. PLSQL Delimiters and Commenting Your Code.mp4	8.4 MB
8. PLSQL Delimiters and Commenting Your Code.vtt	5.4 KB
9. PLSQL Delimiters and Commenting (Code Samples).html	0.4 KB
/5. Control Structures/
1. What are Control Structures & IF Statements.mp4	35.1 MB
1. What are Control Structures & IF Statements.vtt	12.7 KB
10. For Loops (Code Samples).html	0.3 KB
11. Nested Loops & Loop Labeling.mp4	33.8 MB
11. Nested Loops & Loop Labeling.vtt	14.9 KB
12. Nested Loops & Loop Labeling (Code Samples).html	1.0 KB
13. Continue Statement.mp4	23.9 MB
13. Continue Statement.vtt	9.9 KB
14. Continue Statement (Code Samples).html	1.0 KB
15. GOTO Statement.mp4	23.3 MB
15. GOTO Statement.vtt	12.0 KB
16. GOTO Statement (Code Samples).html	1.4 KB
17. Quiz 4 - Control Structures.html	0.2 KB
2. What are Control Structures & IF Statements (Code Samples).html	1.2 KB
3. Case Expressions.mp4	25.5 MB
3. Case Expressions.vtt	13.3 KB
4. Case Expressions (Code Samples).html	1.6 KB
5. What are Loops - Basic Loops.mp4	26.8 MB
5. What are Loops - Basic Loops.vtt	10.4 KB
6. Basic Loops (Code Samples).html	0.5 KB
7. While Loops.mp4	12.9 MB
7. While Loops.vtt	5.4 KB
8. While Loops (Code Samples).html	0.4 KB
9. For Loops.mp4	24.3 MB
9. For Loops.vtt	9.9 KB
/6. Using SQL in PLSQL/
1. Operating with Selected Database Data...mp4	42.6 MB
1. Operating with Selected Database Data...vtt	16.9 KB
2. Operating Wİth Selected Queries (Code Samples).html	1.4 KB
3. DML Operations in PLSQL.mp4	35.4 MB
3. DML Operations in PLSQL.vtt	11.5 KB
4. DML Operations in PLSQL (Code Samples).html	0.7 KB
5. Using Sequences in PLSQL.mp4	33.8 MB
5. Using Sequences in PLSQL.vtt	11.1 KB
6. Using Sequences in PLSQL (Code Samples).html	3.2 KB
7. Bonus - Enabling Server Outputs by Default..mp4	12.2 MB
7. Bonus - Enabling Server Outputs by Default..vtt	4.4 KB
8. Quiz 5 - Using SQL in PLSQL.html	0.2 KB
/7. Composite Data Types/
1. Simple Data Types vs Composite Data Types.mp4	22.6 MB
1. Simple Data Types vs Composite Data Types.vtt	9.3 KB
10. Nested Tables.mp4	23.9 MB
10. Nested Tables.vtt	10.6 KB
11. Nested Tables (Code Samples).html	1.8 KB
12. PL&SQL Associative Arrays (Part 1).mp4	28.9 MB
12. PL&SQL Associative Arrays (Part 1).vtt	17.7 KB
13. PL&SQL Associative Arrays (Part 2).mp4	23.4 MB
13. PL&SQL Associative Arrays (Part 2).vtt	12.8 KB
14. Associative Arrays (Code Samples).html	5.4 KB
15. Storing Collections in Tables - (Part 1).mp4	29.8 MB
15. Storing Collections in Tables - (Part 1).vtt	12.3 KB
16. Storing Collections in Tables - (Part 2).mp4	18.1 MB
16. Storing Collections in Tables - (Part 2).vtt	9.7 KB
17. Storing Collections in Tables (Code Samples).html	5.2 KB
18. Quiz 6 - Composite Data Types.html	0.2 KB
2. PLSQL Records - Part 1.mp4	40.6 MB
2. PLSQL Records - Part 1.vtt	15.9 KB
3. PLSQL Records - Part 2.mp4	115.0 MB
3. PLSQL Records - Part 2.vtt	12.3 KB
4. PLSQL Records (Code Samples).html	2.8 KB
5. Easy DML With Records.mp4	16.6 MB
5. Easy DML With Records.vtt	7.7 KB
6. Easy DML With Records (Code Samples).html	1.1 KB
7. What Are Collections.mp4	12.1 MB
7. What Are Collections.vtt	7.5 KB
8. Varrays & Collection Methods.mp4	33.7 MB
8. Varrays & Collection Methods.vtt	24.6 KB
9. Varrays (Code Samples).html	3.5 KB
/8. PLSQL Cursors/
1. What are Cursors and Cursor Types in PL SQL.mp4	18.1 MB
1. What are Cursors and Cursor Types in PL SQL.vtt	9.7 KB
10. PL SQL Cursor Attributes.mp4	13.7 MB
10. PL SQL Cursor Attributes.vtt	8.4 KB
11. PL SQL Cursor Attributes (Code Samples).html	0.7 KB
12. For Update Clause.mp4	35.9 MB
12. For Update Clause.vtt	18.4 KB
13. For Update Clause (Code Samples).html	1.6 KB
14. Where Current Of Clause.mp4	16.8 MB
14. Where Current Of Clause.vtt	10.6 KB
15. Where Current Of Clause (Code Samples).html	1.1 KB
16. Reference Cursors.mp4	39.4 MB
16. Reference Cursors.vtt	25.1 KB
17. Reference Cursors - (Code Samples).html	5.7 KB
2. Using Explicit Cursors.mp4	18.7 MB
2. Using Explicit Cursors.vtt	11.4 KB
3. Using Explicit Cursors (Code Samples).html	1.1 KB
4. Using Cursors with Records.mp4	9.6 MB
4. Using Cursors with Records.vtt	6.0 KB
5. Cursors with Records (Code Samples).html	1.0 KB
6. Looping with Cursors.mp4	17.4 MB
6. Looping with Cursors.vtt	11.6 KB
7. Looping with Cursors (Code Samples).html	1.9 KB
8. PL SQL Cursors with Parameters.mp4	22.5 MB
8. PL SQL Cursors with Parameters.vtt	12.6 KB
9. PL SQL Cursors with Parameters (Code Samples).html	4.7 KB
/9. PLSQL Exceptions/
1. What are the Exceptions.mp4	16.1 MB
1. What are the Exceptions.vtt	11.7 KB
10. Using RAISE_APPLICATION_ERROR() Procedure (Code Samples).html	1.2 KB
2. What are the Exceptions (Code Sample).html	0.2 KB
3. Handling the Exceptions!.mp4	156.5 MB
3. Handling the Exceptions!.vtt	19.7 KB
4. Handling the Exceptions (Code Samples).html	3.6 KB
5. Handling the Nonpredefined Exceptions.mp4	54.3 MB
5. Handling the Nonpredefined Exceptions.vtt	6.5 KB
6. Handling Nonpredefined Exceptions (Code Sample).html	0.5 KB
7. Handling & Raising User-Defined Exceptions.mp4	64.3 MB
7. Handling & Raising User-Defined Exceptions.vtt	8.0 KB
8. Handling & Raising User-Defined Exceptions (Code Samples).html	1.6 KB
9. Using RAISE_APPLICATION_ERROR() Procedure.mp4	86.1 MB
9. Using RAISE_APPLICATION_ERROR() Procedure.vtt	9.1 KB
/
[FreeCourseLab.com].url	0.1 KB
Total files 272