PL/SQL by Example - Beginner to Advanced PL/SQL
PL/SQL by Example - Beginner to Advanced PL/SQL
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
- Describe the features and syntax of PL/SQL
- Design PL/SQL anonymous blocks that execute efficiently
- Use the Oracle supplied PL/SQL packages to generate screen output
- Create and debug Stored Procedures and Functions
- Design PL/SQL packages to group related constructs
- Use PL/SQL programming constructs and conditionally control code flow
- Create overloaded package subprograms for more flexibility
- Handle runtime errors using Exceptions
- Writing manageable code using Records
- Storing and processing data using Collections
- Processing data using Implicit and Explicit Cursors
Softwares used
- Oracle Database 11g
- SQL Developer
Using PL/SQL learn how to combine the efficiency of SQL & Procedural Language(PL) to build a powerful PL/SQL Application
Url: View Details
What you will learn
- Declare PL/SQL Variables
- Conditionally control code flow (loops, control structures)
- Use some of the Oracle supplied PL/SQL packages to generate screen output
Rating: 4.46461
Level: All Levels
Duration: 5.5 hours
Instructor: Amarnath Reddy
Courses By: 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
About US
The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of course-link.com.
View Sitemap