Training
Courses and docs that will have you building high-quality mobile and web apps with OutSystems.

SQL Queries

This course will introduce you to writing your own SQL queries. With this course, you will be able to know how to create complex SQL queries to interact with the entities defined in OutSystems.

What will you learn?

You’ll learn how to create custom SQL queries, how to create SELECT, INSERT, UPDATE and DELETE queries. Demos on these scenarios are also included!

What do you need?

Your laptop with Windows 7 or higher and version 11 of the OutSystems Development Environment tools. You will also need access to an OutSystems 11 server (or Personal Environment).

Before you start...

We recommend that you first take the following course:

Enroll in this courseAre you ready to start learning?
Enroll in this course to track your progress, resume where you left off and have proof of completion.
Course Ratings & Reviews
Course rating
4.6
(1.074 ratings)
Sort by
Stefano Valente
Its not necessary to have a separate video for Insert, Update and Delete, since they all work the same. Let the Trainee make them in the exercise.

I would however think its quite nice to have an example of a procedure that deletes records and tells us howmany records were affected. (would be best if the non-select query would return this info by default.
14 Jan (2 days ago)

Gary1
Gives a good general overview of the pure sql function provided within OutSystems.
11 Jan (5 days ago)

Samyak Biswas
good and clear
2020-12-30

Nicholas Augusto Carvalho
Still boring
2020-12-29

Lyle Martin
Solution Architect
Exercise was good practice, remembering to put parameters in the right place, interface vs. logic.  Or else things do not work as expected.
2020-12-28

Showing 1-5 out of 61 reviews