Oracle PL/SQL Essential Training.

The ultimate PL/SQL beginners guide.
4.0 (1 rating) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
5 students enrolled
Instructed by Victor Ebai IT & Software / Other
$19
$40
52% off
Take This Course
  • Lectures 63
  • Length 2.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 5/2015 English

Course Description

Master the basic concepts, tools and techniques that you will need to create fully functional, robust and portable oracle PL/SQL applications.

Build a Powerful Foundation in PL/SQL With This Course For Beginners.

Oracle 11g and SQL developer installation and configuration.

Anonymous blocks, subprograms, exceptions, triggers and packages.

Transaction control statements. Loops, conditionals and sequence.

A powerful and lucrative skill at your fingertips.

Mastering the fundamentals of PL/SQL puts a very lucrative skill at your fingertips. Oracle and SQL developer are free, easy to learn and use. PL/SQL is the only language used to build business logic within an oracle database. Jobs in PL/SQL development are plentiful and very lucrative. Mastering PL/SQL could double your income if you are already an SQL developer. This is true for other third generation developers (c++, java). PL/SQL will help you improve performance by pushing your business logic to the database.

Content and Overview.

Suitable for beginning programmers, through this course of 63 lectures over two and a half hours, you will learn PL/SQL fundamentals and establish a powerful understanding of the concepts behind procedural programming. Each chapter ends with a recap and a quiz to reinforce your knowledge.

Starting with the installation and configuration of oracle and SQL developer, through lexical units to variables. Next you create anonymous blocks which will establish a strong understanding of variables and the DBMS_OUTPUT package.

With the basics mastered, the course will take you through advanced topics like flow control (loops, GOTO), subprograms (functions and procedures) and transaction control (SAVEPOINT, ROLLBACK).

After completing this course, you will have the skills to build professional, production ready, business applications. You will also be able to answer 100 practical PL/SQL interview questions.

The course includes working code samples which you could adapt for your study or professional projects.

What are the requirements?

  • Check your computer processor type (32 or 64 bit operating system). On windows go to the start menu and right click on the “This PC” option. You will need this to determine which version of oracle to download.

What am I going to get from this course?

  • Write fast optimised PL/SQL programs
  • Answer tricky interview and exam questions.
  • Hit the ground running on a new job with a PL/SQL component.
  • Be able to build end to end PL/SQL applications.

What is the target audience?

  • This course is meant for newbies who are not familiar with PL/SQL syntax. It could also serve as a refresher for intermediate level PL/SQL developers. However, a beginner to intermediate level competence in SQL is highly recommended. No previous procedural programming experience is required.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting Started With PL/SQL
Welcome To Oracle PL/SQL Essential Training.
Preview
01:03
Prerequisites and Install oracle
Preview
03:53
The Hr Schema and SQL Developer
Preview
06:35
Conclusion
00:29
Section 2: Introduction to PL/SQL
Introduction and Overview of PL/SQL
03:49
Data Types and Lexical Units
04:37
Identifiers and Literals
05:27
Delimiters and Comments
02:45
Conclusion
00:42
Quiz 1
9 questions
Section 3: Anonymous Blocks
Creating Anonymous Blocks
03:50
Executable Blocks containing Variables
05:26
Variables and Nested Bocks
02:27
Conclusion
00:41
Quiz 2
12 questions
Section 4: Flow Control Statements
Conditional Flow Control Statements (IF THEN ELSE)
03:00
Conditional Flow Control Statements (CASE)
02:12
Iterative Control Statements Simple Loop
01:50
Iterative Control Statements (WHILE LOOP)
01:47
Iterative Control Statements (FOR LOOP)
01:05
Sequential Control Statements (GOTO)
02:30
Using the CONTINUE Statement to manage Iteration
01:41
Conclusion 4
00:53
Quiz 3
12 questions
Section 5: Composite Data Types.
Composite Data Types and Records.
04:16
Assigning Values to Record Fields
02:22
Composite Data Types and Collections
02:42
Collection Methods and Composite Index By Tables
02:39
Compostie Data Types and Nested Tables
01:54
Conclusion 5
00:46
Quiz 4
10 questions
Section 6: Introduction to Cursors
Introduction to Cursors
05:11
Explicit Cursor FOR LOOPs
01:19
Implicit Cursor FOR LOOP
01:03
Introducing Parameters in Cursors
01:25
Oracle REF CURSOR
02:00
Conclusion 6
00:43
Quiz 5
9 questions
Section 7: Subprograms, Procedures, Functions, and Parameters
Subprograms
04:49
Subprogram Parameters
02:44
Procedures
05:08
Functions
04:08
Functions Returning Composite Data Types
01:38
Conclusion
01:00
Quiz 6
10 questions
Section 8: Error Handling
Error Handling and Named Predefined Exceptions.
04:18
Using SQLCODE and SQLERRM in WHEN OTHERS Statement
01:31
Unnamed Predefined Exceptions
01:56
User-Defined Business Exceptions
01:39
The raise_application_error Procedure
01:34
Exception Dependency
02:54
Conclusion
00:58
Quiz 7
11 questions
Section 9: PL/SQL Transaction Processing
Introduction to PL/SQL Transaction Processing
02:51
ROLLBACK Using EXCEPTION Handlers
01:36
SAVEPOINT Using COMMIT, EXCEPTION Handlers, and ROLLBACK
02:00
Conclusion
00:49
Quiz 8
8 questions
Section 10: Introduction to PL/SQL Packages
PL/SQL Packages
03:14
Creating Package Specifications without Bodies
01:27
Creating Package Specifications with Package Bodies
01:46
Extending Package Functionality by Overloading Subprograms
02:37
Oracle Built-in Packages: The UTIL_File Package
02:36
Using the UTIL_FILE Package
04:53
The DBMS_SCHEDULER Built in package
04:03
Dynamic SQL
04:39
Conclusion
01:01
Quiz 9
10 questions
Section 11: Triggers
Introduction to Triggers
02:35
System Level Triggers
05:15
Table Level DML Trigger
03:02
Final conclsion.
00:56
Quiz 10
10 questions

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Victor Ebai, Senior Business Intelligence Consultant

Hi there! I'm Victor and I am a senior business intelligence consultant for high tech and financial corporations. Some of my previous clients include SAP AG, Oracle, Lloyds Bank, O2, and HSBC. I am currently working on big data and SAP Hana projects. I am also a published author and public speaker.

My role for the last 15 years generally involves leading the delivery of business intelligence solutions. Specifically, this includes integrating data warehouse databases (oracle, SQL server) with ETL (SAP data services) and reporting t (SAP crystal reports, web intelligence) to give the best insights to senior management.

My motivation to create Udemy courses is two fold. First, I struggled for years to master PL/SQL and other programming languages. The second reason is that, when I interview unsuccessful candidates for PL/SQL roles, their understanding of the fundamental principles was always lacking.

Thus I decided to create simple, clear, coherent and concise courses which will prepare students for their professional life. Just so they do not struggle as much as I did when I was coming up.

Ready to start learning?
Take This Course