Oracle PL/SQL Unit Testing with Oracle SQL Developer

In this course, you'll learn how to test your PL/SQL code using the Oracle SQL Developer Unit Testing Framework.

At the core of developing a high quality, bug free application lies our skills and knowledge to test our applications thoroughly and effectively. In this course, Oracle PL/SQL Unit Testing with Oracle SQL Developer, you'll learn how to test your PL/SQL code using the Oracle SQL Developer Unit Testing Framework. It is a robust and feature rich framework which allows you to easily create test cases for your PL/SQL program units, organize them in test suites, reuse your work with libraries and share your tests in a team development environment. First, you'll discover that it allows you to analyze your code coverage and view previous runs and results with several built-in reports. Next, you'll explore how it lets you synchronize your tests when the name or definition of the underlying program units change. Finally, you'll learn how it gives you the ability to automate your tests using the SQL Developer command line interface, which is extremely useful in implementing your continuous testing strategy. When you're finished with this course, you'll have a foundational understanding of Oracle SQL Developer PL/SQL Unit Testing feature, which will help you immensely when implementing extensive test cases for your PL/SQL program units and achieving test automation.

• Course Overview 2mins
• Introduction 7mins
• Understanding the Unit Test Workflow 7mins
• Installing and Configuring Test Repository 8mins
• Creating Unit Tests 23mins
• Dynamically Generating Test Implementations 17mins
• Organizing & Synchronizing Tests 19mins
• Running Test from Command Line & Generating Code Coverage Reports 21mins