Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Database Testing

( Duration: 2 Days )

This Database Testing training course will enable testers to directly interact with a database independently of any given application, and thus be able to explicitly test the integrity and accuracy of corporate data and it’s adherence to corporate business rules.

Many test engineers know the basics of SQL and relational databases and can write simple SELECT queries. However, a lot is to be gained from learning how to construct more advanced SQL statements. Armed with those, Data Quality Testing can be much more effective and efficient. Preventing and testing for SQL Injection vulnerability will also be covered.

By attending this Database Testing workshop, delegates will learn to:

  • Prepare a Primary Database for a Data Guard Configuration
  • Create a Physical Standby Database
  • Create a Logical Standby Database
  • Create a Snapshot Standby Database
  • Monitor a Standby Database Configuration
  • Manage a Data Guard Configuration
  • Troubleshoot Standby Database Configurations
  • Tune a Standby Database
  • Back up and Recover a Data Guard Configuration
  • Use Flashback in a Data Guard Configuration
  • Use the Data Guard Broker

  • Knowledge of Manual Testing
  • Knowledge of SQL

COURSE AGENDA

1

Database concepts primer

  • What is a Database Application?
  • Testing the Application vs. Testing the DBMS
  • Back-end vs. Front End Testing
  • QA’ing Data- Who is responsible?
  • What should we test in the Database
  • Knowledge required for the Database Tester
  • Database Testing Phases
  • Database Testing Methodologies
    • Structural Database Testing
    • Functional Database Testing
2

Basic SQL (Structured Query Language)

  • SQL Coding Standards — what you need to know
  • SQL Basics: Select, Insert, Update and Delete
  • Using the Select Statement to Test data
  • Using the Insert Statement to generate Test data
  • Testing for application accuracy using the Update and Delete statements
  • Testing for basic data integrity using Constraints
3

Testing with SQL

  • Joining tables
  • Useful SQL Queries for Data Verification
  • How Concurrency Issues affect data accuracy
  • Database objects:
  • Views
    • Indexes
    • Stored procedures
    • Triggers
    • User-Defined Functions
    • Testing Stored procedures using SQL
  • Testing Triggers and functions
  • Performance Testing using SQL
  • Additional Areas to Test
  • Uncovering corrupt data bugs with SQL
4

Using SQL in Scripting Languages

  • Structural Database Testing using TOAD Tool
  • Database schema tests
  • Databases and devices
  • Tables, columns, column types, defaults, and rules
  • Keys and indexes
  • Stored procedure tests
  • Individual procedure tests
  • Integration tests of procedures
  • Trigger tests
  • Testing Update triggers
  • Testing Insert triggers
  • Testing Delete triggers
  • Functional Database Testing Using QTP
  • Dividing back end based on functionality
  • Checking data integrity and consistency
  • Test back end via front end
  • Login and user security
  • Stress Testing
  • Catching common Database application hacks:
  • Test cases protecting against SQL Injection and other common hacks

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X