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.

SQL Queries

How To Create a Custom SELECT SQL Query

How To Convert an Aggregate to a SQL Query

How To Create a Custom INSERT SQL Query

How To Create a Custom UPDATE SQL Query

How To Create a Custom DELETE SQL Query

Quiz

Exercise

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

Training

Documentation

SQL Queries

This course is included in these Guided Paths:

Have questions about this course?