Database Testing Table of Contents


Table of Content
 

 

Software Testing Basics

  • Scope
  • Functional vs. Non-Functional testing
  • Defects and Failures
  • Finding Faults Early
  • Compatibility
  • Input Combinations and Preconditions
  • Static vs. Dynamic Testing
  • Software Verification and Validation
  • The Software Testing Team
  • Software Quality Assurance (SQA)
  • Testing Methods - The box approach

Database Basics

  • What is a Data?
  • What is a Database?
  • What is DBMS or Database Management System?
  • Client/Server Basics
  • DBMS Architecture
  • Database Process
  • Data Models
  • Database Schema
  • Data Independence
  • ACID Property

SQL Basics

  • Relational Model
  • Normalization
  • DDL Commands
  • DML Commands
  • Joins
  • Functions
  • Cursor
  • Procedures

Database Testing Basics

  • Objective of the Database Testing
  • Importance of Database Testing
  • Database Testing Attributes
  • Database Testing Types
  • Database Testing Process

Database Test Design

  • Test Design
  • Database Testing Challenges
  • Database Testing Requirements Gathering
  • Database Testing High Level Design
  • Database Testing Low level Design

Database Test Execution

  • Unit Testing
  • Integration Testing
  • Database Test Development
  • Database Testing Defects
  • Defects Reporting
  • Testing Transactions
  • Testing Stored Procedure
  • Testing Database Schemas
  • Testing Triggers
  • Testing Field Constraints

Database Functional Testing

  • What is Database Functional Testing
  • Database Testing for Data Accuracy
  • Database Testing for Data Quality
  • Database Testing for Data Completeness

Database Security Testing

  • What is Database Security Testing
  • Access Security
  • Data Security
  • Single Sign-on Security

Database Stress Testing

  • What is Database Stress Testing
  • Database Testing for Scalability
  • Database Stress Testing
  • Database Testing for Availability

Database Testing Tools

  • Microsoft SQL Server
  • Oracle SQL Developer
  • NoSQL Unit
  • SLOB
  • Orion
  • DB Unit
  • Database Benchmark



Apply for Certification

https://www.vskills.in/certification/testing/database-testing-certificate

 For Support