Trying to take an advantage of sitting at home during covid-19 time, I created this Google BigQuery class that will be helpful for beginners starting with GCP and BigQuery. I put 5 years of my knowledge into 3 hours of video content where I try to explain the whole concept.
You can find it on Udemy.com under this link: Google BigQuery Udemy class.
Content of the class
During the 3 hours of video, I take it through these topics:
- Understand the concept of BigQuery and how does it stand next to other databases such as MySQL or Postgress
- Import your data to BigQuery and Cloud storage, create your table, export data
- SQL basics – SELECT, WHERE, ORDER BY, LIKE, JOIN, Date and String functions
- SQL aggregation functions - SUM, AVG, COUNT, HAVING and GROUP BY
- BigQuery ML to create your own machine learning model easily with SQL, make a time series prediction
- Visualise your data in Google Data Studio and make your own dashboard
- Advanced BigQuery concepts – Partitioning tables, Clustering and Nested Fields
- Window analytical functions - SUM() OVER (PARTITION BY...)
I have always wanted to try making a video lesson as I also bought several of them on Udemy at the beginning of my carrier. In Proficio, company I work for, I've made a several workshops for new people joining the team and was always thinking – what about making a video of it and put it online?
Here we go. The production quality is not as great as it could be but as a first try not too bad after all. By the time I'm writing this post, after 2 weeks since the course was released on Udemy, already 20 people have bought the course which is above my expectations.
Here, the link to my class again: Google BigQuery Udemy class.
I'm already thinking about making other video class that would be more production-wise sophisticated but it takes a lot of time an effort. Let's see :)