1z0-149: Oracle Database Program with PL/SQL Exam Training Course

Curriculum For This Course

What is PL/SQL ?

2Lectures

Time 00:16:00

Software Installation

7Lectures

Time 01:24:00

Let's Start Coding!..

2Lectures

Time 00:22:00

PL/SQL Variables

8Lectures

Time 01:09:00

Control Structures

8Lectures

Time 01:35:00

Using SQL in PL/SQL

4Lectures

Time 00:49:00

Composite Data Types

11Lectures

Time 02:29:00

PL/SQL Cursors

9Lectures

Time 01:54:00

PL/SQL Exceptions

5Lectures

Time 00:49:00

PL/SQL Functions & Procedures

11Lectures

Time 02:40:00

PL/SQL Packages

9Lectures

Time 02:10:00

PL/SQL Triggers

15Lectures

Time 03:23:00

PL/SQL Debugging: Debugging Your Codes & Subprograms

4Lectures

Time 00:37:00

Using Dynamic SQL & PL/SQL

9Lectures

Time 01:52:00

Using Oracle-Supplied Packages

6Lectures

Time 01:27:00

What is PL/SQL ?
	1. What is PL/SQL and Why to Use?	6:00
	2. PL/SQL Architecture	10:00

Software Installation
	1. Which Option to Choose to Have a Database?	9:00
	2. Option 1: Having the Database with the Oracle Virtual Box	16:00
	3. What is Pluggable Database?	3:00
	4. Option 2: Downloading and Installing the Oracle Database	18:00
	5. Option 2: Unlocking the HR Schema	8:00
	6. Option 2: Configuring and Using the SQL Developer	22:00
	7. Option 3: Using Oracle Live SQL	8:00

Let's Start Coding!..
	1. Anonymous Blocks	14:00
	2. PL/SQL Outputs	8:00

PL/SQL Variables
	1. What are Variables and Why to Use Them?	9:00
	2. Naming Rules & Naming Conventions	4:00
	3. Declaring & Initializing & Using Variables - Part 1	11:00
	4. Declaring & Initializing & Using Variables - Part 2	10:00
	5. Using %TYPE Attribute	7:00
	6. PL/SQL Delimiters and Commenting Your Code	6:00
	7. PL SQL Variable Scope	11:00
	8. Using Bind Variables	11:00

Control Structures
	1. What are Control Structures & IF Statements	14:00
	2. Case Expressions	15:00
	3. What are Loops - Basic Loops	10:00
	4. While Loops	6:00
	5. For Loops	10:00
	6. Nested Loops & Loop Labeling	16:00
	7. Continue Statement	10:00
	8. GOTO Statement	14:00

Using SQL in PL/SQL
	1. Operating with Selected Database Data..	18:00
	2. DML Operations in PL/SQL	13:00
	3. Using Sequences in PL/SQL	13:00
	4. Bonus - Enabling Server Outputs by Default.	5:00

Composite Data Types
	1. Simple Data Types vs Composite Data Types	8:00
	2. PL/SQL Records - Part 1	17:00
	3. PL/SQL Records - Part 2	17:00
	4. Easy DML With Records	8:00
	5. What Are Collections?	6:00
	6. Varrays & Collection Methods	23:00
	7. Nested Tables	11:00
	8. PL&SQL Associative Arrays (Part 1)	19:00
	9. PL&SQL Associative Arrays (Part 2)	15:00
	10. Storing Collections in Tables - (Part 1)	14:00
	11. Storing Collections in Tables - (Part 2)	11:00

PL/SQL Cursors
	1. What are Cursors and Cursor Types in PL SQL?	8:00
	2. Using Explicit Cursors	11:00
	3. Using Cursors with Records	6:00
	4. Looping with Cursors	12:00
	5. PL SQL Cursors with Parameters	14:00
	6. PL SQL Cursor Attributes	8:00
	7. For Update Clause	21:00
	8. Where Current Of Clause	10:00
	9. Reference Cursors	24:00

PL/SQL Exceptions
	1. What are the Exceptions?	9:00
	2. Handling the Exceptions!	18:00
	3. Handling the Nonpredefined Exceptions	6:00
	4. Handling & Raising User-Defined Exceptions	8:00
	5. Using RAISE_APPLICATION_ERROR() Procedure	8:00

