Archived
files |
01-course_introduction.mkv
[14e79e1cedd6ffbb]
|
18,266,830 |
593DD0D7 |
02-how_to_install_ssms-sql_server_management_studio.mkv
[56fb8f54543a1168]
|
245,303,216 |
43A6505F |
03-connect_with_sql_server_using_ssms.mkv
[66f22389c1a19d46]
|
104,913,469 |
C9FDDCE6 |
04-database_concepts.mkv
[db338aa133198d35]
|
105,851,746 |
9FFD56BE |
05-tables__creation_and_working_with_that.mkv
[107261783b9284a2]
|
115,804,891 |
8434D108 |
06-default_constraint.mkv
[8aea5b36bf1cab84]
|
82,976,903 |
13648DEB |
07-cascading_referenctial_integrity.mkv
[b239c1afcaab9d73]
|
121,920,697 |
2DA819A0 |
08-check_constraint.mkv
[a9f5c3be8839b986]
|
36,942,076 |
74C49264 |
09-identity_column.mkv
[d91cbc915c396c75]
|
89,460,543 |
EA9E5C60 |
100-select_into_in_sql_server.mkv
[55454bbffaf8f5e1]
|
24,974,174 |
9597D64E |
101-difference_between_where_and_having_in_sql_server.mkv
[6692c88efea8308]
|
9,880,361 |
E810E368 |
102-table_valued_parameters_in_sql_server.mkv
[ad98858454ecffa4]
|
19,258,446 |
23900C1C |
103-send_datatable_as_parameter_to_stored_procedure.mkv
[88ff3e47ab9ff4a]
|
3,602,740 |
9612613B |
104-grouping_sets_in_sql_server.mkv
[5fd20f3d5b58d35f]
|
10,344,374 |
AF3C315E |
105-rollup_in_sql_server.mkv
[1b76d6848eaa4e9d]
|
8,124,366 |
74F90385 |
106-cube_in_sql_server.mkv
[e95b6ebb78b5d43d]
|
3,496,735 |
EBD553B2 |
107-difference_between_cube_and_rollup_in_sql_server.mkv
[9cd35a12d51ac0b3]
|
5,890,360 |
BA1FBF31 |
108-grouping_function_in_sql_server.mkv
[852ca4393bd19529]
|
17,408,460 |
581379BF |
109-grouping_id_function_in_sql_server.mkv
[7353ae6eafcacba4]
|
14,276,895 |
E23667B2 |
10-retrieve_identity_column_value.mkv
[1028cb43873d3ef5]
|
101,700,087 |
DD49E3D9 |
110-debugging_sql_server_stored_procedures.mkv
[ca15e14246b864db]
|
12,935,333 |
9899F1A6 |
111-over_clause_in_sql_server.mkv
[ea63166afacf05ae]
|
5,530,532 |
6EE8B93D |
112-row_number_function_in_sql_server.mkv
[8b267975ef641fae]
|
11,390,026 |
02108852 |
113-rank_and_dense_rank_in_sql_server.mkv
[4ad9cd4419f7fb73]
|
12,651,373 |
F5F047D5 |
114-difference_between_rank_dense_rank_and_row_number_in_sql.mkv
[f92f0ba393a8d6c1]
|
11,377,235 |
4F54DF5F |
115-calculate_running_total_in_sql_server.mkv
[62b6beaa7addb3ca]
|
6,729,588 |
D2FABFA8 |
116-ntile_function_in_sql_server.mkv
[36f942621eef065d]
|
13,976,873 |
22F9021A |
117-lead_and_lag_functions_in_sql_server.mkv
[81b34e65174b1e48]
|
10,496,102 |
9F8CD507 |
118-first_value_function_in_sql_server.mkv
[e9e3e69c6c0ffb07]
|
9,006,966 |
8B8085BC |
119-window_functions_in_sql_server.mkv
[c670d0773ed061ea]
|
13,948,399 |
A2F878ED |
11-unique_key_constraint.mkv
[131f0c4aa4f84d28]
|
72,111,473 |
F362CB09 |
120-difference_between_rows_and_range.mkv
[3c4432d6f48795c8]
|
11,366,981 |
E35DDFD7 |
121-iif_function_in_sql_server.mkv
[357fae8eab40bf5b]
|
5,161,661 |
187D175A |
122-try_parse_function_in_sql_server.mkv
[6374646ab7b7c79]
|
5,505,305 |
41FDAA7E |
123-try_convert_function_in_sql_server.mkv
[7398f4e0e3720b79]
|
6,643,520 |
CC18DD5A |
124-eomonth_function_in_sql_server.mkv
[4a6d364c2829ff6c]
|
6,848,367 |
97554B05 |
125-datefromparts_function.mkv
[f29748fcec26dc47]
|
7,175,242 |
488DE866 |
126-difference_between_datetime_and_smalldatetime_in_sql_server.mkv
[adb9a229254c717f]
|
9,157,902 |
9C72C634 |
127-datetime2fromparts_function_in_sql_server.mkv
[17db8bf0d1d0241]
|
9,894,911 |
D4405E5E |
128-difference_between_datetime_and_datetime2_in_sql_server.mkv
[60e64d6baebad94b]
|
9,892,513 |
6EE21994 |
129-difference_between_datetime_and_datetime2_in_sql_server_1.mkv
[cf0b766c9c693e1d]
|
9,018,164 |
2F08EE7B |
12-select_statement_usages.mkv
[72f84c5d4bd9e208]
|
76,412,811 |
2F52CC44 |
130-offset_fetch_next_in_sql_server.mkv
[b3e62ad7bebbef6b]
|
13,642,279 |
8A1CDCE4 |
131-identifying_object_dependencies_in_sql_server.mkv
[7f31a8a56ccea0ac]
|
5,221,657 |
F617EFB2 |
132-sys.dm_sql_referencing_entities_in_sql_server.mkv
[9353a656f49cdaed]
|
22,002,301 |
84F9B3EF |
133-sp_depends_in_sql_server.mkv
[46b421527103a8a8]
|
10,754,439 |
0F4D0A30 |
134-sequence_object_in_sql_server.mkv
[b3d6c0c68e247a7a]
|
20,583,571 |
999D490B |
135-difference_between_sequence_and_identity_in_sql_server.mkv
[32601c49fdd666e0]
|
6,462,059 |
E69E42B7 |
136-guid_in_sql_server.mkv
[2b7e5291743de9e7]
|
9,932,905 |
0F6F8928 |
137-how_to_check_guid_is_null_or_empty_in_sql_server.mkv
[b96d5fd3fc5de1a5]
|
6,794,712 |
0E7CEE32 |
138-dynamic_sql_in_sql_server.mkv
[e00220854eebe0bc]
|
15,104,513 |
A03555D6 |
139-implement_search_web_page_using_asp.net_and_stored_procedure.mkv
[a971af9801a9357]
|
17,833,949 |
15362B3A |
13-group_by.mkv
[aaba837da3d60cdb]
|
83,016,276 |
98D01C7C |
140-implement_search_web_page_using_asp.net_dynamic_sp.mkv
[a8d86f7418cb2e7c]
|
11,525,092 |
92A87A7C |
141-prevent_sql_injection_with_dynamic_sql.mkv
[67f6730abd27cdaa]
|
12,005,441 |
12BCD79A |
142-dynamic_sql_in_stored_procedure.mkv
[666ad0dbb17aa509]
|
14,122,083 |
BDD138E0 |
143-sql_server_query_plan_cache.mkv
[cbaf24afa79c9d9b]
|
28,123,727 |
DE000430 |
144-exec_vs_sp_executesql_in_sql_server.mkv
[9604b0be8a25d062]
|
8,145,248 |
E0B0B9F2 |
145-dynamic_sql_table_name_variable.mkv
[228d3df8519ad12e]
|
11,535,995 |
FAA7750D |
146-quotename_function_in_sql_server.mkv
[d45731e067780f70]
|
36,481,680 |
F6B9C0B7 |
147-dynamic_sql_vs_stored_procedure.mkv
[d1277a3b8d860e40]
|
61,317,446 |
475E4404 |
148-dynamic_sql_output_parameter.mkv
[556d9eef916e6ee2]
|
15,027,506 |
DD9ECA0E |
149-temp_tables_in_dynamic_sql.mkv
[9579c962ee90ad47]
|
19,878,307 |
BBA56085 |
14-joins.mkv
[6c1fe85e6e72cd5a]
|
97,475,331 |
4F12DDE4 |
15-advanced_joins.mkv
[6e5fc2966c252bd6]
|
81,350,100 |
5562EAF5 |
16-self_joins.mkv
[a67079c24ef33053]
|
16,846,814 |
AF3BD759 |
17-how_to_replace_null-different_ways.mkv
[f90acc3542cf7f6]
|
18,989,904 |
3EAC8147 |
18-coalesce_function.mkv
[be926c833a0e2f3f]
|
9,493,704 |
B8C3BF48 |
19-union_and_union_all.mkv
[6f8e7249ba4472ea]
|
15,755,864 |
E16967BC |
20-stored_procedures.mkv
[c94ee799ec81d115]
|
82,281,073 |
97E62313 |
21-stored_procedures_with_output_parameters.mkv
[5b53c3bdafbbc8e9]
|
27,163,973 |
74F1C676 |
22-difference_between_output_parameters_and_return_values.mkv
[d8b7ebf7c05f4f5c]
|
56,283,881 |
F382C403 |
23-stored_procedures___advantages.mkv
[6e2b21fe8b0d0e2]
|
59,397,229 |
C3586586 |
24-string_functions.mkv
[63059930067a271d]
|
83,117,255 |
31D524AB |
25-left__right_charindex_and_substring.mkv
[7f632370769a31]
|
35,883,696 |
11801A75 |
26-replicatespacepatindex.mkv
[5f8305a239c114c2]
|
35,509,474 |
64D42D88 |
27-replace_and_stuff.mkv
[67de7888c90e1bdf]
|
18,399,231 |
1E8CC2CA |
28-datetime_functions.mkv
[3c1fe66dd844e441]
|
27,530,973 |
418DB936 |
29-isdatedaymonthyear_and_datename_functions.mkv
[b95f38cdd9a0a0a7]
|
33,178,292 |
895A4BDC |
30-datepartdateadd_and_datediff.mkv
[38d6e6e4facfebeb]
|
47,127,305 |
F7DC65FF |
31-convert_and_cast.mkv
[20de72f57a383bdb]
|
8,439,888 |
CDD00877 |
32-mathematical_functions.mkv
[182a209536ef4d40]
|
45,860,658 |
8C15BEDB |
33-scalar_user_defined_functions.mkv
[715e386cc75bbf6d]
|
19,122,734 |
C62324CE |
34-inline_table_valued_functions.mkv
[71a486a66cb979e5]
|
18,494,516 |
191B60C2 |
35-multi_statement_table_valued_functions.mkv
[daf00cdcd103a88b]
|
17,075,128 |
0B9AD920 |
36-functions.mkv
[d624b57bb683ad1]
|
10,221,724 |
DAACD88F |
37-temporary_tables.mkv
[84746b639758f7f0]
|
17,160,064 |
1EC1ECCC |
38-indexes.mkv
[11c3b57322ccd102]
|
9,112,643 |
299C3FE4 |
39-clustered_and_nonclustered_indexes.mkv
[afb43ba56081b77d]
|
17,811,972 |
0360D4C9 |
40-unique_and_non_unique_indexes.mkv
[9f999b6a623c3369]
|
8,465,702 |
33D75D93 |
41-advantages_and_disadvantages_of_indexes.mkv
[4657130f6b7d6fec]
|
6,862,251 |
BDF94D65 |
42-views.mkv
[3e1a0d9edc65be94]
|
10,070,401 |
91F63BA6 |
43-updateable_views.mkv
[1c6846c2368ab211]
|
13,398,484 |
E1EADC70 |
44-indexed_views.mkv
[782c6769182f7ebe]
|
11,093,445 |
0C4CCCC0 |
45-view_limitations.mkv
[b76076d4aafe416b]
|
3,884,032 |
931844BA |
46-dml_triggers.mkv
[9d530fb468afbe1b]
|
12,898,619 |
B1D63C2C |
47-dml_after_update_trigger.mkv
[b285d6f4313f58d6]
|
4,239,409 |
74901620 |
48-instead_of_insert_trigger.mkv
[66b94762c09f374]
|
8,375,093 |
6346CA50 |
49-instead_of_update_trigger.mkv
[d46c6136ffbaffaa]
|
3,932,167 |
CA49F2CC |
50-instead_of_delete_trigger.mkv
[41420bb03a92491f]
|
3,825,360 |
6C9DDB87 |
51-derived_table_and_ctes.mkv
[541b56ae40e3c54a]
|
9,061,495 |
F0980677 |
52-common_table_expressions-cte.mkv
[c8bfa9116756e2ec]
|
26,348,268 |
F69C466E |
53-updatable_cte.mkv
[c3c2ef2de82093e3]
|
9,631,606 |
5E3707A8 |
54-recursive_cte.mkv
[d4c6c0bd6c79e7be]
|
13,452,749 |
2E0B1C07 |
55-normalization_and_first_normal_form.mkv
[74f2f50d6f18314]
|
12,593,167 |
D6C41165 |
56-2nd_and_3rd_normal_form.mkv
[de18929542261da2]
|
4,672,378 |
FBA7CB7A |
57-pivot_operator.mkv
[c0ff72c8f113717]
|
4,358,976 |
882A540C |
58-error_handling_in_sql_server_2000.mkv
[a9e9c8bbc12d2a49]
|
23,107,377 |
1AFCB3D1 |
59-error_handling_in_sql_server_2005_and_later_versions.mkv
[264b05fbe477fd6c]
|
8,154,314 |
145D3972 |
60-transactions_in_sql_server.mkv
[dc2d7aa092fa11e3]
|
12,464,051 |
2BC287AD |
61-transaction_acid_tests.mkv
[b0d2d339d77d607e]
|
36,574,568 |
F451D884 |
62-subqueries_in_sql.mkv
[94814c9096dea1e3]
|
27,876,620 |
80DFA826 |
63-correlated_subquery.mkv
[85e68f9262bafef4]
|
15,889,546 |
05B22A0B |
64-creating_a_large_table_with_random_data_for_performance_testing.mkv
[ee552f152bec1a48]
|
19,361,275 |
DA063998 |
65-what_to_choose_for_performance___subquery_or_joins.mkv
[bdf00c9d7085b18b]
|
13,055,046 |
88D55A95 |
66-cursors_in_sql_server.mkv
[61a7e6088e62b9c0]
|
14,987,588 |
F9188403 |
67-replacing_cursors_using_joins.mkv
[1a86d43896d89ded]
|
14,119,971 |
D3F17223 |
68-list_all_tables_in_a_sql_server_database_using_a_query.mkv
[49efa7cbf184a7fc]
|
8,298,063 |
F3556E33 |
69-writing_re_runnable_sql_server_scripts.mkv
[c7242a2c43165ec5]
|
8,202,587 |
1890F5EA |
70-alter_database_table_columns_without_dropping_table.mkv
[70ff08526fc386ce]
|
17,146,667 |
8AFFBC6A |
71-optional_parameters_in_sql_server_stored_procedures.mkv
[37b01a4da0b43837]
|
13,061,317 |
4F346BEF |
72-merge_in_sql_server.mkv
[90fff6fc214a7e4]
|
11,319,753 |
0D9885D9 |
73-sql_server_concurrent_transactions.mkv
[86bc888931385d6]
|
17,725,681 |
00D70C57 |
74-sql_server_dirty_read_example.mkv
[12b12a2900024993]
|
11,272,871 |
B5A23BCD |
75-sql_server_lost_update_problem.mkv
[9aa04f34a37eb5b4]
|
11,141,731 |
8FCF9607 |
76-non_repeatable_read_example_in_sql_server.mkv
[1cefa6045bc416de]
|
15,601,688 |
E87965FA |
77-phantom_reads_example_in_sql_server.mkv
[e2322e1772326d07]
|
16,894,819 |
CB94E206 |
78-snapshot_isolation_level_in_sql_server.mkv
[495da3b4432172a4]
|
28,201,023 |
07A89FE6 |
79-read_committed_snapshot_isolation_level_in_sql_server.mkv
[a77048cbeaa794]
|
11,346,376 |
245C2041 |
80-difference_between_snapshot_isolation_and_read_committed_snapshot.mkv
[5891ca70bf9e3f94]
|
7,347,123 |
DDFF7F15 |
81-sql_server_deadlock_example.mkv
[9913502338d41678]
|
9,945,020 |
D74A64B7 |
82-sql_server_deadlock_victim_selection.mkv
[d1e25fc89c3fe5db]
|
34,577,539 |
09529655 |
83-logging_deadlocks_in_sql_server.mkv
[1e40794c65917fd5]
|
6,618,200 |
B0AA83E8 |
84-sql_server_deadlock_analysis_and_prevention.mkv
[a559bcc533e4ecb7]
|
12,504,756 |
800B7BF5 |
85-capturing_deadlocks_in_sql_profiler.mkv
[39bd306a1948eb51]
|
14,910,384 |
4CFCB2D3 |
86-sql_server_deadlock_error_handling.mkv
[c5bb870cec61e420]
|
9,328,255 |
D9A7E528 |
87-handling_deadlocks_in_ado.net.mkv
[2b0aeb587c66b0ed]
|
3,721,301 |
B431F0FD |
88-retry_logic_for_deadlock_exceptions.mkv
[14dad1b5a092192c]
|
3,656,174 |
50D4E146 |
89-how_to_find_blocking_queries_in_sql_server.mkv
[1835c4a5ef2d395b]
|
15,528,992 |
B57E8C0E |
90-sql_server_except_operator.mkv
[93588cd88fc11a29]
|
2,467,319 |
2425FB4B |
91-difference_between_except_and_not_in_sql_server.mkv
[a09a42dea78132d8]
|
4,773,658 |
F5BCDE56 |
92-intersect_operator_in_sql_server.mkv
[d3c371613deca552]
|
4,570,673 |
E010D2DB |
93-difference_between_union_intersect_and_except_in_sql_server.mkv
[c755d978ae7a4481]
|
9,597,511 |
27E37584 |
94-cross_apply_and_outer_apply_in_sql_server.mkv
[ce1f8b2d7893cf2]
|
6,035,556 |
E8F8C2A2 |
95-ddl_triggers_in_sql_server.mkv
[70276ce3e6ecf5ed]
|
14,695,771 |
155EA088 |
96-server_scoped_ddl_triggers.mkv
[fd6433986c652fd9]
|
18,215,846 |
FEC1BA41 |
97-sql_server_trigger_execution_order.mkv
[3c67839f9007a8ad]
|
9,257,605 |
CB7CECDD |
98-audit_table_changes_in_sql_server.mkv
[6726914a1b1c305f]
|
9,402,070 |
9680BFAF |
99-logon_triggers_in_sql_server.mkv
[7604a81e64bb6304]
|
10,042,955 |
11D669DC |
Answers.zip.zip |
2,881 |
73E0B0D0 |
QnA.pptx.pptx |
71,899 |
A9FE878C |
|
Total size: |
3,546,461,280 |
|
|