Once the schema is created, close the SQL Script window. You’re ready to create a table. Creating a table I’ve created a database called SERVERS, that will be listed in the SCHEMAS pane.

You create a database, add tables, and then start adding data to the tables. All data is stored in a folder on your device’s internal storage (named PortoDB).

Creating a new table from query results can help you build a database of your clients, employees, expenses and other business details by allowing you to select certain columns from existing tables.

Notice that the pivot table is displaying only the data that’s pertinent to our present analysis. On the right-hand side, you’ll find the criteria that Excel used to create it in the ...