[NEW] Oracle PL/SQL – An Ultimate Bootcamp (2023)

سرفصل های دوره

Become an Expert in PL/SQL | Latest Version of PL/SQL on Oracle 21c | All script files attached | Published: 16.09.2023

1. Introduction

1. PLSQL Overview

2. Course Structure and How to Maximize Its Benefits

3. Message From Trainer

2. Environment Setup

1.1 table data scripts.zip

1. Live SQL cloud account creation, demo data setup

2. Oracle 21c - XE Installation

3. Multitenant Architecture overview

4.1 FAQ Documents.docx

4.2 table data scripts oracle.zip

4. Create PDB, Schema user, Connect to 21C from Oracle SQL Developer

3. PLSQL - Anonymous Block

1. Create a Simple Anonymous Block

2. Overview of the Types of PLSQL blocks

3. Generate Output from a PLSQL Block

4. Lab & Assignment - 01

5.1 solution 01.zip

5. Solution - 01

6. Recap

4. PLSQL Identifiers

1. List the different Types of Identifiers in a PLSQL subprogram

2. Usage of the Declarative Section to define Identifiers

3. Use variables to store data

4. Identify Scalar Data Types

5. The %TYPE and %ROWTYPE Attribute

6. What are Bind Variables

7. Sequences in PLSQL Expressions

8. Lab & Assignment - 02

9.1 solution 02.zip

9. Solution - 02

10. Recap

5. Write Executable Statements

1.1 basic plsql block syntax guidelines.zip

1. Describe Basic PLSQL Block Syntax Guidelines

2. Comment Code

3. Deployment of SQL Functions in PLSQL

4. How to convert Data Types

5. Nested Blocks

6. Identify the Operators in PLSQL

7. Assignment - 03

8.1 solution 03.zip

8. Solution - 03

9. Recap

6. Interaction with the Oracle Server

1. Invoke SELECT Statements in PLSQL to Retrieve data

2. Data Manipulation in the Server Using PLSQL

3. SQL Cursor concept

4. Usage of SQL Cursor Attributes to Obtain Feedback on DML

5. Save and Discard Transactions

6.1 04 assignment db scripts.zip

6. Assignment - 04

7.1 04 solution script.zip

7. Solution - 04

8. Recap

7. Control Structures

1. Conditional processing Using IF Statements

2. Conditional processing Using CASE Statements

3. Use simple Loop Statement

4. Use While Loop Statement

5. Use For Loop - Part I

6. Use For Loop - Part II

7. Describe the Continue Statement

8. GO TO statement

9. NULL Statement

10. Assignment - 05

11.1 05 solution.zip

11. Solution - 05

12. Recap

8. Explicit Cursors

1. What are Explicit Cursors

2. Open the Cursor, Fetch a Cursor data, Close a Cursor

3. Cursor FOR loop

4.1 explicit cursor attributes.zip

4. Explicit Cursor Attributes

5.1 for update script.zip

5. FOR UPDATE Clause and WHERE CURRENT Clause

6. Assignment - 06

7.1 06 solution.zip

7. Solution - 06

8. Recap

9. Exception Handling

1. Understand Exceptions

2. Handle Exceptions with PLSQL

3. Trap Predefined Oracle Server Errors

4. Trap Non-Predefined Oracle Server Errors

5.1 user defined exception script 01.zip

5. User-Defined Exceptions - Part I

6.1 user defined exception script 02.zip

6. User-Defined Exceptions - Part II (RAISE APPLICATION ERROR)

7.1 propagate exception script.zip

7. Propagate Exceptions

8.1 07 lab.zip

8. Demo - Live Project

9. Assignment - 07

10.1 07 solution.zip

10. Solution - 07

11. Recap

10. Stored Procedures and Functions - Part I

1. Understand Stored Procedures and Functions

2.1 create simple procedure.zip

2. Create a Simple Procedure

3.1 execute procedure.zip

3. Execute a Simple Procedure

4.1 procedure with in parameters.zip

4. Create a Simple Procedure with IN parameter

5.1 create a simple function script.zip

5. Create a Simple Function

6.1 execute function scripts.zip

6. Execute a Simple Function

7.1 function with in parameters.zip

7. Create a Simple Function with IN parameter

8. Demo & Assignment - 08

9.1 08 solution script.zip

9. Solution - 08

10. Recap

11. Stored Procedures - Part II

1.1 procedure with in out inout parameters.zip

1. Procedure Parameters Modes (IN OUT IN OUT)

2.1 modularized sample script.zip

2. Create a Modularized and Layered Subprogram Design

3.1 create replace procedure script.zip

3. DROP and CREATE OR REPLACE Command.

4. View Procedures Information Using the Data Dictionary Views

5. Lab & Assignment - 09

6.1 solution 09.zip

6. Solution - 09

7. Recap - 09

12. Stored Functions - Part II

1. DROP Stored Function Using Commands

2. Context switch in User-Defined Functions in SQL Statements

3. Restrictions when calling Functions from SQL statements.

4. View Functions Information

5. Assignments - 10

6.1 solution 10.zip

6. Solution - 10

7. Recap

13. Create Packages

1. Describe Packages

