Google BigQuery for Programmers: Analyze & Visualize

سرفصل های دوره

Advance your career with Google BigQuery: Become a sought-after data analyst with in-demand skills

1 - Welcome to the Course

1 - Welcome to the Course

2 - Creating GCP Account

2 - Introduction to BigQuery

3 - Introduction

4 - Tables Structure

5 - Slots

6 - Data Structure

7 - Demo create a Data Set

8 - Create Empty Table

9 - Create Table from a Query

10 - Create Table from Source Data

11 - Exercise 1 Create Tables

11 - Exercise 1 Create Tablespdf.txt

11 - natality2020csv.txt

12 - Exercise 1 Solution

3 - SQL

13 - Introduction to SQL

14 - The Select Statement

15 - Join

16 - Aggregate Functions

17 - Group By

18 - Exercise 2 SQL Queries

18 - Exercise 2 SQL Queriespdf.txt

19 - Exercise 2 Solution

4 - Querying Data in BigQuery

20 - Section overview

21 - Dataset Overview

21 - heart2020csv.txt

22 - Run Query

23 - More Queries

24 - Union Queries

25 - Generating Codes Table

25 - Source code Querying Data in BigQuery Generating Codes Table.txt

26 - Exercise 3 Qurying in BigQuery

26 - Exercise 3 Qurying in BigQuerypdf.txt

27 - Exercise 3 Solution

27 - Source code Querying Data in BigQuery Exercise 3 Solution.txt

5 - Advanced Features

28 - Normallization

29 - Nested and Repeated Fields

30 - Creating Tables with Nested Values

30 - Source code Advanced Features Creating Tables with Nested Values.txt

31 - Querying Nested and Repeated Fields

32 - Partitioning

33 - Creating Partitioned Table

34 - Clustering

35 - Exercise 4 Nested and repeated Fields

35 - Exercise 4 Nested and repeated Fieldspdf.txt

35 - Source code Advanced Features Exercise 4 Nested and repeated Fields.txt

6 - Data Visualization

36 - Introduction to Data Visuallization

37 - Open Looker Studio

37 - PupilsGradescsv.txt

38 - Looker Studio UI

39 - Scoreboard

40 - Pie and Line Charts

41 - Calculated Fields

42 - Bar Chart

43 - Box Plot

44 - Exercise 5 Visualizing Data

44 - Exercise 5 Visualizing Datapdf.txt

44 - natality2020csv.txt

7 - Data Cleaning and Preperation

45 - Intro to data preperation

46 - Data Cleaning Challenges

47 - Dataset Overview

48 - Deleteing Columns

49 - Removing Duplications

50 - Remove Null Values

51 - Categorize Strings

52 - Visualizing the Data

53 - Removing Outliers

54 - Recap

54 - Source code Data Cleaning and Preperation Recap.txt

54 - UsedCarsCleancsv.txt

55 - Exercise 6 Cleaning Data

55 - Exercise 6 Data Preperationpdf.txt

8 - Machine Learning with BigQuery

56 - Introduction to Machine Learning

57 - Linear Regression

58 - Create Model

59 - Evaluate Model

60 - Running Evaluation in Bigquery

61 - Making Predictions

62 - Exercise 7 Create a Machine Learning Model

62 - Exercise 7 MLpdf.txt

9 - Course Summary

63 - Course Summary

10 - Extra Information Source code and other stuff

64 - Source Codes.html

65 - Bonus Lecture and Information

65 - Free-Course-and-Programming-Guide.pdf

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy