Building Queries and Data Views
|
Next Steps: Building and Testing Sample Queries
If you have not already done so, we suggest working through the steps in Getting Started, which takes you through the basic tasks of configuring some data sources and using the Data View Builder to design a query using the Order Query example from our Avitek Sample. (For more information about the Avitek Sample and other samples, see the Samples introduction page.) Working through the Getting Started (or even reading through the steps related specifically to using the Data View Builder) is an easy, hands-on way to get familiar with working with schema representations of data sources and using the basic query-building tools, task flow, and workspaces in the Data View Builder.
If you have already worked through the Getting Started topic or if you are ready to get started on building some other basic queries, we suggest you skip to the following topics in this document:
- Examples of Simple Queries (at the end of Designing Queries) provides two example queries that provide practice in some basic techniques such as creating join conditions, using functions, setting scope of the target, using the sort-by feature to specify the order of the result, and running queries.
- Query Cookbook provides several examples of complex queries using more advanced features and functions such as creating unions, using date and time functions, using aggregate functions, using hints to optimize queries, and using data views in queries.