In industry, your data is very likely to live within a data warehouse such as BigQuery, Redshift, or Snowflake. Therefore, to be an effective data scientist in the industry, you should learn how to use data warehouses effectively.
Once you learn data warehousing and SQL with any one of these products, it is quite easy to pick up another. So which one do you start with?
You can use Snowflake on all three of the major public clouds. Because it’s a standalone product, it is the most similar to a “traditional” data warehouse and can be picked up easily even if you are not familiar with cloud computing. That makes it a good data warehouse to start with, and is the reason my second book pick is this book on Snowflake.
BigQuery is also available on all three major public clouds, but it works best (and is used most commonly) on Google Cloud. Because BigQuery is truly serverless (you pay by the query and never deal with clusters or virtual data warehouses), it is quite unlike traditional data warehouses and you will have to learn some public cloud concepts in order to use BigQuery. On the other hand, starting with BigQuery has several advantages — first, it offers 1 TB of querying per month for free; second, it has machine learning built-in — Google Colab even offers a free Jupyter notebook from which to access BigQuery; and third, it’s the best choice for production uses cases as BigQuery is typically more scalable and less expensive than the alternatives. If you are willing to learn public cloud, start with the Definitive Guide to BigQuery.
AWS is the most widely used cloud, and Redshift is the most widely used data warehouse on AWS. Your organization probably already has a Redshift cluster set up and ready to go. The path of least resistance might be to learn data warehousing using the AWS book on Redshift.