Comparte si te a gustado:

Database Testing and SQL for Testers

Publicado en 04 May 2022

Udemy UK

What you'll learn

  • Importance of Database Testing and Database Test scenarios
  • Creating Databases and Tables in SQL Server
  • Creating tables and writing SQL queries
  • Using SQL Built in functions like LEN, UPPER, LOWER, SUBSTRING and REPLACE etc
  • Aggregate Functions

Requirements

  • Knowledge of general Software testing principles will be useful.

Description

This course has been intended for testers who want to learn the concepts of Database testing and SQL.


Many of the modern applications are creating data in a backend database and hence knowing SQL is an essential skill for testers. It starts with an introduction to Database testing concepts first followed by SQL and finally explains how SQL can be used as a tool to perform effective Database testing. 


Microsoft SQL Server is one of the top popular RDBMS(Relational Database Management System) existing in today's market and hence a large number of organisations are expecting the testers to be proficient in t-SQL which is the SQL for Microsoft SQL Server.

This course starts with an introduction to DB testing, explains how Software testing techniques like Blackbox and Whitebox testing techniques can be applied in Database testing.


It also covers most of the SQL concepts that testers will need on a day to day life like


  • Creating database entities e.g. Database, Table etc,

  • Select, Update and Insert statements,

  • In-built functions like LEFT,LEN,LOWER,LTRIM,REPLACE,REVERSE,RIGHT,SUBSTRING etc.

  • Aggregate Functions like SUM, AVG, MAX,MIN etc.

  • Joins and Unions

  • Operators like And and Or


    Then finally it covers how Database testing can be effectively accomplished by using SQL. 



Who this course is for:

  • This course has been designed for testers looking to acquire SQL and DB testing skills.

Debes tener en cuenta que los cupones duran maximo 4 dias o hasta agotar 1000 inscripciones,pero puede vencer en cualquier momento. Obten el curso con cupon haciendo clic en el siguiente boton:

(Cupón válido para las primeras 1000 inscripciones): 2FB86E9D125DE4597DBD
Udemy UK
Tags:

Articulos Relacionados

content

SQL: Creación de Bases de Datos (De cero a profesional)

Aprende a diseñar bases de datos eficientes para posteriormente crearlas, modificarlas y manipularlas en SQL.

Ir al Curso
content

MongoDB: Aprende desde cero a experto

Vuelvete un experto en Bases de Datos no relacionales aprendiendo de una manera fácil y sencilla.

Ir al Curso
content

SQL: Consultas básicas a complejas

2021: El curso de SQL que te da más valor: Aprenderás cómo hacer consultas SQL desde básicas hasta complejas.

Ir al Curso
Suscríbete a nuestro boletín
Reciba los últimos Cupones y promociones (Solicitar Cupón)