Every single database has its own integrated development environment (IDE) to facilitate database developers to perform various database tasks like writing code, automating processes, and debugging. SQuirreL SQL Client is a universal SQL client supporting over 60 different popular databases. It allows users to view the structure of a database, browse the data in tables, issue SQL commands, and more.
Installation and Configuration Hi. This is Pinal Dave, and welcome to the module of SQuirreL Installation and Configuration. Here is the outline of this module. First we will download SQL SQuirreL Universal Client, and right after that we will install it. Once the installation is complete, we will focus on configuration of various database applications with SQuirreL Universal Client. In this module we will configure SQuirreL with MySQL and SQL Server, and before we end this module we will see a quick summary. Next we will see a scenario where we need to connect to multiple database applications with a single client.
Database and Table Operations Hi. This is Pinal Dave, and welcome to the module of SQuirreL Database and Table Operations. In the last module we have learned how to install and configure the driver for SQuirreL. In this module we will connect MySQL and SQL Server instances with SQuirreL. Once we successfully connect MySQL and SQL Server, we will see various database and table operations. First we will see database and table operations, which are common for MySQL and SQL Server. Right after that we will see a few of the special operations for both the databases individually. First let's start with connecting both of these databases with SQuirreL Universal SQL Client.
Graph Plugin Hi. This is Pinal Dave, and welcome to the module of SQuirreL Graph Plugin. Let's see what we are going to cover in this module. Graph plugin allows user to create and print charts of database table schemas along with various relationships. If we have also installed SQL Script plugin, we can also script tables, as well as build various queries. The Graph plugin makes things very easy for the user as instead of pure text now we can work with various visual diagrams. Let's understand how the Graph plugin works various scenarios and demonstrations next.