Database Testing

DB Testing 1 Introduction

Introduction and Course Content of DB Testing

DB Testing 2 Structure part 1

Database basics and structure design Part 1 - Importance of one to one table, one to many tables and many to many tables are explained

DB Testing 3 Structure part 2

More details on tables and record dependencies

DB Testing 4 ACID Properties

Basics of designing the db structural design introduction - ACID Properties and its explanation - Atomicity, Consistency, isolation and durability

DB Testing 5 Why to test databases part 1 of 3

Why DB testing is required? What to test ? How to test? Part 1 of 3

DB Testing 6 Why to test databases part 2 of 3

Why DB testing is required? What to test ? How to test? Part 2 of 3

DB Testing 7 Why to test databases part 3 of 3

Why DB testing is required? What to test ? How to test? Part 3 of 3

DB Testing 8 RDBMS

Introduction to Relational Database Management System

DB Testing 9 ER Diagrams

RDBMS and ER Diagram (Primary key, foreign key) - Importance of primary key and foreign key

DB Testing 10 Normalization

What is DB normalization? Dealing with multiple table and dependent tables

DB Testing 11 Problems in DBMS

Database management systems - DBMS and its disadvantages

DB Testing 12 Joins

Select query and Join - Inner join, left outer join, right outer join and Full outer join

DB Testing 13 Atomicity Part 1 of 4

How to design for an atomicity properties with examples - Creation of table, assign primary key, foreign key, inserting records, update and deletion of records - Part 1 of 4

DB Testing 14 Atomicity Part 2 of 4

How to design for an atomicity properties with examples - Creation of table, assign primary key, foreign key, inserting records, update and deletion of records - Part 2 of 4

DB Testing 15 Atomicity Part 3 of 4

How to design for an atomicity properties with examples - Creation of table, assign primary key, foreign key, inserting records, update and deletion of records - Part 3 of 4

DB Testing 16 Atomicity Part 4 of 4

How to design for an atomicity properties with examples - Creation of table, assign primary key, foreign key, inserting records, update and deletion of records - Part 4 of 4