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