Select Your Style

Choose your layout

Color scheme

Database Testing

Database Testing

Database Testing

Database Testing
Databases, the collection of interconnected files on a server, storing information, may not deal with the same type of data, i.e. databases may be heterogeneous. As a result, many kinds of implementation and integration errors may occur in large database systems, which negatively affect the system's performance, reliability, consistency and security. Thus, it is important to test in order to obtain a database system which satisfies the ACID properties (Atomicity, Consistency, Isolation, and Durability) of a database management system.

Black Box Testing in database testing

Black box testing involves testing interfaces and the integration of the database, which includes:

  • Mapping of data (including metadata)
  • Verifying incoming data
  • Verifying outgoing data from query functions
  • Various techniques such as Cause effect graphing technique, equivalence partitioning and boundary-value analysis.

With the help of these techniques, the functionality of the database can be tested thoroughly. Pros and Cons of black box testing include: Test case generation in black box testing is fairly simple.

While generating test cases for database testing, the semantics of SQL statement need to be reflected in the test cases.

Basics Of Data Base

  • What are Databases?
  • Create sample database
  • Create base data structure and data content
  • Understanding Primary Key in Data base
  • Understanding Foreign Key in Data base
  • Understanding Unique Key in Data base
  • Difference between Primary, Foreign, and Unique key
  • Understanding Data Type
  • Data Table relationship

SQL Programming

  • SQL – Basic
  • SQL Index
  • Create Database
  • Insert Table
  • SQL Constraints
  • What is SELECT
  • What is FROM
  • What is WHERE
  • SQL Conditions
  • Using ‘OR & ‘AND’
  • ORDER BY: Sorting records Ascending/ Descending
  • BETWEEN: Display records in a range
  • DISTINCT: How to get unique records
  • SQL INSERT: To add new records
  • SQL UPDATE: Update existing records
  • SQL DELETE: Delet existing records
  • SQL TOP: How many rows to return
  • SQL In: Get multiple records
  • SQL Alias: Assigning short names of table inside a query
  • SQL Joins
  • SQL INER Joins
  • SQL LEFT Joins
  • SQL RIGHT Joins
  • SQL FULL Joins

SQL Functions

  • Average ()/li>
  • Count ()
  • First ()
  • Last ()
  • Min ()
  • Max ()
  • Sum ()
  • Group By ()
  • Having ()
  • UCase ()
  • LCase ()
  • MId ()
  • Length ()
  • Round ()
  • Now ()
  • Format ()

Creating SQL Triggers

For detailed course details click here to view. For more information write to us at or fill the Contact form.

Course Duration 12 Hours
Class Timings (Weekend) 10.00 AM - 6.00 PM
Class Timings (Weekdays) Availability Upon request

No Comments

Comments are closed.