Oracle PL/SQL 11g - Fundamentals
3.9 (17 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.
161 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

Oracle PL/SQL 11g - Fundamentals

PL/SQL Language Fundaments,PL/SQL Data Types,Control Structures,Composite Datatypes,Cursors,Exception Handling,Procedure
3.9 (17 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.
161 students enrolled
Last updated 2/2014
English
Current price: $10 Original price: $25 Discount: 60% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6.5 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 Basic 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 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

Who is the target audience?
  • Beginners
  • Fresh Graduates
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 36 Lectures Collapse All 36 Lectures 06:20:15
+
Overview of PL/SQL
2 Lectures 22:26

Features and Architecture of PL/SQL
04:46

Quiz
10 questions
+
Introduction to SQL Developer
2 Lectures 10:51
Getting Started With SQL Developer
06:04

Practical Demonstration
04:47

Quiz
5 questions
+
PL/SQL Language Fundaments
3 Lectures 47:34
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
+
PL/SQL Data Types
3 Lectures 40:45
Scalar Data types
27:23

Composite Datatype, LOB Datatype and User-Defined PL/SQL Subtypes
06:54

Datatype Conversion
06:28

Quiz
10 questions
+
Interacting With Oracle Server
2 Lectures 20:12
Statements in PL/SQL
13:39

Practical demonstration
06:33

Quiz
5 questions
+
Control Structures
3 Lectures 43:09
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
+
Composite Datatypes
3 Lectures 22:39
Working with Records
09:06

Working with INDEX BY TABLE
08:23

Practical Demonstration
05:10

Quiz
6 questions
+
Cursors
4 Lectures 38:43
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
+
Exception Handling
5 Lectures 42:08
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
+
Procedures
5 Lectures 54:05
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
2 More Sections
About the Instructor
Parallel Branch Inc
3.8 Average rating
993 Reviews
10,265 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.