Skip to Main Content

Explore Oracle PL/SQL

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

January 14, 2020

14:00 UTC   Start Times Around the World

Subscribe to be notified of changes to sessions and give us feedback!

Having trouble watching the video on this page? Open the video in your browser.


Setup and Teardown Techniques for Testing Database Code
Following up on our popular session in November that focused on real-world testing of PL/SQL code, two of our speakers will return to focus on one of the most challenge aspects of that testing: how to set up and tear down database state for automated testing.

Deepti Bandari is a senior software engineer at Fidelity Investments since 2013. Her focus areas include database design and development, test automation and promoting engineering excellence. She will share her experience with data setup and teardown for testing pl/sql, some challenges and techniques to overcome the challenges.

Jasmin Fluri is an independent consultant at Schaltstelle GmbH and lectures on software engineering and code review at the University of Applied Sciences North-western Switzerland. Her focus as a database developer and DevOps engineer lies on continuous integration and delivery pipelines, automation of recurring tasks, PL/SQL development, data engineering, and data warehousing.

01:04 Steven sets the context
04:30 Dee Bandari on automated testing
05:47 F.I.R.S.T principles of unit testing
08:07 Challenges with data setup and teardown
11:15 Overcoming the challenges
19:59 Example: testing the smart home application
33:15 Jasmin Fluri on the architecture of unit tests
36:40 Development and test lifecycle - stages of testing
38:16 Management of test data
41:00 Requirements of test data and test code example
46:50 Summary by Jasmin
48:45 Q&A: testing the test code, testing private subprograms and more

Your Experts

    Steven Feuerstein

    Steven Feuerstein   

    Steven Feuerstein is a Senior Advisor at Insum Solutions (, and is obsessed with the Oracle PL/SQL language, having written ten books on it (all published by O'Reilly Media). You will find an abundance of quizzes from Steven at the Dev Gym. Enjoy!
    Chris Saxon

    Chris Saxon   

    Chris Saxon is an Oracle Developer Advocate and quizmaster on Dev Gym. His job is to help you get the best out of the Oracle Database and have fun with SQL! He's also part of the answer team on Ask TOM and creates YouTube videos at The Magic of SQL channel.