# A use case of system SQL templates

As there are many common, standardized SQL statements, Talend Studio allows you to benefit from various system SQL templates.

This section presents you with a use case that takes you through the steps of using MySQL system templates in a Job that:

* opens a connection to a Mysql database.

* collects data grouped by specific value(s) from a database table and writes aggregated data in a target database table.

* deletes the source table where the aggregated data comes from.

* reads the target database table and lists the Job execution result.

To connect to the database and aggregate the database table columns:

### In this section

* [Configuring a connection to a MySQL database](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2026-09/configuring-connection-to-mysql-database)
* [Grouping data, writing aggregated data and dropping the source table](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2026-09/grouping-data-writing-aggregated-data-and-dropping-source-table)
* [Reading the target database and listing the Job execution result](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2026-09/reading-target-database-and-listing-job-execution-result)