Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Desktop application test automation

Name: Desktop application test automation
Rating: 4.2 (7 reviews)

test automation, robot framework, desktop automation, robotic process automation, windows GUI, database testing, rpa

Created byRaphael Roems

Last updated 11/2024

English

English [Auto],

What you'll learn

Creating and executing tests with Robot Framework
Test automation for desktop GUI applications
Test automation for database queries
Test reporting with Robot Framework

Course content

8 sections • 44 lectures • 3h 33m total length

Introduction0:54
Raphael introduces desktop application test automation, focusing on underserved areas and database testing, using Robot Framework’s keyword-driven scripts to empower less technical users while applying core principles to your projects.

Install Python3:16
install python 3.11 from python.org, respect library compatibility with 3.12 and above, configure advanced options and the installation folder, and verify with python --version in the command prompt.
Install rpaframework library5:12
Install robotframework-databaselibrary1:13
Install pymssql library1:08
Install pymysql, the Python database library used to connect to a Microsoft SQL database, via the PyPI site and pip install in the command prompt.
Install rpaframework-recognition library0:59
Install Accessibility Insights2:08
Install Accessibility Insights to locate elements in Windows GUI applications by downloading the tool, running the installer, and configuring telemetry and startup options.
Install Visual Studio Code2:39
Install Robot Framework Language Server VS Code plugin1:34
Open Visual Studio Code and choose a theme (dark modern or light modern). Install the Robot Framework Language Server extension to enable test creation.
Install Rachota application and Java4:18
Install ManicTime application3:07
Install ManicTime by downloading the 64-bit or 32-bit setup, running setup.exe, and accepting the license with default options.
Install Grindstone application1:51

Section overview2:17
Section overview on inspecting desktop GUI elements, actions that will be automated and locator strategy
Inspect Grindstone application elements9:25
Inspecting Grindstone application using Accessibility Insights tool for automation elements
Discuss rpa framework library keywords2:50
Keywords in rpa framework library that will be used for automating actions in the different applications
Discuss Builtin library keywords3:48
Keywords from the Builtin library that will be used for verifying actions
Create initial Robot Framework test using Visual Studio Code3:51
Creating a basic test automation script using Visual Code and Robot Framework libraries
Open Grindstone application6:59
Create an automated test script to open Grindstone with the RPA desktop library in Python, set the app path, use click to handle the okay dialog, and kill the process.
Access Grindstone task option9:49
Navigate the grindstone application to create a new work item by using click commands and send keys, refining test scripts with accessibility insights and keyboard shortcuts.
Create and remove Grindstone task13:18
Create and remove Grindstone tasks by entering a name, details, due date, and priority, saving, and verifying addition and deletion via test runs and return status checks.

Section overview2:17
Develop test scripts for the Manage Time desktop app, covering opening the app, creating and removing a task, verifying deletion, navigating settings, and using Application Insights with Visual Studio Code.
Inspect ManicTime application elements with Accessibility Insights9:17
Use Accessibility Insights to inspect ManicTime elements, note no name or keyboard shortcut, and verify navigation via tab and spacebar, then use image recognition for dynamic settings and delete actions.
Open and close ManicTime application7:10
Create a robot framework test in Visual Studio Code to open and close the Manictime app with rpa desktop, desktop operating system, and rpa.windows libraries.
Access ManicTime menu options11:26
Navigate the ManicTime menu to select all option, use keyboard navigation and screenshot verification, then automate settings and okay clicks using RPA desktop actions.
Remove ManicTime task and verify removal8:49
Remove ManicTime task and verify its removal in an end-to-end test by adding a settings task, capturing a settings.png screenshot, deleting tasks, and validating deletion with automated checks.

Section overview0:35
Discuss DatabaseLibrary keywords2:45
DatabaseLibrary keywords used in this section to perform and verify actions
Discuss String and Collections library keywords1:47
String and Collection library keywords which are used in conjunction with DabaseLibary keywords to structure and verify actions
Connecting to Microsoft SQL database9:16
Manual walkthrough and test automation scripting for connecting to Microsoft SQL Server using Windows and SQL Server authentication
Reading data using the SELECT statement6:46
Using a SELECT statement to a single value
Structuring query result data returned from a SELECT statement4:58
Using a SELECT statement to retrieve multiple values and structuring these values for use in further actions
Updating data using the UPDATE statement6:25
Using the UPDATE statement to update a value and verifying the change
Adding data using the INSERT statement5:47
Using a SQL file to insert data into a database table and verifying the change
Removing data using the DELETE statement3:47
Using the DELETE statement to remove a row of data an verifying the change
Database query keywords

Overview on section0:35
The lecture introduces test script improvements by eliminating duplicated steps, using keywords, and leveraging setup and teardown features to manage variables.
Creating keywords2:10
Create and reuse a unique keyword to eliminate duplication across test scripts by centralizing database connection values as 'database connection', then verify tests pass.
Using Setup and Teardown in test automation scripts1:52
Using variables within tests5:50
Creating and set variables at test, suite and global variables, also the retrieving of the variables within a keyword.
Accessing variables in tests

Requirements

Little to no programming experience needed

Description

- Introduction on Robot Framework.

- A little bit about my background and experience.

- Installation process of Python 3.x and Robot Framework.

- Installation of Visual Studio Code and required extensions needed in this course.

- Creating structured test scripts in Robot Framework, including keywords, documentation and tags.

- Automating tests for 3 different types of desktop applications, covering the following scenarios in each application:

Open application and add task
Edit the same task
Remove newly added task
Navigate through settings option
Close application

Troubleshooting issues will also be covered, as the steps are created from scratch, and any issues encountered as investigated and fixed.

Installing the required libraries and tools needed for desktop GUI automation.

Identifying the locators for the various functionality using Application Insights

Discuss the common keywords used in the various libraries which will be used for automating the different desktop applications.

- Database query automation for a Microsoft SQL database.

Installing the required libraries for database automation.

Connecting to a database, creating and executing queries, and verifying results.

This will include CRUD operations: Create (Update), Read (Select), Update and Delete queries.

- Improvements to test scripts using keywords, setup and teardown steps, and using variables in tests to reduce the duplication of steps.

Who this course is for:

Test automation/RPA for desktop GUI applications

Desktop application test automation

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 1min

Tool installations11 lectures • 27min

Grindstone application automation8 lectures • 52min

ManicTime application automation5 lectures • 39min

Rachota application automation5 lectures • 41min

Database automation9 lectures • 42min

Improving test script structure4 lectures • 10min

Closing thoughts1 lecture • 1min

Requirements

Description

Who this course is for: