目錄(170章)
倒序
- 封面
- 版權信息
- Credits
- Foreword
- About the Authors
- About the Reviewers
- www.PacktPub.com
- Why subscribe?
- Customer Feedback
- Dedication
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Downloading the example code
- Errata
- Piracy
- Questions
- Google Cloud and Google BigQuery
- Getting started with Google Cloud
- Overviewing Google Cloud Platform services
- Google Cloud storage and its features
- Learning Google BigQuery
- Working with the browser
- Running your first query
- BigQuery public datasets
- Getting started with Cloud SQL
- Cloud Datastore
- Google App engine
- App engine standard environment
- App engine flexible environment
- Google container engine
- Google compute engine
- Summary
- Google Cloud SDK
- Installing Google Cloud SDK
- Installing Google Cloud SDK on Windows
- Installing Google Cloud SDK on macOS
- Installing Google Cloud SDK on Linux
- gsutil for Google Cloud Storage
- Using the bq utility for BigQuery
- Using the gcloud utility
- Connecting to Cloud SQL using gcloud
- Authorizing the client machine via Google Cloud Console
- Connecting using a proxy script
- Exporting Cloud SQL databases and tables
- Deploying to Google App Engine
- Summary
- Google BigQuery Data Types
- Supported data types
- Data type considerations
- Converting data
- Sanitizing data
- When to transform your data? Before or after loading to BigQuery?
- Arithmetic Operators
- Comparison Operators
- Date Time Functions
- String Functions
- Regular Expression Functions
- Functions for transformation
- Mastering transformation with User-Defined Functions
- Some considerations when using UDFs
- UDF format
- Summary
- Further Reading
- BigQuery SQL Basic
- The BigQuery interface
- Error checking
- Querying in BigQuery
- Types of queries
- Querying public data
- Basic SQL syntax
- Commenting in BigQuery SQL
- SELECT
- FROM
- WHERE
- GROUP BY
- ORDER BY
- HAVING
- Qualifying tables in query
- DISTINCT
- BigQuery SQL functions
- WITHIN
- OMIT RECORD IF
- ROLLUP
- Joining tables in BigQuery
- Inner join
- Left Outer join
- Right Outer join
- Full Outer join
- Cross join
- UNION UNION ALL and UNION DISTINCT
- Adding your own data in BigQuery
- Creating a table
- Inserting data to a table
- Updating data in a table
- Resetting a value
- Deleting data from a table
- Summary
- Further reading
- BigQuery SQL Advanced
- Partition tables
- Creating a partition table using a GUI
- Creating a partition table using Google Cloud SDK
- Querying data in a partition table
- Using partition tables in your projects
- Querying external data sources using BigQuery
- Creating the table definition
- Querying data from external data sources
- Wildcard tables
- User-defined functions
- Views
- Querying nested and repeated records
- Summary
- Further reading
- Google BigQuery API
- Accessing Google BigQuery
- Introducing Google APIs explorer
- Getting credentials for API access
- Creating a service account
- Programming with BigQuery API in C# .NET
- Authenticating the service account
- Listing all datasets and all tables in the project
- Creating a new dataset in the project
- Creating a new table within a dataset
- Loading data from a file in Google Cloud Storage to a BigQuery table
- Executing a query and displaying the result
- Executing the query and saving the result in a new table
- Streaming insert of rows
- Programming with BigQuery API in Python
- Listing all datasets and all tables in the project
- Creating a new dataset in the project
- Creating a new table within a dataset
- Importing data from a file in Google Cloud Storage to a BigQuery table
- Executing a query and displaying the result
- Execute query and copy results to a new table
- Streaming insert of rows
- Roles and permissions
- Summary
- Visualizing BigQuery Data
- Why is data visualization important?
- The danger of summary statistics
- Making data visualization work for you
- Three tools for visualizing BigQuery data
- Simple yet basic – Google Data Studio
- Getting started
- Making a scatterplot in Data Studio
- Making a map in Data Studio
- Other features of Data Studio
- Simple fairly flexible but with a cost – Tableau
- Getting started
- Map charts in Tableau
- Create a word cloud in Tableau
- Complex but with considerable flexibility – the R programming language
- Getting started
- Summary
- Google Cloud Pub/Sub
- Introduction
- Getting started with Cloud Pub/Sub
- Cloud Pub/Sub via Google Cloud Console
- Cloud Pub/Sub via Google Cloud SDK
- Cloud Pub/Sub pricing
- Message output formats
- Importing message data into BigQuery
- Google Cloud Dataprep
- Summary
- Further reading 更新時間：2021-07-02 21:24:32
推薦閱讀
- Objective-C應用開發全程實錄
- Architecting the Industrial Internet
- 軟件測試工程師面試秘籍
- JavaScript動態網頁開發詳解
- 網絡爬蟲原理與實踐：基于C#語言
- Kotlin從基礎到實戰
- Principles of Strategic Data Science
- 代碼閱讀
- TypeScript 2.x By Example
- Java自然語言處理（原書第2版）
- jQuery Mobile Web Development Essentials（Second Edition）
- C++服務器開發精髓
- RESTful Web API Design with Node.js
- C語言程序設計實驗指導與習題精解
- C語言程序設計
- Mastering Unity Scripting
- Spring MVC Cookbook
- Learning C# by Developing Games with Unity 3D Beginner's Guide
- Instant AutoIt Scripting
- Mastering Python for Data Science
- Learning WebRTC
- C語言程序設計
- Visual Basic實例精通
- 我的第一本魔法編程寶典：一看就懂的Scratch3.0趣味編程
- 從零開始學Python數據分析（視頻教學版）
- 深入理解Kotlin協程
- 數字圖像處理原理與實踐：基于Visual C++開發
- Microservices with Azure
- 程序員的38堂成長課
- 高級前端程序員面試筆試寶典
