Oracle PL/SQL 11g – Advance
3.5 (35 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
472 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle PL/SQL 11g – Advance to your Wishlist.

Add to Wishlist

Oracle PL/SQL 11g – Advance

Packages in PL/SQL,Oracle Supplied Packages,Oracle Large Objects,Analyzing PL/SQL Code,Performance and Tuning.
3.5 (35 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
472 students enrolled
Last updated 2/2014
English
Learn Fest Sale
Current price: $10 Original price: $20 Discount: 50% off
14 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 9 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • In this course, you will learn Advanced concepts of PL/SQL 11g Programming Language.
View Curriculum
Requirements
  • Windows PC, Good Internet Connectivity and Basic database knowledge
Description

==============================================================

EXTREMELY USEFUL TO UNDERSTAND THE ADVANCE PL/SQL 11g CONCEPTS

===============================================================

At the end of this course, you will get the knowledge of...

Packages in PL/SQL,

Oracle Supplied Packages,

Oracle Large Objects,

Performance and Tuning,

Improving Performance with Caching,

Analyzing PL/SQL Code,

Profiling and Tracing PL/SQL Code,

Safeguarding Your Code Against SQL Injection Attacks

Who is the target audience?
  • Beginners
  • Fresh Graduates
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 40 Lectures Collapse All 40 Lectures 09:11:53
+
Packages in PL/SQL Part 1
3 Lectures 32:10

Creating a package
06:30

Practical Demonstration
12:29

Quiz
8 questions
+
Packages in PL/SQL Part 2
3 Lectures 33:13
Overloading, Forward Declaration and One-Time Only Procedure
12:23

Advanced Package Concepts
06:33


Quiz
5 questions
+
Oracle Supplied Packages Part 1
3 Lectures 01:03:25
DBMS_DDL Package
19:27

DBMS_DEBUG Package
28:42

DBMS_SQL Package
15:16

Quiz
9 questions
+
Oracle Supplied Packages Part 2
5 Lectures 01:02:51
DBMS_JOB Package
09:09

DBMS_OUTPUT Package
05:47

UTL_FILE Package
23:11

Other Oracle Supplied Packages
14:48

Practical Demonstration
09:56

Quiz
8 questions
+
Oracle Large Objects
5 Lectures 01:53:05
Introduction to Large Objects
15:44

The DBMS_LOB Package
57:19

Managing BFILE's
10:09

Migrating from LONG to LOB
17:06

Practical Demonstration
12:47

Quiz
10 questions
+
Performance and Tuning
4 Lectures 01:04:47
Using native and interpreted compilation methods
33:12

Bulk Binding
09:40

Inlining
09:02


Quiz
6 questions
+
Improving Performance with Caching
3 Lectures 21:09
Improving memory usage by caching SQL result sets
10:59

PL/SQL Function Result Cache
02:26

Practical Demonstration
07:44

Quiz
5 questions
+
Analyzing PL/SQL Code
4 Lectures 55:27
Finding Information About Your PL/SQL Code
10:18

Determining identifier types and usages
08:47

Using DBMS_METADATA to retrieve object definitions
17:00

Practical Demonstration
19:22

Quiz
11 questions
+
Profiling and Tracing PL/SQL Code
3 Lectures 43:13
Tracing PL/SQL program execution
09:50

Profiling PL/SQL applications
16:41

Practical Demonstration
16:42

Quiz
8 questions
+
Safeguarding Your Code Against SQL Injection Attacks
7 Lectures 01:02:33
Tracing PL/SQL program execution
09:01

Reducing the attack surface
04:51

Avoiding dynamic SQL and Using bind arguments
07:16

Filtering input with DBMS_ASSERT
10:26

Designing code immune to SQL injections
07:14

Testing code for SQL injection flaws
05:59

Practical Demonstration
17:46

Quiz
5 questions
About the Instructor
Parallel Branch Inc
3.8 Average rating
1,075 Reviews
10,609 Students
32 Courses
Academy Of Technical Courses, Grow Your Skills Today

We offer courses in specialized technology domains that are well aligned with market trends, geared towards enabling gainful careers and are affordable. Parallel Branch is an interactive approach to e-learning and a perfect way to Jump Start your career.

In today’s job market, it’s important to have the skills to match current needs and to stay on par with technological advances. The flexible, affordable and high-quality online technical courses at Parallel Branch provide the opportunity for you to learn the skills you need to move ahead and stay there.