Samuel Nitsche: Testing in the Imperial Database
Slides: https://drive.google.com/file/d/16Cc9IgWg-wRxZKNdmTx2ZEAOX4sAf9px/view?usp=sharing
Timecodes:
00:00 Welcome to the Imperial Database
01:10 About the Speaker
02:20 MASH program
03:08 Definitions and additional Information
04:06 The application under test
04:37 Where to test a Database?
07:28 What to test: Availability
09:30 SQL is your Friend
11:03 What to test: Functionality
13:50 The dream of an API at the database level
14:19 An unexpected Partner
15:54 What to test: Validity
17:14 Problematic Data: Multiple Darth Vader entries
21:05 Preventing problematic data
25:00 Problematic Data: Inconsistent Alignments and Roles
27:00 Problematic Data: Non-numeric Salaries
28:45 Beautiful Data
29:53 The final question
31:13 Q&A
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. And 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?
Видео Samuel Nitsche: Testing in the Imperial Database канала Ministry of Testing Abu Dhabi
Timecodes:
00:00 Welcome to the Imperial Database
01:10 About the Speaker
02:20 MASH program
03:08 Definitions and additional Information
04:06 The application under test
04:37 Where to test a Database?
07:28 What to test: Availability
09:30 SQL is your Friend
11:03 What to test: Functionality
13:50 The dream of an API at the database level
14:19 An unexpected Partner
15:54 What to test: Validity
17:14 Problematic Data: Multiple Darth Vader entries
21:05 Preventing problematic data
25:00 Problematic Data: Inconsistent Alignments and Roles
27:00 Problematic Data: Non-numeric Salaries
28:45 Beautiful Data
29:53 The final question
31:13 Q&A
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. And 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?
Видео Samuel Nitsche: Testing in the Imperial Database канала Ministry of Testing Abu Dhabi
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Delvis Echeverria and Christopher Valenciano: JMeter. Hands-on Session](https://i.ytimg.com/vi/ooBKjGLayus/default.jpg)
![Oleksandr Romanov: High Tech-Low Test or Problems of Modern Testing](https://i.ytimg.com/vi/jigPyy6wSfk/default.jpg)
![Artem Grygorenko: Think first approach. How to make your work better](https://i.ytimg.com/vi/1DF2X8Xea8g/default.jpg)
![Artem Grygorenko: 10 Worst Pieces of Advice for a software tester](https://i.ytimg.com/vi/T6yVe8DmsTQ/default.jpg)
![Areti Panou: Changing career path from QA to a Product Owner role](https://i.ytimg.com/vi/6P6Nizhm-KE/default.jpg)
![Abhi Nandan: Contract testing in Polyglot Microservices](https://i.ytimg.com/vi/PWM8iLqpVdA/default.jpg)
![Johannes Dienst: The State and Future of UI Testing](https://i.ytimg.com/vi/KyvvZ46amqs/default.jpg)
![Anton Yakutovich: How to practice Bi-Directional Contract Testing with Pactflow](https://i.ytimg.com/vi/0J4I8xxX3Do/default.jpg)
![Testing canvas-based UI with SikuliFramework and OpenCV](https://i.ytimg.com/vi/2rQ8lP9AkkE/default.jpg)
![Maksym Semenenko: Optimization of JMeter scripts with reusable fragments and CLI parameters](https://i.ytimg.com/vi/6surof0-cv8/default.jpg)
![Kate Riabtseva: Switching from hospitality job to QA](https://i.ytimg.com/vi/hYIRSXWPU-s/default.jpg)
![Anvesh Puli: Introduction to Cypress Automation Tool](https://i.ytimg.com/vi/eKLxmupEpVo/default.jpg)
![Viacheslav Aksenov: Testing high-load FinTech service — lessons learned](https://i.ytimg.com/vi/A4xwlPbGN2c/default.jpg)
![Shashank Garg: JUnit5 features in practice](https://i.ytimg.com/vi/MbBekpeEF0Q/default.jpg)
![Toyer Mamoojee: Shift Left Testing — The right way](https://i.ytimg.com/vi/WROm67BRsBE/default.jpg)
![Siarhei Krukau: GitHub Actions — automate the repository, not the code!](https://i.ytimg.com/vi/-sr9_AItFQQ/default.jpg)
![Sergei Shaikin: Kibana for Testers](https://i.ytimg.com/vi/kfNZM0ciRFE/default.jpg)
![Artem Grygorenko: How we improved our hiring process](https://i.ytimg.com/vi/tS_jl8jA8ks/default.jpg)
![Devendra Josan: Mobile Application Testing in Agile world (plus demo of Perfecto Cloud)](https://i.ytimg.com/vi/jSda4tGTF9k/default.jpg)
![Anton Yakutovich: Insomnia.rest Workshop](https://i.ytimg.com/vi/DKMWl0VswFA/default.jpg)