This section describes the Xcalar SQL basic concepts and provides instructions on how to use SQL statements to create functions and data applications that can be used outside of Xcalar in Developer and Production environments and third-party Business Intelligence (BI) software.

The Xcalar Notebook workspace contains two main data application development areas:

• SQL panel

This panel provides a SQL editor for you to create, edit, and run your SQL statements. It enables you to create data applications by applying SQL statements using Xcalar SQL on your source data from the tables that you created in Xcalar Load. The SQL panel also provides links to features for analyzing your statements, viewing your table details, and creating advanced function extensions that expand the Xcalar SQL syntax.

• App Builder

This panel augments the SQL panel by providing features and functions for monitoring and troubleshooting your statements and applying Xcalar built-in operators. For more information, see Developing your applications.

About Xcalar SQL

Xcalar SQL enables you to run relational database statement type processing on your data in Xcalar Notebook. It is based on the traditional SQL ANSI standard 2011.

About the SQL development area

The SQL development area is intended for users who are experienced with SQL concepts, the SQL language, and applying and running SQL statements on their data for analysis and development.

The SQL panel not only enables you to create and apply new statements and functions to your data, it also provides features that enable you to leverage your existing statements and functions. For more information, see Understanding the SQL panel.