SQL Getting Started

As you already know SQL is used to communicate with the database, so before you start experimenting with SQL, you need access to a database system first.

You can test or execute most of the SQL statements provided as examples throughout the tutorials, using our online SQL editor. This SQL editor uses Web SQL Database to store and access data on the client side. However, to execute some SQL statement you'll need access to a full-fledged database management system like MySQL, SQL Server etc.

What is Relational Database

A relational database is a database divided into logical units called tables, where tables are related to one another within the database. Relational database allows data to be broken down into logical, smaller, and manageable units for easier maintenance and better performance.

Tables are related to one another through common keys or fields in a relational database system, that's why even though the desired data may exist in more than one table, you can easily join multiple tables together to get combined data set using a single query.

Setting Up Work Environment for Practicing SQL

If you have no DBMS (Database Management System) already installed on your system, you have several options to choose from. You can install a free, open-source DBMS.

MySQL is the most popular and widely supported open-source database management system. It is very easy to download and use and available for both Windows and Linux (or UNIX) operating system.

You can also install SQL Server Express. It is a free version of Microsoft SQL Server which allows up to 10GB of database storage.

Alternatively, if you're planning to develop an application with PHP and MySQL you can install WampServer or XAMPP. WampServer is a Windows web development environment. It allows you to create web applications with Apache2, PHP and a MySQL database. It will also provide the MySQL administrative tool PhpMyAdmin to easily manage your databases using a web browser.