Google BigQuery and PostgreSQL BigQuery for Data Analysis

Focused View

11:23:14

18 View

01.01-welcome to the course.mp4

03:05

01.02-course flow.mp4

06:42

02.01-postgresql and pgadmin installation.mp4

09:33

02.02-setting up bigquery on google cloud platform.mp4

08:17

02.03-bigquery interface.mp4

18:07

03.01-create.mp4

11:49

03.02-create in bigquery.mp4

12:50

03.03-exercise 1 create db and table.mp4

01:27

03.04-insert.mp4

09:10

03.05-insert in bigquery.mp4

06:25

03.06-import data from file.mp4

05:00

03.07-importing data from file using bigquery web user interface.mp4

11:14

03.08-file upload in google bigquery through google cloud sdk.mp4

11:07

03.09-importing data from google drive.mp4

10:12

03.10-exercise 2 inserting and importing.mp4

00:56

03.11-select.mp4

03:47

03.12-select in bigquery.mp4

03:53

03.13-select distinct.mp4

06:05

03.14-select distinct in bigquery.mp4

02:56

03.15-where function.mp4

04:04

03.16-where in bigquery.mp4

05:45

03.17-logical operators-and or not.mp4

06:11

03.18-logical operators in bigquery.mp4

07:30

03.19-exercise 3 select and where.mp4

01:18

03.20-update.mp4

05:24

03.21-update in bigquery.mp4

03:04

03.22-delete.mp4

04:12

03.23-delete in bigquery.mp4

03:14

03.24-alter.mp4

17:22

03.25-alter in bigquery.mp4

03:21

03.26-exercise 4 updating table.mp4

01:00

04.01-restore and backup.mp4

07:37

04.02-debugging restoration.mp4

08:27

04.03-creating db using csv files.mp4

05:41

04.04-data set creation in bigquery.mp4

11:11

04.05-exercise 5 restore and backup.mp4

00:51

05.01-in.mp4

04:26

05.02-in in bigquery.mp4

02:53

05.03-between.mp4

05:42

05.04-between in bigquery.mp4

04:07

05.05-like.mp4

08:52

05.06-like in bigquery.mp4

07:41

05.07-exercise 6 in like and between.mp4

00:46

06.01-order by.mp4

07:41

06.02-order by in bigquery.mp4

04:41

06.03-limit.mp4

03:40

06.04-limit in bigquery.mp4

05:51

06.05-order by.mp4

00:44

07.01-as.mp4

03:32

07.02-as in bigquery.mp4

02:25

08.01-count.mp4

05:14

08.02-count in bigquery.mp4

04:46

08.03-sum.mp4

03:23

08.04-sum in bigquery.mp4

02:00

08.05-average.mp4

02:52

08.06-average in bigquery.mp4

03:10

08.07-min max.mp4

04:16

08.08-min max in bigquery.mp4

02:54

08.09-exercise 8 aggregate functions.mp4

01:15

09.01-group by.mp4

11:52

09.02-group by in bigquery.mp4

05:37

09.03-having.mp4

05:04

09.04-having in bigquery.mp4

04:45

09.05-exercise 9 group by.mp4

01:06

10.01-case when.mp4

05:20

10.02-case when in bigquery.mp4

06:14

11.01-introduction to joins.mp4

02:55

11.02-concepts of joining and combining data.mp4

12:00

11.03-preparing the data.mp4

02:03

11.04-creating datasets for joins in bigquery.mp4

03:40

11.05-inner join.mp4

08:02

11.06-inner join in bigquery.mp4

07:42

11.07-left join.mp4

07:30

11.08-left join in bigquery.mp4

04:08

11.09-right join.mp4

06:28

11.10-right join in bigquery.mp4

05:05

11.11-full outer join.mp4

04:59

11.12-full outer join in bigquery.mp4

05:09

11.13-cross join.mp4

04:22

11.14-cross join in bigquery.mp4

04:25

11.15-intersect and intersect all.mp4

07:09

11.16-except.mp4

02:54

11.17-except in bigquery.mp4

04:43

11.18-union.mp4

03:09

11.19-union in bigquery.mp4

04:41

11.20-exercise 10 joins.mp4

01:08

12.01-subqueries.mp4

14:34

12.02-subqueries in bigquery.mp4

05:53

12.03-exercise 11 subqueries.mp4

01:11

13.01-views.mp4

07:21

13.02-views in bigquery.mp4

03:20

13.03-index.mp4

06:39

13.04-views in bigquery.mp4

01:33

13.05-exercise 12 views.mp4

00:43

14.01-length.mp4

03:31

14.02-length in bigquery.mp4

03:11

14.03-upper lower.mp4

02:12

14.04-changing case in bigquery.mp4

02:06

14.05-replace.mp4

04:14

14.06-replace in bigquery.mp4

03:11

14.07-trim ltrim rtrim.mp4

06:57

14.08-trim ltrim rtrim in bigquery.mp4

05:18

14.09-concatenation.mp4

02:58

14.10-concatenation in bigquery.mp4

05:28

14.11-substring.mp4

06:02

14.12-substring in google bigquery.mp4

05:43

14.13-list aggregation.mp4

05:03

14.14-list aggregation in google bigquery.mp4

05:10

14.15-exercise 13 string functions.mp4

02:30

15.01-ceil and floor.mp4

03:33

15.02-ceil and floor in bigquery.mp4

05:50

15.03-random.mp4

05:08

15.04-random in bigquery.mp4

05:38

15.05-setseed.mp4

04:13

15.06-setseed in bigquery.mp4

00:23

15.07-round.mp4

02:28

15.08-power.mp4

02:27

15.09-power in bigquery.mp4

02:00

15.10-exercise 14 mathematical functions.mp4

01:34

16.01-current date and time.mp4

04:32

16.02-current date and time in bigquery.mp4

04:53

16.03-age.mp4

03:52

16.04-age in bigquery.mp4

08:13

16.05-extract.mp4

08:20

16.06-extract in bigquery.mp4

03:52

16.07-exercise 15 date-time functions.mp4

01:15

17.01-pattern matching basics.mp4

07:40

17.02-advance pattern matching (regular expressions).mp4

15:22

17.03-pattern matching in bigquery.mp4

07:58

17.04-exercise 16 pattern matching.mp4

01:44

18.01-google data studio to visualize bigquery data.mp4

03:43

9781803237633 Code.zip

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Packt is a publishing company founded in 2003 headquartered in Birmingham, UK, with offices in Mumbai, India. Packt primarily publishes print and electronic books and videos relating to information technology, including programming, web design, data analysis and hardware.