Course Outline
1 Database testing fundamentals
- Read entity relationships and connect application requirements to stored data.
- Identify test boundaries, expected database states and common integrity defects.
2 SQL for data verification
- Use filtering, joins, aggregation and subqueries to verify application results.
- Compare before and after states for create, update and delete operations.
3 Schema and integrity tests
- Check data types, nullability, defaults, primary keys and uniqueness.
- Test foreign keys and check constraints, including invalid and boundary inputs.
4 Views and database routines
- Check view results and test stored procedures, functions and triggers where supported.
- Verify returned values, changed rows and expected errors against business rules.
5 Transactions and concurrent activity
- Test commit and rollback behaviour and controlled failures during a business operation.
- Observe two-session conflicts and confirm the expected outcome for the selected platform.
6 Basic security and performance checks
- Verify permitted and denied database actions for sample application roles.
- Review SQL injection prevention test cases and establish a small query-timing baseline.
7 Test data and regression automation
- Prepare repeatable sample data and isolate test cases with setup and cleanup steps.
- Create SQL assertions and introduce the selected platform's database unit testing approach.
8 Practical assessment and defect reporting
- Execute an order-processing test suite against seeded data and logic defects.
- Document the SQL, expected result, actual result and retest outcome for each finding.
Lab setup
Choose one platform, such as SQL Server or PostgreSQL, and prepare a non-production database, SQL editor, routines and sample user roles. Use SQL checks as the common foundation. Select any unit testing framework after confirming the platform. SQL Server unit testing tooling is an option when the required environment is available.
Requirements
Participants should understand relational tables, keys and relationships and be able to write basic SQL queries, joins and aggregations. Familiarity with software testing fundamentals is helpful. Database administration experience is not required.
Testimonials (2)
bizim anlayışımız və məlumatlarımıza uyşaldırılmış
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
Machine Translated
The training instruments provided.