A Comprehensive Oracle PL/SQL Course Taught By Infinite Skills
In this training course by Infinite Skills on Oracle PL/SQL Programming, you will learn how to utilize the procedural language extension for SQL in the Oracle relational database. Lewis Cunningham is one of an elite group of Oracle ACE Directors, and a certified PL/SQL developer. With over 15 years experience modelling, developing and architecting Oracle databases, you are learning from one of the best in the industry.
What you’ll learn
- To Master Oracle PL/SQL – Learn From A Leading Expert.
Course Content
- Introduction –> 3 lectures • 8min.
- An Overview Of PL/SQL –> 12 lectures • 1hr 21min.
- Data Types In Detail –> 4 lectures • 17min.
- Complex Data Structures –> 5 lectures • 24min.
- Programming PL/SQL –> 3 lectures • 15min.
- A First Program –> 4 lectures • 23min.
- Flow Control –> 4 lectures • 24min.
- Functions –> 3 lectures • 20min.
- Exception Handling –> 5 lectures • 30min.
- SQL In PL/SQL –> 6 lectures • 37min.
- Packages –> 9 lectures • 49min.
- Triggers –> 4 lectures • 17min.
- PL/SQL Objects –> 5 lectures • 34min.
- Dynamic SQL –> 7 lectures • 1hr.
Requirements
In this training course by Infinite Skills on Oracle PL/SQL Programming, you will learn how to utilize the procedural language extension for SQL in the Oracle relational database. Lewis Cunningham is one of an elite group of Oracle ACE Directors, and a certified PL/SQL developer. With over 15 years experience modelling, developing and architecting Oracle databases, you are learning from one of the best in the industry.
Starting with the basic outline of what PL/SQL is, you will set the ground work for your knowledge expansion by learning about data types, flow control, errors, and more. You will explore strings, numbers, booleans, and arrays. From there, Lewis jumps into creating programs, using if statements, loops functions, how to handle exceptions, using packages, and even objects. This computer based training tutorial really is an in-depth look at programming with PL/SQL like no other out there!
By the conclusion of this video training tutorial, you will be fully versed in the use of the Oracle PL/SQL for getting the most out of your Oracle databases. Extensive working files are included so you can work alongside the author as he trains you in the use PL/SQL.