SQL for Testers
- Global
- Online
- 4.7
- 1 hour 33 minutes
- Basic
- English
- License based
- Ongoing
![LinkedIn logo surrounded by cubes, booksб and certificates.](https://eu-images.contentstack.com/v3/assets/blt892f41c9788ae399/bltcd1c48197c00c7ff/651c12480effa18418843eba/linkedin-learning-header.webp)
![Two people in shirts are sitting at a table with their laptops open and writing with pencils in a notebook. There are also two pens on the table.](https://eu-images.contentstack.com/v3/assets/blt892f41c9788ae399/bltb96ef72909b9bb45/651c13af485b8d8557cd035c/linkedin-learning-description-2x.webp)
Descripción
The SQL programming language opens the door to deeper and more efficient software testing. SQL allows testers to examine the back end of application, automate testing through scripting, and simplify and speed up data generation. This course provides a quick-start guide to database testing with SQL. Dave Westerveld shows how to choose the right tools, set up a local site, and start validating data using simple SQL table joins. Next, you can learn how to generate test data by creating, updating, and deleting table entries. Finally, learn how to test SQL queries and find bugs in transactions, implement field constraints to prevent future bugs, and use schema validation to improve the quality of your application. Plus, find out how to prevent unauthorized access to data and measure the runtime of your queries to make sure you’re not impeding database performance.
Objetivos de aprendizaje
- Getting set up with the tools you need
- Writing SQL queries
- Validating workflows and data with SQL
- Generating test data with SQL
- Finding bugs in transactions
- Validating schema
- Security and performance testing
![A dartboard with two darts hitting 6 and 9.](https://eu-images.contentstack.com/v3/assets/blt892f41c9788ae399/blt7320d9bd6404e888/651c13af85d5143c1cda782e/linkedin-learning-learning-objectives-2x.webp)
Introduction
Getting started
Using SQL for validation
Using SQL for data generation
Testing SQL queries
Conclusion
- Inicia sesiónPara obtener la licencia, crea una cuenta o inicia sesión.
- Conecta tu cuenta de LinkedInEsta accion agregará los datos de tu LinkedIn a tu perfil, permitiendo que Club Anywhere asigne tu licencia y elabore recomendaciones de contenido personalizadas.
- Obtén tu licenciaSolicita tu licencia y actívala a través del correo electrónico asociado a tu cuenta de LinkedIn.