I'm pretty much coming from zero SQL/MySQL knowledge at the start of 2020, to hopefully being a MySQL Hero at the end of 2020. I need to become a Zen master at stitching data together from multiple different sources.
I have been having to google many things. Been to many different websites. And today I came across this website:
Mode.com
https://mode.com/
I stumbled across the tutorials section of the site after googling "SQL Joins on Multiple Keys" and it led me to this:
https://mode.com/sql-tutorial/sql-joins-on-multiple-keys/
My first impression of this site is that the tutorials are really well written and clear. I will definitely be consuming more from this website.
Mode.com: SQL Tutorial: Basic SQL
https://mode.com/sql-tutorial/introduction-to-sql/
Mode.com: SQL Tutorial: Intermediate SQL
https://mode.com/sql-tutorial/sql-aggregate-functions/
Mode.com: SQL Tutorial: Advanced SQL
https://mode.com/sql-tutorial/sql-data-types/
Note: I'm mostly working with MySQL currently and not SQL, but - from https://mythemeshop.com/blog/sql-vs-mysql-difference/ -
"Difference between MySQL and SQL
In short, SQL is a query language, while MySQL is a database management system. ... SQL or Structured Query Language, as the name suggests, is a language that is created to manage relational databases. MySQL, on the other hand, is an open-source software which is based on the SQL language."
Image: Mode.com
I have been having to google many things. Been to many different websites. And today I came across this website:
Mode.com
https://mode.com/
I stumbled across the tutorials section of the site after googling "SQL Joins on Multiple Keys" and it led me to this:
https://mode.com/sql-tutorial/sql-joins-on-multiple-keys/
My first impression of this site is that the tutorials are really well written and clear. I will definitely be consuming more from this website.
Mode.com: SQL Tutorial: Basic SQL
https://mode.com/sql-tutorial/introduction-to-sql/
Mode.com: SQL Tutorial: Intermediate SQL
https://mode.com/sql-tutorial/sql-aggregate-functions/
Mode.com: SQL Tutorial: Advanced SQL
https://mode.com/sql-tutorial/sql-data-types/
Note: I'm mostly working with MySQL currently and not SQL, but - from https://mythemeshop.com/blog/sql-vs-mysql-difference/ -
"Difference between MySQL and SQL
In short, SQL is a query language, while MySQL is a database management system. ... SQL or Structured Query Language, as the name suggests, is a language that is created to manage relational databases. MySQL, on the other hand, is an open-source software which is based on the SQL language."
Image: Mode.com
Comments
Post a Comment