Database Testing

Have Queries? Ask us +91 72592 22234

Course Overview


Xpertised Offers Advanced and Personalized Instructor Led Online Classroom training on Database Testing which gives you the opportunity to interact with a Database Testing instructor and help you enhance yourself to meet the demands of the industry.

Learn from our instructors from the convenience of your home or office. Interact and learn live with trainers and other participants.

Course Content


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   

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   

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

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

Customer Reviews


Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.
-Waseem

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.
-Tanmoy

...more
Share:

For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234