Course

Fundamentals of SQL for Testers

More businesses have now changed to agile development, which increases the need for technical skills of testers. SQL is one way to achieve this.

Learning objectives

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

Target audience

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.

Course format

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.

In-House training?

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.

Advantages of in-house training

  1. Financial savings for more than 5 people
  2. Intensive exchange of experiences and knowledge sharing
  3. Employees gain a common understanding of the subject
  4. Opportunity for unique customization based on your own methods and processes

Contact Us

Contact us to learn more about how we can customize a program specifically for your company.

Fundamentals of SQL for Testers

Fundamentals of SQL for Testers

Need help?

If you have any questions, please call us on +45 44 979 979 or e-mail kompetencecenter@testhuset.dk

Contact

Course content

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. MySQL and SQL instructions

6. Review of database design and its value in relation to databases

7. The use of SQL in a testing role

Introduction

Meet our Trainers