|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/database-testing-and-sql-for-testers/
课程评论：没有评论
课程名称：数据库测试与测试人员的SQL（顶级SQL面试问题） 课程概述：本课程旨在帮助测试人员学习数据库测试和SQL的相关概念。现代应用程序通常会在后端数据库中创建数据，因此掌握SQL对于测试人员而言是一项必备技能。课程首先介绍数据库测试的基本概念，接着讲解SQL，并最终说明如何利用SQL进行有效的数据库测试。Microsoft SQL Server是市场上最流行的关系数据库管理系统（RDBMS）之一，因此许多组织期望测试人员能够熟练使用t-SQL，即Microsoft SQL Server的SQL。课程内容从数据库测试的介绍开始，讨论如何将黑盒测试和白盒测试等软件测试技术应用于数据库测试。此外，课程还涵盖了测试人员日常需要的大部分SQL概念，如创建数据库实体（如数据库、表等）、选择、更新和插入语句、内置函数（如LEFT、LEN、LOWER、LTRIM、REPLACE、REVERSE、RIGHT、SUBSTRING等）、聚合函数（如SUM、AVG、MAX、MIN等）、连接和联合操作符（如And和Or）。最后，课程讲解了如何有效利用SQL完成数据库测试。 此课程适合希望提升数据库测试能力的测试人员，帮助他们在实际工作中更好地应用SQL技能。
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 OrThen finally it covers how Database testing can be effectively accomplished by using SQL.
