---
title: "Now you can do machine learning with SQL in Google BigQuery"
publication: "DB Weekly"
issue: 214
published_at: "2018-07-27"
canonical_url: "https://dbweekly.com/issues/214"
---

This week's database news       

#214 — July 27, 2018 

[Read on the Web](https://dbweekly.com/issues/214)   

Database Weekly 

[![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/jhlbdsulzhy21hpxtz15.jpg)](https://ai.googleblog.com/2018/07/machine-learning-in-google-bigquery.html)  

[Machine Learning in Google BigQuery](https://ai.googleblog.com/2018/07/machine-learning-in-google-bigquery.html) — [BigQuery ML](https://cloud.google.com/blog/big-data/2018/07/bridging-the-gap-between-data-and-insights) extends BigQuery with the ability to build machine learning models on massive structured or semi-structured datasets using the same SQL data analysts/developers are familiar with. 

Google   

[An Introduction to Elasticsearch SQL with Practical Examples](https://www.elastic.co/blog/an-introduction-to-elasticsearch-sql-with-practical-examples-part-1) — Released just over a month ago, [Elasticsearch 6.3](https://www.elastic.co/blog/elasticsearch-6-3-0-released) added initial SQL support to the popular search-oriented document database. Here we see how that works in practice. 

Dale McDiarmid   [![\](https://copm.s3.amazonaws.com/ce740b3b.png)](http://info.enterprisedb.com/rs/069-ALB-339/images/Moving_Oracle_Workloads_to_the_Cloud.pdf) 

[5 Key Decisions to Make When Moving Oracle Workloads to the Cloud](http://info.enterprisedb.com/rs/069-ALB-339/images/Moving_Oracle_Workloads_to_the_Cloud.pdf) — This EDB Tech Guide covers five key decisions you’ll need to make to navigate your choices and enable your success. 

EnterpriseDB sponsor   

[The Evolution of Application Data Caching at Netflix: From RAM to SSD](https://medium.com/netflix-techblog/evolution-of-application-data-caching-from-ram-to-ssd-a33d6fa7a690) — Netflix was storing petabytes of data in a memcached-based cache but using SSDs is significantly cutting costs while still getting the work done. 

Netflix Technology Blog   

[The Best Database-as-a-Service Solutions of 2018](https://uk.pcmag.com/software/116526/guide/the-best-database-as-a-service-solutions-of-2018) — A high level comparison of major database service providers including Microsoft Azure, MongoDB Atlas, AWS, Google, IBM and SAP. 

Pam Baker (PC Magazine)   

PDF: [How Postgres's SQL Dialect Stays Ahead of Its Competitors](https://modern-sql.com/slides/PG-stays-ahead-20180718.pdf) — Yes, it’s a slide deck, but it’s a Markus Winand slide deck and full of examples. I found a possibly unofficial [video of the associated talk](https://www.youtube.com/watch?v=HeXNr13iBzw#t=18m20s) if you’re curious. 

Markus Winand    

[Tuning InnoDB Primary Keys](https://www.percona.com/blog/2018/07/26/tuning-innodb-primary-keys/) — The choice of good InnoDB primary keys is a critical performance tuning decision on MySQL. 

Yves Trudeau (Percona)   

[Introduction to Failover for MySQL Replication](https://severalnines.com/blog/introduction-failover-mysql-replication-101-blog) 

Severalnines   

[MongoDB 4.0 Is Now Generally Available. Try It Now on MongoDB Atlas](https://www.mongodb.com/cloud/atlas/lp/4-0?jmp=cpress&utm_campaign=WW_CP_newsletter_sponsorship_FY19Q1&utm_content=20180727&utm_medium=display&utm_source=dbweekly) — It’s now even easier to address a complete range of use cases with MongoDB. 

mongodb sponsor   

[An Introduction to Azure Cosmos DB Emulator for Building Apps Locally](https://www.red-gate.com/simple-talk/cloud/cloud-data/introduction-to-azure-cosmos-db-emulator-for-creating-applications/) — Azure Cosmos DB is Microsoft’s multi-model cloud database platform but you can set up a local emulator to make your app development process easier without being connected to Azure. 

Suhas Pande   

[UUIDs and Compressibility](http://richardstartin.uk/uuids-and-compressibility/) — Universally unique identifiers, or UUIDs, are often used for database primary keys in scenarios where coordination of persistence is either impossible or impractical. But.. _“using UUIDs instead of naturally occurring composite keys introduces randomness where there could often be order.”_ 

Richard Startin   

▶[Building a Petabyte Scale Warehouse in BigQuery](https://www.youtube.com/watch?v=APBF9Z3uBCc&t=0s&index=28&list=PLBgogxgQVM9v0xG0QTFQ5PTbNrj8uGSS-) 

Google Cloud Next 18   

[18 Places, Books, and Pages to Learn SQL](https://www.eversql.com/best-and-fastest-way-to-learn-sql/) — A variety of sources for online training and tutorials to up your SQL skills. 

EverSQL         

A **[Cooperpress](https://cooperpress.com/)** publication. 

[Change your email address](https://dbweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://dbweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom