{"product_id":"sql-for-data-scientists","title":"SQL for Data Scientists","description":"\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","brand":"Renee M. P. Teate","offers":[{"title":"Default Title","offer_id":42856629502013,"sku":"9781119669364","price":74.66,"currency_code":"AUD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0597\/7689\/2989\/files\/9781119669364_767cadea-cc3f-4193-b05e-6a2508be87d5.jpg?v=1766992996","url":"https:\/\/www.palmleaf.com.au\/products\/sql-for-data-scientists","provider":"Palmleaf","version":"1.0","type":"link"}