Skip to content

Instantly share code, notes, and snippets.

@Apexal
Last active April 28, 2021 16:12
Show Gist options
  • Save Apexal/9c9feb9460dabcc2ac97b50689603336 to your computer and use it in GitHub Desktop.
Save Apexal/9c9feb9460dabcc2ac97b50689603336 to your computer and use it in GitHub Desktop.
RCOS SQL Workshop

Intro to SQL

A super duper brief intro to Structured Query Language for those new to it... and those who need a workshop attendance!

Name

SQL is pronounced both as "sequel" and as "s-q-l". To the best of my abilities I cannot tell if there is a true official pronunciation but the the original creator of SQL suggests that "s-q-l" is probably the standard! Source

Purpose

SQL is the query language used on most relational database management systems. You might've heard of some of those systems such as MySQL, PostgreSQL, and Microsoft SQL Server. There is an official SQL standard but each RDBMS uses their own very slightly different flavors of SQL.

SQL is used to write queries that return data from the database, insert data into the database, update data, delete data, and more.

Relational Databases

Relational databases refer to databases that can represent data in relation to other data in the database. Typically the data is structured as tables with rows and columns. Think of a spreadsheet workbook where each table is a spreadsheet! Unlike in a spreadsheet, the tables in a relational database have defined columns (or fields) that have different attributes. You can have thousands of tables and thousands of columsn and a gazillion records in these tables and SQL provides you a concise way to manipulate that data!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment