目錄(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
推薦閱讀
- Designing Machine Learning Systems with Python
- Mastering Adobe Captivate 2017（Fourth Edition）
- Building a RESTful Web Service with Spring
- Python進階編程：編寫更高效、優雅的Python代碼
- Mastering Ubuntu Server
- Elasticsearch for Hadoop
- Hands-On Swift 5 Microservices Development
- Visual FoxPro程序設計
- Mastering JavaScript High Performance
- Python圖形化編程（微課版）
- 圖數據庫實戰
- MySQL入門很輕松（微課超值版）
- Java Web應用開發給力起飛
- Android移動應用開發項目教程
- Java EE Web應用開發基礎
- Analytics for the Internet of Things（IoT）
- Mastering High Performance with Kotlin
- Oracle 11g寶典
- Learning PowerShell DSC（Second Edition）
- Hands-On Design Patterns with Kotlin
- Odoo Development Cookbook
- 點云庫PCL從入門到精通
- INSTANT Fancybox
- Netty源碼剖析與應用
- Building a 3D Game with LibGDX
- 互聯網輕量級SSM框架解密：Spring、Spring MVC、MyBatis源碼深度剖析
- Django項目開發實戰
- 深入理解Java虛擬機：JVM高級特性與最佳實踐（第2版）
- 軟件架構設計：實用方法及實踐
- C#編程寶典（十年典藏版）
