Transcript

00:08

Rapid SQL

Hello, welcome to an overview of IDERA’s Rapid SQL, you can see the version that I’m showing, which is the current version 17. X. From the IDERA product page, there’s the Rapid SQL Home page that you can drill down into. From IDERA.com the products drill down has the DB PowerStudio homepage So Rapid SQL exists as a standalone tool and also part of a bundle called PowerStudio. You have access to these resources and then other helpful areas. There’s documentation for all the areas in these products. This is a very tested and proven technology and a big time saver and productivity tool for developers or folks that need to access databases and different platforms. I have a few slides here to introduce and then this new momentum now with these products, with a lot of folks working from Home, and the ability to work remotely and connect your databases is more important than ever.

01:11

Database IDE

Just a few slides here for introducing the product. Again, this recording is about Rapid SQL, a database IDE and productivity tool for building SQL accessing table, data, building store procedures, and then a lot of benefits in terms of time saving and code completion code reviews. Those areas throughout the toolbars and the menus that we can look at. Building code efficiently, dragging and dropping to build SQL and the Visual Prairie Builder is a feature that many of us are familiar with and expect in a tool like this. More advanced features like stepping into code, debugging, code, checking code in and out of version control systems. These are all areas that Rapid SQL supports across multiple platforms. Here’s a list of the latest platforms, you can see some of the Oracle 19 SQL Server 2019 SQL Azure now, a lot of enhancements are added as the database platforms have grown over the years.

02:10

SQL Developers

There’s different bundles that I mentioned, right? There’s a DBA bundle and Developer bundle. Today we’ll focus on the developer bundle, which includes Rapid, SQL, DB, Optimizer and Change Manager. Okay, so from the product you have a flexibility in terms of the user interface. I moved the tabs to the top portion of the screen for myself, so lots of options that you can dive into under Tools options. The Tools menu is filled with different resources for working on code and accessing, and then there’s different toolbars as well. You could invoke the Tools Toolbar menu and those icons will show. You can turn menus off or on and choose your user interface. That’s one of the benefits of the PowerStudio products, they’re so robust in terms of menus and ways of accessing things through icons or toolbars or right click menus. I’ll uncheck the Toolbar menu and drive from here.

03:01

SQL IDE

The starting point is building your connection tree and so data Source register or discover you have different ways of starting, but Register Data Source or if you just right click here, Register would show you the wizard interface for connected to the different platforms that wrap SQL supports. Depending on the platform, the wizard will change. Here’s SQL Server, I can click next and you can see what areas it’s looking for, the host name for SQL Server. For Oracle. You’ll look for the Sid or the instance. You have flexibility there in terms of the built intelligence here that knows what platform you’re connecting to and what areas of information are needed. You can create folders in different ways and then even clone connections. Here Register, like would clone a connection and then let you manage or create your folders in different ways. Depending on the platform, you can explore the navigation tree.

03:55

Oracle Database Support

Here in say, SQL Server, I control to my databases, go into my database and see my object supports there. For Oracle, you might have a Schema view, right? If I wanted to sort by schema and then look at my Oracle tree, you have flexibility that way. For Oracle, some users are familiar with the Schema drill down, drill to my Schemas, and then I see all my object types that way. You have options in terms of how you’d like to organize the tree. There’s an Explorer view, which is a subset or tab that gives you that same navigation. Under data source New Explorer I can open up an explorer tree and then I could hide or minimize the main data source navigator So Explorer is similar, but you populate the right hand side tab. Here I could drill into my databases. See my list of databases.

04:44

SQL Create Table

Right click there. There’s create a database object, right, so drill into my database object list here. I could highlight my tables. Right click here and you see lots of actions in terms of creating a table. Dive into the table data for this table, or you can even just double click on a table and then that would open up an additional tab for you. So you have flexibility. Some users might just go right into the Data tab for individual table. Take action there. Otherwise some folks might dive right into the SQL editor and start typing SQL. You have the new ISQL tab there for building SQL or opening up existing SQL scripts, and then other wizards for creating objects. There’s the DDL editor, which would open up a wizard interface for creating an object. Here I could just start typing SQL. Of course you have color coded editors and IntelliSense in ways you might expect.

SQL Statements

05:34

If I just type a single SQL statement and click the green blue run arrow, that would execute, that bring back my Results tab. You can have options in terms of the results, multiple results or individual Results tabs. If I executed multiple statements, I could have multiple results tabs here as well. Here maybe I’ll just type some different statements. Let me close these results tabs here. I’ll just right click here, say close all. Here if I was to execute, say, multiple statements, then I could have multiple result tabs. Here I could click the run arrow and then I have multiple result tabs. So you have options there. Here’s the options icon in terms of would you like a single window? Multiple. Lots of flexibility there just in terms of executing SQL here, let me go to maybe a more advanced SQL statement. I can run that just to show the complexity here.

