Oracle relational databases are currently one of the most popular databases on the market, with a lot of companies looking to use these databases within their infrastructure. Oracle databases are often use Java and SQL for programming, but it wasn’t giving the results that Oracle wanted, which is why they designed the PL/SQL language to add the procedural features of programming languages, making the databases more moldable to the programmer’s needs.
PL/SQL is a procedural language designed specifically to embrace SQL statements within its syntax. The program units are compiled by the Oracle Database server and are commonly stored within the server itself. At run time, the PL/SQL and SQL run at the same time and within the same server process, saving time and offering optimal efficiency.
If you want to become a successful database engineer, then PL/SQL is a very handy language to have on hand. And this course is a great way to actually learn!
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. At the end of this course, you will not only have the theoretical knowledge of how PL/SQL works and its basics, but you will also understand how you can manipulate the RDBMS using PL/SQL, as well as how to practically put these coding process in view.
The course is designed for intermediate database developers, and will not go into details about RDBMS, Oracle databases or even Java. It will directly jump into PL/SQL, so the developers should have prior knowledge of SQL in order to fully understand the course.
What you will find in this course:
Introduction to PL/SQL
Setting up your Sandbox
Building real-world PL/SQL components including:
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.
Enroll now and master PL/SQL programming!
About the Instructor
Dr. Rick Phillips
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. 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."
Frequently Asked Questions
It is an online tutorial that covers a specific part of a topic in several sections. An Expert teaches the students with theoretical knowledge as well as with practical examples which makes it easy for students to understand.
A Course helps the user understand a specific part of a concept. While a path and E-Degrees are broader aspects and help the user understand more than just a small area of the concept.
A Course will help you understand any particular topic. For instance, if you are a beginner and want to learn about the basics of any topic in a fluent manner within a short period of time, a Course would be best for you to choose.
We have an inbuilt question-answer system to help you with your queries. Our support staff will be answering all your questions regarding the content of the Course.
People interested in this course also viewed
How it works
The offer includes all live courses, Deals and E-Degrees.
Bogo Offer will be applied automatically upon adding 2nd Course, Deal or E-degree in the Cart. Offer Price will be reflected in Checkout Total
You can buy multiple courses or deals using your cart but they have to be in combo of 2 to get benefit of the offer.
We are free to withdraw any product from this offer based at our own discretion.
Please complete your profile for better search results