BigQuery String Functions | UPPER, LOWER, LEFT, RIGHT, SUBSTR

Описание: Learn how to use string functions in BigQuery.

Keywords:
BigQuery join tutorial, SQL join types, INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, SQL join keys, BigQuery data manipulation, SQL data types, handle NULL values in SQL, Bike Share data example, BigQuery SQL tutorial, data analytics, SQL for beginners, advanced SQL joins, BigQuery SQL course, optimize BigQuery queries

Company Website: https://www.datadice.io/

Follow us:
Medium (blog posts about Google Data Analytics Release Notes, Data Studio Tips & Tricks, Introductions to Google Cloud Tools and many more): https://bit.ly/3trJPRr

LinkedIn (stay informed about most important company news): https://bit.ly/3qqJKeX

Chapters:
0:21 Introduction to String Function
1:31 UPPER and LOWER String Function in Bigquery
2:56 CONTAIN SUBSTR String Function in BigQuery
4:17 STARTS_WITH AND ENDS_WITH String Function in BigQuery
5:08 SUBSTR String Function in BigQuery
6:21 LEFT AND RIGHT String Function in BigQuery
7:15 LENGTH String Function in BigQuery
7:42 LPAD and RPAD String Function in BigQuery
8:41 REPLACE String Function in BigQuery
10:02 STRPOS String Function in BigQuery
10:40 TRANSLATE String Function in BigQuery
11:37 TRIM String Function in BigQuery
12:50 CONCAT String Function in BigQuery