Testing in the Imperial Database - Samuel Nitsche
13th January 2023
-
Locked
Samuel Nitsche
Senior Software Developer
![Testing in the Imperial Database - Samuel Nitsche image](https://embed-ssl.wistia.com/deliveries/ee500bef208f6f6ede2855b3d583e9bf.jpg?image_crop_resized=1280x720)
Talk Description
In a fast-changing tech world, there is one thing that commonly stays the same for years or even decades: the system that holds the data. This data is often one of the most important assets of a business and it’s critical to keep it safe and in good condition.
In this highly entertaining, light-hearted talk, I want to show you that it’s not only viable but also a lot of fun to do this directly at the database level!
Join me on a journey to the infamous Death Star, where the Galactic Empire runs the Imperial Database™ with all the expectable problems of a complex, long-running software system.
It has survived numerous iterations of different frontend systems - and we are suddenly responsible to ensure the stability and reliability of the data, while constantly dealing with new changes and features.
We will quickly learn that there are some special challenges when testing in relational databases, and meeting a real Sith Lord face-to-face is only one of them. On the other hand, we will also learn about new friends and use practical examples to answer a number of questions:
- What can we test for in a database on a high and low level?
- How can we introduce automated tests to a database?
- And what are these ancient relational force techniques that can be used to prevent errors before they appear?
While the Imperial Database™ runs on Oracle, all of the examples will be presented in a way that is adaptable to other relational databases.
Having beginner-knowledge about SQL is beneficial for attendees.
What you’ll learn
By the end of this talk, you'll be able to:
- What can be (automatically) tested for in a database on a high and low level
- How can automated tests be introduced to a database
- How can core features of relational databases be leveraged to help us with test data setup and cleanup
- How can the relational model help with ensuring data quality
Samuel Nitsche
Senior Software Developer
Samuel Nitsche is a curiosity-driven software developer who programs, learns and collaborates in the software trade since the early 2000s.
He works as Senior Software Developer and trainer at Smart Enterprise Solutions GmbH.
His main interest is on modern database development, automated testing and code quality, topics he writes regularly about on different platforms (e.g. his blog https://developer-sam.de, Simple-Talk and several Oracle-related print magazines).
He is an Oracle ACE, one of the main contributors and maintainers of utPLSQL (http://utplsql.org) and loves to share his experience in an entertaining way - gladly in Sith robes - at meetups and conferences.
Suggested Content
With a combination of SAST, SCA, and QA, we help developers identify vulnerabilities in applications and remediate them rapidly. Get your free trial today!
Explore MoT
![TestBash Brighton 2024](https://www.ministryoftesting.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBbk15IiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--815abcdd8f535ab728e65b8c665daf7c18ddfd5b/TestBash%20Brighton%202024_16%209.jpg)
Thu, 12 Sep 2024, 9:00 AM
We’re shaking things up and bringing TestBash back to Brighton on September 12th and 13th, 2024.
![MoT Intermediate Certificate in Test Automation](https://www.ministryoftesting.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBZ2t3IiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--efd3a1229f295b256d756bac95256552e42b6c5a/MoT%20Certification_MoT-ICTA.jpg)
Elevate to senior test automation roles with mastery in automated checks, insightful reporting, and framework maintenance
Topics
Tags
-
automation
-
quality
-
testbash-world