Oracle PL/SQL 11g - Fundamentals

PL/SQL Language Fundaments,PL/SQL Data Types,Control Structures,Composite Datatypes,Cursors,Exception Handling,Procedure
3.9 (16 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.
156 students enrolled
$19
$25
24% off
Take This Course
  • Lectures 36
  • Length 6.5 hours
  • Skill Level Beginner 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 BASIC PL/SQL 11g CONCEPTS

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

In this course, you’ll learn PL/SQL Fundamentals training introduces you to PL/SQL then engage in demonstrations and hands-on practice to reinforce the fundamental concepts. You’ll use Oracle SQL Developer to develop these program units.

Learn to:

Overview of PL/SQL,

Introduction to SQL Developer,

PL/SQL Language Fundaments,

PL/SQL Data Types,

Interacting With Oracle Server,

Control Structures,

Composite Datatypes,

Cursors,

Exception Handling,

Procedures,

Functions,

Managing Subprograms

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 Basic 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: Overview of PL/SQL
Getting Started With PL/SQL
Preview
17:40
Features and Architecture of PL/SQL
04:46
Quiz
10 questions
Section 2: Introduction to SQL Developer
Getting Started With SQL Developer
06:04
Practical Demonstration
04:47
Quiz
5 questions
Section 3: PL/SQL Language Fundaments
Character Sets and Lexical Units
15:57
PL/SQL Block, Declarations, %TYPE Atribute, Scope and Visibility of Identifiers
23:50
Expressions and Operators
07:47
Quiz
10 questions
Section 4: PL/SQL Data Types
Scalar Data types
27:23
Composite Datatype, LOB Datatype and User-Defined PL/SQL Subtypes
06:54
Datatype Conversion
06:28
Quiz
10 questions
Section 5: Interacting With Oracle Server
Statements in PL/SQL
13:39
Practical demonstration
06:33
Quiz
5 questions
Section 6: Control Structures
Introduction to Control Structures, Conditional Control Structure and CASE Stat
16:48
Iterative Control Structures: LOOP, WHILE – LOOP, FOR LOOP
12:37
Practical Demonstrations
13:44
Quiz
10 questions
Section 7: Composite Datatypes
Working with Records
09:06
Working with INDEX BY TABLE
08:23
Practical Demonstration
05:10
Quiz
6 questions
Section 8: Cursors
Working with Implicit Cursors
07:53
Working with Explicit Cursors
15:07
Working with Cursors and Records, Cursor FOR LOOP
03:51
Practical Demonstration
11:52
Quiz
11 questions
Section 9: Exception Handling
Handling PL/SQL Errors
07:58
Predefined Exceptions
11:12
Non-Predefined Exceptions
05:13
User Defined Exceptions
08:01
Practical Demonstration
09:44
Quiz
10 questions
Section 10: Procedures
Introduction to Program Units in PL/SQL
08:45
Starting With Procedures in PL/SQL
12:03
Parameter Passing Methods and DEFAULT Option
05:50
Exception Handling in Procedures and Removing Procedure
04:48
Practical demonstration
22:39
Quiz
8 questions
Section 11: Functions
Working With Functions
15:52
Practical demonstration
04:54
Quiz
6 questions
Section 12: Managing Subprograms
Working with Records
10:50
Practical demonstration
06:07
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