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
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
In this lecture I have talked about basic elements of tables and relationship between tables
Check you knowledge after lecture about Relation Model
In this lecture we will learn about first three primitive operations on entities
This lecture will explain what kind of set operations are there that have correspondent implementations in SQL
In this lecture we will learn joins between entities such as INNER JOIN, OUTER JOIN etc
In this optional lecture I will introduce conceptions of normalization and de-normalization. We will review first three normal forms
In this lecture I describe the oracle built in data types
This is the second part of the lecture about SQL data types
In this short lecture we are learning how to create, alter, and drop oracle users
Before we can continue we need to learn what are basic elements of SQL. This lecture will introduce them to you.
This is the first DML statement we are describing: SELECT stataement. We are going to learn to write simple queries.
If you need to filters you DML operation such as SELECT, UPDATE, INSERT, or MERGE then watch this lecture
In this lecture we will learn how to aggregate, sort and join data
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.