|
|
0
|
|
342.4 KB
|
|
|
1
|
|
546.2 KB
|
|
|
1 - Introduction.mp4
|
MP4
|
23.4 MB
|
|
|
2
|
|
716.3 KB
|
|
|
3
|
|
971.8 KB
|
|
|
4
|
|
893.5 KB
|
|
|
5
|
|
65.7 KB
|
|
|
6
|
|
560.5 KB
|
|
|
7
|
|
589.4 KB
|
|
|
8
|
|
954.2 KB
|
|
|
9
|
|
130.6 KB
|
|
|
10
|
|
341.3 KB
|
|
|
10 - INSERT in PostgreSQL.mp4
|
MP4
|
73.1 MB
|
|
|
11
|
|
521.2 KB
|
|
|
11 - INSERT in MS SQL.mp4
|
MP4
|
38.1 MB
|
|
|
12 - Import data from File in PostgreSQL.mp4
|
MP4
|
42 MB
|
|
|
12
|
|
17.6 KB
|
|
|
13 - Import data from File in MS SQL.mp4
|
MP4
|
23.4 MB
|
|
|
13
|
|
559.2 KB
|
|
|
14 - SELECT statement in PostgreSQL.mp4
|
MP4
|
31.8 MB
|
|
|
14
|
|
431.5 KB
|
|
|
15
|
|
702.5 KB
|
|
|
100 - AGE in PostgreSQL.mp4
|
MP4
|
23.8 MB
|
|
|
101 - EXTRACT in PostgreSQL.mp4
|
MP4
|
52 MB
|
|
|
102 - DateTime Functions in MS SQL.mp4
|
MP4
|
89.9 MB
|
|
|
103 - Data Type conversion to string in PostgreSQL.mp4
|
MP4
|
61.6 MB
|
|
|
104 - Data Type conversion to Number and Date in PostgreSQL.mp4
|
MP4
|
28.9 MB
|
|
|
105 - PATTERN MATCHING BASICS.mp4
|
MP4
|
36.8 MB
|
|
|
106 - Advanced pattern matching Part 1 REGULAR EXPRESSIONS.mp4
|
MP4
|
50.7 MB
|
|
|
107 - Advanced pattern matching Part 2 REGULAR EXPRESSIONS.mp4
|
MP4
|
32.2 MB
|
|
|
108 - Pattern matching in MS SQL.mp4
|
MP4
|
74.4 MB
|
|
|
109 - The final milestone.mp4
|
MP4
|
12.7 MB
|
|
|
110 - Bonus Lecture.html
|
HTML
|
2.3 KB
|
|
|
15 - SELECT statement in MS SQL.mp4
|
MP4
|
16.7 MB
|
|
|
16
|
|
406.9 KB
|
|
|
16 - SELECT DISTINCT in PostgreSQL.mp4
|
MP4
|
46.2 MB
|
|
|
17
|
|
432.6 KB
|
|
|
17 - SELECT DISTINCT in MS SQL.mp4
|
MP4
|
15.1 MB
|
|
|
18
|
|
754.1 KB
|
|
|
18 - WHERE in PostgreSQL.mp4
|
MP4
|
32.5 MB
|
|
|
19
|
|
22.6 KB
|
|
|
19 - WHERE in MS SQL.mp4
|
MP4
|
22.1 MB
|
|
|
2 - Course resources.html
|
HTML
|
409.6 B
|
|
|
20
|
|
903.4 KB
|
|
|
20 - Logical Operators in PostgreSQL.mp4
|
MP4
|
50.5 MB
|
|
|
3 - This is a milestone.mp4
|
MP4
|
21.9 MB
|
|
|
21
|
|
268 KB
|
|
|
21 - Logical Operators in MS SQL.mp4
|
MP4
|
38.4 MB
|
|
|
22
|
|
557.1 KB
|
|
|
22 - UPDATE in PostgreSQL.mp4
|
MP4
|
38.2 MB
|
|
|
23
|
|
844.7 KB
|
|
|
23 - UPDATE in MS SQL.mp4
|
MP4
|
24.3 MB
|
|
|
24
|
|
817.9 KB
|
|
|
24 - DELETE in PostgreSQL.mp4
|
MP4
|
30 MB
|
|
|
25 - DELETE in MS SQL.mp4
|
MP4
|
24.4 MB
|
|
|
25
|
|
27.8 KB
|
|
|
26
|
|
390 KB
|
|
|
26 - ALTER Part 1 in PostgreSQL.mp4
|
MP4
|
47.2 MB
|
|
|
27
|
|
657.9 KB
|
|
|
27 - ALTER Part 2 in PostgreSQL.mp4
|
MP4
|
92.1 MB
|
|
|
28 - ALTER in MS SQL.mp4
|
MP4
|
98.3 MB
|
|
|
28
|
|
300 KB
|
|
|
29 - Restore and Backup.mp4
|
MP4
|
81.5 MB
|
|
|
29
|
|
111.7 KB
|
|
|
30 - Debugging restoration issues.mp4
|
MP4
|
53.6 MB
|
|
|
30
|
|
994.2 KB
|
|
|
31 - Creating DB using CSV files.mp4
|
MP4
|
38.4 MB
|
|
|
31
|
|
387.5 KB
|
|
|
32 - Debugging summary and Code for CSV files.html
|
HTML
|
2.2 KB
|
|
|
32
|
|
436.1 KB
|
|
|
33 - Restoring and Backup in MySQL.mp4
|
MP4
|
16.6 MB
|
|
|
34
|
|
328.7 KB
|
|
|
34 - Restore and Backup in MS SQL.mp4
|
MP4
|
45.4 MB
|
|
|
35 - IN in PostgreSQL.mp4
|
MP4
|
29.6 MB
|
|
|
35
|
|
46.4 KB
|
|
|
36 - IN in MS SQL.mp4
|
MP4
|
20.2 MB
|
|
|
36
|
|
245.6 KB
|
|
|
37
|
|
580 KB
|
|
|
37 - BETWEEN in PostgreSQL.mp4
|
MP4
|
52.3 MB
|
|
|
38 - BETWEEN in MS SQL.mp4
|
MP4
|
34.6 MB
|
|
|
38
|
|
624.9 KB
|
|
|
39 - LIKE in PostgreSQL.mp4
|
MP4
|
72.7 MB
|
|
|
4 - Installing PostgreSQL and pgAdmin in your PC.mp4
|
MP4
|
71.5 MB
|
|
|
39
|
|
792.1 KB
|
|
|
40 - LIKE in MS SQL.mp4
|
MP4
|
53.6 MB
|
|
|
40
|
|
886.4 KB
|
|
|
41 - Side Lecture Commenting in SQL.mp4
|
MP4
|
13.1 MB
|
|
|
41
|
|
989.2 KB
|
|
|
42 - ORDER BY in PostgreSQL.mp4
|
MP4
|
72.9 MB
|
|
|
42
|
|
232.2 KB
|
|
|
43 - ORDER BY in MS SQL.mp4
|
MP4
|
25 MB
|
|
|
43
|
|
244.3 KB
|
|
|
44 - LIMIT in PostgreSQL.mp4
|
MP4
|
29.3 MB
|
|
|
44
|
|
555.5 KB
|
|
|
45 - LIMIT in MS SQL.mp4
|
MP4
|
19.4 MB
|
|
|
45
|
|
759.4 KB
|
|
|
46
|
|
966.2 KB
|
|
|
46 - AS in PostgreSQL.mp4
|
MP4
|
27.3 MB
|
|
|
47
|
|
280.5 KB
|
|
|
47 - AS in MS SQL.mp4
|
MP4
|
16.5 MB
|
|
|
48
|
|
397.4 KB
|
|
|
48 - COUNT in PostgreSQL.mp4
|
MP4
|
43.9 MB
|
|
|
49 - SUM in PostgreSQL.mp4
|
MP4
|
26.1 MB
|
|
|
5 - If pgAdmin is not opening.html
|
HTML
|
1.6 KB
|
|
|
49
|
|
760.6 KB
|
|
|
50 - AVERAGE in PostgreSQL.mp4
|
MP4
|
21.1 MB
|
|
|
50
|
|
462.6 KB
|
|
|
51
|
|
771.6 KB
|
|
|
51 - MIN & MAX in PostgreSQL.mp4
|
MP4
|
32.2 MB
|
|
|
52 - Aggregate Functions in MS SQL.mp4
|
MP4
|
44.7 MB
|
|
|
52
|
|
810.1 KB
|
|
|
53
|
|
155.5 KB
|
|
|
53 - GROUP BY in PostgreSQL.mp4
|
MP4
|
104.7 MB
|
|
|
54 - GROUP BY in MS SQL.mp4
|
MP4
|
41.6 MB
|
|
|
55 - HAVING in PostgreSQL.mp4
|
MP4
|
38.8 MB
|
|
|
56 - HAVING in MS SQL.mp4
|
MP4
|
10.7 MB
|
|
|
57 - CASE WHEN in PostgreSQL.mp4
|
MP4
|
35.1 MB
|
|
|
58 - CASE WHEN in MS SQL.mp4
|
MP4
|
13.1 MB
|
|
|
59 - Introduction to Joins.mp4
|
MP4
|
8.6 MB
|
|
|
6 - Installing and Setting up MS SQL.mp4
|
MP4
|
34.7 MB
|
|
|
60 - Concepts of Joining and Combining Data.mp4
|
MP4
|
65 MB
|
|
|
61 - Preparing the data.mp4
|
MP4
|
15.7 MB
|
|
|
62 - Inner Join in PostgreSQL.mp4
|
MP4
|
51.1 MB
|
|
|
63 - Inner Join in MS SQL.mp4
|
MP4
|
41.6 MB
|
|
|
64 - Left Join in PostgreSQL.mp4
|
MP4
|
40 MB
|
|
|
65 - Left Join in MS SQL.mp4
|
MP4
|
16.8 MB
|
|
|
66 - Right Join in PostgreSQL.mp4
|
MP4
|
39 MB
|
|
|
67 - Right Join in MS SQL.mp4
|
MP4
|
16.6 MB
|
|
|
68 - Full Outer Join in PostgreSQL.mp4
|
MP4
|
34.3 MB
|
|
|
69 - Full Outer Join in MS SQL.mp4
|
MP4
|
28.2 MB
|
|
|
7 - Debugging the installation process.mp4
|
MP4
|
46 MB
|
|
|
70 - Cross Join in PostgreSQL.mp4
|
MP4
|
20.2 MB
|
|
|
71 - Cross Join in MS SQL.mp4
|
MP4
|
20.5 MB
|
|
|
72 - Intersect and Intersect ALL in PostgreSQL.mp4
|
MP4
|
26.5 MB
|
|
|
73 - Except in PostgreSQL.mp4
|
MP4
|
13.9 MB
|
|
|
74 - Union in PostgreSQL.mp4
|
MP4
|
16.5 MB
|
|
|
75 - Intersect Except & Union in MS SQL.mp4
|
MP4
|
29.9 MB
|
|
|
76 - Subqueries Subquery in WHERE clause in PostgreSQL.mp4
|
MP4
|
26.1 MB
|
|
|
77 - Subqueries Subquery in FROM clause in PostgreSQL.mp4
|
MP4
|
35.3 MB
|
|
|
78 - Subqueries Subquery in SELECT in PostgreSQL.mp4
|
MP4
|
29.4 MB
|
|
|
79 - Subqueries in MS SQL.mp4
|
MP4
|
56.3 MB
|
|
|
8 - CREATE in PostgreSQL.mp4
|
MP4
|
91.1 MB
|
|
|
80 - VIEWS in PostgreSQL.mp4
|
MP4
|
37 MB
|
|
|
81 - VIEWS in MS SQL.mp4
|
MP4
|
29.6 MB
|
|
|
82 - INDEX in PostgreSQL.mp4
|
MP4
|
36.8 MB
|
|
|
83 - INDEX in MS SQL.mp4
|
MP4
|
29.7 MB
|
|
|
84 - LENGTH in PostgreSQL.mp4
|
MP4
|
16.4 MB
|
|
|
85 - UPPER LOWER in PostgreSQL.mp4
|
MP4
|
10 MB
|
|
|
86 - REPLACE in PostgreSQL.mp4
|
MP4
|
24.2 MB
|
|
|
87 - TRIM LTRIM RTRIM in PostgreSQL.mp4
|
MP4
|
45.6 MB
|
|
|
88 - CONCATENATION in PostgreSQL.mp4
|
MP4
|
16.1 MB
|
|
|
89 - SUBSTRING in PostgreSQL.mp4
|
MP4
|
39.7 MB
|
|
|
9 - CREATE in MS SQL.mp4
|
MP4
|
22.3 MB
|
|
|
90 - LIST AGGREGATION in PostgreSQL.mp4
|
MP4
|
30.8 MB
|
|
|
91 - String Functions in MS SQL.mp4
|
MP4
|
101.5 MB
|
|
|
92 - CEIL & FLOOR in PostgreSQL.mp4
|
MP4
|
16.5 MB
|
|
|
93 - RANDOM in PostgreSQL.mp4
|
MP4
|
24.3 MB
|
|
|
94 - SETSEED in PostgreSQL.mp4
|
MP4
|
18.2 MB
|
|
|
95 - ROUND in PostgreSQL.mp4
|
MP4
|
13.7 MB
|
|
|
96 - POWER in PostgreSQL.mp4
|
MP4
|
10.8 MB
|
|
|
97 - Mathematical Functions in MS SQL Part 1.mp4
|
MP4
|
63.5 MB
|
|
|
98 - Mathematical Functions in MS SQL Part 2.mp4
|
MP4
|
35.5 MB
|
|
|
99 - CURRENT DATE & TIME in PostgreSQL.mp4
|
MP4
|
28.5 MB
|
|
|
TutsNode.net.txt
|
TXT
|
102.4 B
|
|
|
[TGx]Downloaded from torrentgalaxy.to .txt
|
TXT
|
614.4 B
|
|
|
54
|
|
231 KB
|
|
|
55
|
|
1.4 KB
|
|
|
56
|
|
135.1 KB
|
|
|
57
|
|
345.4 KB
|
|
|
58
|
|
363.4 KB
|
|
|
59
|
|
457.2 KB
|
|
|
60
|
|
591.4 KB
|
|
|
61
|
|
712.4 KB
|
|
|
62
|
|
125.2 KB
|
|
|
63
|
|
465.6 KB
|
|
|
64
|
|
851.7 KB
|
|
|
65
|
|
667.9 KB
|
|
|
66
|
|
495 KB
|
|
|
67
|
|
931.4 KB
|
|
|
68
|
|
938.9 KB
|
|
|
69
|
|
28.7 KB
|
|
|
70
|
|
633.8 KB
|
|
|
71
|
|
737.7 KB
|
|
|
72
|
|
741.3 KB
|
|
|
73
|
|
821.9 KB
|
|
|
74
|
|
227.9 KB
|
|
|
75
|
|
631.7 KB
|
|
|
76
|
|
636.7 KB
|
|
|
77
|
|
712.3 KB
|
|
|
78
|
|
928.7 KB
|
|
|
79
|
|
126.3 KB
|
|
|
80
|
|
884.8 KB
|
|
|
81
|
|
516.3 KB
|
|
|
82
|
|
812.6 KB
|
|
|
83
|
|
823.2 KB
|
|
|
84
|
|
587.8 KB
|
|
|
85
|
|
795.1 KB
|
|
|
86
|
|
209.2 KB
|
|
|
87
|
|
262.6 KB
|
|
|
88
|
|
421.9 KB
|
|
|
89
|
|
459.9 KB
|
|
|
90
|
|
487.2 KB
|
|
|
91
|
|
512.5 KB
|
|
|
92
|
|
519.8 KB
|
|
|
93
|
|
608.1 KB
|
|
|
94
|
|
963.4 KB
|
|
|
95
|
|
314.5 KB
|
|
|
96
|
|
934.6 KB
|
|
|
97
|
|
56.6 KB
|
|
|
98
|
|
297.4 KB
|
|
|
99
|
|
896.8 KB
|
|
|
100
|
|
971.2 KB
|
|
|
101
|
|
275.1 KB
|
|
|
102
|
|
241.1 KB
|
|
|
103
|
|
352.3 KB
|
|
|
104
|
|
37.6 KB
|