MySQL Tutorial
Introduction Installation of MySQL Getting MySQL server information RDBMS Concepts Data Definition Language Data types Managing Databases Managing Tables Managing Views Inserting records in a table Updating records in a table Deleting records from a table Retrieving Records Data Control Language Variables in MySQL Procedures in MySQL Built-In functions in MySQL User Defined functions in MySQL Triggers in MySQL Cursors in MySQL Transaction control Event scheduler Tuning MySQL Server Performance Managing users Importing and Exporting data Database Testing Workbench PHPMyAdminDatabase testing in MySQL
It is very important to perform complete database testing. You can test below things while doing database testing.- Data Mapping – We can verify that data entered in application UI is properly being saved in correct columns.
- We can also test that CRUD (Create, Retrieve, Update, Delete) actions are working correctly.
- We can also test ACID properties of database.
- We can also test Data Integrity.
- We can also test Business Rules.
- Verification of default values, unique value constraints.
- Verification of triggers
- Verification of procedures and functions.
- Verification of queries involving NULL values.
- Verification of Referential Integrity.
- Verification of the user roles and privileges.
- Verification of transactions Rollbacks and savepoints.
Web development and Automation testing
solutions delivered!!