2. List the components of a Package

3.1 develop package.zip

3. Develop a Package

4.1 scope package.zip

4. Scope of Package Constructs

5.1 invoke package construct.zip

5. Invoke Package Constructs

6. View PLSQL Source Code Using the Data Dictionary

7. Identity the advantages of Packages

8. Assignment - 11

9.1 solution 11.zip

9. Solution - 11

10. Recap

14. Implement Oracle-Supplied Packages in Application Development

1. What are Oracle-Supplied Packages

2.1 dbms output buffer size.zip

2. DBMS OUTPUT Package to write to buffer

3.1 utl file scripts.zip

3. UTL FILE Package to Interact With Operating System Files

4.1 dbms crypto encrypt decrypt package.zip

4. UTL CRYPTO Package to encrypt & decrypt data

5.1 utl mail package scripts.zip

5. UTL MAIL Package to send mail

6. Assignments - 12

7.1 solution 12.zip

7. Solution - 12

8. Recap

15. Triggers - Part I

1. Describe Triggers

2.1 create dml trigger.zip

2. Create a DML Trigger

3. Triggers classification based upon Events

4.1 conditional predicates.zip

4. Conditional Predicates (INSERTING DELETING UPDATING)

5.1 statement and row level.zip

5. Row Level & Statement level Triggers

6. Before and After Triggers

7.1 correlation names and pseudorecords.zip

7. Correlation Names and Pseudorecords (NEW and OLD)

8.1 create instead of triggers.zip

8. Create Instead of Triggers

9.1 create ddl trigger.zip

9. Create a DDL Trigger

10.1 database trigger.zip

10. Create a Database Trigger

11.1 enable disable trigger.zip

11. How to Manage, Test, disable and Remove Triggers

12. Business Application Scenarios for Implementing Triggers

13. Assignment - 13

14. Solution - 13

15. Recap

16. Triggers - Part II

1.1 execution order in triggers.zip

1. Execution Order in Triggers - Follow Clause

2.1 compound trigger.zip

2. Compound Triggers

3.1 mutation error resolve with compound trigger.zip

3. Compound Trigger to Resolve the Mutating Table Error

4.1 system privileges required to manage triggers.zip

4. System Privileges Required to Manage Triggers

5.1 table sequence script.zip

5. Assignment - 14

6.1 mutation error resolve with compound trigger.zip

6. Solution - 14

7. Recap

17. Composite Data Types - Collections

1.1 plsql record.zip

1. Use PLSQL Records

2.1 table%rowtype.zip

2. The %ROWTYPE Attribute

3.1 dml plsql record.zip

3. Insert and Update with PLSQL Records

4. Collection - A composite data types

5. Associative Arrays (INDEX BY Tables)

6.1 nested table collection.zip

6. Nested Tables Collections

7.1 varray collection.zip

7. Varray Collections

8. Assignment - 15

9.1 solution 15.zip

9. Solution - 15

10. Recap

18. Dynamic SQL

1. The Execution Flow of SQL

2.1 dynamic sql.zip

2. What is Dynamic SQL

3.1 declare cursor variables.zip

3. Declare Cursor Variables

4.1 dynamically executing a plsql block.zip

4. Dynamically executing a PLSQL Block

5.1 native dynamic sql.zip

5. Native Dynamic SQL to Compile PLSQL Code

6.1 invoke dbms sql package.zip

6. Invoke DBMS SQL Package

7.1 dbms sql with a parameterized dml statement.zip

7. Implement DBMS SQL with a Parameterized DML Statement

8. Assignment - 16

9.1 solution 16.zip

9. Solution - 16

10. Recap

19. Advanced Packages

1.1 overloading subprograms in plsql.zip

1. Overloading Subprograms in PLSQL

2.1 forward declaration.zip

2. Use Forward Declarations to Solve illegal Procedure Reference

3.1 persistent state of packages variables.zip

3. Persistent State of Packages Variables

4.1 persistent state of packages cursor.zip

4. Persistent State of a Package Cursor

5. Assignment - 17

6.1 solution-17.zip

6. Solution - 17

7. Recap

20. Advanced Manage Dependencies

1. Overview of Schema Object Dependencies

2.1 direct dependencies by user dependencies.zip

2. Object Dependencies using the USER DEPENDENCIES View

3.1 query object status.zip

3. Query an Objects Status

4.1 invalidation of dependent objects.zip

4. Invalidation of Dependent Objects

5.1 direct and indirect dependencies.zip

5. Display the Direct and Indirect Dependencies

6. Understand Remote Dependencies

7.1 recompile plsql program unit.zip

7. Recompile a PLSQL Program Unit

8. Assignment - 18

9.1 solution-18.zip

9. Solution - 18

10. Recap

21. Advanced Pipe Line functions

1.1 table function.zip

1. What is a Table function

2. What is pipeline function

3.1 create pipelined function.zip

3. Create a pipeline function

4.1 check pga memory consumption pipeline functions.zip

4. Check PGA memory consumption pipeline functions

5.1 error handling pipeline functions.zip

5. Error handling in pipeline functions

6. Assignment - 19

7.1 solution 19.zip

7. Solution - 19

8. Recap

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy