Using Custom SQL Queries Exercise

In this exercise, we will create a series of custom SQL Queries that will allow to retrieve, update and delete data in existing entities.This exercise will require a bit of work in Service Studio, but also some testing in the browser.

In the application we have a set of employees, and throughout this exercise we we want to leverage the SQL Tool to\:

  • Retrieve data using a SELECT SQL Query (instead of an Aggregate) with a filtering criteria.
  • Delete data using a DELETE SQL Query.
  • Update data in an entity based on an input parameter.
Need help with this course? Ask in our Forums. | Have an idea to improve your learning experience? Share in Ideas.