Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
PL/SQL Programming with Real-World Examples
Rating: 4.2 out of 5(42 ratings)
3,365 students

PL/SQL Programming with Real-World Examples

Oracle Internal Programming Techniques and Strategies
Created byRick Phillips
Last updated 7/2017
English

What you'll 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.

Course content

5 sections • 17 lectures • 4h 10m total length

  • Introduction4:50

    Explore real-world PL/SQL programming with hands-on setup, sandboxing, and an example schema. Learn language fundamentals, triggers, procedures, functions, and packages through practical, code-heavy examples.

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 this course is for:

  • Anyone seeking to learn Oracle's PL/SQL programming language.

Report abuse