At a glance
Duration:
2 days
2 days
Cost:
AUD $1650 inc GST
NZD $1750 + GST
AUD $1650 inc GST
NZD $1750 + GST
Contact us for any enquiries
including in-house delivery.
including in-house delivery.
Location/Date:
Scripting and SQL for Testers
Start working with the technology
This course is specifically designed to empower testers to:
- use the full potential of their test automation tools using VB scripting*
- maintain their own test data using SQL
- also cover those non-functional requirements utilising SQL and scripting skills.
* Other scripting languages, such as Ruby, Perl or Python, can be made available for in-house courses.
Intended For
Testers with the need to:
- understand programming basics
- automate tests (using VB scripting*)
- create, manipulate and maintain test data using SQL.
Prerequisites
None, this is an introductory course.Learning Outcomes
By the end of this course, participants will be able to:
- recognise the common points of defect injection by developers
- understand the structure of (imperative) programming languages
- become familiar and comfortable with writing VB Scripts (other scripting languages available on request)
- be able to create SQL SELECT statements that retrieve any required data and create SQL INSERT, UPDATE and DELETE statements to make changes to that same data.
Content
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.
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
Method Used
Each participant will have dedicated use of a personal computer for the entire duration of the workshop. Practical scripting and SQL exercises form a large part of the course.
