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

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

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

Ask a Question

Ask The Experts - Right Now!

Do you have a question about Oracle PL/SQL. you'd like our experts to answer in their next session? Sign in and submit it here.

Please note that we cannot guarantee to answer all questions. We cannot help you with open Service Requests or account/licensing issues.


Your Experts
Steven Feuerstein
Steven Feuerstein, Developer Advocate for PL/SQL    
Steven Feuerstein leads a team of Developer Advocate at Oracle Corporation, and is obsessed with the Oracle PL/SQL language, having written ten books on it (all published by O'Reilly Media). He's published over 1400 quizzes on PL/SQL at the Oracle Dev Gym.
Chris Saxon
Chris Saxon, Oracle Developer Advocate for SQL    
Chris Saxon is the quizmaster for the Database Design competitions and an Oracle Developer Advocate for SQL. 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.