Beginners guide Oracle PLSQL Part 1

Beginners guide Oracle PL/SQL Part 1, available at Free, has an average rating of 4.3, with 39 lectures, 2 quizzes, based on 10 reviews, and has 624 subscribers.

You will learn about What PL/SQL is. LIVESQL Variables Variables Naming Rules & Conventions Control Structures (IF,IF ELSE,FOR LOOP,WHILE LOOP) Composite Data Types(Records,Varrays, Associative Arrays,Nested Tables) This course is ideal for individuals who are SQL Developers or Programmers It is particularly useful for SQL Developers or Programmers.

Enroll now: Beginners guide Oracle PL/SQL Part 1

Summary

Title: Beginners guide Oracle PL/SQL Part 1

Price: Free

Average Rating: 4.3

Number of Lectures: 39

Number of Quizzes: 2

Number of Published Lectures: 39

Number of Published Quizzes: 2

Number of Curriculum Items: 42

Number of Published Curriculum Objects: 42

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

What PL/SQL is.

LIVESQL

Variables

Variables Naming Rules & Conventions

Control Structures (IF,IF ELSE,FOR LOOP,WHILE LOOP)

Composite Data Types(Records,Varrays, Associative Arrays,Nested Tables)

Who Should Attend

SQL Developers

Programmers

Target Audiences

SQL Developers

Programmers

Course Overview: In this course, we will use Oracle LiveSQL, a free and accessible platform, to practice and hone our PL/SQL skills without the need to install any software. This approach allows us to focus entirely on learning PL/SQL rather than dealing with installation issues.

What You Will Learn:

1. Introduction to PL/SQL:

2. Understand the basics of PL/SQL and how it integrates with SQL.

3. Learn the advantages of using PL/SQL with Oracle databases.

4. PL/SQL Blocks and Syntax:

5. Explore the structure of PL/SQL blocks, including anonymous blocks, procedures, and functions.

6. Write and execute your first PL/SQL block.

7. Control Structures:

8. Master control structures such as IF statements, loops, and CASE statements to create dynamic and flexible code.

9. SQL in PL/SQL:

10. Learn how to embed SQL statements within PL/SQL blocks for seamless data manipulation.

11. Perform CRUD operations (Create, Read, Update, Delete) using PL/SQL.

12. Error Handling:

13. Implement robust error handling techniques using EXCEPTION blocks.

14. Learn to catch and handle predefined and user-defined exceptions.

15. Composite Data Types:

16. Explore records and collections to handle complex data structures.

17. Use associative arrays, nested tables, and VARRAYs in your PL/SQL programs.

18. Practical Examples and Assignments:

19. Gain hands-on experience with practical examples and assignments designed to reinforce your learning.

20. Work through real-world scenarios, such as salary calculations and employee management.

Course Projects: Throughout the course, you will work on several mini-projects:

Creating a copy of the employees table and performing operations on it.

Inserting, updating, selecting, and deleting records using PL/SQL.

Implementing error handling and using cursors for data retrieval.

Course Structure: This course is divided into two parts due to Udemy’s new rule limiting free video length to a maximum of 2 hours. The complete course would take 4-6 hours, so I decided to split it into two parts. Part 2 will be completed by July 15.

By the end of this course, you will have a solid understanding of PL/SQL and be able to write efficient and maintainable PL/SQL code for Oracle databases. Whether you are a beginner or looking to enhance your database programming skills, this course is designed to meet your needs. Join us and start your journey to mastering PL/SQL today!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Prerequisites

Lecture 3: WHY PART 1 and PART 2

Lecture 4: NEED HELP ?

Lecture 5: Important

Chapter 2: LIVE SQL

Lecture 1: LIVESQL

Lecture 2: Why LIVESQL.

Chapter 3: What is PLSQL?

Lecture 1: What is PLSQL?

Chapter 4: Variables in PLSQL

Lecture 1: Variables

Lecture 2: Naming Rules & Conventions

Lecture 3: Using %TYPE Attribute

Lecture 4: Review

Chapter 5: Control Structures

Lecture 1: What are Control Structures?

Lecture 2: PLSQL IF Statement

Lecture 3: LAB IF Statments

Lecture 4: Case Statement

Lecture 5: LAB Case Statment

Lecture 6: Iterative Control (Loops)

Lecture 7: LAB Iterative Control

Lecture 8: GOTO Statement

Lecture 9: LAB GOTO Statement

Lecture 10: PLSQL Exception Handeling

Lecture 11: LAB Exception Handeling

Lecture 12: Assigment 1: Using Basic Loop.

Lecture 13: Solution (Assigment 1): Using Basic Loop.

Lecture 14: Assignment 2 (FOR LOOP)

Lecture 15: Solution (Assignment 2 FOR LOOP)

Lecture 16: Assignment 3 (WHILE LOOP):

Lecture 17: Solution (Assignment 3 WHILE LOOP):

Chapter 6: Using SQL in PL/SQL

Lecture 1: Using SQL in PL/SQL

Lecture 2: LAB Using SQL in PL/SQL

Chapter 7: Composite Data Types

Lecture 1: Composite Data Types

Lecture 2: LAB Records

Lecture 3: LAB Associative Arrays

Lecture 4: LAB Nested Tables

Lecture 5: LAB Varrays

Chapter 8: Thank You and See you in Part 2

Lecture 1: Thank You and See you in Part 2

Lecture 2: Review

Lecture 3: Next Steps take your SQL skills to next level

Instructors

Aly Dawood
Programmer/Database Developer

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 2 votes

4 stars: 5 votes

5 stars: 3 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!