|
|
0
|
|
495.4 KB
|
|
|
001 Démo _ Discover the powerful Dynamic Data Masking !.en.srt
|
SRT
|
6.5 KB
|
|
|
001 Démo _ Discover the powerful Dynamic Data Masking !.mp4
|
MP4
|
69.1 MB
|
|
|
001 Démo _ Let's discover the synonym !.en.srt
|
SRT
|
3.9 KB
|
|
|
001 Démo _ Let's discover the synonym !.mp4
|
MP4
|
45.2 MB
|
|
|
001 Example of an introduction to windowing functions.en.srt
|
SRT
|
2.7 KB
|
|
|
001 Example of an introduction to windowing functions.mp4
|
MP4
|
22.4 MB
|
|
|
001 Introduction on the security.en.srt
|
SRT
|
1.3 KB
|
|
|
001 Introduction on the security.mp4
|
MP4
|
10.6 MB
|
|
|
001 Presentation of the different isolation modes on SQL.en.srt
|
SRT
|
3.5 KB
|
|
|
001 Presentation of the different isolation modes on SQL.mp4
|
MP4
|
15.4 MB
|
|
|
1
|
|
486.5 KB
|
|
|
002 Démo _ Creating our first account.en.srt
|
SRT
|
6.4 KB
|
|
|
002 Démo _ Creating our first account.mp4
|
MP4
|
65.6 MB
|
|
|
002 Démo _ Do you know the CDC (change data capture) _.en.srt
|
SRT
|
5.1 KB
|
|
|
002 Démo _ Do you know the CDC (change data capture) _.mp4
|
MP4
|
57 MB
|
|
|
002 Démo _ The READ COMMITED isolation mode.en.srt
|
SRT
|
7.1 KB
|
|
|
002 Démo _ The READ COMMITED isolation mode.mp4
|
MP4
|
56.4 MB
|
|
|
002 Démo_ Discover how to create a trigger.en.srt
|
SRT
|
4.8 KB
|
|
|
002 Démo_ Discover how to create a trigger.mp4
|
MP4
|
40.4 MB
|
|
|
002 Démo_ The OVER clause with PARTITION BY.en.srt
|
SRT
|
8.3 KB
|
|
|
002 Démo_ The OVER clause with PARTITION BY.mp4
|
MP4
|
90 MB
|
|
|
2
|
|
174.2 KB
|
|
|
003 Demo _ The functions of RANKING (ROW_NUMBER, DENSE _RANK, RANK, NTILE).en.srt
|
SRT
|
6 KB
|
|
|
003 Demo _ The functions of RANKING (ROW_NUMBER, DENSE _RANK, RANK, NTILE).mp4
|
MP4
|
67.4 MB
|
|
|
003 Démo _ Do you know what is the temporal data _.en.srt
|
SRT
|
6.4 KB
|
|
|
003 Démo _ Do you know what is the temporal data _.mp4
|
MP4
|
84.6 MB
|
|
|
3
|
|
241.6 KB
|
|
|
003 Démo _ The Default database configuration.en.srt
|
SRT
|
4.4 KB
|
|
|
003 Démo _ The Default database configuration.mp4
|
MP4
|
44.7 MB
|
|
|
003 Démo _ The READ UNCOMMITED isolation mode.en.srt
|
SRT
|
6.2 KB
|
|
|
003 Démo _ The READ UNCOMMITED isolation mode.mp4
|
MP4
|
49.8 MB
|
|
|
003 Démo _ What is a virtual table in a trigger _.en.srt
|
SRT
|
2.6 KB
|
|
|
003 Démo _ What is a virtual table in a trigger _.mp4
|
MP4
|
22.1 MB
|
|
|
004 Démo _ Discover the Server Roles on your SQL Server !.en.srt
|
SRT
|
6.7 KB
|
|
|
004 Démo _ Discover the Server Roles on your SQL Server !.mp4
|
MP4
|
76.1 MB
|
|
|
004 Démo _ Discover the fantastic Row Level security.en.srt
|
SRT
|
5.7 KB
|
|
|
004 Démo _ Discover the fantastic Row Level security.mp4
|
MP4
|
58.2 MB
|
|
|
4
|
|
401.2 KB
|
|
|
004 Démo _ Do you know the REPETEABLE READ isolation mode _.en.srt
|
SRT
|
5.9 KB
|
|
|
004 Démo _ Do you know the REPETEABLE READ isolation mode _.mp4
|
MP4
|
36.5 MB
|
|
|
004 Démo _ Learn how to define a trigger on a login SQL.en.srt
|
SRT
|
2.7 KB
|
|
|
004 Démo _ Learn how to define a trigger on a login SQL.mp4
|
MP4
|
32.1 MB
|
|
|
004 Démo _ The functions of RANKING in the real world.en.srt
|
SRT
|
6.4 KB
|
|
|
004 Démo _ The functions of RANKING in the real world.mp4
|
MP4
|
69 MB
|
|
|
005 Do you know the term SARGABLE on SQL Server_.en.srt
|
SRT
|
11.6 KB
|
|
|
5
|
|
236.7 KB
|
|
|
005 Do you know the term SARGABLE on SQL Server_.mp4
|
MP4
|
113.2 MB
|
|
|
005 Démo _ How to set up a IDENTITY on your tables.en.srt
|
SRT
|
9.7 KB
|
|
|
005 Démo _ How to set up a IDENTITY on your tables.mp4
|
MP4
|
72.6 MB
|
|
|
005 Démo _ What is the Row level security _.en.srt
|
SRT
|
5.7 KB
|
|
|
005 Démo _ What is the Row level security _.mp4
|
MP4
|
58.2 MB
|
|
|
005 Démo_ Aggregation with RANKING functions.en.srt
|
SRT
|
4.4 KB
|
|
|
005 Démo_ Aggregation with RANKING functions.mp4
|
MP4
|
53.8 MB
|
|
|
005 Démo_ Let's discover the SERIALIZABLE Mode !.en.srt
|
SRT
|
5.3 KB
|
|
|
005 Démo_ Let's discover the SERIALIZABLE Mode !.mp4
|
MP4
|
46.5 MB
|
|
|
005 RLS_UK.sql
|
SQL
|
3.6 KB
|
|
|
006 Démo _ Aggregation with RANKING functions in the real world.mp4
|
MP4
|
27 MB
|
|
|
006 Démo _ Discover the schema.en.srt
|
SRT
|
10.1 KB
|
|
|
006 Démo _ Discover the schema.mp4
|
MP4
|
88.3 MB
|
|
|
006 Démo _ Don't forget to activate the IFI on SQL Server !.mp4
|
MP4
|
76.9 MB
|
|
|
006 Démo _ Let's talk about the Powerful SEQUENCE !.en.srt
|
SRT
|
10.7 KB
|
|
|
006 Démo _ Let's talk about the Powerful SEQUENCE !.mp4
|
MP4
|
89.3 MB
|
|
|
006 Démo _ The SNAPSHOT isolation mode.en.srt
|
SRT
|
6.1 KB
|
|
|
6
|
|
99.4 KB
|
|
|
006 Démo _ Aggregation with RANKING functions in the real world.en.srt
|
SRT
|
2.4 KB
|
|
|
006 Démo _ Don't forget to activate the IFI on SQL Server !.en.srt
|
SRT
|
8.2 KB
|
|
|
006 Démo _ The SNAPSHOT isolation mode.mp4
|
MP4
|
41.1 MB
|
|
|
006 Schema 2_UK.sql
|
SQL
|
614.4 B
|
|
|
006 Schema_1_UK.sql
|
SQL
|
1.7 KB
|
|
|
007 Demo _ The analytical functions LAG and LEAD.en.srt
|
SRT
|
3.5 KB
|
|
|
007 Demo _ The analytical functions LAG and LEAD.mp4
|
MP4
|
38.6 MB
|
|
|
7
|
|
407.5 KB
|
|
|
007 Do you know the XABORT command _.en.srt
|
SRT
|
3.5 KB
|
|
|
007 Do you know the XABORT command _.mp4
|
MP4
|
30.1 MB
|
|
|
007 Démo _ Be careful on your AUTOGROW settings !.en.srt
|
SRT
|
4.3 KB
|
|
|
007 Démo _ Be careful on your AUTOGROW settings !.mp4
|
MP4
|
47.8 MB
|
|
|
007 Démo _ The primary Key.en.srt
|
SRT
|
5.2 KB
|
|
|
007 Démo _ The primary Key.mp4
|
MP4
|
57 MB
|
|
|
007 synonyme_UK.sql
|
SQL
|
2 KB
|
|
|
008 Démo _ Discover the accelerated recovery database on SQL Server 2019.en.srt
|
SRT
|
4.6 KB
|
|
|
008 Démo _ Discover the accelerated recovery database on SQL Server 2019.mp4
|
MP4
|
46.2 MB
|
|
|
008 Démo _ Let's discover the foreign key.en.srt
|
SRT
|
6.2 KB
|
|
|
008 Démo _ Let's discover the foreign key.mp4
|
MP4
|
56.9 MB
|
|
|
008 Démo _ ROWS _RANGE UNBOUNDED PRECEDING.en.srt
|
SRT
|
7.5 KB
|
|
|
008 Démo _ ROWS _RANGE UNBOUNDED PRECEDING.mp4
|
MP4
|
77.3 MB
|
|
|
008 Démo _ What is a DEADLOCK _.en.srt
|
SRT
|
5.4 KB
|
|
|
008 Démo _ What is a DEADLOCK _.mp4
|
MP4
|
39.1 MB
|
|
|
008 Trigger_UK.sql
|
SQL
|
2.6 KB
|
|
|
8
|
|
407 KB
|
|
|
009 Demo_ The analytical functions FIRST_VALUES and LAST_VALUES.mp4
|
MP4
|
33.4 MB
|
|
|
9
|
|
402.9 KB
|
|
|
009 Demo_ The analytical functions FIRST_VALUES and LAST_VALUES.en.srt
|
SRT
|
2.7 KB
|
|
|
009 Do you know the UPLOCK command _.en.srt
|
SRT
|
3.8 KB
|
|
|
009 Do you know the UPLOCK command _.mp4
|
MP4
|
33.9 MB
|
|
|
009 Démo _ The constraint UNIQUE.en.srt
|
SRT
|
5 KB
|
|
|
009 Démo _ The constraint UNIQUE.mp4
|
MP4
|
53.9 MB
|
|
|
009 virtual table trigger UK.sql
|
SQL
|
1.3 KB
|
|
|
010 Conclusion on the isolation mode.mp4
|
MP4
|
12 MB
|
|
|
010 Démo _ The constraint CHECK.en.srt
|
SRT
|
5.6 KB
|
|
|
010 Démo _ The constraint CHECK.mp4
|
MP4
|
52.5 MB
|
|
|
010 Trigger login_UK.sql
|
SQL
|
1.1 KB
|
|
|
10
|
|
43.5 KB
|
|
|
010 Conclusion on the isolation mode.en.srt
|
SRT
|
2.9 KB
|
|
|
11
|
|
150.2 KB
|
|
|
011 Démo _ The constraint DEFAULT.en.srt
|
SRT
|
3.7 KB
|
|
|
011 Démo _ The constraint DEFAULT.mp4
|
MP4
|
37 MB
|
|
|
011 IDENTITY_UK.sql
|
SQL
|
3.5 KB
|
|
|
012 Démo_ What is the Cascading Referential Integrity Constraint _.en.srt
|
SRT
|
6.6 KB
|
|
|
12
|
|
421.5 KB
|
|
|
012 Démo_ What is the Cascading Referential Integrity Constraint _.mp4
|
MP4
|
62 MB
|
|
|
012 SEQUENCE_UK.sql
|
SQL
|
3.6 KB
|
|
|
13
|
|
468.2 KB
|
|
|
013 primary KEY_UK.sql
|
SQL
|
2 KB
|
|
|
14
|
|
297.5 KB
|
|
|
014 foreign Key_UK.sql
|
SQL
|
2.1 KB
|
|
|
015 UNIQUE_UK.sql
|
SQL
|
1.8 KB
|
|
|
15
|
|
314 KB
|
|
|
016 CHECK_UK.sql
|
SQL
|
2.8 KB
|
|
|
16
|
|
4.7 KB
|
|
|
17
|
|
5.2 KB
|
|
|
017 DEFAUT_UK.sql
|
SQL
|
1.3 KB
|
|
|
018 cascading referential integrity constraint_UK.sql
|
SQL
|
3.2 KB
|
|
|
18
|
|
150 KB
|
|
|
19
|
|
89.1 KB
|
|
|
020 READ COMMITED UK 1.sql
|
SQL
|
1.1 KB
|
|
|
020 READ COMMITED UK 2.sql
|
SQL
|
409.6 B
|
|
|
20
|
|
87.6 KB
|
|
|
21
|
|
209.2 KB
|
|
|
021 Isolation READ UNCOMMITED 1 .sql
|
SQL
|
716.8 B
|
|
|
021 Isolation READ UNCOMMITED 2 .sql
|
SQL
|
716.8 B
|
|
|
22
|
|
461.1 KB
|
|
|
022 Isolation SQL REPETEABLE READ 1 .sql
|
SQL
|
1.5 KB
|
|
|
022 Isolation SQL REPETEABLE READ 2.sql
|
SQL
|
409.6 B
|
|
|
023 Isolation SQL SERIALIZABLE 1_UK.sql
|
SQL
|
1 KB
|
|
|
23
|
|
197.1 KB
|
|
|
023 Isolation SQL SERIALIZABLE 2_UK.sql
|
SQL
|
1 KB
|
|
|
024 Isolation SQL SNAPSHOT 1.sql
|
SQL
|
1.5 KB
|
|
|
024 Isolation SQL SNAPSHOT 2.sql
|
SQL
|
1 KB
|
|
|
24
|
|
177.4 KB
|
|
|
25
|
|
37.1 KB
|
|
|
26
|
|
333.4 KB
|
|
|
026 deadlock query1.sql
|
SQL
|
307.2 B
|
|
|
026 deadlock query2.sql
|
SQL
|
307.2 B
|
|
|
27
|
|
319.1 KB
|
|
|
027 UPDLOCK Fenetre1_UK.sql
|
SQL
|
716.8 B
|
|
|
027 UPDLOCK Fenetre2_UK.sql
|
SQL
|
614.4 B
|
|
|
28
|
|
292.3 KB
|
|
|
029 DDM_UK.sql
|
SQL
|
6.3 KB
|
|
|
29
|
|
434.5 KB
|
|
|
30
|
|
148.4 KB
|
|
|
030 CDC_UK.sql
|
SQL
|
3.2 KB
|
|
|
031 demo temporal data_UK.sql
|
SQL
|
4.2 KB
|
|
|
31
|
|
447 KB
|
|
|
32
|
|
402.8 KB
|
|
|
032 RLS_UK.sql
|
SQL
|
3.6 KB
|
|
|
33
|
|
461.9 KB
|
|
|
033 SARGABLE_UK.sql
|
SQL
|
3.1 KB
|
|
|
34
|
|
490.5 KB
|
|
|
034 IFI.sql
|
SQL
|
1.7 KB
|
|
|
35
|
|
75.8 KB
|
|
|
035 AUTOGROW_UK.sql
|
SQL
|
2.1 KB
|
|
|
036 Query1_UK.sql
|
SQL
|
2.2 KB
|
|
|
036 Query2_UK.sql
|
SQL
|
204.8 B
|
|
|
036 Query3_UK.sql
|
SQL
|
307.2 B
|
|
|
36
|
|
52.7 KB
|
|
|
37
|
|
453.1 KB
|
|
|
38
|
|
384.7 KB
|
|
|
038 OVER partition by CLAUSE_UK.sql
|
SQL
|
2 KB
|
|
|
039 ranking function UK.sql
|
SQL
|
2 KB
|
|
|
39
|
|
28.3 KB
|
|
|
40
|
|
85.5 KB
|
|
|
040 RAnking in the real world.sql
|
SQL
|
3.3 KB
|
|
|
41
|
|
410.8 KB
|
|
|
041 aggregation with RANKING_UK.sql
|
SQL
|
2.5 KB
|
|
|
42
|
|
131.5 KB
|
|
|
042 aggragatio real world_UK.sql
|
SQL
|
2.2 KB
|
|
|
043 LAG and LEAD_UK.sql
|
SQL
|
1.4 KB
|
|
|
045 FIRST_VALUES et LAST VALUES_UK.sql
|
SQL
|
1.2 KB
|
|
|
TutsNode.com.txt
|
TXT
|
102.4 B
|
|
|
[TGx]Downloaded from torrentgalaxy.to .txt
|
TXT
|
614.4 B
|
|
|
43
|
|
492.3 KB
|
