Oracle PL/SQL from scratch (Part I Oracle SQL)
4.3 (7 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.
139 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle PL/SQL from scratch (Part I Oracle SQL) to your Wishlist.

Add to Wishlist

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.3 (7 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.
139 students enrolled
Created by Faig Garayev
Last updated 10/2013
English
Learn Fest Sale
Current price: $10 Original price: $35 Discount: 71% off
3 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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.
View Curriculum
Requirements
  • It would help to have coding experience in different programming languages, but it is not required
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

Who is the target audience?
  • The course is intended for all that want to learn codding and designing PL/SQL and SQL scripts
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 34 Lectures Collapse All 34 Lectures 04:17:37
+
Introduction
5 Lectures 28:45

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

Preview 05:33

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

History of PL/SQL (optional)
04:50

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

Installing Oracle Express Edition (optional)
05:03

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

Connecting to Database
07:31

In this lecture I guide through the SQL Developer installation process

Installing SQL Developer (optional)
05:48
+
Relational Database
6 Lectures 47:56

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

Relational Model
10:15

Check you knowledge after lecture about Relation Model

Relational Model quiz
4 questions

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

Relational Operations. Primitive Operations
03:47

Quiz on Primitive Relational Operations
7 questions

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

Preview 04:17

Quiz on Set Operations
11 questions

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

Preview 14:23

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

Database Normalization (optional)
09:35

Star and Snowflake schemas (optional)
05:39
+
ORACLE SQL
23 Lectures 02:59:56

In this lecture I describe the oracle built in data types

Oracle SQL Data Types (part 1/2)
12:08

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

Oracle SQL Data Types (part 2/2)
13:57

Quiz on SQL data types
12 questions

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

Create and unlock users
04:27

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.

Basic operations
12:00

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.

Select statement
09:54

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

Where clause and Conditions
18:36

Quiz on Where clause and Conditions
28 questions

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

GROUP BY, ORDER BY clauses and JOINS
15:55

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
About the Instructor
Faig Garayev
4.3 Average rating
7 Reviews
139 Students
1 Course
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.