Back to Course Description

Course Agenda for SQL for Software Testers

1. Understanding Database Structures
  • Understanding data and data types
  • Understanding attributes
  • Tables
  • Records
  • Primary/Secondary/Foreign Keys
  • Relationship between tables (one-one, one-many, many-many)
  • Group Workshop: Create a sample database
2. Understanding SQL
  • Define SQL 
  • SQL components
  • Simple SQL-Create, Retrieve, Update and Delete (CRUD)
  • Finding the data needed -Retrieving
  • Group Workshop: Writing Queries
  • Data manipulation (create, delete, update)
  • Group Workshop: Writing Inserts, deletes, modifications
  • Creating Views
  • Group Workshop: Creating Views
  • More advanced SQL
  • Joins, Nesting and recursion 
  • What to do with the data you've retrieved
  • Dumping data to files
  • Populating excel spreadsheets with data
  • Dumping the data into another database
3. Analyzing Database Design
  • Major DB vendors and basic differences in commands & SQL Tools
  • Oracle, SQLServer, MySQL
  • Where is validation done?
  • Data Mining for bugs and test cases
  • Group Workshop: Finding potential bugs in the database
  • Using ODBC 
  • Triggers and cursors
  • Stored Procedures
  • Timing and locking issues
  • Group Workshop: Testing stored procedures 
4. Data Integrity 
  • Looking for data integrity bugs
  • Maintaining multiple test databases
  • Testing a database migration/conversion
  • Course Review