Oracle PL/SQL Unit Testing with Oracle SQL Developer

Good testing is essential to reduce bugs and produce quality software. Oracle SQL Developer offers the PL/SQL unit testing feature which lets developers and analysts effectively write and share test cases and suites to test their PL/SQL code.
Course info
Level
Beginner
Updated
Jul 31, 2017
Duration
1h 49m
Table of contents
Description
Course info
Level
Beginner
Updated
Jul 31, 2017
Duration
1h 49m
Description

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.

About the author
About the author

Experienced technologist, with expertise in various aspects of software development lifecycle, architecting software solutions and software development.

More from the author
Oracle REST Data Services
Beginner
5h 32m
Feb 13, 2018
Getting Productive with SQL Developer
Beginner
3h 54m
Apr 20, 2017
More courses by Pankaj Jain
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hello everyone, my name is Pankaj Jain, and I'm very excited to welcome you to my course, Oracle PL/SQL Unit Testing with Oracle SQL Developer. The importance of testing cannot be overemphasized. Improper testing leads not only to a lot of bugs and production outages, but can also harm a company's reputation seriously. Oracle SQL Developer is a very popular, free, graphical user interface widely used by developers and DBAs around the world. This IDE is packed with tons of cool features, and one very important feature it offers is its Oracle PL/SQL testing framework. It is a robust and feature rich framework, which allows us to easily create test cases for our PL/SQL program units, organize them into suites, reuse our work with libraries, and share our tests in the team development environment, it allows us to analyze our code coverage, as well as gives us the ability to automate our tests using the SQL developer command-line interface, which is extremely useful in implementing our continuous testing strategy. In this course, we will take an in-depth look at this feature. You may be an Oracle database programmer, or an analyst, I'm very confident you will gain some useful knowledge from this course, which will significantly boost your testing skills and testing effectiveness. Some basic Oracle database and programming experience is required. Some of the major topics that we will cover include: understanding the unit testing workflow and components, creating test cases and test suites, dynamically generating test cases, test driven development approach, code coverage report, and running tests from the command-line interface. By the end of this course, you will know the basics of Oracle PL/SQL unit testing, and be productive in your testing efforts and test automation. I hope you will join me on this journey to learn about this useful testing framework with the Oracle PL/SQL Unit Testing with Oracle SQL Developer course, at Pluralsight.