Toad World Blog

Video Series: Enabling Agile Database Development using Toad for Oracle

Jan 10, 2017 3:30:00 PM by John Pocknell

In this 10 part video series by John Pocknell, you will learn how to better enable agile database development using Toad for Oracle.

Step 1: Setting up Team Coding with VCS integration

 

 

 

Step 2: Accessing objects from version control using Team Coding

 

 

 

Step 3: Detecting performance issues using PL/SQL profiler

 

 

 

Step 4: Optimize SQL and PL/SQL using Optimize Current SQL

 

 

 

Step 5: Creating a simple PL/SQL unit test using Toad

 

 

 

Step 6: Creating a comprehensive PL/SQL unit test using Toad

 

 

 

Step 7: Advanced code review using Toad Code Analysis

 

 

 

Step 8: Checking objects into version control using Team Coding

 

 

 

Step 9: Creating and publishing workflow automations

 

 

 

Step 10: Execution of workflow automation on Toad Intelligence Central and integration with CI

 

Tags: Toad for Oracle Video Code Tester for Oracle Development Toad for Oracle Videos Code Tester for Oracle Videos

John Pocknell

Written by John Pocknell

John Pocknell is a senior market strategist at Quest Software and part of the Information Management business unit. Based at the European headquarters in the U.K., John is responsible for synthesising analyst data and customer interviews in order to create and evangelise solutions-based stories and messaging which relate to major IT initiatives for our extensive portfolio of database products, worldwide. He has been with Quest Software since 2000, working in the database design, development and deployment product areas and spent over 10 years as product manager for the Toad product line. John has been successfully evangelising Toad and other database solutions at various conferences and user groups around the world for the last 19 years as well as writing blogs and technical papers both internally and for the media. John has worked in IT for more than 30 years, most of that time in Oracle application design and development. He is a qualified aeronautical engineer with more than 10 years of experience in provisioning IT consultancy services and implementing quality assurance systems to ISO 9001.