{"product_id":"sql-for-data-scientists-a-beginners-guide-for-building-datasets-for-analysis-paperback","title":"SQL for Data Scientists: A Beginner's Guide for Building Datasets for Analysis - Paperback","description":"\u003cp\u003eby \u003cb\u003eRenee M. P. Teate\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003cb\u003eJump-start your career as a data scientist--l\u003c\/b\u003e\u003cb\u003eearn to develop datasets for exploration, analysis, and machine learning\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003ci\u003eSQL for Data Scientists: \u003c\/i\u003e \u003ci\u003eA Beginner's Guide for Building Datasets for Analysis\u003c\/i\u003e 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.\u003c\/p\u003e \u003cp\u003eYou 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.\u003c\/p\u003e \u003cp\u003eThis 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.\"\u003c\/p\u003e \u003cul\u003e \u003cli\u003eGain an understanding of relational database structure, query design, and SQL syntax\u003c\/li\u003e \u003cli\u003eDevelop queries to construct datasets for use in applications like interactive reports and machine learning algorithms\u003c\/li\u003e \u003cli\u003eReview strategies and approaches so you can design analytical datasets\u003c\/li\u003e \u003cli\u003ePractice your techniques with the provided database and SQL code\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eIn 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!\u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e\u003ch3\u003eFront Jacket\u003c\/h3\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003cb\u003eJumpstart your data science career with crucial SQL skills\u003c\/b\u003e\u003c\/p\u003e\u003cp\u003eToday, many organizations expect their data scientists to be able to design and generate their own datasets by extracting and combining raw data from the company's data warehouses without the assistance of data engineers.\u003c\/p\u003e\u003cp\u003eIn \u003ci\u003eSQL for Data Scientists: A Beginner's Guide for Building Datasets for Analysis\u003c\/i\u003e, experienced data scientist and database developer Renée M. P. Teate delivers a singular guide to the SQL skills and techniques every data scientist should know. You'll discover how to approach query design and develop SQL code to construct datasets for exploration, analysis, and data science.\u003c\/p\u003e\u003cp\u003e\u003ci\u003eSQL for Data Scientists\u003c\/i\u003e shows you how to create datasets for use in applications like interactive reports and dashboards, as well as in machine learning algorithms. You'll skip right to the subset of SQL skills that data scientists and analysts use most frequently, and receive expert advice on extracting insights from data while avoiding common pitfalls.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eUnderstand fundamental SQL syntax and design effective SQL queries\u003c\/li\u003e\n\u003cli\u003eConduct Exploratory Data Analysis with SQL\u003c\/li\u003e\n\u003cli\u003eConstruct, filter, and sort your own datasets from pre-existing databases\u003c\/li\u003e\n\u003cli\u003eUse SQL JOINs to combine data from multiple database tables\u003c\/li\u003e\n\u003cli\u003eDesign datasets for analytical reports and machine learning applications\u003c\/li\u003e\n\u003cli\u003eApply more advanced SQL techniques such as Window Functions and Common Table Expressions\u003c\/li\u003e\n\u003cli\u003eCreate database tables and views to store and retrieve the results of your queries\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eAuthor Biography\u003c\/h3\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003cb\u003eRENÉE M. P. TEATE\u003c\/b\u003e is the Director of Data Science at HelioCampus, a higher ed tech startup based in the Washington, DC area. She prepares datasets with SQL, develops predictive models with Python, and designs interactive dashboards in Tableau for university decision-makers. She created the \"Becoming a Data Scientist\" podcast, helped build the data science learning community on Twitter, and is a sought-after speaker at industry conferences.\u003c\/p\u003e\u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 288\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 0.6 x 9.1 x 7.3 IN\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e September 17, 2021\u003c\/div\u003e","brand":"Books by splitShops","offers":[{"title":"Default Title","offer_id":42710054338623,"sku":"9781119669364","price":50.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0105\/8226\/1823\/files\/2a3452e11b9a8ba04158147dcd4bc326.webp?v=1765053646","url":"https:\/\/dhl-adrianne.myshopify.com\/products\/sql-for-data-scientists-a-beginners-guide-for-building-datasets-for-analysis-paperback","provider":"BBB","version":"1.0","type":"link"}