Oracle PL/SQL 11g – Advance

Packages in PL/SQL,Oracle Supplied Packages,Oracle Large Objects,Analyzing PL/SQL Code,Performance and Tuning.
3.0 (24 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.
381 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 40
  • Length 9 hours
  • Skill Level Expert Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2014 English

Course 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

What are the requirements?

  • Windows PC, Good Internet Connectivity and Basic database knowledge

What am I going to get from this course?

  • In this course, you will learn Advanced concepts of PL/SQL 11g Programming Language.

What is the target audience?

  • Beginners
  • Fresh Graduates

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Packages in PL/SQL Part 1
Understanding Packages
Preview
13:11
Creating a package
06:30
Practical Demonstration
12:29
Quiz
8 questions
Section 2: Packages in PL/SQL Part 2
Overloading, Forward Declaration and One-Time Only Procedure
12:23
Advanced Package Concepts
06:33
Practical Demonstration
Preview
14:17
Quiz
5 questions
Section 3: Oracle Supplied Packages Part 1
DBMS_DDL Package
19:27
DBMS_DEBUG Package
28:42
DBMS_SQL Package
15:16
Quiz
9 questions
Section 4: Oracle Supplied Packages Part 2
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
Section 5: Oracle Large Objects
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
Section 6: Performance and Tuning
Using native and interpreted compilation methods
33:12
Bulk Binding
09:40
Inlining
09:02
Practical Demonstration
Preview
12:53
Quiz
6 questions
Section 7: Improving Performance with Caching
Improving memory usage by caching SQL result sets
10:59
PL/SQL Function Result Cache
02:26
Practical Demonstration
07:44
Quiz
5 questions
Section 8: Analyzing PL/SQL Code
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
Section 9: Profiling and Tracing PL/SQL Code
Tracing PL/SQL program execution
09:50
Profiling PL/SQL applications
16:41
Practical Demonstration
16:42
Quiz
8 questions
Section 10: Safeguarding Your Code Against SQL Injection Attacks
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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Parallel Branch Inc, 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.

Ready to start learning?
Take This Course