Danh mục
Duocmmo Tedu Tin học văn phòng Laravel Cyberlearn Khoá học miễn phí Tất cả khoá học
Get link khoá học
Trang chủ
Development
Database Design & Development
1Z0-149: Oracle Database PL/SQL Developer Certified Professional
The Complete PL/SQL Bootcamp : "Beginner to Advanced PL/SQL"

The Complete PL/SQL Bootcamp : "Beginner to Advanced PL/SQL"

Loại khoá học: Database Design & Development

A Comprehensive Guide to Make You a Job-Ready PL/SQL Developer.Also Covers Oracle 1Z0-144 and 1Z0-149 PL SQL Exam Topics

image
50.000 VND
90 VND
Đầy Đủ Bài Giảng
Học Online Tiện Lợi
Kích Hoạt Nhanh 2-5 Phút
Thanh toán tự động
Được phép tải xuống

Tổng quan

Nội dung khoá học

Đánh giá

Mô tả

Latest Course Updates:

  • (Aug 2023) : "Oracle-Supplied PL/SQL Packages" section was added!

  • (Jun 2023): "Using Dynamic SQL & PL/SQL in PL/SQL" section is added!

  • (May 2023) : High-Quality Closed-Captions are added!

  • (Feb 2023): New Quiz Questions are added!

Become an Oracle Database PL/SQL Developer Certified Professional!

This comprehensive PL/SQL Programming Bootcamp is created for Real Beginner to Advanced PL/SQL Subjects with hundreds of Real-World Examples. Every subject starts from the simplest for non-programmers and goes until the most advanced parts for the students who already know PL/SQL. Every student who wants to learn or Become a Hero in PL/SQL will find everything that they are looking for. 

Students will learn and improve their:

  • PL/SQL Coding Skills

  • SQL & PL/SQL Performance

  • PL/SQL Scalability

  • Portability and Security of Database and PL/SQL Programming

And also our students will be prepared for:

  • (NEW!) Exam Number: 1Z0-149 Oracle Database 19c: Program with PL/SQL  Oracle Certification Exam

  • Exam Number: 1Z0-148 Oracle Database 12c: Advanced PL/SQL        | Oracle Certification Exam

  • Exam Number: 1Z0-144 Oracle Database 12c: Program with PL/SQL | Oracle Certification Exam

  • Exam Number: 1Z0-144 Oracle Database 11g: Program with PL/SQL | Oracle Certification Exam

Our PL/SQL Programming Bootcamp Covers:

  • PL/SQL Terminologies

  • PL/SQL Architecture

  • PL/SQL Variables

  • PL/SQL Control Structures

    • If-Then-Else Structure

    • Case Expressions

    • Loops

      • While Loop

      • For Loop

      • Nested Loop

      • Loop Labeling

      • Continue Statement

      • GOTO Statement

  • Using SQL inside PL/SQL

  • PL/SQL Cursors

  • Using PL/SQL Program Units (Functions & Procedures)

  • PL/SQL Packages

  • PL/SQL Exceptions & Exception Handling

  • PL/SQL Debugging

  • Dynamic SQL & PL/SQL

  • PL/SQL Composite Data Types (Collections)

    • Associative Arrays

    • Nested Tables

    • Varrays

    • Records

  • PL/SQL Triggers

  • Oracle-Supplied Packages

  • Using Large Objects in PL/SQL (LOBs)

  • Using PL/SQL Object Oriented

  • Using PL/SQL Compiler

  • PL/SQL Performance &Tuning

  • PL/SQL Caching

  • PL/SQL Security

  • PL/SQL Fine-Grained Access Control (VPD)

  • PL/SQL Hints

  • PL/SQL Object Dependencies

  • Designing Better PL/SQL

  • Using Java/C in PL/SQL

  • Managing Dependencies

Important Note: This course will be continuously getting updated with more lectures, quizzes, assessments to enhance your knowledge of Oracle PL/SQL

See you in the first lecture!

Bạn sẽ học được gì

Pass the Oracle 1Z0-149 : Program with PL/SQL Certification Exam - on your first try!

