Jerzy Balcerzak
Practical Google BigQuery for those who already know SQL
…is made for Data Scientists, Data Engineers, Business Intelligence specialist and Developers that:
– don’t know how BigQuery works and why it’s such a game changer,
– don’t like spending hours browsing through documentation to do things right,
– worry that their queries will be slow and expensive,
– don’t need yet another course that explains types of JOINs in SQL.
If you fit the description, this course will help you understand deeply how BigQuery works, what are all its funky functionalities and how to make this powerful tool work for you.
Over the entire course you will:
learn how to access Google Sheets over BigQuery,
understand BigQuery resources hierarchy – datasets, tables, views,
make use of SQL editor shortcuts (also hidden ones!) like a pro,
understand BigQuery additional functionalities like google transfers,
learn how to access BigQuery from python client,
understand how BigQuery works under the hood – how it stores data and performs queries,
learn how BigQuery pricing works, and how to optimize query costs,
create table with all advanced options – applying partitioning, clustering and retention policy,
setup monitoring of costs of each query in BigQuery,
learn how to recover deleted data in BigQuery using SYSTEM TIME,
Instructor Details
Courses : 1
Specification: Practical Google BigQuery for those who already know SQL
|
9 reviews for Practical Google BigQuery for those who already know SQL
Add a review
| Price | $10.99 |
|---|---|
| Provider | |
| Duration | 3 hours |
| Year | 2020 |
| Level | Intermediate |
| Language | English |
| Certificate | Yes |
| Quizzes | No |
$10.99
Michal Lewandowski –
Good value for money, it could include a little bit more of examples of SQL queries. But overall I’m satisfied. Recommend!
Tomasz Pietruszka –
Seems to be focused on practical aspects, which is what I was looking for
Automatt –
The trainer is very descriptive and engaged in making all the details very clear.
TomaszZ –
Decent course about BigQuery, I liked the part 2. where he explains what is going on under the hood of BigQuery
Lukasz Wojdowski –
Short lectures, easy to follow, acctually nice to get started with BigQuery, especially when you are also working in python for data science.
Pawe Urban –
Nicely served, practical and compressed BigQuery knowledge dish!
Nathan Lo –
I hate to be giving out the first non 5 star review, but the tutorial could be more polished. Tips for improvement: 1. Explain that the data set is located in the Resources section prior to the video. When we are in full screen going video after video, we don’t see which videos have resources available. 2. Take a brief pause between when you say something and when you actually click on something in the video. I pause just a bit too late and keep having to rewind 5 seconds. Not all of the instructions are clearly laid out for someone that’s never used Google Big Query (example, declaring a new data field for that checkbox that we added). I had to follow the mouse very carefully to see where you go 3. Test it out before recording! 4. Speak a little louder and type a little softer. Your typing is sometimes louder than your speaking *updated; instructor was detailed and quick in responding questions.
Esther Uzor –
Rather than slides, it would be more helpful using examples of moving data in and out of BQ using command line line or client library. Moving data (beyond 1GB) in and out will be one of the most repeated tasks using BQ. Disclosure: I’ve not finished watching the entire course.
Sreekumar S L –
Good