You will gain basic knowledge of SQL and relational databases, as well as the following other benefits:
- You know what a relational database is and how it is constructed
- You can use SQL to check and modify the contents of a database
- Training in SQL in various testing situations
- You know the terms and techniques used by developers and data architects
- Help with preparing test data
- Help with migrations and conversions
- Help with database updates
- Use SQL to extract data for reports in test management tools
- Understand how data typically presented in a GUI is stored
You are a software tester with at least one year of practical experience, and you are familiar with common testing concepts (corresponding to the ISTQB Foundation level). This course is particularly suited to testers working in an agile set-up who wish to contribute to solving more technically oriented problems. You are not expected to have any prior knowledge of database construction or SQL.
This course is based on active participant involvement, with lots of exercises and direct practice with SQL statements in an application/database. TestHuset will provide a PC for use during the course.
There will be individual, partner, group, and whole-class exercises. The exercises mix theory and practice, with focus on practising real-world SQL. You will practice using both static and dynamic tests, with an emphasis on dynamic tests.
If you are more than 5 people from same organisation, it can be beneficial to consider the course as in-house training. We conduct the course exclusively for your employees, either as standard as described or tailored to your needs.
In-house training offers several benefits. It can lead to financial savings when training more than five people. This approach fosters intensive exchange of experiences and encourages knowledge sharing among employees. Additionally, it helps in building a common understanding of the subject matter among the workforce. Furthermore, in-house training provides the opportunity for unique customization based on a company’s specific methods and processes.
1. Overview of a database, its construction, and its environment
2. Understanding of ER diagrams
3. Understanding of relational databases
4. Database Management Systems
5. Static and dynamic testing techniques
6. MySQL and SQL instructions
7. Review of database design and its value in relation to databases
8. The use of SQL in a testing role
Meet our Trainers
Meet Lars, the Lead Education Architect and instructor. He holds a degree in computer science, is a certified teacher, and has been working with IT in various forms. Lars has experience with testing and quality management tools through his carreer.rnLars has a background as a professional illustrator, having designed books and newspaper covers, among other things. His ability to draw and facilitate is used extensively in his courses, to the delight of the participants. Lars teaches a range of courses, including ISTQB Foundation, Advanced Test Manager, Advanced Technical Test Analyst, Agile Extension, and everything in between.
Enzo has been working with IT for almost 40 years in many areas of the IT business in Denmark and abroad. Since 2000 he has worked with Quality Assurance, Test, and corresponding functions. The last 6 years he has dived into the agile transformation journey, and this has given me a deep understanding of agile development, SCRUM and Kanban framework. In 2020 he started to teach courses such as ISTQB Foundation, Test Management and Agile Testing etc.
She is a accomplished QA mentor and trainer with a master’s degree in IT and product development and has worked as a consultant in testing and quality assurance since 2016. Her expertise spans Test mentor, Test Management, QA Analysis, and Technical Testing across diverse industries. rnShe holds accreditations to instruct in globally recognized certifications such as ISTQB Foundation, ISTQB Agile Tester Extension, ISTQB Advanced Test Analyst, and ISTQB Advanced Technical Test Analyst. Additionally, she has taught numerous TMAP certification courses and, notably, practical test courses.
Fundamentals of SQL for Testers