Pass the Oracle 1Z0-148 : Advanced PL/SQL Certification Exam - on your first try!

Anything You Need for Coding PL/SQL From Beginner Level to Advanced Level

Every Subject is Explained from the Easiest to the Most Advanced.

Real-World Examples for Every Section

Some Advanced SQL Techniques

Use SQL Developer Efficiently for PL/SQL

Learn PL/SQL Architecture Very Well

Improve Performance of SQL& PL/SQL Codes

Create Your Dynamic SQL & PL/SQL Queries

Learn PL/SQL Object Oriented Programming

Learn PL/SQL Tuning for Performance

Learn & Master PL/SQL by Coding with Hundreds of Practical Examples!

Become a Job-Ready Oracle PL/SQL Developer Certified Professional!

Yêu cầu

  • Basic knowledge of Oracle SQL

Nội dung khoá học

18 sections

What is PL/SQL ?

8 lectures
Course Introductory Video
04:28
UDEMY 101: How to Use Udemy? +Some Useful Tips
05:01
What is PL/SQL and Why to Use?
05:35
PL/SQL Architecture
09:33
What is Pluggable Database?
03:13
The Sample (HR) Schema Used in This Course
07:14
Welcoming Gifts: Course Material & PL/SQL Cheatsheet
00:30
Quiz 1
5 questions

Software Installation

