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