See how to use the console, a gcloud command or a Python script to execute a SQL query statement.
- [Instructor] Now, we added data with the API.…We can query data in three different ways.…So, let's look at those.…We'll go into the instance…into the database…and click on query.…And, we'll paste in…a simple query…and run it.…So, we're simply retrieving the singer ID…the album ID, and the album title from albums.…Now notice we have the query time…we have an explanation…which we'll look at in a little more detail in a minute…and, we have SQL query help.…
Now, in addition to this…we can use G Cloud.…So, I'll show you how that works.…The command is…gcloud, space, beta, space, spanner…space, databases, execute, hyphen, SQL…passing in the database name…example DB in this case as the first parameter…hyphen, hyphen to indicate the second parameter…so instance equals test instance.…Then I'll scroll to the right.…Hyphen, hyphen, SQL, passing in the SQL statement…so we're going to use the same one.…
I'll copy this, go to the terminal…paste it in…and we'll see the result.…Now the next way that we can execute a query…is programmatically.…
- 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.