RAR-files |
skillshare.job-ready.sql.in.an.afternoon-skilledhares.rar |
300,000,000 |
9BEA0DE2 |
skillshare.job-ready.sql.in.an.afternoon-skilledhares.r00 |
300,000,000 |
990756F5 |
skillshare.job-ready.sql.in.an.afternoon-skilledhares.r01 |
300,000,000 |
62C9B2C5 |
skillshare.job-ready.sql.in.an.afternoon-skilledhares.r02 |
300,000,000 |
D04E4D51 |
skillshare.job-ready.sql.in.an.afternoon-skilledhares.r03 |
300,000,000 |
9274FAD0 |
skillshare.job-ready.sql.in.an.afternoon-skilledhares.r04 |
300,000,000 |
9ED7693C |
skillshare.job-ready.sql.in.an.afternoon-skilledhares.r05 |
300,000,000 |
0A279A6C |
skillshare.job-ready.sql.in.an.afternoon-skilledhares.r06 |
300,000,000 |
0D4D842F |
skillshare.job-ready.sql.in.an.afternoon-skilledhares.r07 |
300,000,000 |
B1C5F29B |
skillshare.job-ready.sql.in.an.afternoon-skilledhares.r08 |
109,174,271 |
FF94FDE4 |
|
Total size: |
2,809,174,271 |
|
|
Archived
files |
01-intro.mkv
[488728d5f5cf2f7e]
|
10,786,265 |
568B17C7 |
02-relational_databases_intro.mkv
[1e908816818d9d6]
|
68,652,445 |
80AFD006 |
03-data_types_and_schemas.mkv
[30e2aebd8afe2ed]
|
82,429,674 |
17EC3454 |
04-mac_setting_up_a_local_pg_server.mkv
[f1ac64a392b46bb]
|
35,158,838 |
893886B7 |
05-windows_local_postgres_server.mkv
[2683db909ea49155]
|
37,164,347 |
A0ED9914 |
06-mac_postico_setup.mkv
[2a2f4e9753276f90]
|
39,940,517 |
9A23F0A5 |
07-datagrip_setup.mkv
[99dd0c6286d3ab8d]
|
38,156,894 |
1A2994A9 |
08-cli_connection.mkv
[eb1566497487a50a]
|
7,102,790 |
06741944 |
09-creating_and_dropping_databases.mkv
[7892ab42d94473ba]
|
43,476,336 |
3A058D11 |
10-creating_schemas.mkv
[999860c2f7da57b9]
|
23,095,378 |
0EB30B6D |
11-creating_tables.mkv
[ec9c1ec749ad4fa4]
|
55,023,061 |
FD0C7E0C |
12-altering_tables.mkv
[9876e154484c601b]
|
15,865,198 |
F7F84B3C |
13-enumerated_types.mkv
[c07cc580ca215c5e]
|
26,058,791 |
02331844 |
14-inserting_values.mkv
[c05c47a94e52573b]
|
45,795,252 |
F33ACAF9 |
15-running_an_sql_script.mkv
[125be09afd0d909d]
|
46,657,003 |
842CC75A |
16-reading_data.mkv
[3e4d03f88753227]
|
47,544,537 |
ADF92738 |
17-creating_tables_from_query_result.mkv
[31375aeedac9fecc]
|
44,049,470 |
8B408A60 |
18-16aliasingandorderinghb.mkv
[d2c14fe2e16b5707]
|
97,315,670 |
F1687040 |
19-conditional_filtering_direct_comparison.mkv
[1e2d6d7e1650e968]
|
45,869,072 |
32EF1ABA |
20-18conditionalfilteringgroupcomparisonhb.mkv
[2f91a2028f0fa471]
|
97,709,264 |
5982B173 |
21-19joiningconditionalshb.mkv
[4289c85359044f9]
|
68,007,674 |
F886DB37 |
22-20negatingconditionalshb.mkv
[a864c85a3a83ef1f]
|
46,133,849 |
DF444B6D |
23-21filteringnullvalueshb.mkv
[f9da316e08cbfcfe]
|
15,062,273 |
D06A5074 |
24-22creatingnewcolumnsandarithmeticshb.mkv
[8cba18d27215d37]
|
62,012,409 |
647A9E67 |
25-23datatypeconverstionshb.mkv
[d56be4f1e8f877be]
|
50,682,034 |
999142F7 |
26-24logicstatementshb.mkv
[18d3378e2fa32a9c]
|
57,189,706 |
10370A3F |
27-25manipulatingstringshb.mkv
[586352134cf0cae4]
|
104,541,795 |
41FB03A6 |
28-26stringpositionalinformationhb.mkv
[bab493523d1e822e]
|
82,758,658 |
FA078FC3 |
29-27stringsubsetsandconcatinationshb.mkv
[70cbca35a815936e]
|
204,815,777 |
0D441D09 |
30-28stringreplacementshb.mkv
[3cf8de664a912602]
|
73,192,184 |
2EDAAA05 |
31-29dateandtimehb.mkv
[6296153eda43ac93]
|
50,622,327 |
05C92513 |
32-30datetimeintervalshb.mkv
[1e8eb21fc3b493be]
|
61,898,771 |
110A376D |
33-31commentshb.mkv
[303990ad78702e6d]
|
47,579,291 |
49104103 |
34-32aggregationfunctionshb.mkv
[3c5787ab501a2cfc]
|
60,455,439 |
CA4124E6 |
35-33groupingandfilteringaggregationshb.mkv
[207e317fcb974561]
|
103,078,860 |
1D9ED64C |
36-34joinshb.mkv
[854b63dce8ad0080]
|
178,754,163 |
E68314FD |
37-35leftrightfulljoinshb.mkv
[d99b3bbcc22aa7fe]
|
134,629,827 |
F91DED6E |
38-36selfjoinshb.mkv
[97cf0f98b86dd8fa]
|
63,942,391 |
9F26AC98 |
39-37unionshb.mkv
[57e85bb567657661]
|
39,047,406 |
C2AAF3EC |
40-subqueries.mkv
[679bfef2b6fc265]
|
59,859,051 |
54CEDCC7 |
41-39windowfunctionsandaliaseshb.mkv
[9b616e55071d0d91]
|
132,766,722 |
63A037B7 |
42-40rownumbersandrankshb.mkv
[3e6775b886b27502]
|
41,747,630 |
485D5D08 |
43-41usingotherrowswithwindowfunctionshb.mkv
[9700baeec1b62ab3]
|
106,948,672 |
D2E211C6 |
44-42ntileshb.mkv
[149823ff19511af1]
|
31,960,529 |
08E42455 |
45-43understandingqueryperformancehb.mkv
[3e9adb917a4bb725]
|
23,632,072 |
E5A0E1FD |
|
Total size: |
2,809,170,312 |
|
|