With the explosion of data, computing power, and cloud data warehouses, SQL has become an even more indispensable tool for the savvy analyst or data scientist. This practical book reveals new and hidden ways to improve your SQL skills, solve problems, and make the most of SQL as part of your workflow.

This book 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.

Start your journey towards becoming a JavaScript developer with the help of more than 100 fun exercises and projects. Write eloquent JavaScript and employ fundamental and advanced features to create your own web apps. Interact with the browser with HTML and JavaScript, and add dynamic images, shapes, and text with HTML5 Canvas. Build a password checker, paint web app, hangman game, and many more fun projects.

Master HTML and CSS fundamentals to create beautiful websites. The best book on the market for modern web design fundamentals. Every one of the over 4 billion webpages online today use HTML markup language to display its content. HTML is everywhere.

Get complete instructions for manipulating, processing, cleaning, and crunching datasets in Python. Updated for Python 3.6, the second edition of this hands-on guide is packed with practical case studies that show you how to solve a broad set of data analysis problems effectively. You'll learn the latest versions of pandas, NumPy, IPython, and Jupyter in the process.