PL/SQL Functions & Procedures
	1. What are Functions & Procedures and Why We Use?	9:00
	2. Creating and Using Stored Procedures	17:00
	3. Using IN & OUT Parameters	15:00
	4. Named & Mixed Notations and Default Option	16:00
	5. Creating and Using Functions (Part 1)	17:00
	6. Creating and Using Functions (Part 2)	7:00
	7. Local Subprograms	15:00
	8. Overloading the Subprograms	13:00
	9. Handling the Exceptions in Subprograms	20:00
	10. Finding & Removing the Subprograms	11:00
	11. Regular & Pipelined Table Functions	20:00

PL/SQL Packages
	1. What Are Packages?	10:00
	2. Creating & Using & Modifying & Removing the Packages	27:00
	3. Visibility of Package Objects	11:00
	4. Illegal Object Reference & Forward Declaration	7:00
	5. Package Initialization	9:00
	6. Persistent State of Packages - Part 1	19:00
	7. Persistent State of Packages - Part 2	14:00
	8. Using Collections in Packages - Part 1	26:00
	9. How Can I Find the Packages?	7:00

PL/SQL Triggers
	1. What are Triggers & Trigger Types	10:00
	2. Understanding DML Triggers	11:00
	3. Specifying the Timing of Triggers	19:00
	4. Statement & Row Level Triggers	13:00
	5. Using New & Old Qualifiers in Triggers	19:00
	6. Using Conditional Predicates	10:00
	7. Using RAISE_APPLICATION_ERROR Procedure in Triggers	6:00
	8. Using Update Of Event in Triggers	6:00
	9. Using WHEN Clause in Triggers	7:00
	10. INSTEAD OF Triggers	20:00
	11. Exploring & Managing the Triggers	8:00
	12. Creating Disabled Triggers	5:00
	13. Additional Real-World Examples for DML Triggers	21:00
	14. Compound Triggers	28:00
	15. Handling Mutating Table Errors	20:00

PL/SQL Debugging: Debugging Your Codes & Subprograms
	1. PL/SQL Debugging: Debugging Your Subprograms - (Part 1)	11:00
	2. PL/SQL Debugging: Debugging Your Subprograms - (Part 2)	11:00
	3. PL/SQL Debugging: Debugging Your Subprograms - (Part 3)	9:00
	4. PL/SQL Debugging: Debugging the Anonymous Blocks	6:00

Using Dynamic SQL & PL/SQL
	1. Introduction to Dynamic SQL and Dynamic PL/SQL	13:00
	2. Native Dynamic SQL, PL/SQL	11:00
	3. EXECUTE IMMEDIATE Statement	11:00
	4. EXECUTE IMMEDIATE STATEMENT with the USING Clause	15:00
	5. EXECUTE IMMEDIATE STATEMENT with the USING and INTO Clauses	13:00
	6. EXECUTE IMMMEDIATE with BULK COLLECT INTO Clause	6:00
	7. Dynamic PL/SQL Blocks	12:00
	8. OPEN - FOR, FETCH Statements	7:00
	9. Using the DMBS_SQL Package (The Method 4)	24:00

Using Oracle-Supplied Packages
	1. Using the DBMS_OUTPUT Package	14:00
	2. Using the UTL_FILE Package (Part 1)	16:00
	3. Using the UTL_FILE Package (Part 2)	18:00
	4. Using the UTL_FILE Package (Part 3)	12:00
	5. Using the UTL_MAIL Package (Part 1)	13:00
	6. Using the UTL_MAIL Package (Part 2)	14:00

Free 1z0-149 Exam Questions & Oracle 1z0-149 Dumps
Oracle.realtests.1z0-149.v2024-11-14.by.charlotte.7q.ete	Downloads: 78	Size: 15.64 KB

Student Feedback

5.0

Excellent

56%

44 %

Add Comments

Name:^*

E-mail:^*

Comment:^* Comment will be moderated and published within 1-4 hours

Verification:^*

Type the characters from the picture.

Rate Course:^*

1z0-149: Oracle Database Program with PL/SQL

Curriculum For This Course

Free 1z0-149 Exam Questions & Oracle 1z0-149 Dumps

Student Feedback

Add Comments

Get Premium Membership