Oracle Database 12c - Testing

An online training for all those who wish to learn about Oracle 12c Testing. You will learn some interesting topics like: Testing & Debugging, Creating Procedures, Creating Unit Tests etc.

292

 19m | 3 Videos | 89609 Views |   Intermediate

Oracle 12c Testing course:

eduCBA brings you a course on Oracle 12C. In this course of Oracle 12c Testing you will be learning about

• 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.

• 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.

Oracle 12c Testing Course Pre-requisites:

• Basic Database/RDBMS Database Knowledge
• Testing and Debugging knowledge
• Basic familiarity with Windows environment

What am I going to get from this Oracle 12c Testing course?

• Over 7 lectures and 1 hour 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.

Oracle 12c Testing target audience:

• Students
• Oracle Professionals (Administrators/Developers/Architects/Implementer’s)
• Anyone who wants to operate and learn Oracle Database 12c product

Back to top ^