Database Testing and SQL for Testers
Learn how to test databases and use t-SQL. Learn how to use SQL to test Databases more effectively.
What you’ll learn
Database Testing and SQL for Testers
- It’s important to test databases and set up scenarios for database tests.
- In SQL Server, you can make databases and tables.
- There are two steps to making tables and writing SQL queries:
- It’s possible to do this by using SQL’s built-in functions like LEN and REPLACE.
- Aggregation of functions
Requirements
-
The more you know about general software testing principles, the better.
Description
People who work with databases and SQL should take this class.
SQL is a very important skill for testers because many modern apps use a backend database to store data. It gives an overview of Database testing, then talks about SQL, and then shows how SQL can be used to do good Database testing.
If you work with Microsoft SQL Server, you need to know how to write SQL in t-SQL. This is the SQL for Microsoft SQL Server.
Database testing is the first thing this course talks about. It also talks about how software testing techniques like Blackbox and Whitebox testing techniques can be used in Database testing.
It also talks about most of the things that testers will need to know about SQL on a daily basis, like how to write queries.
- Creating database entities, such as a Database, a Table, and so on,
- Select, change, or add statements.
- In-built functions like LEFT, LEN, LOWER, LTRIM, REPLACE, REVERSE, REVERSE, RIGHT, SUBSTRING, and so on.
- Like SUM, AVG, MAX and MIN. These are called “aggregate functions,” and they work together.
- Unions and Joins
Who this course is for:
- This course is for testers who want to learn how to test SQL and databases.
