Join Joseph Lowery for an in-depth discussion in this video Querying data, part of Up and Running with Google Cloud Platform.
- View Offline
- In the previous lesson, we loaded BigQuery with data…from 10 years of baby names in the U.S.,…and now, we're ready to analyze that data.…If you're not on the BigQuery page, like I'm not,…go to the Google Cloud Console page…and click your project name…and then choose BigData, BigQuery.…If you had played around with the query function,…you'll see a list of recent queries.…We haven't yet, so my page is blank,…except for the projects over on the side.…
So I'm going to expand the data set…that I want to work with,…which we established in the previous lesson,…baby_names_lynda, and here is the table that we brought in.…I'll go ahead and click on that.…Now initially you're going to see…the schema for your tables.…Let's dive in a bit, and I'll also click on details here…over on the right-hand side.…We took a brief look at this in the previous lesson.…Let me show you a little bit more about it.…Now there is some basic info about your table…and its relationship to BigQuery,…its ID, as BigQuery views it,…and you'll see the project name.…
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