2014
Pluralsight
Rudi Bruchez
5h 25m
English
Learn how to secure SQL Server: Access, authentication, permissions, SQL injections, encryption and much more.
Security in SQL Server is often overlooked. Companies tend to concentrate on availability and performance, but a database system often stores virtually all of a company's valuable and confidential data. So what happens if this data is stolen? In this course, we will cover all areas you need to protect to effectively secure SQL Server. It means system and network protection, user authentication, permissions on the objects and data, and data encryption. We will also use some penetration testing frameworks to show you how attacks are performed against SQL Server through various types of exploits, including SQL injection. The course is focused on SQL Server 2012 and 2014, but most of the information applies to all versions from SQL Server 2005 onward.
FileName Size Length Bit rate Data rate Resolution Frame Rate Parent Folder
01_01-Course Introduction 3.18 MB 0:01:39 113kbps 154.00 1024x768 14 frames/second 01. Introduction to Security With SQL Server
01_02-Why do we Need Security 3.90 MB 0:01:47 110kbps 193.00 1024x768 14 frames/second 01. Introduction to Security With SQL Server
01_03-What do we Need to Secure 3.82 MB 0:02:02 113kbps 147.00 1024x768 14 frames/second 01. Introduction to Security With SQL Server
01_04-Demo Stealing Database Files 10.3 MB 0:03:53 110kbps 260.00 1024x768 14 frames/second 01. Introduction to Security With SQL Server
01_05-There are More Risks Than Data Access 9.15 MB 0:03:39 114kbps 234.00 1024x768 14 frames/second 01. Introduction to Security With SQL Server
01_06-What Tools do we Need 4.15 MB 0:02:24 116kbps 123.00 1024x768 14 frames/second 01. Introduction to Security With SQL Server
01_07-How Clients are Connecting to SQL Server 3.38 MB 0:02:26 105kbps 86.00 1024x768 14 frames/second 01. Introduction to Security With SQL Server
01_08-Demo Client Connections 13.0 MB 0:05:01 107kbps 253.00 1024x768 14 frames/second 01. Introduction to Security With SQL Server
01_09-Summary 3.16 MB 0:01:44 115kbps 137.00 1024x768 14 frames/second 01. Introduction to Security With SQL Server
02_01-Module Introduction and System Account 22.2 MB 0:06:21 118kbps 368.00 1024x768 14 frames/second 02. Server and System Security
02_02-Other System Accounts 56.1 MB 0:08:25 119kbps 810.00 1024x768 14 frames/second 02. Server and System Security
02_03-Surface Area Configuration 20.2 MB 0:07:43 118kbps 246.00 1024x768 14 frames/second 02. Server and System Security
02_04-Opening Ports on Windows Firewall With the GUI 8.01 MB 0:03:07 114kbps 242.00 1024x768 14 frames/second 02. Server and System Security
02_05-Opening Ports on Windows Firewall by Script 55.5 MB 0:08:09 117kbps 833.00 1024x768 14 frames/second 02. Server and System Security
02_06-Enabling TCP on an Instance by Script 47.7 MB 0:06:14 116kbps 951.00 1024x768 14 frames/second 02. Server and System Security
02_07-Hiding an Instance in SQL Server Browser 15.7 MB 0:03:29 119kbps 509.00 1024x768 14 frames/second 02. Server and System Security
02_08-Fixing a TCP Port for an Instance 37.0 MB 0:04:56 118kbps 930.00 1024x768 14 frames/second 02. Server and System Security
02_09-Encrypting the Connection Between Client and Server Using SSL 43.7 MB 0:08:30 118kbps 599.00 1024x768 14 frames/second 02. Server and System Security
02_10-Using Extended Protection Against Authentication Relay Attacks 5.80 MB 0:03:47 113kbps 98.00 1024x768 14 frames/second 02. Server and System Security
02_11-Conclusion 3.88 MB 0:02:07 115kbps 139.00 1024x768 14 frames/second 02. Server and System Security
03_01-Introduction 3.26 MB 0:02:03 111kbps 109.00 1024x768 14 frames/second 03. Penetration Testing
03_02-Using Metasploit to Discover SQL Server Instance 15.7 MB 0:03:01 107kbps 618.00 1024x768 14 frames/second 03. Penetration Testing
03_03-Cracking the SA Password 49.2 MB 0:07:14 113kbps 836.00 1024x768 14 frames/second 03. Penetration Testing
03_04-Extracting Information From SQL Server Using Metasploit 25.0 MB 0:03:52 112kbps 790.00 1024x768 14 frames/second 03. Penetration Testing
03_05-Summary 4.34 MB 0:02:22 115kbps 139.00 1024x768 14 frames/second 03. Penetration Testing
04_01-Introduction 5.57 MB 0:03:31 113kbps 105.00 1024x768 14 frames/second 04. Authentication and Logins
04_02-Demo Login Modes 12.8 MB 0:04:24 113kbps 291.00 1024x768 14 frames/second 04. Authentication and Logins
04_03-Authentication and Permission Model 3.88 MB 0:02:16 111kbps 126.00 1024x768 14 frames/second 04. Authentication and Logins
04_04-Demo Principals 24.1 MB 0:06:19 114kbps 418.00 1024x768 14 frames/second 04. Authentication and Logins
04_05-Demo Using SIDs 20.4 MB 0:05:05 114kbps 447.00 1024x768 14 frames/second 04. Authentication and Logins
04_06-Demo Creating Logins 26.0 MB 0:06:50 114kbps 416.00 1024x768 14 frames/second 04. Authentication and Logins
04_07-Demo Password Policies 13.6 MB 0:03:56 109kbps 373.00 1024x768 14 frames/second 04. Authentication and Logins
04_08-Demo Enabling and Disabling Logins and Users 10.4 MB 0:02:59 112kbps 375.00 1024x768 14 frames/second 04. Authentication and Logins
04_09-Demo Changing and Disabling sa 5.93 MB 0:01:39 112kbps 387.00 1024x768 14 frames/second 04. Authentication and Logins
04_10-Conclusion 4.94 MB 0:02:49 113kbps 129.00 1024x768 14 frames/second 04. Authentication and Logins
05_01-Introduction, Permissions 2.36 MB 0:01:25 111kbps 120.00 1024x768 14 frames/second 05. Roles and Permissions
05_02-Principals, Roles, Owners, ... 3.86 MB 0:02:31 111kbps 100.00 1024x768 14 frames/second 05. Roles and Permissions
05_03-What are Securables and How to Assign Permissions 7.13 MB 0:03:58 113kbps 135.00 1024x768 14 frames/second 05. Roles and Permissions
05_04-Fixed Server Roles 3.35 MB 0:01:59 113kbps 121.00 1024x768 14 frames/second 05. Roles and Permissions
05_05-Demo Fixed Server Roles 64.1 MB 0:08:14 116kbps 971.00 1024x768 14 frames/second 05. Roles and Permissions
05_06-Demo Server Permissions 44.8 MB 0:08:00 112kbps 669.00 1024x768 14 frames/second 05. Roles and Permissions
05_07-Demo User-defined Server Roles 48.9 MB 0:07:07 114kbps 845.00 1024x768 14 frames/second 05. Roles and Permissions
05_08-Demo Setting Permissions 44.1 MB 0:08:28 113kbps 612.00 1024x768 14 frames/second 05. Roles and Permissions
05_09-System Database Users 3.91 MB 0:02:42 114kbps 85.00 1024x768 14 frames/second 05. Roles and Permissions
05_10-Database Roles 3.19 MB 0:01:49 113kbps 129.00 1024x768 14 frames/second 05. Roles and Permissions
05_11-Demo Mapping Windows Groups to Database Users 27.0 MB 0:04:07 114kbps 801.00 1024x768 14 frames/second 05. Roles and Permissions
05_12-Summary 4.50 MB 0:02:24 113kbps 146.00 1024x768 14 frames/second 05. Roles and Permissions
06_01-Introduction, What are SQL Injections 6.18 MB 0:03:17 111kbps 149.00 1024x768 14 frames/second 06. Fighting SQL Injections
06_02-Demo Basic SQL Injection Techniques 34.8 MB 0:07:18 115kbps 549.00 1024x768 14 frames/second 06. Fighting SQL Injections
06_03-The Different Types of Injections 18.0 MB 0:06:15 115kbps 284.00 1024x768 14 frames/second 06. Fighting SQL Injections
06_04-Some SQL Injection Tools 2.05 MB 0:01:31 113kbps 73.00 1024x768 14 frames/second 06. Fighting SQL Injections
06_05-Installing and Using SQLMap 43.6 MB 0:07:38 113kbps 684.00 1024x768 14 frames/second 06. Fighting SQL Injections
06_06-Demo Using SQLMap to Perform Injection Against our Server 52.5 MB 0:05:39 111kbps 1187.00 1024x768 14 frames/second 06. Fighting SQL Injections
06_07-How to Prevent Injection 26.7 MB 0:07:37 114kbps 373.00 1024x768 14 frames/second 06. Fighting SQL Injections
06_08-Detecting Common Injection Patterns 24.1 MB 0:05:49 110kbps 468.00 1024x768 14 frames/second 06. Fighting SQL Injections
06_09-Demo Avoiding Dynamic SQL 23.8 MB 0:06:55 106kbps 374.00 1024x768 14 frames/second 06. Fighting SQL Injections
06_10-Ownership Chaining 16.3 MB 0:06:12 109kbps 255.00 1024x768 14 frames/second 06. Fighting SQL Injections
07_01-Introduction 1.04 MB 0:00:39 102kbps 118.00 1024x768 14 frames/second 07. Encryption
07_02-Encryption Keys Symmetric and Asymmetric Encryption 14.1 MB 0:08:29 113kbps 117.00 1024x768 14 frames/second 07. Encryption
07_03-Service and Database Master Keys 13.2 MB 0:05:38 112kbps 215.00 1024x768 14 frames/second 07. Encryption
07_04-Demo Database Master Key 24.5 MB 0:05:16 112kbps 537.00 1024x768 14 frames/second 07. Encryption
07_05-Transparent Data Encryption 21.2 MB 0:07:00 107kbps 315.00 1024x768 14 frames/second 07. Encryption
07_06-Demo Encrypted Backup in SQL Server 2014 13.6 MB 0:03:21 112kbps 456.00 1024x768 14 frames/second 07. Encryption
07_07-Demo Encrypting Data Using a Symmetric Key 36.3 MB 0:07:26 113kbps 567.00 1024x768 14 frames/second 07. Encryption
07_08-Demo Using Asymmetric Keys 13.5 MB 0:03:10 111kbps 483.00 1024x768 14 frames/second 07. Encryption
07_09-Demo Using Certificates 52.3 MB 0:10:08 113kbps 607.00 1024x768 14 frames/second 07. Encryption
07_10-Demo Encrypting Data With Authenticators 43.4 MB 0:07:19 112kbps 714.00 1024x768 14 frames/second 07. Encryption
07_11-Non-reversible Encryption With Hashing 11.9 MB 0:04:01 114kbps 298.00 1024x768 14 frames/second 07. Encryption
07_12-Summary 4.23 MB 0:02:29 107kbps 128.00 1024x768 14 frames/second 07. Encryption
Download File Size:1.27 GB
|
