PL/SQL by Example - Udemy Coupon 100% Off

Learn how to combine the efficiency of SQL and Procedural Language(PL) to build a powerful Application.

Learn to become a PL/SQL developer in just four weeks.

This fast, easy and effective course will take you from zero PL/SQL writing skills to being able to write efficient programs to process data.

PL/SQL is the Oracle Procedural Language extension of SQL. A PL/SQL program can have both SQL statements and procedural statements. In the PL/SQL program, the SQL statements are used to access sets of data stored in a database, while the procedural statements are used to process individual piece of data and control the program flow.

In this course participants will learn

  1. Describe the features and syntax of PL/SQL
  2. Design PL/SQL anonymous blocks that execute efficiently
  3. Use the Oracle supplied PL/SQL packages to generate screen output
  4. Create and debug stored procedures and functions
  5. Design PL/SQL packages to group related constructs
  6. Use PL/SQL programming constructs and conditionally control code flow
  7. Create overloaded package subprograms for more flexibility
  8. Handle runtime errors using Exceptions
  9. Writing manageable code using Records
  10. Storing and processing data using Collections
  11. Processing data using Implicit and Explicit Cursors

Softwares used

  1. Oracle Database 11g
  2. SQL Developer

Udemy Coupon :