1. Welcome to the Course.mp4 (22.32 MB)
10. CREATE in BigQuery.mp4 (66.87 MB)
100. UPPER LOWER.mp4 (9.7 MB)
101. Changing Case in BigQuery.mp4 (15.51 MB)
102. REPLACE.mp4 (20.87 MB)
103. REPLACE in BigQuery.mp4 (22.82 MB)
104. TRIM, LTRIM, RTRIM.mp4 (41.11 MB)
105. TRIM, LTRIM, RTRIM in BigQuery.mp4 (28.71 MB)
106. CONCATENATION.mp4 (14.07 MB)
107. CONCATENATION in BigQuery.mp4 (35.06 MB)
108. SUBSTRING.mp4 (34.63 MB)
109. SUBSTRING.mp4 (36.11 MB)
11. Exercise 1 Create DB and Table.mp4 (5.14 MB)
110. LIST AGGREGATION.mp4 (27.05 MB)
111. LIST AGGREGATION.mp4 (37.33 MB)
112. Exercise 13 String Functions.mp4 (15.06 MB)
113. CEIL & FLOOR.mp4 (17.36 MB)
114. CEIL & FLOOR in BigQuery.mp4 (39.97 MB)
115. RANDOM.mp4 (25.36 MB)
116. RANDOM in BigQuery.mp4 (32.49 MB)
117. SETSEED.mp4 (20.15 MB)
118. SETSEED in BigQuery.mp4 (1.85 MB)
119. ROUND.mp4 (13.3 MB)
12. INSERT.mp4 (46.54 MB)
120. POWER.mp4 (10.03 MB)
121. POWER in BigQuery.mp4 (10.92 MB)
122. Exercise 14 Mathematical Functions.mp4 (9.45 MB)
123. CURRENT DATE & TIME.mp4 (26.81 MB)
124. CURRENT DATE & TIME in BigQuery.mp4 (26.79 MB)
125. AGE.mp4 (21.76 MB)
126. AGE in BigQuery.mp4 (49.53 MB)
127. EXTRACT.mp4 (46.96 MB)
128. EXTRACT in BigQuery.mp4 (18.82 MB)
129. Exercise 15 Date time functions.mp4 (4.95 MB)
13. INSERT in BigQuery.mp4 (30.33 MB)
130. PATTERN MATCHING BASICS.mp4 (35.34 MB)
131. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).mp4 (84.73 MB)
132. PATTERN MATCHING in BigQuery.mp4 (53.21 MB)
133. Exercise 16 Pattern Matching.mp4 (7.1 MB)
134. Google Data Studio for visualizing BigQuery Data.mp4 (21.56 MB)
135. The final milestone!.mp4 (11.86 MB)
14. Import data from File.mp4 (26.64 MB)
15. Importing data from File using BigQuery Web User Interface.mp4 (59.67 MB)
16. File Upload in Google Big Query through Google cloud sdk.mp4 (91.62 MB)
17. Importing data from Google Drive.mp4 (55.73 MB)
18. Exercise 2 Inserting and Importing.mp4 (4.02 MB)
19. SELECT.mp4 (22.24 MB)
2. Course Flow.mp4 (28.18 MB)
20. SELECT in BigQuery.mp4 (20.44 MB)
21. SELECT DISTINCT.mp4 (34.43 MB)
22. SELECT DISTINCT in BigQuery.mp4 (15.23 MB)
23. WHERE.mp4 (22.37 MB)
24. WHERE in BigQuery.mp4 (30.55 MB)
25. Logical Operators AND, OR, NOT.mp4 (33.66 MB)
26. Logical Operators in BigQuery.mp4 (39.18 MB)
27. Exercise 3 SELECT & WHERE.mp4 (6.67 MB)
28. UPDATE.mp4 (30.07 MB)
29. UPDATE in BigQuery.mp4 (16.43 MB)
30. DELETE.mp4 (23.32 MB)
31. DELETE in BigQuery.mp4 (16.76 MB)
32. ALTER.mp4 (102.89 MB)
33. ALTER in BigQuery.mp4 (16.72 MB)
34. Exercise 4 Updating Table.mp4 (3.45 MB)
35. Restore and Back up.mp4 (58.38 MB)
36. Debugging Restoration.mp4 (50.19 MB)
37. Creating DB using CSV files.mp4 (35.5 MB)
38. Data Set creation in BigQuery.mp4 (83.27 MB)
39. Exercise 5 Restore and Back up.mp4 (2.65 MB)
4. This is a milestone!.mp4 (20.64 MB)
40. IN.mp4 (23.72 MB)
41. IN in BigQuery.mp4 (21.66 MB)
42. BETWEEN.mp4 (42.29 MB)
43. BETWEEN in BigQuery.mp4 (33.72 MB)
44. LIKE.mp4 (50.96 MB)
45. LIKE in BigQuery.mp4 (49.87 MB)
46. Exercise 6 In, Like & Between.mp4 (4.83 MB)
47. ORDER BY.mp4 (59.42 MB)
48. ORDER BY in BigQuery.mp4 (32.33 MB)
49. LIMIT.mp4 (24.13 MB)
5. PostgreSQL and PGAdmin Installation.mp4 (58.63 MB)
50. LIMIT in BigQuery.mp4 (41.41 MB)
51. Exercise 7 Sorting.mp4 (2.78 MB)
52. AS.mp4 (20.41 MB)
53. AS in BigQuery.mp4 (14.83 MB)
54. COUNT.mp4 (30.84 MB)
55. COUNT in BigQuery.mp4 (33.56 MB)
56. SUM.mp4 (17.21 MB)
57. SUM in BigQuery.mp4 (13.78 MB)
58. AVERAGE.mp4 (14.44 MB)
59. AVERAGE in BigQuery.mp4 (21.29 MB)
60. MIN MAX.mp4 (26.07 MB)
61. MIN MAX in BigQuery.mp4 (18.93 MB)
62. Exercise 8 Aggregate functions.mp4 (5.76 MB)
63. GROUP BY.mp4 (75.6 MB)
64. GROUP BY in BigQuery.mp4 (34.29 MB)
65. HAVING.mp4 (30.37 MB)
66. HAVING in BigQuery.mp4 (29.26 MB)
67. Exercise 9 Group By.mp4 (5.34 MB)
68. CASE WHEN.mp4 (23.89 MB)
69. CASE WHEN in BigQuery.mp4 (42.02 MB)
7. Setting up BigQuery on Google Cloud Platform.mp4 (50.94 MB)
70. Introduction to Joins.mp4 (7.93 MB)
71. Concepts of Joining and Combining Data.mp4 (59.81 MB)
72. Preparing the data.mp4 (13.84 MB)
73. Creating Datasets for Joins in BigQuery.mp4 (23.31 MB)
74. Inner Join.mp4 (47.18 MB)
75. INNER JOIN in BigQuery.mp4 (48.36 MB)
76. Left Join.mp4 (36.75 MB)
77. LEFT JOIN in BigQuery.mp4 (27.83 MB)
78. Right Join.mp4 (36 MB)
79. RIGHT JOIN in BigQuery.mp4 (33.17 MB)
8. BigQuery Interface.mp4 (107.51 MB)
80. Full Outer Join.mp4 (32.03 MB)
81. FULL OUTER JOIN in BigQuery.mp4 (34.9 MB)
82. Cross Join.mp4 (18.76 MB)
83. CROSS JOIN in BigQuery.mp4 (25.45 MB)
84. Intersect and Intersect ALL.mp4 (24.74 MB)
85. Except.mp4 (12.66 MB)
86. EXCEPT in BigQuery.mp4 (32.24 MB)
87. Union.mp4 (15.12 MB)
88. UNION in BigQuery.mp4 (27.67 MB)
89. Exercise 10 Joins.mp4 (6.37 MB)
9. CREATE.mp4 (54.42 MB)
90. Subqueries.mp4 (86.36 MB)
91. Subqueries in BigQuery.mp4 (36.93 MB)
92. Exercise 11 Subqueries.mp4 (4.46 MB)
93. Views.mp4 (36.05 MB)
94. Views in BigQuery.mp4 (20 MB)
95. Index.mp4 (33.98 MB)
96. Index in BigQuery.mp4 (7.54 MB)
97. Exercise 12 Views.mp4 (2.79 MB)
98. LENGTH.mp4 (15.79 MB)
99. LENGTH in BigQuery.mp4 (22.37 MB)