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.
120 students enrolled
$19
$35
46% 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

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 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.

What 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.

Curriculum

Section 1: Introduction
05:33

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

04:50

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

05:03

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

07:31

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

05:48

In this lecture I guide through the SQL Developer installation process

Section 2: Relational Database
10:15

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

03:47

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

Quiz on Primitive Relational Operations
7 questions
04:17

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

Quiz on Set Operations
11 questions
14:23

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

Quiz on Joins
16 questions
09:35

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)
05:39
Section 3: ORACLE SQL
12:08

In this lecture I describe the oracle built in data types

13:57

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

Quiz on SQL data types
12 questions
04:27

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

Quiz on Create User
3 questions
12:00

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
09:54

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
18:36

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
15:55

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
05:28
Quiz on Transaction, Commit, Rollback
19 questions
Insert statement
15:14
Quz on Insert statement
13 questions
Update statement
07:42
Quiz on Update statement
7 questions
Delete and Truncate statements
02:17
Quiz on DELETE and TRUNCATE
7 questions
Merge statement
04:07
Quiz on Merge statement
3 questions
Grants and Roles
07:04
Quiz on Grants And Roles
21 questions
Directory
02:30
Quiz on Directories
6 questions
Constraints
03:33
Quiz on Constraints
12 questions
Table (Part 1/2)
06:24
Quiz on Tables (part 1/2)
12 questions
Table (Part 2/2)
07:20
Quiz on Tables (part 2/2)
18 questions
Index and IOT
07:06
Quiz on Index and IOT
20 questions
View and Materialized View
06:42
Quiz on View and Materialized View
11 questions
Sequence
02:58
Quiz on Sequence
7 questions
Oracle Supplied SQL Functions
10:02
Quiz on Oracle supplied Functions
28 questions
SQL Case statement
04:32
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