Support

Thank you from doMore

I'd like to thank you for being involved in the doMore.com.au community and the team and I hope that you've received value from being a part of it.

doMore was our original passion project born out of the desire to help connect people wanting to learn something new with experts that could teach them over 10 years ago.

Over the years we have helped almost 70,000 learners connect with one of over 1,500 courses and providers, across the country. For that, we're very proud and grateful for your contribution.

doMore.com.au also served to teach us about how to help measure and improve business performance and inspired the launch and growth of two other companies as a result, one of which we've decided to dedicate our resources and energy to making great.

We'll be switching the site off on Tuesday 31st of July. If you have any questions or concerns, please contact us directly on [email protected].

Thanks again and good luck with your teaching endeavours in the future.

Warm regards,

The doMore team.

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 Development Delivery Phase Start Me Up Training Course
Agile Development Delivery Phase Start Me Up Training Course
8 sessions available starting from $1,650.00
Mastering the Requirements Process Course  - Part 2
Mastering the Requirements Process Course - Part 2
4 sessions available starting from $1,870.00
ISTQB Training Course | Advanced Technical Test Analyst Module
ISTQB Training Course | Advanced Technical Test Analyst Module
2 sessions available starting from $2,200.00

see all listings ยป


Found In