Torrent details for "SQL Server 2019 : Administration SQL Server Part 3" Log in to bookmark
Controls:
Language:
EnglishTotal Size:
2.31 GB
Info Hash:
8c827c4fa08cdaf3ed285080cb9bec4fda08ddba
Added By:
Added:
22-06-2021 06:00
Views:
487
Health:
Seeds:
4
Leechers:
1
Completed:
10
| File | Size |
|---|---|
| .pad/0 | 495.40 kB |
| .pad/1 | 486.53 kB |
| .pad/10 | 43.50 kB |
| .pad/11 | 150.24 kB |
| .pad/12 | 421.47 kB |
| .pad/13 | 468.18 kB |
| .pad/14 | 297.53 kB |
| .pad/15 | 313.98 kB |
| .pad/16 | 4.70 kB |
| .pad/17 | 5.24 kB |
| .pad/18 | 150.00 kB |
| .pad/19 | 89.11 kB |
| .pad/2 | 174.18 kB |
| .pad/20 | 87.61 kB |
| .pad/21 | 209.24 kB |
| .pad/22 | 461.10 kB |
| .pad/23 | 197.11 kB |
| .pad/24 | 177.42 kB |
| .pad/25 | 37.07 kB |
| .pad/26 | 333.45 kB |
| .pad/27 | 319.13 kB |
| .pad/28 | 292.28 kB |
| .pad/29 | 434.47 kB |
| .pad/3 | 241.55 kB |
| .pad/30 | 148.44 kB |
| .pad/31 | 447.02 kB |
| .pad/32 | 402.82 kB |
| .pad/33 | 461.92 kB |
| .pad/34 | 490.47 kB |
| .pad/35 | 75.82 kB |
| .pad/36 | 52.72 kB |
| .pad/37 | 453.13 kB |
| .pad/38 | 384.67 kB |
| .pad/39 | 28.34 kB |
| .pad/4 | 401.24 kB |
| .pad/40 | 85.55 kB |
| .pad/41 | 410.76 kB |
| .pad/42 | 131.46 kB |
| .pad/43 | 492.34 kB |
| .pad/5 | 236.71 kB |
| .pad/6 | 99.37 kB |
| .pad/7 | 407.48 kB |
| .pad/8 | 407.04 kB |
| .pad/9 | 402.89 kB |
| TutsNode.com.txt | 63.00 B |
| [TGx]Downloaded from torrentgalaxy.to .txt | 585.00 B |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/01 Introduction/001 Introduction on the security.en.srt | 1.27 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/01 Introduction/001 Introduction on the security.mp4 | 10.62 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/01 Introduction/002 Démo _ Creating our first account.en.srt | 6.37 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/01 Introduction/002 Démo _ Creating our first account.mp4 | 65.59 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/01 Introduction/003 Démo _ The Default database configuration.en.srt | 4.43 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/01 Introduction/003 Démo _ The Default database configuration.mp4 | 44.71 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/01 Introduction/004 Démo _ Discover the Server Roles on your SQL Server !.en.srt | 6.71 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/01 Introduction/004 Démo _ Discover the Server Roles on your SQL Server !.mp4 | 76.10 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/01 Introduction/005 Démo _ What is the Row level security _.en.srt | 5.69 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/01 Introduction/005 Démo _ What is the Row level security _.mp4 | 58.19 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/01 Introduction/005 RLS_UK.sql | 3.63 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/01 Introduction/006 Démo _ Discover the schema.en.srt | 10.07 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/01 Introduction/006 Démo _ Discover the schema.mp4 | 88.26 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/01 Introduction/006 Schema 2_UK.sql | 590.00 B |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/01 Introduction/006 Schema_1_UK.sql | 1.66 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/001 Démo _ Let's discover the synonym !.en.srt | 3.89 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/001 Démo _ Let's discover the synonym !.mp4 | 45.19 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/002 Démo_ Discover how to create a trigger.en.srt | 4.81 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/002 Démo_ Discover how to create a trigger.mp4 | 40.36 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/003 Démo _ What is a virtual table in a trigger _.en.srt | 2.63 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/003 Démo _ What is a virtual table in a trigger _.mp4 | 22.10 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/004 Démo _ Learn how to define a trigger on a login SQL.en.srt | 2.70 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/004 Démo _ Learn how to define a trigger on a login SQL.mp4 | 32.06 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/005 Démo _ How to set up a IDENTITY on your tables.en.srt | 9.72 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/005 Démo _ How to set up a IDENTITY on your tables.mp4 | 72.60 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/006 Démo _ Let's talk about the Powerful SEQUENCE !.en.srt | 10.65 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/006 Démo _ Let's talk about the Powerful SEQUENCE !.mp4 | 89.33 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/007 Démo _ The primary Key.en.srt | 5.25 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/007 Démo _ The primary Key.mp4 | 56.99 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/007 synonyme_UK.sql | 1.95 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/008 Démo _ Let's discover the foreign key.en.srt | 6.17 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/008 Démo _ Let's discover the foreign key.mp4 | 56.85 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/008 Trigger_UK.sql | 2.55 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/009 Démo _ The constraint UNIQUE.en.srt | 5.00 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/009 Démo _ The constraint UNIQUE.mp4 | 53.91 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/009 virtual table trigger UK.sql | 1.32 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/010 Démo _ The constraint CHECK.en.srt | 5.58 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/010 Démo _ The constraint CHECK.mp4 | 52.55 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/010 Trigger login_UK.sql | 1.08 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/011 Démo _ The constraint DEFAULT.en.srt | 3.66 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/011 Démo _ The constraint DEFAULT.mp4 | 37.05 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/011 IDENTITY_UK.sql | 3.47 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/012 Démo_ What is the Cascading Referential Integrity Constraint _.en.srt | 6.62 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/012 Démo_ What is the Cascading Referential Integrity Constraint _.mp4 | 62.04 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/012 SEQUENCE_UK.sql | 3.61 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/013 primary KEY_UK.sql | 1.96 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/014 foreign Key_UK.sql | 2.13 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/015 UNIQUE_UK.sql | 1.78 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/016 CHECK_UK.sql | 2.83 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/017 DEFAUT_UK.sql | 1.29 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/02 The Trigger,synonym, the sequence, and the constraints/018 cascading referential integrity constraint_UK.sql | 3.19 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/001 Presentation of the different isolation modes on SQL.en.srt | 3.49 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/001 Presentation of the different isolation modes on SQL.mp4 | 15.37 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/002 Démo _ The READ COMMITED isolation mode.en.srt | 7.06 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/002 Démo _ The READ COMMITED isolation mode.mp4 | 56.41 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/003 Démo _ The READ UNCOMMITED isolation mode.en.srt | 6.23 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/003 Démo _ The READ UNCOMMITED isolation mode.mp4 | 49.81 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/004 Démo _ Do you know the REPETEABLE READ isolation mode _.en.srt | 5.87 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/004 Démo _ Do you know the REPETEABLE READ isolation mode _.mp4 | 36.52 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/005 Démo_ Let's discover the SERIALIZABLE Mode !.en.srt | 5.25 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/005 Démo_ Let's discover the SERIALIZABLE Mode !.mp4 | 46.46 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/006 Démo _ The SNAPSHOT isolation mode.en.srt | 6.05 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/006 Démo _ The SNAPSHOT isolation mode.mp4 | 41.08 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/007 Do you know the XABORT command _.en.srt | 3.49 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/007 Do you know the XABORT command _.mp4 | 30.12 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/008 Démo _ What is a DEADLOCK _.en.srt | 5.36 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/008 Démo _ What is a DEADLOCK _.mp4 | 39.06 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/009 Do you know the UPLOCK command _.en.srt | 3.82 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/009 Do you know the UPLOCK command _.mp4 | 33.93 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/010 Conclusion on the isolation mode.en.srt | 2.85 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/010 Conclusion on the isolation mode.mp4 | 12.02 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/020 READ COMMITED UK 1.sql | 1.06 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/020 READ COMMITED UK 2.sql | 383.00 B |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/021 Isolation READ UNCOMMITED 1 .sql | 701.00 B |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/021 Isolation READ UNCOMMITED 2 .sql | 742.00 B |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/022 Isolation SQL REPETEABLE READ 1 .sql | 1.54 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/022 Isolation SQL REPETEABLE READ 2.sql | 389.00 B |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/023 Isolation SQL SERIALIZABLE 1_UK.sql | 1.01 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/023 Isolation SQL SERIALIZABLE 2_UK.sql | 1.01 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/024 Isolation SQL SNAPSHOT 1.sql | 1.47 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/024 Isolation SQL SNAPSHOT 2.sql | 1,002.00 B |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/026 deadlock query1.sql | 300.00 B |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/026 deadlock query2.sql | 263.00 B |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/027 UPDLOCK Fenetre1_UK.sql | 669.00 B |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/03 The different modes of isolation/027 UPDLOCK Fenetre2_UK.sql | 624.00 B |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/04 Another topics on the Adminstration of your SQL Server/001 Démo _ Discover the powerful Dynamic Data Masking !.en.srt | 6.46 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/04 Another topics on the Adminstration of your SQL Server/001 Démo _ Discover the powerful Dynamic Data Masking !.mp4 | 69.11 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/04 Another topics on the Adminstration of your SQL Server/002 Démo _ Do you know the CDC (change data capture) _.en.srt | 5.14 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/04 Another topics on the Adminstration of your SQL Server/002 Démo _ Do you know the CDC (change data capture) _.mp4 | 57.00 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/04 Another topics on the Adminstration of your SQL Server/003 Démo _ Do you know what is the temporal data _.en.srt | 6.40 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/04 Another topics on the Adminstration of your SQL Server/003 Démo _ Do you know what is the temporal data _.mp4 | 84.61 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/04 Another topics on the Adminstration of your SQL Server/004 Démo _ Discover the fantastic Row Level security.en.srt | 5.69 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/04 Another topics on the Adminstration of your SQL Server/004 Démo _ Discover the fantastic Row Level security.mp4 | 58.21 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/04 Another topics on the Adminstration of your SQL Server/005 Do you know the term SARGABLE on SQL Server_.en.srt | 11.64 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/04 Another topics on the Adminstration of your SQL Server/005 Do you know the term SARGABLE on SQL Server_.mp4 | 113.19 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/04 Another topics on the Adminstration of your SQL Server/006 Démo _ Don't forget to activate the IFI on SQL Server !.en.srt | 8.21 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/04 Another topics on the Adminstration of your SQL Server/006 Démo _ Don't forget to activate the IFI on SQL Server !.mp4 | 76.90 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/04 Another topics on the Adminstration of your SQL Server/007 Démo _ Be careful on your AUTOGROW settings !.en.srt | 4.28 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/04 Another topics on the Adminstration of your SQL Server/007 Démo _ Be careful on your AUTOGROW settings !.mp4 | 47.83 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/04 Another topics on the Adminstration of your SQL Server/008 Démo _ Discover the accelerated recovery database on SQL Server 2019.en.srt | 4.61 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/04 Another topics on the Adminstration of your SQL Server/008 Démo _ Discover the accelerated recovery database on SQL Server 2019.mp4 | 46.17 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/04 Another topics on the Adminstration of your SQL Server/029 DDM_UK.sql | 6.33 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/04 Another topics on the Adminstration of your SQL Server/030 CDC_UK.sql | 3.25 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/04 Another topics on the Adminstration of your SQL Server/031 demo temporal data_UK.sql | 4.22 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/04 Another topics on the Adminstration of your SQL Server/032 RLS_UK.sql | 3.63 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/04 Another topics on the Adminstration of your SQL Server/033 SARGABLE_UK.sql | 3.08 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/04 Another topics on the Adminstration of your SQL Server/034 IFI.sql | 1.74 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/04 Another topics on the Adminstration of your SQL Server/035 AUTOGROW_UK.sql | 2.13 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/04 Another topics on the Adminstration of your SQL Server/036 Query1_UK.sql | 2.21 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/04 Another topics on the Adminstration of your SQL Server/036 Query2_UK.sql | 254.00 B |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/04 Another topics on the Adminstration of your SQL Server/036 Query3_UK.sql | 256.00 B |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/05 Let's discover the power of the Ranking functions/001 Example of an introduction to windowing functions.en.srt | 2.67 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/05 Let's discover the power of the Ranking functions/001 Example of an introduction to windowing functions.mp4 | 22.42 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/05 Let's discover the power of the Ranking functions/002 Démo_ The OVER clause with PARTITION BY.en.srt | 8.33 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/05 Let's discover the power of the Ranking functions/002 Démo_ The OVER clause with PARTITION BY.mp4 | 90.02 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/05 Let's discover the power of the Ranking functions/003 Demo _ The functions of RANKING (ROW_NUMBER, DENSE _RANK, RANK, NTILE).en.srt | 6.03 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/05 Let's discover the power of the Ranking functions/003 Demo _ The functions of RANKING (ROW_NUMBER, DENSE _RANK, RANK, NTILE).mp4 | 67.35 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/05 Let's discover the power of the Ranking functions/004 Démo _ The functions of RANKING in the real world.en.srt | 6.41 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/05 Let's discover the power of the Ranking functions/004 Démo _ The functions of RANKING in the real world.mp4 | 68.96 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/05 Let's discover the power of the Ranking functions/005 Démo_ Aggregation with RANKING functions.en.srt | 4.44 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/05 Let's discover the power of the Ranking functions/005 Démo_ Aggregation with RANKING functions.mp4 | 53.80 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/05 Let's discover the power of the Ranking functions/006 Démo _ Aggregation with RANKING functions in the real world.en.srt | 2.43 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/05 Let's discover the power of the Ranking functions/006 Démo _ Aggregation with RANKING functions in the real world.mp4 | 26.97 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/05 Let's discover the power of the Ranking functions/007 Demo _ The analytical functions LAG and LEAD.en.srt | 3.51 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/05 Let's discover the power of the Ranking functions/007 Demo _ The analytical functions LAG and LEAD.mp4 | 38.61 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/05 Let's discover the power of the Ranking functions/008 Démo _ ROWS _RANGE UNBOUNDED PRECEDING.en.srt | 7.47 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/05 Let's discover the power of the Ranking functions/008 Démo _ ROWS _RANGE UNBOUNDED PRECEDING.mp4 | 77.27 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/05 Let's discover the power of the Ranking functions/009 Demo_ The analytical functions FIRST_VALUES and LAST_VALUES.en.srt | 2.73 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/05 Let's discover the power of the Ranking functions/009 Demo_ The analytical functions FIRST_VALUES and LAST_VALUES.mp4 | 33.45 MB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/05 Let's discover the power of the Ranking functions/038 OVER partition by CLAUSE_UK.sql | 2.02 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/05 Let's discover the power of the Ranking functions/039 ranking function UK.sql | 2.04 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/05 Let's discover the power of the Ranking functions/040 RAnking in the real world.sql | 3.27 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/05 Let's discover the power of the Ranking functions/041 aggregation with RANKING_UK.sql | 2.53 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/05 Let's discover the power of the Ranking functions/042 aggragatio real world_UK.sql | 2.23 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/05 Let's discover the power of the Ranking functions/043 LAG and LEAD_UK.sql | 1.40 kB |
| [TutsNode.com] - SQL Server 2019 Administration SQL Server Part 3/05 Let's discover the power of the Ranking functions/045 FIRST_VALUES et LAST VALUES_UK.sql | 1.17 kB |
Description
Welcome to my administration course part 3, this course will cover several topics on SQL administration
Administration rhymes with precaution, and therefore of course with security. We will discuss security and privilege management during 2 hours. We will learn :
Fixed server roles
Making a custom role for the server
What is a schema?
What is multibase chaining?
What is Row Level Security?
And much more
We will also cover a long chapter on the different isolation modes (READ COMMITED, SERIALIZABLE, SNAPSHOT…), we will also see the different types of constraints (PK,FK,CHECK,UNIQUE…), as well as SEQUENCES, and IDENTITY.
We will also discuss the change data capture (CDC), many new features released on SQL Server 2016 such as Row Level Security, Dynamic Data Masking (DDM), Temporal Data.
A very long chapterof 1h30 minutes on RANKING functions such as ROW_NUMBER, OVER and PARTITION BY, ROWS /RANGE UNBOUNDED PRECEDING, FIRST and LAST VALUES, LAG and LEAD,ROW_NUMBER, DENSE _RANK, RANK, NTILE.
Do you know SARGABLE queries? I let you discover it in this chapter, to rewrite your SQL queries, in a better way, and thus of course, better performance.
Why get into SQL administration?
SQL is one of the most actively sought after skills in the job market.
Administering SQL Server today is a full-time job.
In addition, SQL Server, by its simplicity, allows you to quickly gain skills on specific subjects.
If you are a Tech Lead, a developer, a future DBA, or any other profession that will tackle SQL, then this course is for you
I also made sure that the videos were no longer than 10 minutes, so that it wouldn’t be too boring
Look at the average of my other courses (4,6/5), and you will see that my courses are quality courses
Who this course is for:
Future Database Administrators (DBA)
Students who want to get started on SQL
Requirements
Installation of SQL server on his station + management studio (SSMS)
Last Updated 5/2021