Best seller!
Best seller!
€41.65
€24.99
1z0-149: Oracle Database Program with PL/SQL Certification Video Training Course
The complete solution to prepare for for your exam with 1z0-149: Oracle Database Program with PL/SQL certification video training course. The 1z0-149: Oracle Database Program with PL/SQL certification video training course contains a complete set of videos that will provide you with thorough knowledge to understand the key concepts. Top notch prep including Oracle 1z0-149 exam dumps, study guide & practice test questions and answers.
98 Students Enrolled
22:56:00 Hours
1z0-149: Oracle Database Program with PL/SQL Certification Video Training Course Exam Curriculum
1
What is PL/SQL ?
2 Lectures
Time 00:16:00
2
Software Installation
7 Lectures
Time 01:24:00
3
Let's Start Coding!..
2 Lectures
Time 00:22:00
4
PL/SQL Variables
8 Lectures
Time 01:09:00
5
Control Structures
8 Lectures
Time 01:35:00
6
Using SQL in PL/SQL
4 Lectures
Time 00:49:00
7
Composite Data Types
11 Lectures
Time 02:29:00
8
PL/SQL Cursors
9 Lectures
Time 01:54:00
9
PL/SQL Exceptions
5 Lectures
Time 00:49:00
10
PL/SQL Functions & Procedures
11 Lectures
Time 02:40:00
11
PL/SQL Packages
9 Lectures
Time 02:10:00
12
PL/SQL Triggers
15 Lectures
Time 03:23:00
13
PL/SQL Debugging: Debugging Your Codes & Subprograms
4 Lectures
Time 00:37:00
14
Using Dynamic SQL & PL/SQL
9 Lectures
Time 01:52:00
15
Using Oracle-Supplied Packages
6 Lectures
Time 01:27:00
What is PL/SQL ?
-
6:00
1. What is PL/SQL and Why to Use?
-
10:00
2. PL/SQL Architecture
Software Installation
-
9:00
1. Which Option to Choose to Have a Database?
-
16:00
2. Option 1: Having the Database with the Oracle Virtual Box
-
3:00
3. What is Pluggable Database?
-
18:00
4. Option 2: Downloading and Installing the Oracle Database
-
8:00
5. Option 2: Unlocking the HR Schema
-
22:00
6. Option 2: Configuring and Using the SQL Developer
-
8:00
7. Option 3: Using Oracle Live SQL
Let's Start Coding!..
-
14:00
1. Anonymous Blocks
-
8:00
2. PL/SQL Outputs
PL/SQL Variables
-
9:00
1. What are Variables and Why to Use Them?
-
4:00
2. Naming Rules & Naming Conventions
-
11:00
3. Declaring & Initializing & Using Variables - Part 1
-
10:00
4. Declaring & Initializing & Using Variables - Part 2
-
7:00
5. Using %TYPE Attribute
-
6:00
6. PL/SQL Delimiters and Commenting Your Code
-
11:00
7. PL SQL Variable Scope
-
11:00
8. Using Bind Variables
Control Structures
-
14:00
1. What are Control Structures & IF Statements
-
15:00
2. Case Expressions
-
10:00
3. What are Loops - Basic Loops
-
6:00
4. While Loops
-
10:00
5. For Loops
-
16:00
6. Nested Loops & Loop Labeling
-
10:00
7. Continue Statement
-
14:00
8. GOTO Statement
Using SQL in PL/SQL
-
18:00
1. Operating with Selected Database Data..
-
13:00
2. DML Operations in PL/SQL
-
13:00
3. Using Sequences in PL/SQL
-
5:00
4. Bonus - Enabling Server Outputs by Default.
Composite Data Types
-
8:00
1. Simple Data Types vs Composite Data Types
-
17:00
2. PL/SQL Records - Part 1
-
17:00
3. PL/SQL Records - Part 2
-
8:00
4. Easy DML With Records
-
6:00
5. What Are Collections?
-
23:00
6. Varrays & Collection Methods
-
11:00
7. Nested Tables
-
19:00
8. PL&SQL Associative Arrays (Part 1)
-
15:00
9. PL&SQL Associative Arrays (Part 2)
-
14:00
10. Storing Collections in Tables - (Part 1)
-
11:00
11. Storing Collections in Tables - (Part 2)
PL/SQL Cursors
-
8:00
1. What are Cursors and Cursor Types in PL SQL?
-
11:00
2. Using Explicit Cursors
-
6:00
3. Using Cursors with Records
-
12:00
4. Looping with Cursors
-
14:00
5. PL SQL Cursors with Parameters
-
8:00
6. PL SQL Cursor Attributes
-
21:00
7. For Update Clause
-
10:00
8. Where Current Of Clause
-
24:00
9. Reference Cursors
PL/SQL Exceptions
-
9:00
1. What are the Exceptions?
-
18:00
2. Handling the Exceptions!
-
6:00
3. Handling the Nonpredefined Exceptions
-
8:00
4. Handling & Raising User-Defined Exceptions
-
8:00
5. Using RAISE_APPLICATION_ERROR() Procedure
PL/SQL Functions & Procedures
-
9:00
1. What are Functions & Procedures and Why We Use?
-
17:00
2. Creating and Using Stored Procedures
-
15:00
3. Using IN & OUT Parameters
-
16:00
4. Named & Mixed Notations and Default Option
-
17:00
5. Creating and Using Functions (Part 1)
-
7:00
6. Creating and Using Functions (Part 2)
-
15:00
7. Local Subprograms
-
13:00
8. Overloading the Subprograms
-
20:00
9. Handling the Exceptions in Subprograms
-
11:00
10. Finding & Removing the Subprograms
-
20:00
11. Regular & Pipelined Table Functions
PL/SQL Packages
-
10:00
1. What Are Packages?
-
27:00
2. Creating & Using & Modifying & Removing the Packages
-
11:00
3. Visibility of Package Objects
-
7:00
4. Illegal Object Reference & Forward Declaration
-
9:00
5. Package Initialization
-
19:00
6. Persistent State of Packages - Part 1
-
14:00
7. Persistent State of Packages - Part 2
-
26:00
8. Using Collections in Packages - Part 1
-
7:00
9. How Can I Find the Packages?
PL/SQL Triggers
-
10:00
1. What are Triggers & Trigger Types
-
11:00
2. Understanding DML Triggers
-
19:00
3. Specifying the Timing of Triggers
-
13:00
4. Statement & Row Level Triggers
-
19:00
5. Using New & Old Qualifiers in Triggers
-
10:00
6. Using Conditional Predicates
-
6:00
7. Using RAISE_APPLICATION_ERROR Procedure in Triggers
-
6:00
8. Using Update Of Event in Triggers
-
7:00
9. Using WHEN Clause in Triggers
-
20:00
10. INSTEAD OF Triggers
-
8:00
11. Exploring & Managing the Triggers
-
5:00
12. Creating Disabled Triggers
-
21:00
13. Additional Real-World Examples for DML Triggers
-
28:00
14. Compound Triggers
-
20:00
15. Handling Mutating Table Errors
PL/SQL Debugging: Debugging Your Codes & Subprograms
-
11:00
1. PL/SQL Debugging: Debugging Your Subprograms - (Part 1)
-
11:00
2. PL/SQL Debugging: Debugging Your Subprograms - (Part 2)
-
9:00
3. PL/SQL Debugging: Debugging Your Subprograms - (Part 3)
-
6:00
4. PL/SQL Debugging: Debugging the Anonymous Blocks
Using Dynamic SQL & PL/SQL
-
13:00
1. Introduction to Dynamic SQL and Dynamic PL/SQL
-
11:00
2. Native Dynamic SQL, PL/SQL
-
11:00
3. EXECUTE IMMEDIATE Statement
-
15:00
4. EXECUTE IMMEDIATE STATEMENT with the USING Clause
-
13:00
5. EXECUTE IMMEDIATE STATEMENT with the USING and INTO Clauses
-
6:00
6. EXECUTE IMMMEDIATE with BULK COLLECT INTO Clause
-
12:00
7. Dynamic PL/SQL Blocks
-
7:00
8. OPEN - FOR, FETCH Statements
-
24:00
9. Using the DMBS_SQL Package (The Method 4)
Using Oracle-Supplied Packages
-
14:00
1. Using the DBMS_OUTPUT Package
-
16:00
2. Using the UTL_FILE Package (Part 1)
-
18:00
3. Using the UTL_FILE Package (Part 2)
-
12:00
4. Using the UTL_FILE Package (Part 3)
-
13:00
5. Using the UTL_MAIL Package (Part 1)
-
14:00
6. Using the UTL_MAIL Package (Part 2)
About 1z0-149: Oracle Database Program with PL/SQL Certification Video Training Course
1z0-149: Oracle Database Program with PL/SQL certification video training course by prepaway along with practice test questions and answers, study guide and exam dumps provides the ultimate training package to help you pass.
Prepaway's 1z0-149: Oracle Database Program with PL/SQL video training course for passing certification exams is the only solution which you need.
Pass Oracle 1z0-149 Exam in First Attempt Guaranteed!
Get 100% Real Exam Questions, Accurate & Verified Answers As Seen in the Real Exam!
30 Days Free Updates, Instant Download!
Student Feedback
5.0
Excellent
Only Registered Members
Can View Online Video Courses
Can View Online Video Courses
Please fill out your email address below in order to view Online Courses.
Registration is Free and Easy, You Simply need to provide an email address.
- Trusted By 1.2M IT Certification Candidates Every Month
- Hundreds Hours of Videos
- Instant download After Registration
A confirmation link will be sent to this email address to verify your login.
Log into your Prepaway Account
Please Log In to view Online Course
Registration is free and easy - just provide your E-mail address.
Click Here to Register
