PL/SQL Programming with Real-World Examples
4.3 (14 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.
3,212 students enrolled
Wishlisted Wishlist

Please confirm that you want to add PL/SQL Programming with Real-World Examples to your Wishlist.

Add to Wishlist

PL/SQL Programming with Real-World Examples

Oracle Internal Programming Techniques and Strategies
4.3 (14 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.
3,212 students enrolled
Created by Dr. Rick Phillips
Last updated 7/2017
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • 33 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • By the end of the course students will be able to fully utilize Oracle's PL/SQL programming language.
  • By the end of the course students will have seen and studies a large number of real-world PL/SQL programming examples.
View Curriculum
Requirements
  • Those taking this course should have prior working knowledge of SQL and at least one full-featured programming language.
Description

This course takes a comprehensive look at the Oracle PL/SQL programming language.  We begin with a thorough review of the language syntax and datatype primitives.  We next explore  user-defined datatypes, flow control, scope and error management. 

The majority of the course is devoted to taking that foundational knowledge and applying it to the resolution of very real-world examples. Real-world examples include:

  1.  development of a password strength function,
  2. parsing XML files,
  3. reading an external directory, and
  4. generating random number, range-based random number and even weighted random numbers.

Join Dr. Phillips as he transfers his many years of PL/SQL programming skill and knowledge.

Who is the target audience?
  • Anyone seeking to learn Oracle's PL/SQL programming language.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
17 Lectures
04:10:00
+
Introduction
1 Lecture 04:50
+
Setting Up Your Sandbox
1 Lecture 09:03
+
PL/SQL Language Fundamentals
4 Lectures 57:40
Primitive Datatypes and PL/SQL Syntax Elements
19:55

Primitive Datatypes and PL/SQL Syntax Elements Quiz
3 questions

User-Defined Data Types and Structures
09:52

Lecture 4 Quiz
3 questions

Flow Control
12:23

Lecture 5 Flow Control Quiz
3 questions

Variable Scope and Exception Management
15:30

Lecture 6 Scope and Error Handling Quiz
3 questions
+
Building Real-World PL/SQL Components
8 Lectures 02:08:13
Triggers Part 1
19:16

Triggers Part 1 Quiz
3 questions

Triggers Part 2
12:29

Triggers Part 2 Quiz
3 questions

Procedures Part 1 Parsing an External XML File
19:41

Section 3 Lecture 9 Procedures Part 1 Quiz
4 questions

Procedures Part 2 External Directory Listing
14:54

Procedures Part 2 Quiz
3 questions

Functions Part 1 Password Strength Calc
18:39

Functions Part 1 Quiz
3 questions

Functions Part 2 Pick Next Play
14:26

Functions Part 2 Quiz
3 questions

Packages Part 1
13:43

Packages Part 2
15:05

Packages Quiz
3 questions
+
Course Overview and Summary
3 Lectures 50:14
Summary and Overview Part 1
17:39

Summary and Overview Part 2
16:49

Summary and Overview Part 3
15:46
About the Instructor
Dr. Rick Phillips
4.3 Average rating
206 Reviews
11,470 Students
4 Courses
PhD with 25+ years computer industry experience

I received my Ph.D. from the University of Wisconsin in Visual Psychophysics with a minor in Computer Science.  I worked my entire professional career within the computer industry specializing in relational database design and large-scale international databases.

Out of school, I went to work for VeriFone the credit card processing company because they were headquartered in Hawaii and I yearned to get out of the cold of Wisconsin.  I started as employee #36.  By the time I left, they were publically traded, had thousands of employees and billions in revenue.  At the time of my departure, I was VeriFone's Database Design Manager and oversaw a technical staff of 125+.

I subsequently served as MIS Manager for Family Health International, Database Manager for A4 Health Systems, and CTO and President of Castle Worldwide.  I retired from Castle in 2014 at the age of 55.

After retirement I was searching for a great means to keep my hands in technology.  Teaching with Udemy has provided that venue.  I enjoy creating the courses and interacting with the students.  It is my new passion.  Middle aged and young people are my favorite students - seeing them better utilize their new toys and skills gives me great pleasure, such energy.

I am a huge advocate of life-long learning and love this opportunity to share that passion with others.  Remember, "keep on learning."