Review common query optimization techniques and best practices you'll use to get the most efficient query performance from your Cloud Spanner database.
- [Instructor] As I mentioned in the previous movie,…one of the great things about Spanner,…one of the reasons it's such a good value for…what you're buying, is that you can use so much…of what you probably have learned from working…with other relational databases over the years.…These include techniques such as using…optimal ANSI SQL.…So Spanner is ANSI SQL compliant and that is…really, really important in terms of value.…You can use the advance SQL statements like…when doing, having and group all of the statements…that we're familiar with.…
It's very important that your data is modeled correctly,…and we talk about that in an earlier movie…and talked about why you wanna use an optimal…primary partitioning key.…You may remember that you want to avoid hot-spotting…on inserts by having a non-incrementing key…using something like a hash plus a key.…If that's something that's new to you,…you definitely gonna wanna read that documentation…and make sure that you do that correctly.…You wanna add and/or verify optimal primary…
- What is Cloud Spanner?
- Creating an instance and database using the console
- Making hot schema updates
- Cloud Spanner queries
- Loading data into Cloud Spanner
- Understanding transactions
- Cloud Spanner DevOps tools
- Auditing logs with Stackdriver
- Cost optimization
Skill Level Intermediate
Google Cloud Storage and Data Essential Trainingwith Joseph Lowery2h 54m Intermediate
Google Cloud Platform Essential Trainingwith Lynn Langit3h 56m Intermediate
1. Why Cloud Spanner?
2. Cloud Spanner Basics
3. Cloud Spanner Queries
4. Cloud Spanner DevOps
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.