Description
Course info
Rating
(62)
Level
Beginner
Updated
Oct 3, 2014
Duration
1h 25m
Description

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.

About the author
About the author

Pinal Dave is a Pluralsight Developer Evangelist.

More from the author
Getting Started with MariaDB
Beginner
2h 23m
Nov 2, 2018
Monitoring MySQL with Performance Schema
Intermediate
1h 59m
Apr 28, 2017
More courses by Pinal Dave
Section Introduction Transcripts
Section Introduction Transcripts

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.