01.01-welcome to the course
01.02-course flow
02.01-postgresql and pgadmin installation
02.02-setting up bigquery on google cloud platform
02.03-bigquery interface
03.01-create
03.02-create in bigquery
03.03-exercise 1 create db and table
03.04-insert
03.05-insert in bigquery
03.06-import data from file
03.07-importing data from file using bigquery web user interface
03.08-file upload in google bigquery through google cloud sdk
03.09-importing data from google drive
03.10-exercise 2 inserting and importing
03.11-select
03.12-select in bigquery
03.13-select distinct
03.14-select distinct in bigquery
03.15-where function
03.16-where in bigquery
03.17-logical operators-and or not
03.18-logical operators in bigquery
03.19-exercise 3 select and where
03.20-update
03.21-update in bigquery
03.22-delete
03.23-delete in bigquery
03.24-alter
03.25-alter in bigquery
03.26-exercise 4 updating table
04.01-restore and backup
04.02-debugging restoration
04.03-creating db using csv files
04.04-data set creation in bigquery
04.05-exercise 5 restore and backup
05.01-in
05.02-in in bigquery
05.03-between
05.04-between in bigquery
05.05-like
05.06-like in bigquery
05.07-exercise 6 in like and between
06.01-order by
06.02-order by in bigquery
06.03-limit
06.04-limit in bigquery
06.05-order by
07.01-as
07.02-as in bigquery
08.01-count
08.02-count in bigquery
08.03-sum
08.04-sum in bigquery
08.05-average
08.06-average in bigquery
08.07-min max
08.08-min max in bigquery
08.09-exercise 8 aggregate functions
09.01-group by
09.02-group by in bigquery
09.03-having
09.04-having in bigquery
09.05-exercise 9 group by
10.01-case when
10.02-case when in bigquery
11.01-introduction to joins
11.02-concepts of joining and combining data
11.03-preparing the data
11.04-creating datasets for joins in bigquery
11.05-inner join
11.06-inner join in bigquery
11.07-left join
11.08-left join in bigquery
11.09-right join
11.10-right join in bigquery
11.11-full outer join
11.12-full outer join in bigquery
11.13-cross join
11.14-cross join in bigquery
11.15-intersect and intersect all
11.16-except
11.17-except in bigquery
11.18-union
11.19-union in bigquery
11.20-exercise 10 joins
12.01-subqueries
12.02-subqueries in bigquery
12.03-exercise 11 subqueries
13.01-views
13.02-views in bigquery
13.03-index
13.04-views in bigquery
13.05-exercise 12 views
14.01-length
14.02-length in bigquery
14.03-upper lower
14.04-changing case in bigquery
14.05-replace
14.06-replace in bigquery
14.07-trim ltrim rtrim
14.08-trim ltrim rtrim in bigquery
14.09-concatenation
14.10-concatenation in bigquery
14.11-substring
14.12-substring in google bigquery
14.13-list aggregation
14.14-list aggregation in google bigquery
14.15-exercise 13 string functions
15.01-ceil and floor
15.02-ceil and floor in bigquery
15.03-random
15.04-random in bigquery
15.05-setseed
15.06-setseed in bigquery
15.07-round
15.08-power
15.09-power in bigquery
15.10-exercise 14 mathematical functions
16.01-current date and time
16.02-current date and time in bigquery
16.03-age
16.04-age in bigquery
16.05-extract
16.06-extract in bigquery
16.07-exercise 15 date-time functions
17.01-pattern matching basics
17.02-advance pattern matching (regular expressions)
17.03-pattern matching in bigquery
17.04-exercise 16 pattern matching
18.01-google data studio to visualize bigquery data
![[3-in-1] Data Viz Bundle: Tableau, Excel & Looker Studio](https://farinmedia.ir/farinmedia-img/https://farinmedia.ir/farinmedia-img/images-123/14000.jpgmain-resized.jpg)
