How to build queries faster in Toad for SAP Solutions

Hello, folks. My name is Robert Pound. And I am a product technologist for Quest. The topic of this video is how can I build queries faster in SAP databases. For this video, I will use Toad for SAP solutions, Query Builder, and Editor. Note, for this video I've already established a connection to an SAP ASE. So the first thing I will do is click the Build button in the ribbon bar. This will open up a Query Builder. Tab and I will go ahead and drop in the desired object. And a second object. And a join has already been established because of the primary foreign key relationship in the database. But you can create joins by clicking and dragging on one column and dragging it to the column in another table. And with a few simple mouse clicks, I've added all the columns in both tables. And we can go ahead and deselect some of them. Both in the visual portion as well as at the bottom. And we'll go ahead and run the results and see what we get back. So we've gotten some results sets. And if we look at the Query tab, we can see that it's already built out the query based on what we've got in the diagram. So let's go back to that real quick. And we'll go ahead and filter by state just so we can modify this. And we'll filter on Washington. And run it again. And we've got a filtered result set. So as we modify the query, we can see the results that change. And we can compare it over time. We can also look at things like profiling, which will give us an idea of the makeup of the data itself. So from here we've already gotten a pretty solid base. We could come back to the Query tab and copy and paste from here to a larger script. We can come to the top and send this to the Editor and continue working on the script from here and get that intelligent feedback in the Editor to continue modifying. You can also take advantage of some of the productivity tools like SQL Recall and Code Snippets. And there you have it. Short and sweet. Obviously, this isn't everything from the Editor. There are many different tools and productivity tools in both the Editor and the Query Builder. But hopefully, this showed you that you could get started quickly with a few simple mouse clicks. For more information on this or other topics, you can check out the Help file. It has a wide range of information as well as tutorials to help get you started. You can also check out the community driven innovation going on at www.ToadWorld.com and clicking the blog tab. For more information on this product, go to www.Quest.com/products/Toad-for-SAP-Solutions. Thank you, and have a tremendous day.