Guide: SQL & Relational Databases
WRITTEN BY: RYAN ZERNACH
SUMMARY — What are the building blocks of SQL and how is this language used to manipulate data that’s stored in relational databases?
Some Highly Used Commands
USE — from which database should the data be queried (if simultaneously connected to multiple databases)
SELECT — from which columns in the table should the data be queried
FROM — from which tables within the database should the data be queried
WHERE — to filter data being queried using logical operators
▻ AND — both conditions are met; higher order of precedence than OR
▻ OR — either conditions are met; lower order of precedence than AND
▻ NOT — negates the condition by querying for the inverse
▻ IN — the list form of “or”; to filter results based on if the query is in the list
▻ BETWEEN/AND — to select a range of values where >= x and <= y
ORDER BY — the order that the data is displayed
Good reliable databases are a big and hard problem, and while I’m sure there are developments in dataframe frontends for them, the Achilles heel of dataframes is that they generally want all your data in memory at the same time. Relational databases only need the keys/relations in memory, and can scan for the rest on disk, which lets them aggressively optimize queries and have superior performance.
THANKS FOR READING!
CHECK OUT ANOTHER PROJECT OR BLOG POST OF MINE…
AWS offers certification programs to demonstrate platform mastery. I earned my AWS Cloud Practitioner Certification!
I’ve been working hard towards my official TensorFlow Certification! What tools have I been using to study?
Which machine learning algorithms did I learn to use in Lambda School and when are the most appropriate times to use them?
What projects did I build using DataRobot? What problems does DataRobot’s AutoML platform solve?
What are the building blocks of SQL and how is this language used to manipulate data that’s stored in relational databases?
Django is a high-level Python Web framework that encourages rapid development and clean, pragmatic design.