SQL! Who said Anything about SQL by Aaron Swerlein
Data management is a crucial aspect of any project and frequent pain point for QA. Automation can be leveraged to yield multiple benefits when handling databases. These benefits include: (1) reducing time to create/maintain and remove ‘test’ data; (2) ensuring all data manipulation & scenarios are covered; (3) automating deployment to production and production-like environments; and (4) less manual effort invested. Automating these redundant activities help ensure testers can spend more time on valuable tasks that require human involvement. Attendees will learn each level of automation from data management to the database itself, as well as tools to enable the use of automation of CRUD (Create, Read, Update, and Delete) operations.
Aaron is an Application Architect at Huntington National Bank. He’s presently supporting multiple business segments across Huntington building automation frameworks and training application teams. His scope of work includes desktop applications, web-based applications, databases, services, and remote server validations. Previously, Aaron served as a Sr. Automation Developer with Nationwide Insurance focusing on test automation around the ETL process. He loves working with Ruby, PERL, and SQL.
1 Easton Oval #175
Practical API Testing – by Andy Griffin
Many members of the IT community are just gaining experience testing with web API’s. Testing API’s can be intimidating compared to those comfortable GUI’s, but the world of requests and responses is full of opportunities. Perhaps your team isn’t sure where API testing fits into your SDLC or your organization doesn’t believe API’s should be tested directly at all. Even if you have no idea what API even stands for or how to being to approach testing, we will address those questions in this session. Those in attendance will be provided with an overview on how your team should approach API testing as part of your test strategy. We will also provide working examples on interacting with services via automation testing.
Andy presently works as an Application Architect at Huntington National Bank, with a focus on automation development. He graduated from The Ohio State University with a degree in Computer Science, and has subsequently worked at multiple large firms in Central Ohio. His experience includes leading testing teams updating legacy applications, coordinating quality assurance efforts on teams from the ground-up, and architecting automation frameworks for enterprise applications. In his spare time, Andy enjoys traveling, golfing, fantasy football, and dominating at kickball.
1 Easton Oval #175