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:
- development of a password strength function,
- parsing XML files,
- reading an external directory, and
- 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.