Coursera
SubscriptionBeginners guide Oracle PL/SQL Part 1
4.5(202)3k studentsBEGINNEREnglish
UdemyUdemyMark your own learning status. Opening a course link does not establish enrollment.
Loading saved status…
This first part teaches PL/SQL in Oracle LiveSQL, a browser-based environment, so you can practise without setting up software. The approach keeps attention on the language itself rather than on installation problems.
The early material introduces the language and its link to SQL, then the structure of anonymous blocks, procedures and functions. Control flow comes next, including IF statements, loops and CASE, followed by embedding SQL in PL/SQL to create, read, update and delete data.
Error handling with EXCEPTION blocks covers predefined and user-defined exceptions. Composite types such as records and collections are introduced, including associative arrays, nested tables and VARRAYs.
Practice centres on mini-projects built around an employees table, with salary calculations and cursor-based retrieval. The description presents this as part 1 of a two-part course, so the second part is a separate study step.
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:
Introduction to PL/SQL:
Understand the basics of PL/SQL and how it integrates with SQL.
Learn the advantages of using PL/SQL with Oracle databases.
PL/SQL Blocks and Syntax:
Explore the structure of PL/SQL blocks, including anonymous blocks, procedures, and functions.
Write and execute your first PL/SQL block.
Control Structures:
Master control structures such as IF statements, loops, and CASE statements to create dynamic and flexible code.
SQL in PL/SQL:
Learn how to embed SQL statements within PL/SQL blocks for seamless data manipulation.
Perform CRUD operations (Create, Read, Update, Delete) using PL/SQL.
Error Handling:
Implement robust error handling techniques using EXCEPTION blocks.
Learn to catch and handle predefined and user-defined exceptions.
Composite Data Types:
Explore records and collections to handle complex data structures.
Use associative arrays, nested tables, and VARRAYs in your PL/SQL programs.
Practical Examples and Assignments:
Gain hands-on experience with practical examples and assignments designed to reinforce your learning.
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!
Advertisement
No Korshub reviews yet.