06:26

Execute SQL

And then here’s the execution plan. That’s an icon where you can view the execution path the database is taking. You have different ways of viewing this as well. Some of this might be getting a little advanced, but just showing some of the vibrant visual effects of Rapid and DB artisan really is what brings value and makes using the tool so productive. Okay, so here were typing SQL, right? If you’re familiar enough with typing your own SQL, but maybe you’re newer to building SQL, right? You have features like the query builder. Under the Tools menu, query builder, this would bring back a window with a list of my objects. I could choose a database here and then drag and drop objects to the white space and build SQL that way. If I was, say, newer to writing SQL, this can be a visual way to build SQL where you can see the relationships between tables if you have referential integrity in the database.

07:26

I could say select additional fields. It starts building a tree view on the left and then the sequel on the lower portion of my screen. Depending on how familiar you are with executing SQL, this might be more helpful for some users than others. I can just run that with the green run arrow here, bring back a result set, and then you have the similar options for working with your data wherever you have result sets, right, so here I executed SQL in the query builder, right click here. Save as would allow me to save this. Here I had the Data tab for an individual table, rightclick? Save as. From the Data tab for an individual table. Here were executing SQL, had my results tab. So similar consistent menu. Wherever you have a result set, you can save that. Just generate statement options, but different ways for generating your results set.

08:19

SQL Query from Excel

If you wanted to go to Excel, that’s fine tab delimited comment delimited some different ways of executing SQL and then you have different directories that allow you to save code, to save your code in different areas. Projects are something that might be helpful. Here just to show opening a project that can be a tab with the Navigator. This is a way to organize different pieces of code. Lots of robust features like that in terms of organizing your code. You have advanced features as well. If I go back to an Explorer, maybe I’ll look at some stored procedures. For example, here I can right click here. There’s some advanced features, say, for stepping into and debugging code. These are all areas that benefit the developer user of Rapid SQL. Depending on what areas you’re most interested in, there’s other utilities, right? There’s Code Analysis here’s an import data wizard that can import data from files, from data in different file formats.

09:22

You can schedule certain tasks through your Windows test scheduler. There’s also something called a Code workbench. These are advanced features for folks that develop code and write code for applications. Maybe more of developer centric with the Code Analyst code workbench. If you’re more of a business analyst, you have the query builder and then import and export data features that would be helpful for you. Lots of functionality that saves you time connecting and just accessing all the different data sources that we’re responsible for now. There’s different resources here on the web for you. You have utilities, we’re starting reoccurring webcasts, so we encourage you to download, you can visit the product site and then you see links here for downloading. You can download the Rapid SQL executable comes with a free 14 day trial. There’s also the bundle that would give you some additional products. Maybe just to mention those while we have the time here together.

10:27

DB Optimizer

DB Optimizer allows you to go further with tuning or optimizing SQL, right? Were looking at say, an execution plan earlier, and this is where the developer that was looking to improve code would need to know how to improve the SQL statement to improve the execution plan here. A tool like the DB Optimizer can help with those areas as well. The DB Optimizer has a sequel editor to execute SQL and then the ability to tune or rewrite that SQL in different ways. Do comparisons of those rewrites and see how performance was improved through a tuning engine. There’s a tuning engine and DB Optimizer for the major platforms. There’s also ways of collecting current running transactions from your application, and then perhaps looking closer at that SQL and then even generating load and running transactions against your database. The DB optimizer is a component in the Rapid SQL bundle called PowerStudio Developer Edition.

11:32

Schema Compare

Another area that’s enhanced for the Developer Edition is Change Manager. There’s in the Rapid SQL, you do have some visual diff capabilities you can do side by side comparisons of code. Right here I could choose say, a source and target to a left and right hand side comparison of code, but Change Manager is more of a wizard interface that would step you through creating jobs. You have a series of utilities here for creating a configuration archive and then doing a comparison to see if any database changes occurred to do a schema comparison or schema archive compared to either a live schema or historical archive and then more for the developer user is the data comparison job. That’s the utility where a developer step through and compare data across two different tables of data and then see what matches what did match. Comparing database parameters in a config archive or compare comparing schema objects in a schema archive or compare and then data comparison, these areas that are enhanced with the Change Manager in the Rapid SQL PowerStudio Developer Edition.

12:55

IDERA

Okay, so again we encourage you to join the future webcasts and share the benefit of Rapid SQL with other users within your company. You benefit from some economies of scale with licensing when you have multiple licenses. Visit the IDERA Homepage and you can benefit from installing and using Rapid sequel, maybe a little more than you realize with all the functionality that’s there for you. Okay, thank you for joining today’s presentation and again visit IDERA. You have the Products drill down here that will bring you to the Rapid SQL Home page you can download for free. Thanks. Thank you.