RAR-files |
ilearn-gbapbqfda.rar |
50,000,000 |
D4FEF720 |
ilearn-gbapbqfda.r00 |
50,000,000 |
7EF0885A |
ilearn-gbapbqfda.r01 |
50,000,000 |
D83A007C |
ilearn-gbapbqfda.r02 |
50,000,000 |
DC5C3B45 |
ilearn-gbapbqfda.r03 |
50,000,000 |
8034D69E |
ilearn-gbapbqfda.r04 |
50,000,000 |
11276C05 |
ilearn-gbapbqfda.r05 |
50,000,000 |
6E36D625 |
ilearn-gbapbqfda.r06 |
50,000,000 |
8B744315 |
ilearn-gbapbqfda.r07 |
50,000,000 |
1E95E529 |
ilearn-gbapbqfda.r08 |
50,000,000 |
7950A9B0 |
ilearn-gbapbqfda.r09 |
50,000,000 |
3B2DD15C |
ilearn-gbapbqfda.r10 |
50,000,000 |
690095CB |
ilearn-gbapbqfda.r11 |
50,000,000 |
54D3A8F4 |
ilearn-gbapbqfda.r12 |
50,000,000 |
75E416BC |
ilearn-gbapbqfda.r13 |
50,000,000 |
81DCE9F9 |
ilearn-gbapbqfda.r14 |
50,000,000 |
1220A89F |
ilearn-gbapbqfda.r15 |
50,000,000 |
B505B245 |
ilearn-gbapbqfda.r16 |
50,000,000 |
AEB30517 |
ilearn-gbapbqfda.r17 |
50,000,000 |
4FF00CC7 |
ilearn-gbapbqfda.r18 |
50,000,000 |
EFC3953B |
ilearn-gbapbqfda.r19 |
50,000,000 |
749E584C |
ilearn-gbapbqfda.r20 |
50,000,000 |
A3B90847 |
ilearn-gbapbqfda.r21 |
50,000,000 |
9EC2F736 |
ilearn-gbapbqfda.r22 |
50,000,000 |
84FFEF5C |
ilearn-gbapbqfda.r23 |
50,000,000 |
74A84959 |
ilearn-gbapbqfda.r24 |
50,000,000 |
B809A249 |
ilearn-gbapbqfda.r25 |
50,000,000 |
3F4D454E |
ilearn-gbapbqfda.r26 |
50,000,000 |
88791DAD |
ilearn-gbapbqfda.r27 |
50,000,000 |
06E6990C |
ilearn-gbapbqfda.r28 |
50,000,000 |
4D590FD6 |
ilearn-gbapbqfda.r29 |
50,000,000 |
D87EDD4D |
ilearn-gbapbqfda.r30 |
50,000,000 |
FBE3BE60 |
ilearn-gbapbqfda.r31 |
50,000,000 |
E91FF1B7 |
ilearn-gbapbqfda.r32 |
50,000,000 |
82E59A59 |
ilearn-gbapbqfda.r33 |
50,000,000 |
D73BB647 |
ilearn-gbapbqfda.r34 |
50,000,000 |
EEE6E9F1 |
ilearn-gbapbqfda.r35 |
50,000,000 |
5545102C |
ilearn-gbapbqfda.r36 |
50,000,000 |
7119F158 |
ilearn-gbapbqfda.r37 |
50,000,000 |
580A67DA |
ilearn-gbapbqfda.r38 |
50,000,000 |
CACD302A |
ilearn-gbapbqfda.r39 |
50,000,000 |
26C7B607 |
ilearn-gbapbqfda.r40 |
50,000,000 |
FBC34CA2 |
ilearn-gbapbqfda.r41 |
50,000,000 |
0CDF1DBA |
ilearn-gbapbqfda.r42 |
50,000,000 |
7BB1DD67 |
ilearn-gbapbqfda.r43 |
50,000,000 |
4534E326 |
ilearn-gbapbqfda.r44 |
50,000,000 |
CBDCA701 |
ilearn-gbapbqfda.r45 |
50,000,000 |
5CB4D362 |
ilearn-gbapbqfda.r46 |
50,000,000 |
8E124173 |
ilearn-gbapbqfda.r47 |
50,000,000 |
6695EE8E |
ilearn-gbapbqfda.r48 |
50,000,000 |
85C2DEE7 |
ilearn-gbapbqfda.r49 |
50,000,000 |
449AB501 |
ilearn-gbapbqfda.r50 |
50,000,000 |
C698D41E |
ilearn-gbapbqfda.r51 |
50,000,000 |
D9A90050 |
ilearn-gbapbqfda.r52 |
50,000,000 |
EC3179ED |
ilearn-gbapbqfda.r53 |
50,000,000 |
B9412D11 |
ilearn-gbapbqfda.r54 |
50,000,000 |
03F6CDD2 |
ilearn-gbapbqfda.r55 |
50,000,000 |
118EAB91 |
ilearn-gbapbqfda.r56 |
50,000,000 |
25130553 |
ilearn-gbapbqfda.r57 |
50,000,000 |
210A7B09 |
ilearn-gbapbqfda.r58 |
50,000,000 |
52A08091 |
ilearn-gbapbqfda.r59 |
50,000,000 |
60A57E35 |
ilearn-gbapbqfda.r60 |
50,000,000 |
4ACC2F5C |
ilearn-gbapbqfda.r61 |
50,000,000 |
DE2ABF59 |
ilearn-gbapbqfda.r62 |
50,000,000 |
FE555FDD |
ilearn-gbapbqfda.r63 |
50,000,000 |
27D70C87 |
ilearn-gbapbqfda.r64 |
50,000,000 |
5B7C446C |
ilearn-gbapbqfda.r65 |
50,000,000 |
1369B424 |
ilearn-gbapbqfda.r66 |
50,000,000 |
93159A3F |
ilearn-gbapbqfda.r67 |
50,000,000 |
7D4D5B5E |
ilearn-gbapbqfda.r68 |
50,000,000 |
AA10FE6E |
ilearn-gbapbqfda.r69 |
50,000,000 |
CD03F86B |
ilearn-gbapbqfda.r70 |
50,000,000 |
5DF22EC6 |
ilearn-gbapbqfda.r71 |
50,000,000 |
8645F27F |
ilearn-gbapbqfda.r72 |
50,000,000 |
9B574499 |
ilearn-gbapbqfda.r73 |
50,000,000 |
DD18E4C7 |
ilearn-gbapbqfda.r74 |
50,000,000 |
00443701 |
ilearn-gbapbqfda.r75 |
50,000,000 |
4C42539B |
ilearn-gbapbqfda.r76 |
50,000,000 |
11EE0EB8 |
ilearn-gbapbqfda.r77 |
50,000,000 |
375DDC0F |
ilearn-gbapbqfda.r78 |
50,000,000 |
A5982732 |
ilearn-gbapbqfda.r79 |
50,000,000 |
8B44D3F7 |
ilearn-gbapbqfda.r80 |
50,000,000 |
F42F7B4A |
ilearn-gbapbqfda.r81 |
50,000,000 |
E99EDEE3 |
ilearn-gbapbqfda.r82 |
41,524,169 |
E3499297 |
|
Total size: |
4,191,524,169 |
|
|
Archived
files |
5. PostgreSQL and PGAdmin Installation.mp4
[3e0c33d0951fabd4]
|
61,474,762 |
AC998CFF |
7. Setting up BigQuery on Google Cloud Platform.mp4
[cc9fb41d1a022a6d]
|
53,418,037 |
7E97132E |
8. BigQuery Interface.mp4
[e29dff7149facdba]
|
112,734,960 |
90679903 |
9. CREATE.mp4
[a8dac0f1fbce1a1d]
|
57,061,278 |
C5B62B2B |
10. CREATE in BigQuery.mp4
[d714db1dc97ed5be]
|
70,113,449 |
94113540 |
11. Exercise 1 Create DB and Table.mp4
[2fb3f036411a3379]
|
5,391,300 |
6CF739E7 |
12. INSERT.mp4
[76bd608897ddd41c]
|
48,797,685 |
7D1ECEDA |
13. INSERT in BigQuery.mp4
[5c3cac83b50f8eb9]
|
31,804,649 |
C71A520D |
14. Import data from File.mp4
[8706f891588e56b7]
|
27,929,444 |
6F34E43C |
15. Importing data from File using BigQuery Web User Interface.mp4
[611ebedc165fcfb4]
|
62,564,364 |
9AEB2B14 |
16. File Upload in Google Big Query through Google cloud sdk.mp4
[d0cf522caf3a6a80]
|
96,066,693 |
71FD4D89 |
17. Importing data from Google Drive.mp4
[27407827667eb8c5]
|
58,438,446 |
897ABFA4 |
18. Exercise 2 Inserting and Importing.mp4
[f79de0cbb57e39bf]
|
4,220,158 |
CCA075C9 |
19. SELECT.mp4
[b45448e529c80da9]
|
23,318,229 |
A74F321C |
20. SELECT in BigQuery.mp4
[167970a329b7f2a7]
|
21,429,014 |
580005BC |
21. SELECT DISTINCT.mp4
[fd6a61a7c228a9c2]
|
36,102,535 |
3F8643E9 |
22. SELECT DISTINCT in BigQuery.mp4
[e1f890f57f800006]
|
15,974,488 |
0895D409 |
23. WHERE.mp4
[cf40e45fa03ce678]
|
23,452,426 |
92057398 |
24. WHERE in BigQuery.mp4
[7d87a0f9627d6149]
|
32,032,795 |
37A011DB |
25. Logical Operators - AND, OR, NOT.mp4
[2b05340dda8c7e6f]
|
35,290,592 |
D9E09D22 |
26. Logical Operators in BigQuery.mp4
[50862b6500397479]
|
41,084,257 |
4FE987C8 |
27. Exercise 3 SELECT & WHERE.mp4
[89e928563160e30a]
|
6,996,353 |
CB833A01 |
28. UPDATE.mp4
[5e6dd6cc16eca330]
|
31,531,706 |
ABE3FB6B |
29. UPDATE in BigQuery.mp4
[dccbc2e647af5428]
|
17,223,080 |
0D09BB5A |
30. DELETE.mp4
[33a3e0dcd93bb98c]
|
24,456,150 |
488927EE |
31. DELETE in BigQuery.mp4
[4304ac873958e168]
|
17,577,563 |
117CBE99 |
32. ALTER.mp4
[38e7d029c18c1a1c]
|
107,891,222 |
2F66A707 |
33. ALTER in BigQuery.mp4
[244e93a7a15d954f]
|
17,529,594 |
63E556D7 |
34. Exercise 4 Updating Table.mp4
[28f10bc28f0b0cf2]
|
3,614,837 |
BD87E801 |
35. Restore and Back-up.mp4
[a2d9fcc05e9dd1fa]
|
61,210,677 |
C67CB671 |
36. Debugging Restoration.mp4
[1acfce1e09934987]
|
52,632,222 |
EF6C023D |
37. Creating DB using CSV files.mp4
[cf3d5f368341d605]
|
37,221,017 |
EDC85140 |
38. Data Set creation in BigQuery.mp4
[ae5204adfa351364]
|
87,314,742 |
12A5D131 |
39. Exercise 5 Restore and Back-up.mp4
[1ddb702d5d0857a1]
|
2,776,940 |
F38CC01E |
40. IN.mp4
[253cd8eae6e721ab]
|
24,877,361 |
AA9D6A65 |
41. IN in BigQuery.mp4
[e3cc5c29dd755c7b]
|
22,710,210 |
FF249039 |
42. BETWEEN.mp4
[d2e3a5f58281331e]
|
44,340,121 |
F05640D9 |
43. BETWEEN in BigQuery.mp4
[1d3a5be39006721b]
|
35,362,963 |
7166862F |
44. LIKE.mp4
[8b45595705ad2842]
|
53,439,221 |
455A4D10 |
45. LIKE in BigQuery.mp4
[900e15e0690ba288]
|
52,296,099 |
56017206 |
46. Exercise 6 In, Like & Between.mp4
[b450bf200f7009ff]
|
5,068,678 |
3518ABA3 |
47. ORDER BY.mp4
[7a0e19da6b9d27a4]
|
62,303,391 |
3D367C99 |
48. ORDER BY in BigQuery.mp4
[8f1964b71ae85c03]
|
33,902,159 |
526C722F |
49. LIMIT.mp4
[21dcdec2cfa64e1b]
|
25,302,628 |
680F6C0C |
50. LIMIT in BigQuery.mp4
[5cd58d8908ba8085]
|
43,422,591 |
C70B10F1 |
51. Exercise 7 Sorting.mp4
[d1b79dea4488d1f0]
|
2,917,344 |
B406C150 |
52. AS.mp4
[62058cc4050a6edf]
|
21,397,865 |
1AF4A0AE |
53. AS in BigQuery.mp4
[dabab2f3e2f1bdb0]
|
15,550,558 |
8BCAAA15 |
54. COUNT.mp4
[f1e52df33125d3d2]
|
32,342,602 |
F06AB2FD |
55. COUNT in BigQuery.mp4
[ae178925e8815529]
|
35,188,719 |
FF42E512 |
56. SUM.mp4
[617cb6b18e74dab7]
|
18,045,300 |
61B0F90A |
57. SUM in BigQuery.mp4
[52ba84db4db480a2]
|
14,451,093 |
4FC8F2FE |
58. AVERAGE.mp4
[798b28bfdb7f26ce]
|
15,142,662 |
7987FAB8 |
59. AVERAGE in BigQuery.mp4
[c4a92f89ec3fa2c5]
|
22,325,260 |
1D40A5BE |
60. MIN MAX.mp4
[6be2447a9e873066]
|
27,333,623 |
7973C600 |
61. MIN MAX in BigQuery.mp4
[c50239536f4b86c4]
|
19,848,034 |
49855AC9 |
62. Exercise 8 Aggregate functions.mp4
[6e321bc90c503134]
|
6,038,750 |
C7407DF4 |
63. GROUP BY.mp4
[2d584b58313a9a9e]
|
79,275,603 |
83F41F67 |
64. GROUP BY in BigQuery.mp4
[467e4bcceffc0c28]
|
35,953,520 |
7E9D9B35 |
65. HAVING.mp4
[4db3759178a6c58b]
|
31,845,607 |
D6F6796C |
66. HAVING in BigQuery.mp4
[b699de0ef3c9f36e]
|
30,678,941 |
273105A3 |
67. Exercise 9 Group By.mp4
[f74e54a708e9d9da]
|
5,601,284 |
B04C3A18 |
68. CASE WHEN.mp4
[ad325b4714ad5765]
|
25,053,746 |
41F38D73 |
69. CASE WHEN in BigQuery.mp4
[a3e088de0acd800d]
|
44,062,493 |
0C8C54C8 |
70. Introduction to Joins.mp4
[3d678547e6dc8f6a]
|
8,313,342 |
BE3B4861 |
71. Concepts of Joining and Combining Data.mp4
[29667a686116fc58]
|
62,714,301 |
76DFD0EE |
72. Preparing the data.mp4
[7475ef98d4e044d9]
|
14,509,865 |
8AAB104D |
73. Creating Datasets for Joins in BigQuery.mp4
[cc1b33c195dba927]
|
24,437,077 |
65305316 |
74. Inner Join.mp4
[3d7760c0d9ace66f]
|
49,467,079 |
634F1E23 |
75. INNER JOIN in BigQuery.mp4
[78ee050bb0baed86]
|
50,704,317 |
8FD95DDA |
76. Left Join.mp4
[7c31fe5fc5f6570]
|
38,533,153 |
FEA7D2B5 |
77. LEFT JOIN in BigQuery.mp4
[2b71b0d7b0b332b0]
|
29,186,675 |
D84036D6 |
78. Right Join.mp4
[829e5280e0c9711b]
|
37,747,867 |
3B9A08A8 |
79. RIGHT JOIN in BigQuery.mp4
[243e05410e0e68e3]
|
34,780,109 |
E34D3808 |
80. Full Outer Join.mp4
[516733c8af88e1d0]
|
33,580,780 |
32F339A9 |
81. FULL OUTER JOIN in BigQuery.mp4
[f96996dedda76f66]
|
36,595,244 |
29FE9B82 |
82. Cross Join.mp4
[a4a777861b3a7152]
|
19,674,990 |
65E5F1C1 |
83. CROSS JOIN in BigQuery.mp4
[ba7ee05ff9c64e72]
|
26,690,042 |
54B6F7B7 |
84. Intersect and Intersect ALL.mp4
[ef7329e4c35158]
|
25,937,229 |
E38C44BA |
85. Except.mp4
[aac3e0c9f047d3ab]
|
13,278,965 |
B1351069 |
86. EXCEPT in BigQuery.mp4
[f2ec131a080d41e7]
|
33,810,693 |
DEE28541 |
87. Union.mp4
[eb2f532849a290c8]
|
15,849,857 |
301EF109 |
88. UNION in BigQuery.mp4
[c2c04dbe126daecd]
|
29,012,100 |
FAF4334E |
89. Exercise 10 Joins.mp4
[fde36e2c797eb1af]
|
6,674,296 |
D2516280 |
90. Subqueries.mp4
[b12bec9b79e02197]
|
90,552,161 |
E418EC85 |
91. Subqueries in BigQuery.mp4
[3cb791f9462b3ad3]
|
38,722,510 |
4234471A |
92. Exercise 11 Subqueries.mp4
[e17a45df8b259c97]
|
4,680,905 |
7705F362 |
93. Views.mp4
[435f5c810ea0e9c6]
|
37,798,698 |
62423721 |
94. Views in BigQuery.mp4
[3bf99121870b64d]
|
20,968,042 |
B706D060 |
95. Index.mp4
[ca46355f53d947c5]
|
35,634,978 |
F3E25AA5 |
96. Index in BigQuery.mp4
[93102261e9db9a0]
|
7,911,276 |
D719B130 |
97. Exercise 12 Views.mp4
[995b919454877da5]
|
2,926,245 |
7CADD485 |
98. LENGTH.mp4
[4a6a3cef2296f2ec]
|
16,552,382 |
F28167CE |
99. LENGTH in BigQuery.mp4
[fa366afff76b0623]
|
23,459,954 |
99F5FEE5 |
100. UPPER LOWER.mp4
[4ba451eff676dd10]
|
10,171,507 |
B4314540 |
101. Changing Case in BigQuery.mp4
[760535ebf46fdb12]
|
16,265,127 |
9D7A7A61 |
102. REPLACE.mp4
[6f98e9cde3c45956]
|
21,888,715 |
87FC9254 |
103. REPLACE in BigQuery.mp4
[6631af1b9362e01d]
|
23,928,937 |
42E01C47 |
104. TRIM, LTRIM, RTRIM.mp4
[ed56c747e9a0b797]
|
43,107,343 |
DAB094AF |
105. TRIM, LTRIM, RTRIM in BigQuery.mp4
[77f711d8576d7ef9]
|
30,105,225 |
6690526E |
106. CONCATENATION.mp4
[c4202f405d27fc3c]
|
14,756,350 |
383FF3F8 |
107. CONCATENATION in BigQuery.mp4
[a95a195f4ba15577]
|
36,767,899 |
E23CF582 |
108. SUBSTRING.mp4
[b18606c0d37eed95]
|
36,308,702 |
B8AD6E70 |
109. SUBSTRING.mp4
[839a41df3e5fb1f6]
|
37,862,420 |
5E34DC70 |
110. LIST AGGREGATION.mp4
[4cfb9abe30b23a76]
|
28,361,479 |
2E85D58E |
111. LIST AGGREGATION.mp4
[c2740d765a2297b8]
|
39,138,133 |
E7F04AAC |
112. Exercise 13 String Functions.mp4
[51282a6aed524805]
|
15,787,081 |
3A9DE9F6 |
113. CEIL & FLOOR.mp4
[9c8b19725459897b]
|
18,198,152 |
F1831739 |
114. CEIL & FLOOR in BigQuery.mp4
[300701bbbb551d0b]
|
41,916,777 |
51B84B29 |
115. RANDOM.mp4
[47968e74d088f2be]
|
26,594,335 |
C772D626 |
116. RANDOM in BigQuery.mp4
[dace2db0b25a0d5c]
|
34,069,402 |
8DAB4AE7 |
117. SETSEED.mp4
[669aca91d199bc39]
|
21,133,224 |
62F30EA8 |
118. SETSEED in BigQuery.mp4
[2a5d11866eca494d]
|
1,944,410 |
A54ACF66 |
119. ROUND.mp4
[90d2b5a11c0124aa]
|
13,944,486 |
2DDBB6E1 |
120. POWER.mp4
[53ea3fef68452b30]
|
10,521,423 |
CB207E95 |
121. POWER in BigQuery.mp4
[1342d188f79482db]
|
11,448,326 |
EEC19B80 |
122. Exercise 14 Mathematical Functions.mp4
[cceafc880638ae3a]
|
9,909,643 |
8403AA12 |
123. CURRENT DATE & TIME.mp4
[8593abdddc7b987c]
|
28,115,028 |
6B070E43 |
124. CURRENT DATE & TIME in BigQuery.mp4
[f8fd6e08b41eb92c]
|
28,089,132 |
48E2DBBC |
125. AGE.mp4
[d5bf71debace4817]
|
22,816,203 |
8D24B07F |
126. AGE in BigQuery.mp4
[4278791aa5981e7d]
|
51,941,075 |
5F264BE4 |
127. EXTRACT.mp4
[56a394abe9adfabf]
|
49,241,437 |
45E6FBDE |
128. EXTRACT in BigQuery.mp4
[3de6a616fe018cfc]
|
19,738,923 |
24B6E3BF |
129. Exercise 15 Date-time functions.mp4
[4bd20a44ff62acc1]
|
5,193,147 |
31C368A5 |
130. PATTERN MATCHING BASICS.mp4
[857b834fcc4f7551]
|
37,054,844 |
9B1E3511 |
131. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).mp4
[53c6f9a7fff3b13f]
|
88,844,809 |
BEEC1266 |
132. PATTERN MATCHING in BigQuery.mp4
[48949653e38a1360]
|
55,790,741 |
24196231 |
133. Exercise 16 Pattern Matching.mp4
[7086f9b2737b7511]
|
7,444,793 |
9E63992E |
134. Google Data Studio for visualizing BigQuery Data.mp4
[26a914a9b7e940de]
|
22,606,953 |
C25A8333 |
135. The final milestone!.mp4
[96a92d63a29da034]
|
12,433,539 |
0FB07B83 |
1. Welcome to the Course.mp4
[1d4ed43ddbaac96b]
|
23,408,753 |
C38B3554 |
2. Course Flow.mp4
[3eb0ef14b5bd0af1]
|
29,552,107 |
2BBE6CEF |
4. This is a milestone!.mp4
[9a44edfb03bb628c]
|
21,647,293 |
B2CF27C8 |
|
Total size: |
4,191,507,095 |
|
|