RAR-files |
ilearn-smsfda.rar |
50,000,000 |
657117C3 |
ilearn-smsfda.r00 |
50,000,000 |
39B74E8D |
ilearn-smsfda.r01 |
50,000,000 |
C19C5D56 |
ilearn-smsfda.r02 |
50,000,000 |
B4F5FEF8 |
ilearn-smsfda.r03 |
50,000,000 |
EF9508EF |
ilearn-smsfda.r04 |
50,000,000 |
75379429 |
ilearn-smsfda.r05 |
50,000,000 |
6D0DF59D |
ilearn-smsfda.r06 |
50,000,000 |
3D6BE636 |
ilearn-smsfda.r07 |
50,000,000 |
08A46B0A |
ilearn-smsfda.r08 |
50,000,000 |
193E8066 |
ilearn-smsfda.r09 |
50,000,000 |
E812D0B2 |
ilearn-smsfda.r10 |
50,000,000 |
C98A734E |
ilearn-smsfda.r11 |
50,000,000 |
081A2957 |
ilearn-smsfda.r12 |
50,000,000 |
5A4DDC65 |
ilearn-smsfda.r13 |
50,000,000 |
0F9C34DB |
ilearn-smsfda.r14 |
50,000,000 |
882C1D0A |
ilearn-smsfda.r15 |
50,000,000 |
26AE7300 |
ilearn-smsfda.r16 |
50,000,000 |
4DE3FEFF |
ilearn-smsfda.r17 |
50,000,000 |
6DA35FDE |
ilearn-smsfda.r18 |
50,000,000 |
28A330FE |
ilearn-smsfda.r19 |
50,000,000 |
8B4FB4E3 |
ilearn-smsfda.r20 |
50,000,000 |
4B2F97CE |
ilearn-smsfda.r21 |
50,000,000 |
F6615DF0 |
ilearn-smsfda.r22 |
50,000,000 |
45023662 |
ilearn-smsfda.r23 |
50,000,000 |
0207BDCF |
ilearn-smsfda.r24 |
50,000,000 |
0EA2E575 |
ilearn-smsfda.r25 |
50,000,000 |
D831066B |
ilearn-smsfda.r26 |
50,000,000 |
C6066910 |
ilearn-smsfda.r27 |
50,000,000 |
F1034769 |
ilearn-smsfda.r28 |
50,000,000 |
30D86323 |
ilearn-smsfda.r29 |
50,000,000 |
1A3A7583 |
ilearn-smsfda.r30 |
50,000,000 |
D4CF834B |
ilearn-smsfda.r31 |
50,000,000 |
F45372AA |
ilearn-smsfda.r32 |
50,000,000 |
24898CEB |
ilearn-smsfda.r33 |
50,000,000 |
ACC76459 |
ilearn-smsfda.r34 |
50,000,000 |
79ED7955 |
ilearn-smsfda.r35 |
50,000,000 |
4F744FDB |
ilearn-smsfda.r36 |
50,000,000 |
F88C4E72 |
ilearn-smsfda.r37 |
50,000,000 |
E465FE0E |
ilearn-smsfda.r38 |
50,000,000 |
54AEE6AE |
ilearn-smsfda.r39 |
50,000,000 |
9A10FBFC |
ilearn-smsfda.r40 |
50,000,000 |
2F381665 |
ilearn-smsfda.r41 |
50,000,000 |
DECDEB73 |
ilearn-smsfda.r42 |
50,000,000 |
CE60DB62 |
ilearn-smsfda.r43 |
50,000,000 |
FCB713F6 |
ilearn-smsfda.r44 |
50,000,000 |
92F05A32 |
ilearn-smsfda.r45 |
50,000,000 |
751CBD3C |
ilearn-smsfda.r46 |
50,000,000 |
05D3D2B3 |
ilearn-smsfda.r47 |
50,000,000 |
9148FDF0 |
ilearn-smsfda.r48 |
50,000,000 |
3EBB0438 |
ilearn-smsfda.r49 |
50,000,000 |
05264973 |
ilearn-smsfda.r50 |
50,000,000 |
589D4A07 |
ilearn-smsfda.r51 |
50,000,000 |
8470ADFB |
ilearn-smsfda.r52 |
50,000,000 |
98E85035 |
ilearn-smsfda.r53 |
50,000,000 |
A5B4EA88 |
ilearn-smsfda.r54 |
50,000,000 |
3025859A |
ilearn-smsfda.r55 |
50,000,000 |
DDA35890 |
ilearn-smsfda.r56 |
50,000,000 |
0CA58023 |
ilearn-smsfda.r57 |
50,000,000 |
FB2ABFE7 |
ilearn-smsfda.r58 |
50,000,000 |
857D6003 |
ilearn-smsfda.r59 |
50,000,000 |
6A856395 |
ilearn-smsfda.r60 |
50,000,000 |
A0826620 |
ilearn-smsfda.r61 |
50,000,000 |
2E8F7179 |
ilearn-smsfda.r62 |
41,259,511 |
BBF2220E |
|
Total size: |
3,191,259,511 |
|
|
Archived
files |
9. Exercise 1 Create DB and Table.mp4
[c20afdc4be5606b3]
|
6,153,469 |
CEA3FB00 |
11. INSERT.mp4
[c0f40551482ebd45]
|
59,102,366 |
87DD63B8 |
12. Import data from File.mp4
[b871b3e80fb379f2]
|
34,217,629 |
7E8A0CF2 |
13. Exercise 2 Inserting and Importing.mp4
[c22e5352b193eaa0]
|
4,810,048 |
94EF666B |
14. SELECT statement.mp4
[d1272cacbdac6261]
|
28,403,429 |
4C79B261 |
15. SELECT DISTINCT.mp4
[f54da0630dcf4d68]
|
45,321,731 |
F4E6CED5 |
16. WHERE.mp4
[e88b862c64bab40a]
|
29,013,458 |
79A1BBF6 |
17. Logical Operators.mp4
[b2a6763a0b7dc5a3]
|
43,872,640 |
B495478E |
18. Exercise 3 SELECT & WHERE.mp4
[535a31aace098872]
|
7,525,259 |
C7B1BE6B |
19. UPDATE.mp4
[104e1e3a471b5d04]
|
39,501,223 |
8984C014 |
20. DELETE.mp4
[dd3c260baeb0cd3]
|
30,654,109 |
DBA7B3FD |
21. ALTER.mp4
[800c738ba2117dd7]
|
131,856,735 |
F92B55DA |
22. Exercise 4 Updating Table.mp4
[958dca8c31f1d875]
|
4,121,483 |
74670EF2 |
23. Restore and Back-up.mp4
[6c7b36c14e946094]
|
75,602,415 |
73E63695 |
24. Debugging restoration issues.mp4
[961e73a6cac77977]
|
52,617,006 |
E7EE4DE0 |
25. Creating DB using CSV files.mp4
[2b70fce496952a21]
|
37,193,589 |
FD4E6DAF |
27. Exercise 5 Restore and Back-up.mp4
[4f22bf56ea73c0e9]
|
3,142,918 |
D7D75809 |
28. IN.mp4
[9b480951db004de]
|
30,833,686 |
F68EB334 |
29. BETWEEN.mp4
[71dabf3019259b33]
|
52,149,356 |
5DCE7AA0 |
30. LIKE.mp4
[91cd239491f2bcdb]
|
64,134,907 |
DF83F0B0 |
31. Exercise 6 In, Like & Between.mp4
[593a93124c299b5d]
|
5,507,879 |
29ECA637 |
32. Side Lecture Commenting in SQL.mp4
[e07ff6baca25f0b0]
|
12,900,044 |
5AA2B219 |
33. ORDER BY.mp4
[fcbb9223889610f7]
|
74,837,260 |
E50296A4 |
34. LIMIT.mp4
[efcb958ae9288a29]
|
31,043,896 |
194C94B8 |
35. Exercise 7 Sorting.mp4
[89e40051aea1be48]
|
3,320,232 |
B482E959 |
36. AS.mp4
[5e1f55845b714e5c]
|
26,809,395 |
D6296150 |
37. COUNT.mp4
[80533d87c823073c]
|
40,211,423 |
F3982CC3 |
38. SUM.mp4
[7a75e88230c0af38]
|
22,083,593 |
AA36952F |
39. AVERAGE.mp4
[2b18c21797573eb6]
|
18,364,168 |
25614554 |
40. MIN & MAX.mp4
[8e8c5e3cc0390862]
|
34,050,250 |
F8F197FC |
41. Exercise 8 Aggregate functions.mp4
[9510bbb4ca5b960c]
|
6,741,793 |
FA2D9FA8 |
42. GROUP BY.mp4
[5ed843a675f1f195]
|
97,861,489 |
BFC93DCD |
43. HAVING.mp4
[dab3cf132276412b]
|
39,739,602 |
470F81CA |
44. Exercise 9 Group By.mp4
[ae2e062424dd91dc]
|
6,470,988 |
649EA144 |
45. CASE WHEN.mp4
[bc5e911fb69128a7]
|
29,906,170 |
75E7834C |
46. Introduction to Joins.mp4
[440a8147e7bb90ec]
|
8,313,984 |
C8C32BE3 |
47. Concepts of Joining and Combining Data.mp4
[32d8140214fc0b2d]
|
62,683,262 |
DA9C9494 |
48. Preparing the data.mp4
[36a7ae88bdfedd91]
|
14,520,618 |
82C4BF39 |
49. Inner Join.mp4
[f800d0f7b5becb9b]
|
49,440,812 |
65DB952F |
50. Left Join.mp4
[7ce5aa478858a31c]
|
38,581,354 |
2273654F |
51. Right Join.mp4
[b95d61d0168e2c36]
|
37,751,182 |
CD508652 |
52. Full Outer Join.mp4
[2a526e83ce8ad17e]
|
33,621,775 |
A46D3ED9 |
53. Cross Join.mp4
[562ea98c0eedba9d]
|
19,671,042 |
4073D6FB |
54. Intersect and Intersect ALL.mp4
[ef7329e4c33704]
|
25,930,489 |
A94A741E |
55. Except.mp4
[712252754fbd5e1c]
|
13,276,343 |
EE7448BE |
56. Union.mp4
[e2985c28505f9fc1]
|
15,852,922 |
D01E2EB4 |
57. Exercise 10 Joins.mp4
[523cc279a4a0e4fa]
|
7,234,007 |
D692FAC2 |
58. Subqueries.mp4
[b936d782a7d5eccf]
|
108,893,473 |
190C2A28 |
59. Exercise 11 Subqueries.mp4
[bad70f282e2d908b]
|
5,350,144 |
7B9DBAF0 |
60. VIEWS.mp4
[384708ecea7e1b0c]
|
44,574,888 |
39A2EEFC |
61. INDEX.mp4
[4022f06b9dcc9992]
|
42,300,832 |
0A307D3A |
62. Exercise 12 Views.mp4
[2315eedc90ae49d7]
|
3,350,316 |
370C18B3 |
63. LENGTH.mp4
[b37aad23c960ccc8]
|
19,468,477 |
914697ED |
64. UPPER LOWER.mp4
[f3ba53f7985ceafb]
|
12,204,958 |
46510010 |
65. REPLACE.mp4
[d9f73c3ae44f58a2]
|
26,474,277 |
5CB03C24 |
66. TRIM, LTRIM, RTRIM.mp4
[c06d7c956ee01581]
|
52,400,181 |
BC7E3DA3 |
67. CONCATENATION.mp4
[ad6d3ca70fedd14c]
|
17,733,267 |
45ED0826 |
68. SUBSTRING.mp4
[cd85b90207512d04]
|
44,346,746 |
5EE49CEF |
69. LIST AGGREGATION.mp4
[7c318b9c16045de5]
|
34,684,154 |
73CF5C00 |
70. Exercise 13 String Functions.mp4
[6ec1d6efdffeb524]
|
17,259,433 |
1FE04599 |
71. CEIL & FLOOR.mp4
[7ec04063493c1465]
|
21,968,106 |
15EE58FB |
72. RANDOM.mp4
[474bc0e4151be98d]
|
32,925,839 |
71ED6528 |
73. SETSEED.mp4
[193fe4e18b1c5177]
|
26,004,469 |
2849032F |
74. ROUND.mp4
[98e7f81c4c34ecb4]
|
17,561,892 |
3297706E |
75. POWER.mp4
[178a40a5fc7c76ad]
|
12,712,089 |
2519AF1A |
76. Exercise 14 Mathematical Functions.mp4
[871a7b9a6a8ff077]
|
10,835,190 |
0C07D796 |
77. CURRENT DATE & TIME.mp4
[4d7d8647fac777b4]
|
33,883,774 |
10600322 |
78. AGE.mp4
[7c44e25b0b6c783e]
|
27,932,325 |
83553DAA |
79. EXTRACT.mp4
[ba1a52d42f30b816]
|
61,489,830 |
6186841E |
80. Exercise 15 Date-time functions.mp4
[302da6bcebc66d03]
|
5,978,567 |
B6C43D3B |
81. PATTERN MATCHING BASICS.mp4
[2c885680aeda4a53]
|
42,922,335 |
33EC5088 |
82. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).mp4
[b947c7c74cd09da2]
|
108,055,811 |
2201C9F2 |
83. Exercise 16 Pattern Matching.mp4
[a4eb837a1c66d8aa]
|
8,709,372 |
1A10346B |
84. Converting Numbers Date to String.mp4
[ec9c654106963545]
|
76,738,904 |
0EBDFA56 |
85. Converting String to Numbers Date.mp4
[ffc34daeebc69d1]
|
40,936,888 |
77DFAE8E |
86. User Access Control.mp4
[e1343430a6b44524]
|
84,376,647 |
C5008B3F |
87. Tablespace.mp4
[6b6ddd4d127d4316]
|
38,034,228 |
AE4CE200 |
88. PRIMARY KEY & FOREIGN KEY.mp4
[2f7f696c85b772cf]
|
26,643,579 |
C4F1664B |
89. ACID compliance.mp4
[164a3be6c93a4387]
|
44,747,036 |
A0AE7422 |
90. Truncate.mp4
[3f010cefd3dcba5b]
|
22,107,474 |
AEE50CDD |
91. TIP 1 (EXPLAIN).mp4
[50737502f14998b1]
|
26,724,104 |
CD67FCF6 |
92. TIP 2.mp4
[7c33f186d8f5cd3c]
|
6,083,090 |
98ACEDDB |
93. TIP 3.mp4
[365645b098f32a77]
|
14,954,668 |
A682AF3C |
94. TIP 4 (VACCUM).mp4
[9aea636ff33fa320]
|
3,001,900 |
E597BEC5 |
95. TIP 5.mp4
[fc9c436dab6ea040]
|
12,015,703 |
438CF2D5 |
96. TIP 6 (STRING FUNCTIONS).mp4
[66b25ef2a74146a4]
|
14,354,970 |
02D500D1 |
97. TIP 7 (JOINS).mp4
[1e1d24277242a462]
|
11,320,256 |
2A6625A9 |
98. TIP 8 (SCHEMAS).mp4
[6fc8ea6ba1ee1a8e]
|
33,512,240 |
751034BB |
99. What is SQL.mp4
[19085f57970e45aa]
|
9,083,681 |
25EA5A95 |
100. Tables and DBMS.mp4
[af5ae8169c62de12]
|
15,389,890 |
6A6DDC71 |
101. Types of SQL commands.mp4
[6f298c46b0ec55eb]
|
23,132,903 |
A7299052 |
102. PostgreSQL.mp4
[5001d495a45ac637]
|
14,782,862 |
8FAF24E4 |
103. The final milestone!.mp4
[9a05435fc6f57336]
|
12,420,478 |
ACC1E76C |
1. Course Overview.mp4
[7cce5d3322029852]
|
30,749,058 |
22E79E38 |
2. Installing and setting up PostgreSQL.mp4
[1110e569b2cd8e5a]
|
61,495,933 |
71C874CC |
3. This is a milestone!.mp4
[f3e0e4bf5bd0019d]
|
21,665,333 |
C8B8D3FA |
6. Case Study Part 1.mp4
[5425c7677d533db6]
|
29,339,546 |
7B04B334 |
7. Case Study Part 2.mp4
[a64f1af1a36cfdd4]
|
53,733,795 |
32EADCA3 |
8. CREATE.mp4
[68c9e6bc55ecef36]
|
66,927,778 |
A00A1570 |
|
Total size: |
3,191,247,117 |
|
|