Udemy - Google BigQuery guide for beginners

[ FreeCourseWeb.com ] Google BigQuery guide for beginners



Download More  Courses Visit and Support Us -->> https://FreeCourseWeb.com







MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch

Genre: eLearning | Language: English + .srt | Duration: 25 lectures (2h 53m) | Size: 980.8 MB

The best way to get you started with data science in Google BigQuery

What you'll learn:

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...)



Requirements

Interest in data or cloud technologies

No specific technical knowledge needed



Description

I designed this class for people that are starting with Google Cloud Platform and BigQuery. I put 5 years of my knowledge into 3 hours of video content where I try to explain all the important concepts of BigQuery.



We will take it through:



Use Winrar to Extract. And use a shorter path when extracting, such as C: drive



ALSO ANOTHER TIP: You Can Easily Navigate Using Winrar and Rename the Too Long File/ Folder Name if Needed While You Cannot in Default Windows Explorer. You are Welcome ! :)



Download More  Courses Visit and Support Us -->> https://FreeCourseWeb.com



Get More Tutorials and Support Us -->> https://DevCourseWeb.com



We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...