The Applied SQL Data Analytics Workshop: A Quick interactive approach to learning Analytics with SQL,2nd Edition
by: Upom Malik
Publication Date 出版日期: 2020
ISBN-13: 9781800203679
Print Length 页数: 404
Language 语言: English
Print Length 页数: PDF/EPUB
Size: 128 Mb
Book Description
By finelybook
Cut through the noise and get real results with a step-by-step approach to learning about SQL data analysis
You already know that you want to learn data analysis with SQL,and a smarter way to learn is to learn by: doing. The Applied SQL Data Analytics Workshop focuses on building up your practical skills so that you can navigate and compose custom reports like an expert data analyst. You’ll learn from real examples that lead to real results.
Throughout The Applied SQL Data Analytics Workshop,you’ll take an engaging step-by-step approach to understand data analytics with SQL. You won’t have to sit through any unnecessary theory. You can jump into a single exercise each day if you’re short on time,or you can spend an entire weekend tinkering with SQLAlchemy and Python. It’s your choice. Learning on your terms,you’ll build up and reinforce key skills in a way that feels rewarding.
Every physical print copy of The Applied SQL Data Analytics Workshop unlocks access to the interactive edition. With videos detailing all exercises and activities,you’ll always have a guided solution. You can also benchmark yourself against assessments,track progress,and receive content updates. You’ll even earn a secure credential that you can share and verify online upon completion. It’s a premium learning experience that’s included with your printed copy. To redeem,follow the instructions located at the start of your book.
Fast-paced and direct,The Applied SQL Data Analytics Workshop is the ideal companion for SQL beginners. You’ll perform SQL queries like a professional data scientist,learning along the way. This process means that you’ll find that your new skills stick,embedded as best practice. A solid foundation for the years ahead.
Learn
Experiment with data analytics using basic and advanced queries
Learn data interpretation through descriptive statistics and aggregate functions
Export data from outside sources using powerful SQL queries
Discover how to work with and manipulate data using SQL joins and constraints
Speed up your data analysis workflow by: automating tasks and optimizing queries
Discover different advanced analytics techniques,including geospatial and text analysis
Contents
Preface
Chapter 1: Introduction to SQL for Analytics
Chapter 2: SQL for Data Preparation
Chapter 3: Aggregate and Window Functions
Chapter 4: Importing and Exporting Data
Chapter 5: Analytics Using Complex Data Types
Chapter 6: Performant SQL
Chapter 7: The Scientific Method and Applied Problem Solving
Appendix
Index
