close
Sign in
with your social network
or

sign in
Not a member? Sign up forgot password
close
Sign up
signup
Already registered? Sign in
Devops E-degree kickstarter

Updated Cookies Notice - you'll see this message only once.

We use cookies and similar technology on this website, which helps us to know a little bit about you and how you use our website. This improves the browsing experience for you and enables us to tailor better products and services to you and others. Cookies are stored locally on your computer or mobile device.
To accept cookies continue browsing as normal or go to the Cookies Notice for more information and to set your preferences.

video

PL/SQL Programming with Real World Examples

This course is designed for intermediate database developers who can learn Pl Sql tutorial with practical examples now
Instructors : Dr. Rick Phillips
$99   $5
Black Friday Offer Price
Redeem coupon
4.6 (124 reviews)
Wishlist
Lectures:
17
Video:
4 hours
Level:
All level
Languages:
English
Last Updated:
11/2017
Includes:
30 day money back guarantee! Lifetime Access. No Limits! Certificate of Completion

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
  • PL/SQL fundamentals
  • 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!

Students also bought
Back To Top