17 lectures
About the Database Installation
03:02
The Ways to Get a Database
14:50
Option 1: Installing VMware and VirtualBox on Windows
07:33
Option 1: How to Install the Virtual Box on Mac OS X?
01:51
Option 1: Downloading Virtual Machine Image(19c)
00:43
Option 1: Downloading Virtual Machine Image(If the previous lecture didn't work)
04:11
Option 1: Configuring the VMware Virtualization Software
08:18
Option 1: Configuring the Oracle VirtualBox Virtualization Software
06:45
Option 1: Configuring SQL Developer inside of the Virtual Machine
13:02
Important Note
00:43
Option 2: Downloading and Installing the Oracle Database
18:18
Option 2: Unlocking the HR Schema
07:34
Option 2: Configuring and Using the SQL Developer
22:14
Option 2: Installing Sample Schemas in Oracle Database
07:44
Option 2: HR Schema Create Code (if you could not get the HR user in other ways)
32:33
Option 3: Using Oracle Live SQL
07:40
Option 3: About Oracle Live SQL Restrictions
00:29

Let's Start Coding!

3 lectures
Anonymous Blocks
13:42
PL/SQL Outputs
08:19
Quiz (First Steps)
6 questions

PL/SQL Variables

14 lectures
What are Variables and Why to Use Them?
08:36
Naming Rules & Naming Conventions
04:24
Declaring & Initializing & Using Variables - Part 1
10:44
Declaring & Initializing & Using Variables - Part 2
10:22
Declaring & Initializing & Using Variables (Code Samples)
00:23
Using %TYPE Attribute
07:07
Using %Type Attribute (Code Samples)
00:06
PL/SQL Delimiters and Commenting Your Code
05:36
PL/SQL Delimiters and Commenting (Code Samples)
00:07
PL SQL Variable Scope
11:15
PL SQL Variable Scope (Code Samples)
00:09
Using Bind Variables
10:53
Using Bind Variables (Code Samples)
00:19
Quiz (Variables)
10 questions

Control Structures

17 lectures
What are Control Structures & IF Statements
13:57
What are Control Structures & IF Statements (Code Samples)
00:34
Case Expressions
14:48
Case Expressions (Code Samples)
00:38
What are Loops - Basic Loops
10:11
Basic Loops (Code Samples)
00:13
While Loops
05:32
While Loops (Code Samples)
00:10
For Loops
09:54
For Loops (Code Samples)
00:08
Nested Loops & Loop Labeling
16:00
Nested Loops & Loop Labeling (Code Samples)
00:27
Continue Statement
10:23
Continue Statement (Code Samples)
00:27
GOTO Statement
13:30
GOTO Statement (Code Samples)
00:33
Quiz (Control Structures)
10 questions

Using SQL in PL/SQL

8 lectures
Operating with Selected Database Data..
18:26
Operating With Selected Queries (Code Samples)
00:35
DML Operations in PL/SQL
12:46
DML Operations in PL/SQL (Code Samples)
00:19
Using Sequences in PL/SQL
12:37
Using Sequences in PL/SQL (Code Samples)
00:31
Extra - Enabling Server Outputs by Default
04:39
Quiz (Using SQL in PL/SQL)
3 questions

Composite Data Types

18 lectures
Simple Data Types vs Composite Data Types
07:52
PL/SQL Records - Part 1
16:40
PL/SQL Records - Part 2
16:30
PL/SQL Records (Code Samples)
00:56
Easy DML With Records
08:14
Easy DML With Records (Code Samples)
00:22
What Are Collections?
06:14
Varrays & Collection Methods
22:59
Varrays (Code Samples)
01:39
Nested Tables
10:57
Nested Tables (Code Samples)
00:50
PL&SQL Associative Arrays (Part 1)
18:54
PL&SQL Associative Arrays (Part 2)
14:53
Associative Arrays (Code Samples)
02:34
Storing Collections in Tables - (Part 1)
14:07
Storing Collections in Tables - (Part 2)
11:15
Storing Collections in Tables (Code Samples)
01:13
Quiz (Composite Data Types)
15 questions

PL/SQL Cursors

18 lectures
What are Cursors and Cursor Types in PL SQL?
08:05
Using Explicit Cursors
11:13
Using Explicit Cursors (Code Samples)
00:21
Using Cursors with Records
06:11
Cursors with Records (Code Samples)
00:22
Looping with Cursors
12:16
Looping with Cursors (Code Samples)
00:46
PL SQL Cursors with Parameters
13:33
PL SQL Cursors with Parameters (Code Samples)
01:36
PL SQL Cursor Attributes
08:28
PL SQL Cursor Attributes (Code Samples)
00:14
For Update Clause
20:32
For Update Clause (Code Samples)
00:39
Where Current Of Clause
09:52
Where Current Of Clause (Code Samples)
00:31
Reference Cursors
24:10
Reference Cursors - (Code Samples)
02:16
Quiz (Cursors)
6 questions

PL/SQL Exceptions

11 lectures
What are the Exceptions?
09:15
What are the Exceptions (Code Sample)
00:03
Handling the Exceptions!
17:55
Handling the Exceptions (Code Samples)
01:26
Handling the Nonpredefined Exceptions
06:24
Handling Nonpredefined Exceptions (Code Sample)
00:10
Handling & Raising User-Defined Exceptions
07:53
Handling & Raising User-Defined Exceptions (Code Samples)
00:51
Using RAISE_APPLICATION_ERROR() Procedure
07:49
Using RAISE_APPLICATION_ERROR() Procedure (Code Samples)
00:33
Quiz (Exceptions)
10 questions

PL/SQL Functions & Procedures

21 lectures
What are Functions & Procedures and Why We Use?
08:36
What are Functions & Procedures and Why We Use (Code Samples)
00:33
Creating and Using Stored Procedures
16:51
Creating and Using Stored Procedures (Code Samples)
00:44
Using IN & OUT Parameters
14:34
Using IN & OUT Parameters (Code Samples)
00:57
Named & Mixed Notations and Default Option
16:25
Named & Mixed Notations and Default Option (Code Samples)
00:33
Creating and Using Functions (Part 1)
16:31
Creating and Using Functions (Part 2)
07:21
Creating and Using PL/SQL Functions (Code Samples)
00:19
Local Subprograms
14:48
Local Subprograms (Code Samples)
00:55
Overloading the Subprograms
13:11
Overloading the Subprograms (Code Samples)
00:46
Handling the Exceptions in Subprograms
19:42
Handling the Exceptions in Subprograms (Code Samples)
00:52
Finding & Removing the Subprograms
11:02
Regular & Pipelined Table Functions
19:32
Regular & Pipelined Table Functions (Code Samples)
00:32
Quiz (PL/SQL Functions & Procedures)
10 questions

PL/SQL Packages

15 lectures
What Are Packages?
09:37
Creating & Using & Modifying & Removing the Packages
27:16
Creating & Using & Modifying & Removing the Packages (Code Samples)
00:26
Visibility of Package Objects
11:23
Visibility of Package Objects (Code Samples)
00:42
Illegal Object Reference & Forward Declaration
07:27
Package Initialization
08:45
Persistent State of Packages - Part 1
19:13
Persistent State of Packages - Part 2
13:59
Persistent State of Packages (Code Samples)
00:20
Using Collections in PL/SQL Packages - Part 1
26:12
Using Collections in PL/SQL Packages - Part 2
09:43
Using Collections in PL/SQL Packages (Code Samples)
01:35
How Can I Find the Packages?
07:28
Quiz (Packages)
11 questions

PL/SQL Triggers

28 lectures
What are Triggers & Trigger Types
10:00
Understanding DML Triggers
11:20
Specifying the Timing of Triggers
19:02
Specifying the Timing of Triggers (Code Samples)
00:13
Statement & Row Level Triggers
13:29
Statement & Row Level Triggers (Code Samples)
00:34
Using New & Old Qualifiers in Triggers
19:22
Using New & Old Qualifiers in Triggers (Code Samples)
00:12
Using Conditional Predicates
10:26
Using Conditional Predicates (Code Samples)
00:20
Using RAISE_APPLICATION_ERROR Procedure in Triggers
05:32
Using RAISE_APPLICATION_ERROR Procedure in Triggers (Code Samples)
00:24
Using Update Of Event in Triggers
06:28
Using Update Of Event in Triggers (Code Samples)
00:07
Using WHEN Clause in Triggers
07:10
Using When Clause in Triggers (Code Samples)
00:08
INSTEAD OF Triggers
19:45
Instead of Triggers (Code Samples)
00:29
Exploring & Managing the Triggers
08:20
Creating Disabled Triggers
05:05
Creating Disabled Triggers (Code Samples)
00:08
Additional Real-World Examples for DML Triggers
21:27
Additional Real-World Examples for DML Triggers (Code Samples)
00:50
Compound Triggers
27:39
Compound Triggers (Code Samples)
00:58
Handling Mutating Table Errors
20:17
Handling Mutating Table Errors (Code Samples)
01:19
Quiz (Triggers)
13 questions

PL/SQL Debugging: Debugging Your Codes & Subprograms

6 lectures
PL/SQL Debugging: Debugging Your Subprograms - (Part 1)
10:53
PL/SQL Debugging: Debugging Your Subprograms - (Part 2)
11:16
PL/SQL Debugging: Debugging Your Subprograms - (Part 3)
08:42
Granting Debug Privileges to a User
00:23
PL/SQL Debugging: Debugging the Anonymous Blocks
05:49
Source Code: Debugging the Anonymous Blocks
00:16

Using Dynamic SQL & PL/SQL in PL/SQL!

17 lectures
Introduction to Dynamic SQL and Dynamic PL/SQL
12:43
Native Dynamic SQL, PL/SQL
11:15
EXECUTE IMMEDIATE Statement
10:55
Execute Immediate Statement (Code Samples)
00:19
EXECUTE IMMEDIATE STATEMENT with the USING Clause
15:15
EXECUTE IMMEDIATE STATEMENT with the USING Clause (Code Samples)
01:02
EXECUTE IMMEDIATE STATEMENT with the USING and INTO Clauses
12:30
EXECUTE IMMEDIATE STATEMENT with the USING and INTO Clauses (Code Samples)
00:50
EXECUTE IMMMEDIATE with BULK COLLECT INTO Clause
05:57
Execute Immediate with Bulk Collect (Code Samples)
00:19
Dynamic PL/SQL Blocks
11:46
Dynamic PL/SQL Blocks (Code Sample)
01:24
OPEN - FOR, FETCH Statements
07:17
OPEN - FOR, FETCH Statements (Code Sample)
00:33
Using the DMBS_SQL Package (The Method 4)
24:01
Using the DBMS_SQL Package (Code Samples)
01:02
Quiz (Dynamic SQL)
8 questions

Using Oracle-Supplied Packages

11 lectures
What are Oracle Supplied Packages?
07:10
Using the DBMS_OUTPUT Package
13:59
Using the DBMS_OUTPUT Package (Code Samples)
00:29
Using the UTL_FILE Package (Part 1)
15:57
Using the UTL_FILE Package (Part 2)
17:41
Using the UTL_FILE Package (Part 3)
11:40
Using the UTL_FILE Package (Code Samples)
01:11
Using the UTL_MAIL Package (Part 1)
13:05
Using the UTL_MAIL Package (Part 2)
13:56
Using the UTL_MAIL Package (Code Samples)
02:29
Quiz (Oracle-Supplied Packages)
8 questions

Miscellaneous PL/SQL Topics & Concepts

4 lectures
Managing Security for Definer's Rights and Invoker's Rights (Part 1)
12:37
Managing Security for Definer's Rights and Invoker's Rights (Part 2)
12:50
Managing Security for Definer's Rights and Invoker's Rights (Code Samples)
01:04
Quiz (Miscellaneous Topics)
4 questions

Appendix

4 lectures
Appendix 1: Oracle Database 12c Installation into Your Computer
09:04
Appendix 2: How to Unlock the HR Schema in the Oracle Database 12c?
01:40
Appendix 3: Configuring and Using Oracle SQL Developer for Oracle Database 12c
09:53
How to Uninstall Oracle Database?
00:34

Bonus

1 lectures
Bonus Lecture
00:30

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

Khoá học liên quan

Appium -Mobile Testing (Android/IOS) from Scratch+Frameworks

Appium -Mobile Testing (Android/IOS) from Scratch+Frameworks

95 VND
50.000 VND
Appium - Mobile Testing with Latest 2.0 and Live Projects

Appium - Mobile Testing with Latest 2.0 and Live Projects

70 VND
50.000 VND
Deep Learning for Object Detection with Python and PyTorch

Deep Learning for Object Detection with Python and PyTorch

899.000 VND
50.000 VND
Full Android Development Masterclass | 14 Real Apps-46 Hours

Full Android Development Masterclass | 14 Real Apps-46 Hours

1.699.000 VND
50.000 VND
Go Java Full Stack with Spring Boot and Angular

Go Java Full Stack with Spring Boot and Angular

90 VND
50.000 VND
Machine Learning Practical Workout | 8 Real-World Projects

Machine Learning Practical Workout | 8 Real-World Projects

79 VND
50.000 VND
WordPress 2024: The Complete WordPress Website Course

WordPress 2024: The Complete WordPress Website Course

90 VND
50.000 VND
Android App Development Master Course with Java | Android

Android App Development Master Course with Java | Android

99 VND
50.000 VND
Unreal Engine 5: Soulslike Melee Combat System

Unreal Engine 5: Soulslike Melee Combat System

1.399.000 VND
50.000 VND
ASP.NET Core Web Application Using Razor Pages

ASP.NET Core Web Application Using Razor Pages

1.699.000 VND
50.000 VND
Build Undetectable Malware Using C Language: Ethical Hacking

Build Undetectable Malware Using C Language: Ethical Hacking

75 VND
50.000 VND
Angular - The Complete Guide (2024 Edition)

Angular - The Complete Guide (2024 Edition)

120 VND
50.000 VND
.NET 8 Microservices: DDD, CQRS, Vertical/Clean Architecture

.NET 8 Microservices: DDD, CQRS, Vertical/Clean Architecture

100 VND
50.000 VND
Unreal Engine 5: The Complete Beginner's Course

Unreal Engine 5: The Complete Beginner's Course

1.899.000 VND
50.000 VND
Complete WordPress Developer Course 2023 - Plugins & Themes

Complete WordPress Developer Course 2023 - Plugins & Themes

1.999.000 VND
50.000 VND
The Data Science Course: Complete Data Science Bootcamp 2024

The Data Science Course: Complete Data Science Bootcamp 2024

140 VND
50.000 VND
image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.

Get khoá học cho tôi