Course Overview
45m | 7 Videos | 81779 Views | 
Expert Introduction: This section introduces the Testing and Debugging tool that is part of the SQL Developer 4.0. In this section you establish a connection to the sample HR schema and review existing objects in the HR schema.
Executing a DDL Script: In this section, you will execute the DDL script that was created in the tutorial on Data Modeler that will update the HR schema. You will use the DDL script file that you created in the previous session on Data Modeler. This SQL file contains all the DDL to change the HR Schema so that it is synchronized with the model changes you made in the previous tutorial. When you execute this script, the PROJECTS and TASKS tables will be created, and the new COST_CENTER column will be added to the DEPARTMENTS table.
Create Table APIs: In this topic, you create API packages for the DEPARTMENTS table. Table APIs allows you to make PL/SQL calls to insert, update, delete records in your application without writing or managing raw INSERT, UPDATE, and DELETE statements. This feature is very useful if you are building a new application for which the database has been setup and you want to populate data for testing purpose.
Creating, Executing and Debugging a Procedure : In this topic, you create, execute and debug a procedure that determines the commission any employee receives based on a sales amount and the employees commission percentage. You then setup break-points and execute the procedure in debugging mode that enables you to view intermediate data to diagnose coding issues. This feature is very useful when you are building a new application and you want to test the business processes that update the database schema.
Creating a Unit Test Repository: In this topic, you create a database user called UNIT_TEST_REPOS. You create this user to hold the Unit Testing Repository data. You will then create the repository in the schema of the user that you created. This feature is very useful when you are testing a new application that has been built and you want to create and store unit tests for each coding unit or procedure that can be run for each version of the application code, as it is being built.
Creating and Running a Unit Test: Now that the Unit Testing Repository has been created, you will create a unit test for the PL/SQL procedure you created earlier in this tutorial. Then you will run the unit test to see if various values will work. Using this feature you can create unit tests for each coding unit or module of the application in the same development environment , as testing does not impact the development database, but uses its own temporary tables for test execution.
What are the requirements?
Basic Database/RDBMS Database Knowledge
Testing and Debugging knowledge
Basic familiarity with Windows environment
What am I going to get from this course?
Over 7 lectures and 45 mins of content!
The objective of the course is to provide Oracle professionals namely Administrators, Developers, Architects & Implementers an insight into the new Oracle database 12c product by installing and running Testing and Debugging tools in the familiar Windows environment on a desktop/laptop.
This will enable them to learn how this product can help customers to “Plug into the Cloud” or adapt the new cloud environment.
What is the target audience?
Students
Oracle Professionals (Administrators/Developers/Architects/Implementer’s)
Anyone who wants to operate and learn Oracle Database 12c product
