Basic SQL Querying

SQL(Structured Query Language) is a language commonly used to manage and query data in relational databases. It is normally required for many jobs including data analysts and data scientists. Therefore, knowing at least the basics is very important and useful if you are dealing with data manipulation and querying from a database.

A site that I have found useful for learning and practicing SQL is Mode.com since they have a browser based application to use SQL in and have databases provided for you to practice and better understand SQL in a practical and convenient manner. You also have the option to import your own database and work with it there as well. The examples provided will be referencing the tutorial databases from Mode.

Essential Commands for SQL Queries

There are some commands that are the building blocks for making queries in SQL and mastering their usage will at the very least allow you to be comfortable searching through and pulling data from a database. We’ll go over the following in this blog:

SELECT ___ FROM ___
WHERE
LIKE
AND/OR
NOT
ORDER BY

SELECT ___ FROM ___

WHERE

LIKE

AND/OR

NOT

ORDER BY