SQL is a relational database management system (RDBMS) that organizes data into tables (columns and rows). Tables can be linked together to form relationships to manage data efficiently.

Several popular versions of SQL include:

  • Microsoft SQL Server
  • MySQL
  • PostgreSQL
  • Google BigQuery
  • SQLight

This article mentions some of the minor but important differences between the different SQL based languages.

SQL on the Web
Web applications that use RDBMS databases often make CRUD requests (Create, Read, Update and Delete) using SQL. These requests are typically handled using a separate web API (Application Programming Interface) which allows web developers to use a simple URL in their Web application to make potentially complex data requests.

SQL In Analytics
The Google Data Analytics Certification Course demonstrates several ways SQL can be used for cleaning and wrangling data for analysis by combining and filtering datasets.

Links to SQL examples will be provided here in the future.