Oracle PL/SQL Essential Training.
3.3 (3 ratings)
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.
17 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle PL/SQL Essential Training. to your Wishlist.

Add to Wishlist

Oracle PL/SQL Essential Training.

The ultimate PL/SQL beginners guide.
3.3 (3 ratings)
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.
17 students enrolled
Created by Victor Ebai
Last updated 4/2015
English
Current price: $10 Original price: $40 Discount: 75% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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.
View Curriculum
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.
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.

Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
63 Lectures
02:42:39
+
Introduction to PL/SQL
5 Lectures 17:20
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
+
Anonymous Blocks
4 Lectures 12:24
Creating Anonymous Blocks
03:50

Executable Blocks containing Variables
05:26

Variables and Nested Bocks
02:27

Conclusion
00:41

Quiz 2
12 questions
+
Flow Control Statements
8 Lectures 14:58
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
+
Composite Data Types.
6 Lectures 14:39
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
+
Introduction to Cursors
6 Lectures 11:41
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
+
Subprograms, Procedures, Functions, and Parameters
6 Lectures 19:27
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
+
Error Handling
7 Lectures 14:50
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
+
PL/SQL Transaction Processing
4 Lectures 07:16
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
+
Introduction to PL/SQL Packages
9 Lectures 26:16
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
1 More Section
About the Instructor
Victor Ebai
3.3 Average rating
3 Reviews
17 Students
1 Course
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.