Development Online Course by Udemy, On Sale Here
Learn about Oracle’s Extension to SQL
An excellent training about Database Design & Development
PL /SQL For Beginners
PL /SQL is Oracle database’s version of the standard SQL. The PL in the SQL stands for Procedural language and combines it’s programming abilitieswith SQL to make Oracle database’s robust and run more efficiently. It includes the standard SQL language as well as Oracle’s proprietary extensions to the standardSQL language. PL/SQL is high performance and portable. PL/SQL can also be accessed from the command line using oracle’s database built in SQL*Plus. PL/SQL is closely integrated with SQL and supports various data types. PL/SQL can also be used in developing web applications and supports object -oriented programming. PL/SQL allows you to create procedures, functions, cursors and Triggers. In this course we will setup a test environment from scratch by downloading and installing sample oracle database and TOAD. Once we have our lab fully setup we will then start writing proper PL/SQL syntax. What You Will Learn in this course: How to write PL/SQL syntaxHow to write proceduresHow to create functionsHow to create cursorsHow to create TriggersHow to insert PL/SQL commentsThe SQL in the PL/SQL is similar to how the standard SQL is used. The way you write a standard Create, Read (Select),update and delete is similar. Oracle’s procedural language is used to add extra functionalities to the SQL language. At the end of this course you should have the basic skills to write PL/SQL syntax and create procedures, triggers, cursors and functions. Youwill also know how to use the delimiters. Welcome to the course.
Udemy is the leading global marketplace for learning and instruction
By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams.
Study anytime, anywhere.
Reviews
There are no reviews yet.