Scripting and SQL for Software Testers

#text-block-10 { margin-bottom:0px; text-align:left; }

Day 1: Scripting

• Overview of programming: an overview of different categories of programming languages like functional and imperative, with a focus on the more ‘mainstream’ imperative type.
• Translation: turning English descriptions into scripts.
• VB Scripting*:
  • What are variables and how do we use them?
  • Creating procedures (subroutines) and functions
  • Conditional statements and loops
  • Built-in data types and functions
  • Using objects

* Other scripting languages, such as Ruby, Perl or Python, can be made available for in-house courses.

#text-block-11 { margin-bottom:0px; text-align:left; }

Day 2: SQL

• Relational Databases, an overview of relational database schemas:
  • Tables
  • Fields
  • Indices
  • Primary and foreign keys
  • Relationships
• Reading Data:
  • The SQL SELECT statement: reading rows, duplicate values, filtering rows and ordering rows
  • Modifying and summarising the data: expressions, aggregate functions, field aliases, grouping values and filtering rows and groups
  • Retrieving data from multiple tables: joins and table aliases
  • Simplifying queries with nesting: nesting with from, nesting with in, nesting with operators, unions and views
• Adding Data, inserting new data rows:
  • Adding a single record
  • Adding a new table
  • Nested queries
• Changing Data, modifying existing data:
  • Updating all records
  • Updating selected records
  • Updating multiple fields
• Deleting Records, removing data rows:
  • Deleting all records
  • Deleting selected records.
• Parameters, using values picked up at runtime rather than ‘hard-coded’:
  • queries
  • modifying data
• Database Management, managing the database schema/structure:
  • managing tables
  • indices