Welcome to the Oracle APEX Foundations Course. Today in this lesson on using SQL Workshop, I will be talking about generating SQL using Quick SQL. Let's get started. In this section, you'll learn what is Quick SQL and you'll also learn how to load some Quick SQL samples. What is Quick SQL?

Quick SQL allows you to rapidly design and prototype data models by using a markdown-like shorthand syntax that expands to standards-based Oracle SQL. The following are some of the top use cases of Quick SQL: Quickly create robust data models, save Quick SQL shorthand syntax as a model to iterate through model changes for use as a template model to jump start the next model design, easily generate random data, learn SQL, create table, select, insert, index, trigger, PL/SQL package, and view syntax by using the provided examples. Quick SQL is designed to reduce the time and effort required to create SQL tables, triggers, and index structures. This tool is not designed to be a replacement for data modelling.

After you generate the SQL, you can then tweak and expand it. Now let us see the two different ways of navigating to Quick SQL in the APEX workspace. From your workspace homepage, click the 'SQL Workshop', down arrow, select Utilities and then select Quick SQL. Alternatively, from your homepage, you can select the SQL Workshop icon, go to Utilities and select Quick SQL. You can load and view Quick SQL samples to learn about SQL shorthand syntax. You can load these samples by clicking either the Help button or the Load button. Here you see the different samples you can load when you click the load button. For example, if I click on the Departments and Employees, Load Model, I can see the Quick SQL shorthand syntax and the corresponding generated SQL on the right hand pane. Similarly, if I click on the 'Help' button, navigate to the Samples tab, and you can load the different samples from the given list. To summarize, in this section you learned what is Quick SQL and how to load Quick SQL samples. I hope you learned something useful. Thank you for watching.