Bridging the Gap between Technology and Business

Database Testing (45 Hours)

  • Introduction to DB Testing
  • Importance of DB Testing
  • Roles & Responsibilities of DB Test Engineer
  • Database Components to be tested
    • Data Design Testing
    • Data Validity Testing
    • Data Integrity Testing
      • Domain Integrity Testing
      • Entity Integrity Testing
      • Referential Integrity Testing
    • Stored Procedure Testing
    • Performance Testing
  • DB Testing Phases
  • DB Testing methodologies

  • Introduction to Database
  • What is DBMS & RDBMS?
  • Normalization
  • Introduction to SQL
    • Data types
    • Operators
  • Data Definition Language
    • Create
    • Alter
    • Drop
    • Truncate
  • Data Manipulation Language
    • Insert
    • Update
    • Delete
  • Data Retrieval Language
    • Select
  • Aggregate Functions
  • Grouping the result of a Query
    • DISTINCT Clause
    • WHERE Clause
    • ORDER BY Clause
    • GROUP BY Clause
    • HAVING Clause
  • Data Integrity
    • Entity Integrity (Primary Key, Not Null)
    • Domain Integrity (Check, Unique, Default)
    • Referential Integrity (Foreign Key)
    • Testing Key Constraints & Schema Definitions
  • SET Operators
  • Sub Queries
  • Aliases (Table / Column)
  • Joins and Types
    • Inner Join
    • Outer Join (LEFT, RIGHT, FULL)
    • Self-Join
    • Cross Join
    • Testing of Joins & Sub queries
  • Data Control Language
    • Grant
    • Revoke
  • Transaction Control Statements
    • Commit
    • Rollback

  • Introduction to T-SQL
  • Advantages of T-SQL
  • SQL Server Architecture
  • Variables & Data types
  • Conditional and Iterative Statements
  • Cursors
  • Stored Procedures
  • Testing of Procedures
  • Triggers
  • Testing of Triggers

  • DB Testing Process
    • Test Plan
    • Test Scenarios
    • Test Cases
    • Entry Criteria for DB Testing
    • Test Execution
    • Defect Management
    • Test Deliverables
    • Test summary report
    • Bugs summary report

  • SSMS for SQL Server
    • Introduction to SSMS
    • DB Testing using SSMS
    • SSMS Navigation process



Be Our Channel Partner for IT Training Division

Do you want to be a part of our mission in providing Quality Training and help in “Bridging the Gap Between technology and Business”?

  • Amoeba Technologies Sales Executive will contact you and shortlist you for being our channel partner based out on our discussion and shortlisting process
  • We only promote limited partnership depending upon the credibility, location and Business demand
  • No compromise on Trainer Technical Expertise. Amoeba Technologies will provide their own Technical Consultants and Trainers

Please drop your interest and profile at Sales@amoebatechno.com

Testimonials

We sincerely perceive, consider and positively act on our customer’s feedback

Our Clients

Our focus is only you and your benefit