2 Working with Local Data

Enterprise applications thrive on data, and Oracle APEX makes working with any data simple and efficient. While it's also easy to integrate remote data, most APEX applications work primarily with data in local tables.

• Database Concepts Primer
  The Oracle APEX engine and App Builder run inside the Oracle database.
• Working with Sample Data
  While you are learning Oracle APEX, if you don't already have an existing set of database tables to experiment with, you can work initially with built-in sample data.
• Installing a Sample Dataset
  In addition to working with built-in sample data, you can also install additional sample datasets that include multiple tables related to a functional area.
• Importing Data from a File
  The APEX Builder's Data Workshop lets you easily import data from Excel spreadsheets or files in JSON, XML, or Comma-Separated Values (CSV) format.
• Creating Data Models with Quick SQL
  Create tables and relationships quickly by describing your data model in Quick SQL shorthand.
• Creating a Data Model Using Natural Language
  You can create a data model by using natural language to describe what data your application needs to manage.