| Archived
files |
|
01-sql_promo_skillshare.mkv
[89e8bb60868f4567]
|
5,540,442 |
C385CB08 |
|
02-instructor_introduction.mkv
[4f4c9ffbfac3f649]
|
1,322,163 |
E62D3EF5 |
|
03-course_requirement.mkv
[d14a8d2dadd49ba2]
|
4,883,015 |
5B515293 |
|
04-course_structure.mkv
[c87988eb1611474f]
|
8,144,379 |
63B7F9E4 |
|
05-application_downloads_and_installation.mkv
[84b37cf7d0193b31]
|
1,600,450 |
64E83ACF |
|
06-install_sql_server_on_windows.mkv
[24c02111cd731509]
|
47,253,965 |
96B5462A |
|
07-install_sql_server_on_macbook.mkv
[f6e8fa6d9a38b143]
|
214,440,970 |
2AD4407F |
|
08-review_sql_server_environment.mkv
[a29596776d41f1c9]
|
50,819,964 |
AED6BC92 |
|
09-section_2-data_databases_and_database_management_system.mkv
[13f3f7e9a8d37d35]
|
1,827,264 |
DAF661BA |
|
100-greater_than_or_equal.mkv
[f6f0a76ed958e7df]
|
28,156,570 |
BB7A239E |
|
101-less_than_or_equal.mkv
[621f7844beceede2]
|
20,916,749 |
D94FB7C4 |
|
102-section_14-logical_operator.mkv
[37448c776f959ba2]
|
516,207 |
24AF1A20 |
|
103-and_operator.mkv
[b86fb258698b62b2]
|
77,974,036 |
7F58F26E |
|
104-or_operator.mkv
[1b7cfe4ea9d1ae8a]
|
52,949,625 |
474259C7 |
|
105-between_operator.mkv
[d050cfc54c48ef8f]
|
38,681,865 |
80E8A6F6 |
|
106-like_and_not_like_operator.mkv
[8ab95517f302f408]
|
22,744,323 |
54278D4F |
|
107-case_statement.mkv
[2292c61ca640aac8]
|
136,837,868 |
58CAA6CD |
|
108-section_15-data_relationship.mkv
[511905bab8451769]
|
883,604 |
B2614977 |
|
109-understanding_data_relationship.mkv
[f7444ce52e6edadb]
|
33,921,089 |
7EB829BE |
|
10-understanding_data.mkv
[ea96998d2e8079a4]
|
4,253,019 |
75184834 |
|
110-one_to_one_relationship.mkv
[c9f90448f0dfd8a1]
|
17,368,161 |
4FAB6FC0 |
|
111-one_to_many_relationship.mkv
[54f17ebfaeb5c656]
|
29,217,531 |
097CDF3D |
|
112-many_to_many_relationship.mkv
[af3ad35bcf7c11dd]
|
10,607,859 |
12BDDC7C |
|
113-data_normalization.mkv
[10d41ffca56b51c9]
|
40,566,816 |
749B78B9 |
|
114-section_16-one_to_many.mkv
[7a4b34b85dd3fedc]
|
883,604 |
13EF21D5 |
|
115-create_one_to_many_relationship.mkv
[45797bde4a92bd5d]
|
7,983,200 |
ECC3B142 |
|
116-foreign_key_constraint.mkv
[a6d77cf51f879a9e]
|
11,571,379 |
46368F50 |
|
117-create_one_to_many_schema.mkv
[4f15df393823a4c]
|
81,635,832 |
31E8BE61 |
|
118-introduction_to_join.mkv
[e6b52499a8fde224]
|
17,461,416 |
7DEA181F |
|
119-inner_join.mkv
[2616ca12b3c070c4]
|
168,849,305 |
E510A068 |
|
11-database.mkv
[e9deffffb273aa58]
|
10,523,957 |
1BFC5B8B |
|
120-left_join.mkv
[93db62cdd1fe97e2]
|
70,134,122 |
E236DEBB |
|
121-right_join.mkv
[b8c51dd8ffceda66]
|
62,633,950 |
272ED369 |
|
122-full_join.mkv
[9859c2172bf1e97]
|
46,375,167 |
94F428C2 |
|
123-section_17-many_to_many.mkv
[e9b6709e144fa5c1]
|
883,604 |
EAF0603B |
|
124-create_many_to_many_relationship.mkv
[bff88b1751cd71d6]
|
11,409,074 |
5FF9B7A0 |
|
125-create_schema_many_to_many.mkv
[ce7519d2d793f9e9]
|
177,066,759 |
CECCE018 |
|
126-insert_records_into_schema.mkv
[40f23fb944f87af7]
|
21,997,798 |
6188F550 |
|
127-task_1.mkv
[da67010f2fbeaf0b]
|
50,747,744 |
FDEC0E9A |
|
128-task_2.mkv
[14c418c0ae854f5b]
|
42,762,921 |
30F4C572 |
|
129-task_3.mkv
[6162518cc0b830a7]
|
31,700,563 |
8E223CBA |
|
12-introduction_to_database_management_system.mkv
[ad3c02d3312f655d]
|
3,205,627 |
6C9429C4 |
|
130-task_4.mkv
[3f961261ef07056]
|
67,759,975 |
1E2B49E6 |
|
131-task_5.mkv
[a8792758cdbb5d96]
|
23,049,678 |
B5D7AF32 |
|
132-task_6.mkv
[8d96e7fbae4e0910]
|
32,377,576 |
63F169FC |
|
133-task_7.mkv
[b76029cf50e98be]
|
37,309,650 |
1D69A99E |
|
134-task_8.mkv
[28152f3d96d7689c]
|
20,078,305 |
2B0168F8 |
|
135-task_9.mkv
[6510e3ef9daf57eb]
|
156,587,360 |
1AAF7FB2 |
|
136-task_10.mkv
[ccf752d7ede05f23]
|
47,063,362 |
8D3C82AF |
|
137-section_18-conclusion.mkv
[4f7be01d61bf385a]
|
30,209,365 |
6B3C7A6A |
|
13-relational_database_management_systems.mkv
[aaf3f1bb0be6d1dd]
|
27,859,959 |
3EEC9D88 |
|
14-how_to_create_a_database.mkv
[a1eff162a1a352eb]
|
21,020,999 |
55E97827 |
|
15-save_queries_in_sql_server.mkv
[68490dcf0c554f0f]
|
18,632,177 |
64CAECF9 |
|
16-selecting_a_database.mkv
[cbcf5133fef20dbf]
|
17,953,967 |
50FC59A6 |
|
17-delete_database.mkv
[438ead3afb0b45e3]
|
13,437,425 |
8D48E33A |
|
18-section_3-introduction_to_sql_(structured_query_language).mkv
[612b10a68ea721df]
|
883,604 |
DA1A4527 |
|
19-what_is_sql.mkv
[a639757c4bc1a63b]
|
6,373,951 |
B4D40D96 |
|
20-sql_dialects.mkv
[c9e67ac25b24141d]
|
24,567,882 |
A9F421B0 |
|
21-sql_naming_convention.mkv
[48166195ef833cce]
|
6,810,029 |
2D15F9A0 |
|
22-section_4-data_types.mkv
[df6fb021863cd8fe]
|
875,642 |
13F0A765 |
|
23-sql_data_types.mkv
[454c5dfce829e306]
|
3,856,897 |
7D0BDD83 |
|
24-numeric_data_type.mkv
[329ce86bad1343ca]
|
8,277,675 |
C87BC6D0 |
|
25-string_data_type.mkv
[ab8ededa09b9e732]
|
13,045,297 |
B5228EDF |
|
26-importance_of_data_types.mkv
[bd463e78378a53e5]
|
11,442,207 |
FD0BF48E |
|
27-section_5-tables.mkv
[f88c7c0d28838877]
|
875,642 |
88A65CE2 |
|
28-introduction_to_tables.mkv
[bfa3cd0d2ddad695]
|
7,451,251 |
698ED1E0 |
|
29-create_tables.mkv
[cde749b59cabaa9e]
|
47,840,162 |
84338B22 |
|
30-insert_records_into_tables.mkv
[b17e8cdf122f72ee]
|
82,469,864 |
AF5A57F8 |
|
31-retrieve_records_from_tables.mkv
[dc4adb1b0f7ed5a7]
|
14,344,095 |
BDE83BD1 |
|
32-delete_records_from_tables.mkv
[156a472a22e5c0b]
|
10,101,438 |
85ADFA1B |
|
33-section_introduction.mkv
[6dc7a0cda9c70254]
|
1,279,511 |
0BD745B5 |
|
34-section_6-data_definition_language.mkv
[3c371ef5b7fd85e2]
|
1,279,511 |
D58710E6 |
|
35-create_drop_alter_commands.mkv
[d79749c0e004a7db]
|
65,689,607 |
752DEFBE |
|
36-adding_comments.mkv
[e955d3dcc72369d3]
|
19,828,294 |
8F926288 |
|
37-null_and_not_null-sql_constraints.mkv
[b33edcd0530df26]
|
86,818,870 |
2007FEB8 |
|
38-default_constraint.mkv
[7e97a242fd05f693]
|
35,833,456 |
23CB9DE4 |
|
39-unique_constraint.mkv
[60060a87008d6dd7]
|
40,435,966 |
857DBDED |
|
40-primary_key_constraint.mkv
[810a3e83253e3831]
|
46,067,888 |
48BE9B6A |
|
41-use_identity_to_auto_generate_ids.mkv
[dcbecc9cb9faa58e]
|
29,415,587 |
A98E2E90 |
|
42-section_7-data_query_language.mkv
[642832cb27ff8dd0]
|
1,279,511 |
4EE35C2F |
|
43-select_statement.mkv
[d5837ed4268ec40f]
|
48,643,210 |
BCA6D838 |
|
44-where_clause.mkv
[6f216f6e35bb9dcd]
|
39,621,215 |
D1B355C0 |
|
45-section_8-data_manipulation_language.mkv
[24f85e3e2b0e9c1b]
|
875,642 |
17089185 |
|
46-update_command.mkv
[39e5c7e42256c9ff]
|
67,124,372 |
798E6059 |
|
47-delete_command.mkv
[21e403ab03bc3442]
|
61,462,637 |
852DAB99 |
|
48-adding_aliases.mkv
[9eddaa27ac689178]
|
35,083,706 |
46EB2D38 |
|
49-decimal_data_type.mkv
[8fe3465020684867]
|
67,440,028 |
33EA5E50 |
|
50-section_9-string_function.mkv
[576f3007d034fe89]
|
1,072,024 |
A452A909 |
|
51-string_functions.mkv
[59753537afe4090e]
|
30,930,829 |
DA554AF9 |
|
52-concat_function.mkv
[1c5f619eb7ed33ce]
|
116,692,286 |
93145A3C |
|
53-concat_ws.mkv
[efbe25a751354022]
|
35,198,021 |
35A10F61 |
|
54-left_function.mkv
[164df0eff52c323d]
|
70,224,572 |
19E6BC32 |
|
55-right_function.mkv
[30734fff7f568ea5]
|
46,965,470 |
CB25BFE5 |
|
56-len_function.mkv
[47b5ef91944b4dd2]
|
46,474,358 |
3FA93085 |
|
57-upper_function.mkv
[2563ebdde1dd9d06]
|
32,903,813 |
E38930CB |
|
58-lower_function.mkv
[22a8bb484860c0d7]
|
28,432,769 |
A5765F1D |
|
59-ltrim_rtrim_trim_function.mkv
[ce454434b36900c9]
|
78,490,262 |
CBC85562 |
|
60-reverse_function.mkv
[8de30b1ea2105e88]
|
31,054,909 |
B68FE018 |
|
61-replace_function.mkv
[ca37520069c7f3bd]
|
38,613,222 |
B1800F6B |
|
62-substring_function.mkv
[5051857f4362d071]
|
41,220,171 |
0ECC22A3 |
|
63-section_10-sorting_records.mkv
[86e420ed5f0d12c3]
|
972,473 |
2536EE8E |
|
64-characters_with_single_quote.mkv
[c2f4776c566bd9f4]
|
37,159,477 |
74DEB663 |
|
65-order_by.mkv
[5fa6cc5950f102a2]
|
153,389,694 |
CB5998C6 |
|
66-distinct_statement.mkv
[fc7a089efbf71136]
|
75,373,326 |
4702EB1C |
|
67-top_clause.mkv
[12d4cd38019a7e6c]
|
50,461,580 |
E4A5F4A7 |
|
68-offset_and_fetch_argument.mkv
[8ad2bee2047136b]
|
80,881,510 |
EFCE5C05 |
|
69-_wildcard.mkv
[7f4ee358a7ab9df9]
|
70,865,958 |
F362B13B |
|
70-underscore_wildcard.mkv
[ad72fc06c6136a67]
|
53,341,537 |
0A738F62 |
|
71-section_11-aggregate_function.mkv
[56a33f6da5765e49]
|
972,473 |
7A9E527E |
|
72-aggregate_functions.mkv
[b04ef3bd013e4413]
|
5,374,380 |
5D23F1A9 |
|
73-count_function.mkv
[70ea6d4f0544875d]
|
81,431,157 |
EEABE9D7 |
|
74-group_by_function.mkv
[ddb0863cca9ed713]
|
74,865,193 |
B6012410 |
|
75-average_function.mkv
[6a0c74d1105971dd]
|
30,471,403 |
4DBD773D |
|
76-sum_function.mkv
[a3f3cd7750ce9431]
|
26,010,430 |
E3023441 |
|
77-max_function.mkv
[cb30d4b104b2f6d7]
|
47,456,960 |
FE980C7A |
|
78-min_function.mkv
[914a1472d61c2f0b]
|
34,825,054 |
5EFF1981 |
|
79-having_clause.mkv
[32eec3cd5f4c9061]
|
71,087,015 |
792C3212 |
|
80-in_operator.mkv
[ad9b8c48687f4dc3]
|
62,260,914 |
587222B4 |
|
81-sub_queries.mkv
[e1545efca2f8738b]
|
65,964,068 |
727FD66B |
|
82-section_12-date_and_time_data_type.mkv
[7763c6aa438b9235]
|
883,604 |
16B0D6DD |
|
83-date_and_time.mkv
[c64f63e397aa9bcc]
|
63,739,555 |
286E7FEB |
|
84-extract_part_of_date_values.mkv
[6636bbb64cc479f1]
|
26,054,514 |
62E546A0 |
|
85-getdate_function.mkv
[cb9c0f15e5dfacec]
|
75,938,492 |
4CC18402 |
|
86-current_timestamp.mkv
[d6eda2e0b9ad79ff]
|
14,286,316 |
DC331913 |
|
87-datepart_function.mkv
[af557a51354c386f]
|
47,903,537 |
85F41BB0 |
|
88-datediff_function.mkv
[689b729d56174374]
|
46,743,236 |
337FD27C |
|
89-dateadd_function.mkv
[7096c3ed60f9273c]
|
21,774,572 |
2D5A5D21 |
|
90-date_format.mkv
[72fb9fc8194df691]
|
109,007,225 |
C697DB2B |
|
91-time_format.mkv
[6de2363a39a9f50d]
|
16,974,898 |
C2958B1E |
|
92-10.mkv
[99347e2069acd39c]
|
57,781,463 |
51E6D140 |
|
93-11.mkv
[695ca813ca83b575]
|
128,366,260 |
38916F37 |
|
94-section_13-comparison_operator.mkv
[bc4a5e5518bb685b]
|
1,072,024 |
2FA39155 |
|
95-comparison_operators_in_sql.mkv
[2519e74fdd7a2875]
|
98,147,189 |
E6D4229B |
|
96-equal_operator.mkv
[6a6129ea6f4687f2]
|
43,605,122 |
C4B21D3E |
|
97-not_equal_operator.mkv
[46791592f614c23c]
|
36,175,421 |
F0EB2A0E |
|
98-greater_than_operator.mkv
[a29fa132a9d9ba42]
|
27,053,830 |
264C8940 |
|
99-less_than_operator.mkv
[94c52a76fce77f2d]
|
28,146,458 |
6720E265 |
|
| Total size: |
5,535,079,425 |
|
|
