Disclosure: when you buy through links on our site, we may earn an affiliate commission.

PL/SQL by Example – Beginner to Advanced PL/SQL

Using PL/SQL learn how to combine the efficiency of SQL & Procedural Language(PL) to build a powerful PL/SQL Application
4.5
4.5/5
(5,236 reviews)
23,596 students
Created by

8.6

CourseMarks Score®

6.9

Freshness

9.1

Feedback

9.1

Content

Platform: Udemy
Video: 5h 41m
Language: English
Next start: On Demand

Top Pl/SQL courses:

Detailed Analysis

CourseMarks Score®

8.6 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness Score

6.9 / 10
This course was last updated on 12/2018 .

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Student Feedback

9.1 / 10
We analyzed factors such as the rating (4.5/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Content Score

9.1 / 10
Video Score: 8.4 / 10
The course includes 5h 41m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
The average video length is 8 hours 19 minutes of 23 Pl/SQL courses on Udemy.
Detail Score: 9.3 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 9.5 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

0 article.
4 resources.
0 exercise.
0 test.

Table of contents

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.
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 CursorsSoftwares used
•Oracle Database 11g•SQL Developer

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
✓ Create anonymous PL/SQL blocks, functions and procedures
✓ Use PL/SQL packages to group and contain related constructs
✓ Catch run time errors using Exceptions
✓ Perform Data processing using Records and Cursors
✓ Manage data using Collections
✓ Create triggers to solve business challenges
✓ Peform Bulk Processing to improve performance
✓ Execute SQL using Dynamic SQL
✓ Pipelining the data as it is processed
✓ Working with Large Objects (LOB’s)

Requirements

• SQL Knowledge is needed and is a must!!!

This course is for

• This PL/SQL course is meant for students who want to learn Procedure Language to control SQL Statements.
• This course is not for you if you’re looking to learn more advanced concepts of PL/SQL

How much does the PL/SQL by Example - Beginner to Advanced PL/SQL course cost? Is it worth it?

The course costs $21.99. And currently there is a 82% discount on the original price of the course, which was $124.99. So you save $103 if you enroll the course now.
The average price is $13.3 of 23 Pl/SQL courses on Udemy.

Does the PL/SQL by Example - Beginner to Advanced PL/SQL course have a money back guarantee or refund policy?

YES, PL/SQL by Example – Beginner to Advanced PL/SQL has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any SCHOLARSHIPS for this course?

Currently we could not find a scholarship for the PL/SQL by Example - Beginner to Advanced PL/SQL course, but there is a $103 discount from the original price ($124.99). So the current price is just $21.99.

Who is the instructor? Is Amarnath Reddy a SCAM or a TRUSTED instructor?

Amarnath Reddy has created 9 courses that got 18,972 reviews which are generally positive. Amarnath Reddy has taught 82,477 students and received a 4.5 average review out of 18,972 reviews. Depending on the information available, Amarnath Reddy is a TRUSTED instructor.
Oracle Architect & Best Selling Instructor | 27000+ Students
Amarnath has a Masters Degree in computer science with around 15 years of experience in the IT industry. He has successfully designed and implemented projects for clients in South Africa, India and USA. Currently his main focus is on Datawarehouse Architecture.
Amarnath is currently working for a fortune 500 company in USA and has pioneered the data architecture discipline. His Innovative and simple architectural designs have won accolades in the company.
Today, he brings leadership and technical expertise to enable customers to optimize and modernize their IT environments leveraging Business Intelligence tools, Big Data, social, mobile, and the Internet of Things.

8.6

CourseMarks Score®

6.9

Freshness

9.1

Feedback

9.1

Content

Platform: Udemy
Video: 5h 41m
Language: English
Next start: On Demand

Students are also interested in

Review widget (for course creators):

PL/SQL by Example - Beginner to Advanced PL/SQL rating
Code for the widget (just copy and paste it to your site):
<a href="https://coursemarks.com/course/pl-sql-by-example-beginner-to-advanced-pl-sql/" target="_blank" title="PL/SQL by Example – Beginner to Advanced PL/SQL on Coursemarks.com"><img border="0" src="https://coursemarks.com/widget/86.svg" width="200px" alt="PL/SQL by Example – Beginner to Advanced PL/SQL rating"/></a>