Oracle PL/SQL from scratch (Part I Oracle SQL)

Learn Oracle PL/SQL from scratch. Start from beginning and master intermediate and advance topics
4.0 (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.
128 students enrolled
Sale Ends Today!
57% off
Take This Course
  • Lectures 34
  • Length 4.5 hours
  • Skill Level All Levels
  • 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


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


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

About This Course

Published 10/2013 English

Course Description

This course will teach you how to start programming in Oracle PL/SQL. Course is designed to be a guide not only for those that completely new in computer programming but also for those that has quite experience in different programming languages as well as for those that had already had pleasure to code in PL/SQL.

I will shoot all my lectures from my laptop by sharing the screen. At the end of most lectures I will post quizzes as well as scripts used in lecture.

The lectures are going to include mostly practical examples with explanations.

I will keep adding the contest and lectures so even after you completed the course you can come back for more.

Course will have three type of lectures: beginner, intermediate and advanced. For those who are just starting with PL/SQL I would highly recommend to watch all the lectures for beginner first before switching to the next intermediate and advanced topics.

The lectures will switch back and force between PL/SQL and SQL topics.

Beginners PL/SQL developers earn $30-40 per hour USA and there is growing demand for new programmers.

Little bit about myself. I have more than 13 years of experience designing and coding in Oracle PL/SQL. I love this powerful language and I am passioned about it. I hope I will be able to infect you with my love to PL/SQL

What are the requirements?

  • It would help to have coding experience in different programming languages, but it is not required

What am I going to get from this course?

  • Course is designed to be a guide not only for those that completely new in computer programming but also for those that has quite experience in different programming languages as well as for those that had already had pleasure to code in PL/SQL.
  • After completing this course you will be able to start working as PL/SQL developer.

Who is the target audience?

  • The course is intended for all that want to learn codding and designing PL/SQL and SQL scripts

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.


Section 1: Introduction

In this introduction lecture I talk about course expectations, goals and its structure.


In this lecture I talk about the history of programming languages, SQL and PL/SQL.


In this lecture I guide through Oracle Database Express Edition installation process


In this lecture I explain what the TNS entry is and how to connect to Oracle


In this lecture I guide through the SQL Developer installation process

Section 2: Relational Database

In this lecture I have talked about basic elements of tables and relationship between tables

4 questions

Check you knowledge after lecture about Relation Model


In this lecture we will learn about first three primitive operations on entities

Quiz on Primitive Relational Operations
7 questions

This lecture will explain what kind of set operations are there that have correspondent implementations in SQL

Quiz on Set Operations
11 questions

In this lecture we will learn joins between entities such as INNER JOIN, OUTER JOIN etc

Quiz on Joins
16 questions

In this optional lecture I will introduce conceptions of normalization and de-normalization. We will review first three normal forms

Star and Snowflake schemas (optional)
Section 3: ORACLE SQL

In this lecture I describe the oracle built in data types


This is the second part of the lecture about SQL data types

Quiz on SQL data types
12 questions

In this short lecture we are learning how to create, alter, and drop oracle users

Quiz on Create User
3 questions

Before we can continue we need to learn what are basic elements of SQL. This lecture will introduce them to you.

Quiz on Basic Operations
12 questions

This is the first DML statement we are describing: SELECT stataement. We are going to learn to write simple queries.

Quiz on Select statement
14 questions

If you need to filters you DML operation such as SELECT, UPDATE, INSERT, or MERGE then watch this lecture

Quiz on Where clause and Conditions
28 questions

In this lecture we will learn how to aggregate, sort and join data

Quiz on Group by, order by and Joins
15 questions
Transaction, Commit, Rollback
Quiz on Transaction, Commit, Rollback
19 questions
Insert statement
Quz on Insert statement
13 questions
Update statement
Quiz on Update statement
7 questions
Delete and Truncate statements
7 questions
Merge statement
Quiz on Merge statement
3 questions
Grants and Roles
Quiz on Grants And Roles
21 questions
Quiz on Directories
6 questions
Quiz on Constraints
12 questions
Table (Part 1/2)
Quiz on Tables (part 1/2)
12 questions
Table (Part 2/2)
Quiz on Tables (part 2/2)
18 questions
Index and IOT
Quiz on Index and IOT
20 questions
View and Materialized View
Quiz on View and Materialized View
11 questions
Quiz on Sequence
7 questions
Oracle Supplied SQL Functions
Quiz on Oracle supplied Functions
28 questions
SQL Case statement
Wrap Up
1 page

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Faig Garayev, Solution, Data and BI Architect, PMP, PhD

I have graduated from Baku State University (Baku, Azerbaijan) in 2003 and got PhD in economics in 2007 from Institute of Cybernetics of Azerbaijan Academy of Science.

Started my career as Delphi developer and currently holding Solution Architect position in one of biggest USA retail chain.

I am IT Team Lead and Project manager with more than 13 year IT software development experience in taxation, inventory management and marketing research.

Ready to start learning?
Take This Course