Course Description
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.
Curriculum
Anonymous Blocks
Associative Arrays
Calling a Function
Calling a Procedure
CASE Statemet
Collection Methods
Collection Terminology
Collections Summary
Comments in PL/SQL
Creating a Procedure
Cursor FOR Loop
Cursor Variable and Reference Cursor
Declaring Variables
Exceptions Example
Exceptions for Cursors
Executing sub programs present in Packages
Exercise #1
Exercise #2
Exercise #3
Exercise #4
Exercise #5
Exercise #6
Exercise #7
Exercise #8
Explicit Cursor
First Example
FOR Loop
How to make best use of the Program...
IF then ELSE statement
Implicit Cursor
Inserting data into database
Inserting data using Records
Installing Java SDK
Installing Oracle
Installing SQL Developer
MULTISET Operators
Nested Tables
Package Body
Package Specification
Passing Records as parameters
PL/SQL Advantages
PL/SQL Structure
Procedure with IN OUT Mode
Procedure with OUT Mode
Reading data from database
Records Example
Retrieving 1 row using Explicit Cursor
Retrieving more than 1 row using Explicit Cursor
Running scripts necessary for the course
Scope of Variables
Scripts for our Lab Exercises
Section 1: Software Installation
Section 10: Conclusion
Section 2: PL/SQL Basics
Section 3: Processing Data via PL/SQL
Section 4: PL/SQL Blocks
Section 5: Exceptions
Section 6: Packages
Section 7: Working with Records
Section 8: Cursors
Section 9: Collections
System Defined Exceptions list
Updating data using Records
User Defined Exceptions
User defined Record Example
User defined Record Types
Using Records in Cursors
Welcome...
What are Collections
What are Cursors?
What are Exceptions
What are Functions?
What are Packages
What are Procedures?
What are Records?
What are VARRAYS
What is %TYPE
What is PL/SQL
Where to go from here...
WHILE Loop
Working with Record data
LINK FOR THE FREE COURSE
100% Off, Udemy 100% Off, Udemy Coupon, Udemy Coupon Code, Udemy course, Udemy course download, Udemy course reviews, Udemy courses, Udemy courses for free, Udemy courses free, Udemy courses free download, Udemy discount, Udemy download, Udemy education, Udemy free, Udemy free course, Udemy free courses, Udemy free online courses, Udemy online, Udemy online course, Udemy online courses, Udemy online courses review, Udemy reviews, Udemy tutorial, Udemy tutorials, Udemy.com free courses,
