Support

Scripting and SQL for Testers Course

7 sessions available starting from $1,650.00

Subject: Database Software

Ages: All ages

Skill level: All difficulty levels

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...

see more

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.

see less

Choose from 7 available sessions:

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • Melbourne, VIC

Price: $1,650.00

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • Melbourne, VIC 2000

Price: $1,650.00

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • Canberra, ACT

Price: $1,650.00

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • Melbourne, VIC

Price: $1,650.00

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • Brisbane, QLD

Price: $1,650.00

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • Melbourne, VIC 2000

Price: $1,650.00

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • Canberra, ACT

Price: $1,650.00




My Other Listings

Agile Leadership Course
Agile Leadership Course
9 sessions available starting from $990.00
Advanced Business Process Management Course
Advanced Business Process Management Course
2 sessions available starting from $1,870.00
ISTQB Training Course | Advanced Test Analyst Module
ISTQB Training Course | Advanced Test Analyst Module
3 sessions available starting from $2,200.00

see all listings ยป


Found In