Skip to Main Content

Explore Oracle PL/SQL

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

This month we are celebrating Developers at AskTOM. We welcome Developers of all levels of experience to join us at our FREE Developer Live events coming in August. Just click on the left to register today! If you are brand new to Database Technology, then we also have got you covered. Just click on the right for your comprehensive FREE training program to kick start your Oracle Database Development journey!

Header container

January 14

14:00 UTC   Start Times Around the World

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!


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.