Location: Malmömässan
Time: November 19
Level: Intermediate
Karen N. Johnson, USA

Karen N. Johnson is a software testing consultant in Chicago, Illinois. Karen views software testing as an intellectual challenge and believes in the context-driven school of testingexternal link, opens in new window. She has extensive experience in software testing and test management.

Karen frequently speaks at software testing conferences.  She has presented at STPCon, CAST, PNSQ, StarEast, and StarWest. She’s also presented at several local quality group meetings such as IQAA, CQAA, and NOSQAA.  She publishes articles on software testing and has been published in Better Software, InformIT and StickyMinds.comexternal link.
Karen is an executive board member for the Association for Software Testing (AST). She is program co-chair for CAST 2008, the Conference for the Association for Software Testing.
Karen is a hosted software testing expert on Tech Target’s website, searchsoftwarequality.comexternal link, opens in new window. For more information about Karen, visit http://www.karennjohnson.comexternal link, opens in new window
SQL for Testers
Understanding the relational data model behind an application enables testers to design additional tests and gain a deeper understanding of the application they’re testing.  This class is an introduction to relational databases and SQL.  The class is designed for software testers and test leads to gain an understanding of relational data models and data types.  Students will learn the fundamentals of writing structured queries and learn how to navigate through a data schema. SQL knowledge helps both manual and automated testers.

This class is not designed specifically for any relational database. This class will discuss several of the most common databases including MySQL, Oracle, Sybase, and Microsoft SQL Server.

Learning Objectives:  As a result of taking this course, testers will:

  • Understand how information is stored and retrieved
  • Be able to execute SQL queries
  • Be able to test database scripts
  • Understand indexes and how to look for performance bottlenecks
  • Understand constraints, deadlocks, and the value of multi-user testing

Key concepts:

  • Understand data models and schemas
  • Learn about the different data types and how application data is stored
  • Understand transactions, deadlocks, and concurrency issues
  • Learn how to write and execute SQL queries

Why each concept is important or useful:

  • Understanding data models and data types helps testers gain additional test ideas
  • Knowing how to write a structured query is helpful for both manual and automated testers to find data, to ensure data integrity, and to manipulate test data for specific tests
  • Understand what a transaction is from a database perspective. Testers will gain an understanding of how an application works with a relational database
  • Learning how indexes are used helps testers look for performance issues

Students need to bring a lap top computer to class.
Telephone: +46-(0)40-602 3134, email: info@oredev.org