|
|
0
|
|
285.3 KB
|
|
|
1 - Introduction.mp4
|
MP4
|
23.5 MB
|
|
|
1
|
|
928.6 KB
|
|
|
2
|
|
836.3 KB
|
|
|
3
|
|
581.2 KB
|
|
|
4
|
|
578.4 KB
|
|
|
5
|
|
962.6 KB
|
|
|
6
|
|
133.5 KB
|
|
|
7
|
|
329.6 KB
|
|
|
8
|
|
844.8 KB
|
|
|
9
|
|
490.1 KB
|
|
|
10 - Weather Observation Station 7 10 points EASY level.mp4
|
MP4
|
13.7 MB
|
|
|
10
|
|
841.7 KB
|
|
|
11
|
|
134.6 KB
|
|
|
11 - Weather Observation Station 8 15 points EASY level.mp4
|
MP4
|
16.8 MB
|
|
|
12
|
|
9.4 KB
|
|
|
12 - Weather Observation Station 9 10 points EASY level.mp4
|
MP4
|
11.9 MB
|
|
|
13
|
|
727.7 KB
|
|
|
13 - Weather Observation Station 10 10 points EASY level.mp4
|
MP4
|
9.2 MB
|
|
|
14
|
|
205.4 KB
|
|
|
14 - Weather Observation Station 11 15 points EASY level.mp4
|
MP4
|
22.5 MB
|
|
|
15
|
|
789 KB
|
|
|
15 - Weather Observation Station 12 15 points EASY level.mp4
|
MP4
|
11 MB
|
|
|
16
|
|
402.4 KB
|
|
|
16 - Weather Observation Station 13 10 points EASY level.mp4
|
MP4
|
12.6 MB
|
|
|
17
|
|
747.4 KB
|
|
|
17 - Weather Observation Station 14 10 points EASY level.mp4
|
MP4
|
8 MB
|
|
|
18
|
|
890.1 KB
|
|
|
18 - Weather Observation Station 15 15 points EASY level.mp4
|
MP4
|
10.3 MB
|
|
|
19
|
|
753.9 KB
|
|
|
19 - Weather Observation Station 16 10 points EASY level.mp4
|
MP4
|
10.5 MB
|
|
|
2 - Course Resources.html
|
HTML
|
409.6 B
|
|
|
20 - Weather Observation Station 17 15 points EASY level.mp4
|
MP4
|
12.3 MB
|
|
|
20
|
|
199.5 KB
|
|
|
21 - Weather Observation Station 18 25 points MEDIUM level.mp4
|
MP4
|
19.6 MB
|
|
|
21
|
|
887.1 KB
|
|
|
22 - Weather Observation Station 19 30 points MEDIUM level.mp4
|
MP4
|
24.8 MB
|
|
|
22
|
|
409.6 KB
|
|
|
23
|
|
680 KB
|
|
|
23 - Weather Observation Station 20 40 points MEDIUM level.mp4
|
MP4
|
19.4 MB
|
|
|
24
|
|
22.2 KB
|
|
|
24 - The Pads 30 points MEDIUM level.mp4
|
MP4
|
43.5 MB
|
|
|
25
|
|
868.4 KB
|
|
|
25 - Binary Tree Nodes 30 points MEDIUM level.mp4
|
MP4
|
36.4 MB
|
|
|
26 - New Companies 30 points MEDIUM level.mp4
|
MP4
|
67.2 MB
|
|
|
3 - This is a milestone.mp4
|
MP4
|
21.9 MB
|
|
|
26
|
|
259.5 KB
|
|
|
27 - The Report 20 points MEDIUM level.mp4
|
MP4
|
50.4 MB
|
|
|
27
|
|
466.7 KB
|
|
|
28 - Top Companiess 30 points MEDIUM level.mp4
|
MP4
|
62.8 MB
|
|
|
28
|
|
575.1 KB
|
|
|
29
|
|
573.8 KB
|
|
|
29 - Ollivanders Inventory 30 points MEDIUM level.mp4
|
MP4
|
58.3 MB
|
|
|
30 - Challenges 30 points MEDIUM level.mp4
|
MP4
|
56.8 MB
|
|
|
30
|
|
850.1 KB
|
|
|
31
|
|
775.9 KB
|
|
|
31 - Contest Leaderboard 30 points MEDIUM level.mp4
|
MP4
|
38.4 MB
|
|
|
32 - Placements 40 points MEDIUM level.mp4
|
MP4
|
31.2 MB
|
|
|
32
|
|
388.5 KB
|
|
|
33
|
|
668.1 KB
|
|
|
33 - Symmetric Pairs 40 points MEDIUM level.mp4
|
MP4
|
29.8 MB
|
|
|
34 - SQL Project Planning 40 points MEDIUM level.mp4
|
MP4
|
40.3 MB
|
|
|
34
|
|
40.3 KB
|
|
|
35
|
|
258.5 KB
|
|
|
35 - Installing PostgreSQL and pgAdmin in your PC.mp4
|
MP4
|
83.4 MB
|
|
|
36
|
|
383.7 KB
|
|
|
36 - If pgAdmin is not opening.html
|
HTML
|
1.6 KB
|
|
|
37 - Installing and Setting up MySQL.mp4
|
MP4
|
43.7 MB
|
|
|
4 - Weather Observation Station 1 15 points EASY level.mp4
|
MP4
|
28.5 MB
|
|
|
37
|
|
533.7 KB
|
|
|
38
|
|
947.4 KB
|
|
|
38 - CREATE in PostgreSQL.mp4
|
MP4
|
91.2 MB
|
|
|
39
|
|
312.7 KB
|
|
|
39 - CREATE in MySQL.mp4
|
MP4
|
22.3 MB
|
|
|
40 - INSERT in PostgreSQL.mp4
|
MP4
|
73.1 MB
|
|
|
40
|
|
706 KB
|
|
|
41 - INSERT in MySQL.mp4
|
MP4
|
39.9 MB
|
|
|
42
|
|
96.7 KB
|
|
|
42 - Import data from File in PostgreSQL.mp4
|
MP4
|
42.1 MB
|
|
|
43
|
|
315.1 KB
|
|
|
43 - Import data from File in MySQL.mp4
|
MP4
|
27.3 MB
|
|
|
44
|
|
48.6 KB
|
|
|
44 - SELECT statement in PostgreSQL.mp4
|
MP4
|
31.9 MB
|
|
|
45
|
|
205.9 KB
|
|
|
45 - SELECT statement in MySQL.mp4
|
MP4
|
13.9 MB
|
|
|
46
|
|
426.1 KB
|
|
|
46 - SELECT DISTINCT in PostgreSQL.mp4
|
MP4
|
46.2 MB
|
|
|
5 - Weather Observation Station 2 15 points EASY level.mp4
|
MP4
|
9.3 MB
|
|
|
6 - Weather Observation Station 3 10 points EASY level.mp4
|
MP4
|
10.2 MB
|
|
|
7 - Weather Observation Station 4 10 points EASY level.mp4
|
MP4
|
9.8 MB
|
|
|
8 - Weather Observation Station 5 30 points EASY level.mp4
|
MP4
|
16.4 MB
|
|
|
47
|
|
594.3 KB
|
|
|
47 - SELECT DISTINCT in MySQL.mp4
|
MP4
|
12.6 MB
|
|
|
48 - WHERE in PostgreSQL.mp4
|
MP4
|
32.6 MB
|
|
|
48
|
|
649.9 KB
|
|
|
49 - WHERE in MySQL.mp4
|
MP4
|
23.4 MB
|
|
|
49
|
|
788.7 KB
|
|
|
50 - Logical Operators in PostgreSQL.mp4
|
MP4
|
50.5 MB
|
|
|
50
|
|
998.8 KB
|
|
|
51 - Logical Operators in MySQL.mp4
|
MP4
|
41.7 MB
|
|
|
51
|
|
246 KB
|
|
|
52 - UPDATE in PostgreSQL.mp4
|
MP4
|
38.2 MB
|
|
|
52
|
|
279.7 KB
|
|
|
53
|
|
289.5 KB
|
|
|
53 - UPDATE in MySQL.mp4
|
MP4
|
21.7 MB
|
|
|
54
|
|
630.6 KB
|
|
|
54 - DELETE in PostgreSQL.mp4
|
MP4
|
30 MB
|
|
|
55
|
|
516.5 KB
|
|
|
55 - DELETE in MySQL.mp4
|
MP4
|
17.2 MB
|
|
|
56
|
|
787.9 KB
|
|
|
56 - ALTER Part 1 in PostgreSQL.mp4
|
MP4
|
47.2 MB
|
|
|
57
|
|
977.9 KB
|
|
|
57 - ALTER Part 2 in PostgreSQL.mp4
|
MP4
|
92.1 MB
|
|
|
58 - ALTER in MySQL.mp4
|
MP4
|
45.3 MB
|
|
|
58
|
|
723 KB
|
|
|
59
|
|
428.8 KB
|
|
|
59 - Restore and Backup.mp4
|
MP4
|
81.4 MB
|
|
|
60
|
|
764.8 KB
|
|
|
60 - Debugging restoration issues.mp4
|
MP4
|
53.6 MB
|
|
|
61 - Creating DB using CSV files.mp4
|
MP4
|
38.4 MB
|
|
|
61
|
|
816.6 KB
|
|
|
62
|
|
143.7 KB
|
|
|
62 - Debugging summary and Code for CSV files.html
|
HTML
|
2.2 KB
|
|
|
63 - Restoring and Backup in MySQL.mp4
|
MP4
|
13.7 MB
|
|
|
63
|
|
831 KB
|
|
|
64
|
|
208.5 KB
|
|
|
64 - Restore and Backup in MySQL.mp4
|
MP4
|
23.1 MB
|
|
|
65 - IN in PostgreSQL.mp4
|
MP4
|
29.7 MB
|
|
|
65
|
|
24.4 KB
|
|
|
66 - IN in MySQL.mp4
|
MP4
|
22.3 MB
|
|
|
66
|
|
232.5 KB
|
|
|
67 - BETWEEN in PostgreSQL.mp4
|
MP4
|
52.3 MB
|
|
|
67
|
|
320 KB
|
|
|
68 - BETWEEN in MySQL.mp4
|
MP4
|
35.5 MB
|
|
|
68
|
|
584.1 KB
|
|
|
69
|
|
694.4 KB
|
|
|
70
|
|
140.3 KB
|
|
|
71
|
|
456.7 KB
|
|
|
72
|
|
545.7 KB
|
|
|
73
|
|
682.3 KB
|
|
|
74
|
|
703.6 KB
|
|
|
75
|
|
60.1 KB
|
|
|
76
|
|
495.1 KB
|
|
|
77
|
|
940.1 KB
|
|
|
78
|
|
943.4 KB
|
|
|
79
|
|
177.7 KB
|
|
|
80
|
|
701.9 KB
|
|
|
81
|
|
750.6 KB
|
|
|
82
|
|
829.6 KB
|
|
|
83
|
|
85.5 KB
|
|
|
84
|
|
207 KB
|
|
|
85
|
|
477.6 KB
|
|
|
86
|
|
564.5 KB
|
|
|
100 - Right Join in MySQL.mp4
|
MP4
|
21.3 MB
|
|
|
101 - Full Outer Join in PostgreSQL.mp4
|
MP4
|
34.3 MB
|
|
|
102 - Full Outer Join in MySQL.mp4
|
MP4
|
36.7 MB
|
|
|
103 - Cross Join in PostgreSQL.mp4
|
MP4
|
20.2 MB
|
|
|
104 - Cross Join in MySQL.mp4
|
MP4
|
20.9 MB
|
|
|
105 - Intersect and Intersect ALL in PostgreSQL.mp4
|
MP4
|
26.5 MB
|
|
|
106 - Intersect in MySQL.mp4
|
MP4
|
2.5 MB
|
|
|
107 - Except in PostgreSQL.mp4
|
MP4
|
13.9 MB
|
|
|
108 - Except in MySQL.mp4
|
MP4
|
20.7 MB
|
|
|
109 - Union in PostgreSQL.mp4
|
MP4
|
16.5 MB
|
|
|
110 - Union in MySQL.mp4
|
MP4
|
23.9 MB
|
|
|
111 - Subqueries Subquery in WHERE clause in PostgreSQL.mp4
|
MP4
|
26.1 MB
|
|
|
112 - Subqueries Subquery in FROM clause in PostgreSQL.mp4
|
MP4
|
35.2 MB
|
|
|
113 - Subqueries Subquery in SELECT in PostgreSQL.mp4
|
MP4
|
29.4 MB
|
|
|
114 - Subqueries in MySQL.mp4
|
MP4
|
70.2 MB
|
|
|
115 - VIEWS in PostgreSQL.mp4
|
MP4
|
37 MB
|
|
|
116 - VIEWS in MySQL.mp4
|
MP4
|
24.3 MB
|
|
|
117 - INDEX in PostgreSQL.mp4
|
MP4
|
36.7 MB
|
|
|
118 - INDEX in MySQL.mp4
|
MP4
|
22.7 MB
|
|
|
119 - LENGTH in PostgreSQL.mp4
|
MP4
|
16.4 MB
|
|
|
120 - UPPER LOWER in PostgreSQL.mp4
|
MP4
|
10 MB
|
|
|
121 - REPLACE in PostgreSQL.mp4
|
MP4
|
24.2 MB
|
|
|
122 - TRIM LTRIM RTRIM in PostgreSQL.mp4
|
MP4
|
45.6 MB
|
|
|
123 - CONCATENATION in PostgreSQL.mp4
|
MP4
|
16.1 MB
|
|
|
124 - SUBSTRING in PostgreSQL.mp4
|
MP4
|
39.7 MB
|
|
|
125 - LIST AGGREGATION in PostgreSQL.mp4
|
MP4
|
30.8 MB
|
|
|
126 - String Functions Part 1 in MySQL.mp4
|
MP4
|
58.1 MB
|
|
|
127 - String Functions Part 2 in MySQL.mp4
|
MP4
|
57.3 MB
|
|
|
128 - CEIL & FLOOR in PostgreSQL.mp4
|
MP4
|
16.5 MB
|
|
|
129 - RANDOM in PostgreSQL.mp4
|
MP4
|
24.3 MB
|
|
|
130 - SETSEED in PostgreSQL.mp4
|
MP4
|
18.2 MB
|
|
|
131 - ROUND in PostgreSQL.mp4
|
MP4
|
13.7 MB
|
|
|
132 - POWER in PostgreSQL.mp4
|
MP4
|
10.8 MB
|
|
|
133 - Mathematical Functions in MySQL.mp4
|
MP4
|
56.1 MB
|
|
|
134 - CURRENT DATE & TIME in PostgreSQL.mp4
|
MP4
|
28.6 MB
|
|
|
135 - AGE in PostgreSQL.mp4
|
MP4
|
23.8 MB
|
|
|
136 - EXTRACT in PostgreSQL.mp4
|
MP4
|
52 MB
|
|
|
137 - DateTime Functions in MySQL.mp4
|
MP4
|
64.3 MB
|
|
|
138 - Data Type conversion to string in PostgreSQL.mp4
|
MP4
|
61.6 MB
|
|
|
139 - Data Type conversion to Number and Date in PostgreSQL.mp4
|
MP4
|
28.9 MB
|
|
|
140 - Data Type conversion in MySQL.mp4
|
MP4
|
68.5 MB
|
|
|
141 - PATTERN MATCHING BASICS.mp4
|
MP4
|
36.8 MB
|
|
|
142 - Advanced pattern matching Part 1 REGULAR EXPRESSIONS.mp4
|
MP4
|
50.7 MB
|
|
|
143 - Advanced pattern matching Part 2 REGULAR EXPRESSIONS.mp4
|
MP4
|
32.2 MB
|
|
|
144 - Pattern matching in MySQL.mp4
|
MP4
|
49.4 MB
|
|
|
145 - The final milestone.mp4
|
MP4
|
12.7 MB
|
|
|
146 - Bonus Lecture.html
|
HTML
|
2.3 KB
|
|
|
69 - LIKE in PostgreSQL.mp4
|
MP4
|
72.7 MB
|
|
|
70 - LIKE in MySQL.mp4
|
MP4
|
62.2 MB
|
|
|
71 - Side Lecture Commenting in SQL.mp4
|
MP4
|
13.1 MB
|
|
|
72 - ORDER BY in PostgreSQL.mp4
|
MP4
|
72.9 MB
|
|
|
73 - ORDER BY in MySQL.mp4
|
MP4
|
66.9 MB
|
|
|
74 - LIMIT in PostgreSQL.mp4
|
MP4
|
29.3 MB
|
|
|
75 - LIMIT in MySQL.mp4
|
MP4
|
18.1 MB
|
|
|
76 - AS in PostgreSQL.mp4
|
MP4
|
27.3 MB
|
|
|
77 - AS in MySQL.mp4
|
MP4
|
12.2 MB
|
|
|
78 - COUNT in PostgreSQL.mp4
|
MP4
|
44 MB
|
|
|
79 - COUNT in MySQL.mp4
|
MP4
|
15.8 MB
|
|
|
80 - SUM in PostgreSQL.mp4
|
MP4
|
26.1 MB
|
|
|
81 - SUM in MySQL.mp4
|
MP4
|
19.3 MB
|
|
|
82 - AVERAGE in PostgreSQL.mp4
|
MP4
|
21.1 MB
|
|
|
83 - AVERAGE in MySQL.mp4
|
MP4
|
12.4 MB
|
|
|
84 - MIN & MAX in PostgreSQL.mp4
|
MP4
|
32.3 MB
|
|
|
85 - MIN & MAX in MySQL.mp4
|
MP4
|
12.6 MB
|
|
|
86 - GROUP BY in PostgreSQL.mp4
|
MP4
|
104.7 MB
|
|
|
87 - GROUP BY in MySQL.mp4
|
MP4
|
38.6 MB
|
|
|
9 - Weather Observation Station 6 10 points EASY level.mp4
|
MP4
|
12.2 MB
|
|
|
TutsNode.net.txt
|
TXT
|
102.4 B
|
|
|
[TGx]Downloaded from torrentgalaxy.to .txt
|
TXT
|
614.4 B
|
|
|
87
|
|
950.6 KB
|
|
|
88
|
|
296 KB
|
|
|
88 - HAVING in PostgreSQL.mp4
|
MP4
|
38.8 MB
|
|
|
89 - HAVING in MySQL.mp4
|
MP4
|
26.9 MB
|
|
|
89
|
|
466.7 KB
|
|
|
90
|
|
680.9 KB
|
|
|
90 - CASE WHEN in PostgreSQL.mp4
|
MP4
|
35 MB
|
|
|
91
|
|
713.6 KB
|
|
|
91 - CASE WHEN in MySQL.mp4
|
MP4
|
14.4 MB
|
|
|
92
|
|
133.4 KB
|
|
|
92 - Introduction to Joins.mp4
|
MP4
|
8.6 MB
|
|
|
93 - Concepts of Joining and Combining Data.mp4
|
MP4
|
65 MB
|
|
|
93
|
|
311 KB
|
|
|
94
|
|
765 KB
|
|
|
94 - Preparing the data.mp4
|
MP4
|
15.7 MB
|
|
|
95 - Inner Join in PostgreSQL.mp4
|
MP4
|
51.2 MB
|
|
|
95
|
|
915.4 KB
|
|
|
96
|
|
83.9 KB
|
|
|
96 - Inner Join in MySQL.mp4
|
MP4
|
43.6 MB
|
|
|
97 - Left Join in PostgreSQL.mp4
|
MP4
|
40 MB
|
|
|
97
|
|
299.3 KB
|
|
|
98 - Left Join in MySQL.mp4
|
MP4
|
19.9 MB
|
|
|
98
|
|
804 KB
|
|
|
99 - Right Join in PostgreSQL.mp4
|
MP4
|
39 MB
|
|
|
99
|
|
105.7 KB
|
|
|
100
|
|
388.4 KB
|
|
|
101
|
|
658.6 KB
|
|
|
102
|
|
707.5 KB
|
|
|
103
|
|
789.2 KB
|
|
|
104
|
|
941.9 KB
|
|
|
105
|
|
842.1 KB
|
|
|
106
|
|
163.3 KB
|
|
|
107
|
|
489.7 KB
|
|
|
108
|
|
499.9 KB
|
|
|
109
|
|
619.8 KB
|
|
|
110
|
|
651.2 KB
|
|
|
111
|
|
962.5 KB
|
|
|
112
|
|
164.6 KB
|
|
|
113
|
|
316.8 KB
|
|
|
114
|
|
622.7 KB
|
|
|
115
|
|
61.9 KB
|
|
|
116
|
|
107.1 KB
|
|
|
117
|
|
261.5 KB
|
|
|
118
|
|
285.2 KB
|
|
|
119
|
|
332.5 KB
|
|
|
120
|
|
889.3 KB
|
|
|
121
|
|
271.1 KB
|
|
|
122
|
|
382 KB
|
|
|
123
|
|
383.3 KB
|
|
|
124
|
|
407.6 KB
|
|
|
125
|
|
649.3 KB
|
|
|
126
|
|
745.3 KB
|
|
|
127
|
|
787.8 KB
|
|
|
128
|
|
851.6 KB
|
|
|
129
|
|
104.8 KB
|
|
|
130
|
|
978.6 KB
|
|
|
131
|
|
237.6 KB
|
|
|
132
|
|
509.5 KB
|
|
|
133
|
|
714.6 KB
|
|
|
134
|
|
830.5 KB
|
|
|
135
|
|
35.3 KB
|
|
|
136
|
|
212.2 KB
|
|
|
137
|
|
682 KB
|
|
|
138
|
|
805.7 KB
|
|
|
139
|
|
436.9 KB
|
|
|
140
|
|
39.6 KB
|
