
Database Testing Syllabus
Database Testing is a type of software testing that checks the schema, tables, triggers, etc. of the Database under test. It also checks data integrity and consistency.
Database Testing can be done in two ways, one Testing Databases Manually, and Testing Databases using Test Tools.
Database Testing Syllabus. Introduction to Databases, Basic SQL, Types of Database Testing, Database Testing Life Cycle, and Database Test scenarios.
1. Database Concepts
Introduction to Databases
GUI Testing vs Database Testing
Life Cycle of Database Testing
2. Basic SQL
SQL Syntax
SQL Data Types
SQL Operators
Data Definition Language
Data Manipulation Language
Data Control Language
SQL Functions
SQL Queries and Sub Queries
SQL Clauses
SQL Joins
SQL Views
SQL Indexes
SQL Transactions
SQL Injection
3. Types of Database Testing
Structural Database Testing
Functional Testing
Nonfunctional Testing
4.Database Testing Processes
5. Database Testing Techniques
Database Schema Testing
Stored Procedure Tests
Trigger Tests
Server Setup Scripts
Functional Testing Method
Stress Testing
Benchmark Testing
Testing a Database via Front-end
6. Database Testing – Objects
Schema
Tables in Database
Stored Procedures
Triggers
7. Database Testing – Data Integrity
8. Database Testing – Data Mapping
Key Aspects of Data Mapping
Steps in Data Mapping Testing
9. Database Testing – Performance
Load Testing
Stress Testing
Spike Testing
Data Volume Testing
10. Database Testing – Database Backup
11. Database Testing – Data Recovery
12. Database Testing – Data Security
13. Types of Threats on a Database System
14. Database Security Testing Techniques
15. Database Testing Challenges
Functional Database Tester Job Responsibilities:
Identifying Database Test Scenarios
Connecting to Database and Data Retrieval Operations
Verifying Data Integrity
Verifying Data Manipulation Operations (Addition, Modification and Deletion)
Data Comparisons (Front-end Data with Back-end, Database data with Excel file data etc..)
Verifying Data Back-up and Recovery Operations
Verifying Stored Procedures
Verifying the Data Processing
Functional Database Testing Scenarios:
Verify that data inserted from UI is reflecting properly in the appropriate table.
Check values for columns which are not accepting null values
Check if correct data is getting saved in the database upon successful page submit.
Check for data integrity. Data should be stored in single or multiple tables based on design.
Index names should be given as per the standards.
Tables should have a primary key column.
Table columns should have description information available.
Required table indexes should be created.
Check if data is committed to the database only when the operation is completed
Data should be rolled back in case of failed transactions
Database name should be given as per the application type.
Database logical names should be given according to database name.
Check values for table audit columns.
Check if input data is not truncated while saving.
Check numeric fields with minimum, maximum, and float values.
Check numeric fields with negative values.
Check if radio button and dropdown list options are saved correctly in the database
Check if database fields are designed with the correct data type and data length
Check if all table constraints like a Primary key, Foreign key, etc. are implemented correctly
Test stored procedures and triggers with sample input data
Input field leading and trailing spaces should be truncated before committing data to the database
Null values should not be allowed for the Primary key column
BIIT is an IT institute for students who want to achieve their academic and professional goals.
At BIIT, we understand the individual objectives of students and adapt our course content accordingly.
Since its inception our institute has been recongised amongst the best for IT training in Laxmi Nagar and our students have consistently shared their experience through their reviews as excellent.
Advance Java | PHP | Python | .Net(Basic Advance) | MVC Framework | Asp .Net | HTML5 & CSS3 | Web Designing | Node JS | Angular JS | MEAN Stack | Python | MySql | PostgreSQL | MongoDB | AWS Devops Engineer- Professional | Andriod | iPhone | ADOBE Photoshop
A-115, First Floor, Near Panna Sweet , opp. Metro pillar no.33 , Shakarpur, Laxmi Nagar, Delhi 110092
Phone No. : +91 9311441524
Mail Us : info@biitnewdelhi.com
Timings : 08 AM – 08 PM
BEST COMPUTER TRAINING COURSES IN LAXMI NAGAR EAST DELHI | BEST COMPUTER CLASSESS IN LAXMI NAGAR | BEST COMPUTER TRAINING INSTITUTE IN LAXMI NAGAR | BEST COMPUTER IT TRAINING ISTITUTE IN LAXMI NAGAR DELHI | BEST SOFTWARE TRAINING INSTITUTE IN LAXMI NAGAR EAST DELHI | BEST HARDWARE NETWORKING TRAINING INSTITUTE IN LAXMI NAGAR | BEST DIGITAL MARKETING TRAINING INSTITUTE IN EAST DELHI | BEST DIGITAL MARKETING COURSES TRAINING INSTITUTE IN EAST DELHI LAXMI NAGAR | BEST BASIC COMPUTER COURSES IN EAST DELHI | BEST TALLY AND ACCOUNTING TRAINING INSTITUTE IN EAST DELHI | BEST COMPUTER IT TRAINING INSTITUTE NEAR ME | BEST CLOUD COMPUTING TRAINING COURSES IN LAXMI NAGAR EAST DELHI | BEST CLOUD COMPUTING CLASSESS IN LAXMI NAGAR | BEST CLOUD COMPUTING TRAINING INSTITUTE IN LAXMI NAGAR | BEST TALLY TRAINING ISTITUTE IN LAXMI NAGAR DELHI | BEST WEB DESIGN TRAINING INSTITUTE IN LAXMI NAGAR EAST DELHI | BEST SOFTWARE TRAINING INSTITUTE IN LAXMI NAGAR | BEST BASIC COMPUTER TRAINING INSTITUTE IN EAST DELHI | BEST PROGRAMING LANGUAGE COURSES TRAINING INSTITUTE IN EAST DELHI LAXMI NAGAR | BEST TALLY AND ACCOUNTING TRAINING INSTITUTE IN EAST DELHI | BEST GRAPHIC DESIGN TRAINING INSTITUTE NEAR ME | BEST JAVA COMPUTER TRAINING COURSES IN LAXMI NAGAR EAST DELHI | BEST PYTHON COMPUTER CLASSESS IN LAXMI NAGAR | BEST C / C++ COMPUTER TRAINING INSTITUTE IN LAXMI NAGAR | BEST SHORT COMPUTER IT TRAINING ISTITUTE IN LAXMI NAGAR DELHI | BEST HARDWARE NETWORKING TRAINING INSTITUTE IN LAXMI NAGAR EAST DELHI | BEST HARDWARE IT TRAINING INSTITUTE IN LAXMI NAGAR | BEST ADVANCED EXCEL TRAINING INSTITUTE IN EAST DELHI | BEST DCA TRAINING INSTITUTE IN EAST DELHI LAXMI NAGAR | BEST ADVANCE EXCEL COMPUTER COURSES IN EAST DELHI | BEST PROGRAMING TRAIMNING INSTITUTE IN EAST DELHI | BEST MULTI MEDIA TRAINING INSTITUTE NEAR ME | BEST VIDEO EADITING COURSES IN LAXMI NAGAR EAST DELHI | BEST COMPUTER CLASSESS IN LAXMI NAGAR | BEST COMPUTER TRAINING INSTITUTE IN LAXMI NAGAR | BEST COMPUTER IT TRAINING ISTITUTE IN LAXMI NAGAR DELHI | BEST VFX INSTITUTE IN LAXMI NAGAR EAST DELHI | BEST WEB DEVELOPMENT INSTITUTE IN LAXMI NAGAR | BEST EMAIL MARKETING TRAINING INSTITUTE IN EAST DELHI | BEST GRAPHIC DESIGNING COURSES TRAINING INSTITUTE IN EAST DELHI LAXMI NAGAR | BEST ANIMATIONS COURSES IN EAST DELHI | BEST UI/UX TRAINING INSTITUTE IN EAST DELHI | BEST ADVANCE COMPUTER TRAINING INSTITUTE NEAR ME
An ISO 9001:2015 Certified Company