This Oracle 11g PL/SQL Part 2 course will be very advantageous for you to learn about developing database server-side PL/SQL program units within an Oracle database. This course covers a variety of topics which include understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. In addition to that, you’ll take the support of advanced programming techniques such as cursor variables and cursor expressions, which broadly discussed in the course. This course is ideal to prepare yourself for the Oracle certification exams (OCP).
Upon successful completion of this course, you’ll stand out from your competition while you’re chasing your dream job!
What Will I Learn?
- Prepare your environment
- Introducing Database Program Units
- Creating and Maintaining Stored Procedures & Functions
- Creating and Maintaining Packages
- Advanced Cursor Techniques
- Using System-Supplied Packages
- Creating and Maintaining Database Triggers
- Implementing System Event Triggers
Requirements
- Familiarity with database and programming principles
Who is the target audience?
- Application designers and developers
- Database administrators
- Business users and non-technical senior end users
Course Curriculum
| Introduction | |||
| Introduction | 00:03:00 | ||
| Install Oracle XE | 00:11:00 | ||
| SQL Developer Installation | 00:00:00 | ||
| Workstation Setup | 00:12:00 | ||
| Database Program Units | |||
| Introducing the Database Program Unit | 00:19:00 | ||
| Working with Stored Procedures and Functions | |||
| Creating Stored Procedures and Functions | 00:19:00 | ||
| Understanding the Parameter Specification | 00:23:00 | ||
| Executing Procedures and Functions | 00:26:00 | ||
| Calling Functions from within SQL | 00:13:00 | ||
| Handling Compilation Errors | 00:08:00 | ||
| Maintaining Stored Procedures and Functions | |||
| Recompiling and Dropping Programs | 00:16:00 | ||
| Data Dictionary Storage | 00:25:00 | ||
| Managing Dependencies | 00:13:00 | ||
| Tracking Dependencies | 00:08:00 | ||
| Using the Dependency Tracking Utility | 00:09:00 | ||
| Creating and Maintaining Packages | |||
| What Is a Package? | 00:10:00 | ||
| Creating a Package | 00:19:00 | ||
| Package Definition Information | 00:08:00 | ||
| Advanced Programming Techniques | 00:06:00 | ||
| Using Persistent Global Objects | 00:04:00 | ||
| Including Initialization Logic | 00:15:00 | ||
| Object Oriented Support within Packages | 00:14:00 | ||
| Package Maintenance | 00:18:00 | ||
| Advanced Cursor Techniques | |||
| Learning to Use Cursor Variables | 00:24:00 | ||
| Advanced Cursor Techniques Weak Cursor Definitions | 00:16:00 | ||
| REFCURSOR Cursor Definition | 00:05:00 | ||
| Using Cursor Expression | 00:14:00 | ||
| Using System Supplied Packages | |||
| Using the DBMS OUTPUT() Package | 00:12:00 | ||
| Using the UTL FILE() Package | 00:30:00 | ||
| Creating Database Triggers | |||
| Understanding the Database Trigger | 00:23:00 | ||
| Statement-Level Triggers | 00:23:00 | ||
| Row-Level Triggers | 00:12:00 | ||
| Row Level Trigger Example 1 | 00:11:00 | ||
| Row Level Trigger Example 2 | 00:07:00 | ||
| Row Level Trigger Example 3 | 00:08:00 | ||
| Working with the INSTEAD OF Trigger | 00:11:00 | ||
| Using Triggers within an Application | 00:09:00 | ||
| Trigger Maintenance | |||
| Using the CALL Statement | 00:09:00 | ||
| Trigger Maintenance Tasks | 00:12:00 | ||
| Work with Multiple Triggers for a Single Table | 00:11:00 | ||
| Handling Mutating Table Issues | 00:22:00 | ||
| Using the Compound Trigger | 00:06:00 | ||
| Working with System Event Triggers | |||
| What Is a System Event Trigger | 00:05:00 | ||
| Defining Scope | 00:04:00 | ||
| Identifying Available System Events | 00:12:00 | ||
| Conclusion | |||
| Conclusion | 00:02:00 | ||
| Course Certification | |||
| Order your Certificate | 00:00:00 | ||
FAQs
This course is for anyone who's interested in this topic and wants to learn more about it. This course will also help you gain potential professional skills.
No prior qualifications are needed to take this course.
You can study this course from wherever and whenever you want. You can study at your own pace and from any device. Just log in to your account from any device and start learning!
Yes, there is a test at the end of the course. Once you’ve completed all the modules of the course, you will have to give a multiple-choice test. The questions will be based on the topics of the modules you studied. And of course, you can take the test at any time, from any device and from anywhere you want.
Don’t worry if you fail the test, you can retake it as many times as you want.
You don’t have to wait a minute after your payment has been received, you can begin immediately. You will create your login details during the checkout process and we will also send you an email confirming your login details.
We make the payment process easy for you. You can either use your Visa, MasterCard, American Express, Solo cards or PayPal account to pay for the online course. We use the latest SSL encryption for all transactions, so your order is safe and secure.
After you complete the course, you’ll immediately receive a free printable PDF certificate. Hard Copy certificate is also available, and you can get one for just £9! You may have to wait for 3 to 9 days to get the hard copy certificate.
