SQL for Data Scientists: A Beginner's Guide for Building Datasets for Analysis

by Renee M Teate

Jump-start your career as a data scientist―l earn to develop datasets for exploration, analysis, and machine learning SQL for Data A Beginner's Guide for Building Datasets for Analysis is a resource that’s dedicated to the Structured Query Language (SQL) and dataset design skills that data scientists use most. Aspiring data scientists will learn how to how to construct datasets for exploration, analysis, and machine learning. You can also discover how to approach query design and develop SQL code to extract data insights while avoiding common pitfalls. You may be one of many people who are entering the field of Data Science from a range of professions and educational backgrounds, such as business analytics, social science, physics, economics, and computer science. Like many of them, you may have conducted analyses using spreadsheets as data sources, but never retrieved and engineered datasets from a relational database using SQL, which is a programming language designed for managing databases and extracting data. This guide for data scientists differs from other instructional guides on the subject. It doesn’t cover SQL broadly. Instead, you’ll learn the subset of SQL skills that data analysts and data scientists use frequently. You’ll also gain practical advice and direction on "how to think about constructing your dataset." In this book, author Renee Teate shares knowledge gained during a 15-year career working with data, in roles ranging from database developer to data analyst to data scientist. She guides you through SQL code and dataset design concepts from an industry practitioner’s perspective, moving your data scientist career forward!        

288 pages, Paperback

Published September 15, 2021

Reviews

[Alejandro Maldonado · Rating 4 out of 5]

5 stars if i become a data scientist

[Astharen · Rating 4 out of 5]

The book proved to be a valuable resource overall, effectively delivering on its promise to teach the fundamentals of SQL queries. I particularly appreciated the author's adeptness in addressing almost all the questions I had throughout the book and her insightful explanations of data science-specific challenges. However, I found chapters 9-13 to be somewhat lacking, as they predominantly consisted of practice exercises solved by the author.

In summary, this book serves as an excellent introduction to SQL for individuals with limited knowledge, providing a solid foundation. I would suggest supplementing it with practical exercises, specifically in window functions.

[Micaela McMullan · Rating 5 out of 5]

I wish I had this book 3 years ago! This was written in a way that was very educational and informative, but not so formal and complex that it was hard to understand. The style of writing/teaching makes it so anyone (even those with little technical background) could feel confident and learn from this book. Like I said, I wish I had been able to learn from this text years ago because this is the perfect way to learn for those looking to teach themselves SQL. Very well written book!

[Frank]

Will come back later to finish this book.