Organizations today are bombarded with more and more data every single day. Data may come from traditional sources like an accounting system and B2C websites or from non-traditional sources like social media and smart devices. As a result, more and more people need access to that data to make decisions and grow their business. That's where Toad Data Point and it's visual Query Builder step in to the rescue.
The Query Builder is a visual [and easy] way to query any data source so I wanted to introduce it to the masses. It can query a single data source or many data sources at the same time. This is accomplished via the Query Builder window below.
The top portion of the Diagram tab is the object palette where we can drag and drop various data elements to build your query. These can be tables or views from a RDBMS like Oracle or SQL Server or from an Excel spreadsheet. Each column represents a selected field from the data elements in the object palette. The numbered items below the object palette are used to define your query.
1. Aggregate - summarize the data, i.e. count, summation, average.
2. Where - filter the data.
3. Group By - used in conjunction with #1 to group the data by non-aggregated columns.
4. Having - used in conjunction with #1 to filter summarized data.
5. Sort - order the data in ascending or descending order for each column.
6. Visible - include the column in the result set or hide it for use in a filter as I've done for the PART_ID column.
7. Field Alias - name the column something else in the result set.
The Query tab displays your resulting query and the Results tab show the result set from executing the query. In my next few blogs I will show you how to build complex queries step by step and different types of queries that satisfy varied data requirements. Until then... Cheers!