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.