What you'll 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.

Course content

3 sections • 34 lectures • 4h 16m total length

About course5:33
In this introduction lecture I talk about course expectations, goals and its structure.
History of PL/SQL (optional)4:50
In this lecture I talk about the history of programming languages, SQL and PL/SQL.
Installing Oracle Express Edition (optional)5:03
In this lecture I guide through Oracle Database Express Edition installation process
Connecting to Database7:31
In this lecture I explain what the TNS entry is and how to connect to Oracle
Installing SQL Developer (optional)5:48
In this lecture I guide through the SQL Developer installation process

Relational Model10:15
In this lecture I have talked about basic elements of tables and relationship between tables
Relational Model quiz
Relational Operations. Primitive Operations3:47
In this lecture we will learn about first three primitive operations on entities
Quiz on Primitive Relational Operations
Relational Operations. Set Operations4:17
This lecture will explain what kind of set operations are there that have correspondent implementations in SQL
Quiz on Set Operations
Relational Operations. Joins14:23
In this lecture we will learn joins between entities such as INNER JOIN, OUTER JOIN etc
Quiz on Joins
Database Normalization (optional)9: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)5:39

Oracle SQL Data Types (part 1/2)12:08
In this lecture I describe the oracle built in data types
Oracle SQL Data Types (part 2/2)13:57
This is the second part of the lecture about SQL data types
Quiz on SQL data types
Create and unlock users4:27
In this short lecture we are learning how to create, alter, and drop oracle users
Quiz on Create User
Basic operations12: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
Select statement9: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
Where clause and Conditions18: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
GROUP BY, ORDER BY clauses and JOINS15:55
In this lecture we will learn how to aggregate, sort and join data
Quiz on Group by, order by and Joins
Transaction, Commit, Rollback5:28
Quiz on Transaction, Commit, Rollback
Insert statement15:14
Quz on Insert statement
Update statement7:42
Quiz on Update statement
Delete and Truncate statements2:17
Quiz on DELETE and TRUNCATE
Merge statement4:07
Quiz on Merge statement
Grants and Roles7:04
Quiz on Grants And Roles
Directory2:30
Quiz on Directories
Constraints3:33
Quiz on Constraints
Table (Part 1/2)6:24
Quiz on Tables (part 1/2)
Table (Part 2/2)7:20
Quiz on Tables (part 2/2)
Index and IOT7:06
Quiz on Index and IOT
View and Materialized View6:42
Quiz on View and Materialized View
Sequence2:58
Quiz on Sequence
Oracle Supplied SQL Functions10:02
Quiz on Oracle supplied Functions
SQL Case statement4:32
Wrap Up1:00

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 this course is for:

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

What you'll learn

Explore related topics

Course content

Introduction5 lectures • 29min

Relational Database6 lectures • 48min

ORACLE SQL23 lectures • 3hr 1min

Requirements

Description

Who this course is for: