SQL Query Analyzer

Query Analyzer

Welcome to an overview video presentation. Aqua Data Studio query Analyzer. The query analyzer is a core window. Once you connect or register servers connected to your databases, you can easily open a Query Analyzer window under the Server Query Analyzer menu. Also you see the icon there with the data grid and the magnifying glass. Here I am connected to a number of different environments. I can expand these connections to say, an Amazon Cloud environment, an Excel spreadsheet, a MySQL database, and a SQL Server environment and easily bring up a Query Analyzer by right clicking and choosing Query Analyzer. Let’s show some examples of opening up some different Query Analyzers where I have some different color coding connections that we talked about in the Register Server. Once you open up a Query Analyzer, you can type SQL or open up a SQL statement with the File menu open or the yellow folder and easily bring a SQL statement into your Query Analyzer.

SQL Query Analyzer

Here’s an example of a saved SQL statement that will bring it to the Query Analyzer and execute with the green run arrow and bring back my result set. For executing this SQL statement, I can easily open up multiple Query analyzers just by right clicking Query Analyzer or again under Server Query Analyzer. Let’s show some other examples of bringing SQL into the Query Analyzer. Here I could easily just start typing SQL and I’ll see the IntelliSense and color coded pop up windows that you’d expect in a tool like Aqua Data Studio Query Analyzer. Also the Sql Editor functionality in other tools. Here I can easily choose a table in this example and then again execute that SQL statement just by clicking on the green run arrow and bringing back the results set for that SQL statement. If I drill down into the table through the navigation tree, I could easily right click on a table and create SQL that way.

Write SQL Queries

Here’s an easy way to also write SQL against this products table. For example, here I can choose in the right click menu script Object to Window as a select statement, and that would build a SQL statement in the Query Analyzer for me. I also have the choice to perhaps choose a qualified path. Here for example, right click Script Object to Window and there I can choose where it will have the qualified paths for each column name. Now I can talk more about the execution arrows within the Query Analyzer. The first four or five icons are listed here under the Query Main menu, and we can talk about those here. The first icon with the cylinder and the double green run arrows is the parse. That will just parse through this Query Analyzer and show what types of statements make up this Query Analyzer. In this case, I have three DML statements.

SQL Statements

This single green run arrow will execute all the SQL. If I click on the green run arrow it will execute all the SQLl and I have individual result tabs for multiple statements. Or I could execute just a single statement with the execute current where that would just execute a single statement for me. You have the flexibility in the Query Analyzer to execute all or multiple statements or single statements. The execute edit will bring up the table editor, in this case the table being called on in this sql statement. Here’s the table data editor and we’ll have more details in another video on the table data editor. The execute with explain will show the execution plan, the path the database is taking to execute that statement, and that may be of interest for developers or users interested in improving or tuning SQL. Thank you for watching this introduction video.

Aqua data Studio query Analyzer.