Join Joseph Lowery for an in-depth discussion in this video Querying the SQL database, part of Up and Running with Google Cloud Platform.
- View Offline
- Once you have your cloud SQL database instance populated,…how do you interact with it?…Well as noted in this chapter's intro,…there are a number of ways, including Java,…Python and command line.…But yet another way is to use the SQL prompt…that's accessible online.…And that's what we're gonna be working with in this lesson.…To get to the SQL prompt, let's start from our…console page for our project and…go to APIs & auth, APIs.…
Now the Cloud SQL API is not enabled by default,…so we're going to scroll down a little bit…'til we get to Google Cloud SQL API,…and you can see it there.…And I'll turn it on.…We'll get a little indicator that it's enabling.…It's enabled, so now we can scroll back up to the top,…and then enter it.…And once you have that, choose View reports in API Console.…
And this is going to open up that older interface…that we've seen from time to time.…Now select from that page Google Cloud SQL,…and there we'll see the database instance…that we created in the previous lesson.…I'll click on that, and that finally brings us to…
Learn the basics of hosting a mobile app with App Engine and see how to analyze massive datasets in seconds with BigQuery. Then explore the benefits of Cloud Storage, including unlimited file storage and fast data retrieval, and learn how to establish a cloud-based private network with Compute Engine. Finally, the course explores how to set up and manage cloud-based databases with Cloud Datastore and Cloud SQL.
- Why Google Cloud Platform?
- Deploying an app with Google App Engine
- Activating and working with Google Cloud Storage
- Loading, querying, and exporting data with BigQuery
- Working with Cloud Storage buckets
- Managing cloud-based private networks
- Importing and exporting data
- Scheduling backups
- Working with Google Datastore
- Filtering data with Cloud SQL