SQL Server 2014, Part 5 of 9: Security Basics

The SQL Server 2014: Security Basics course will show you the basics of SQL Server security by giving you an understanding of potential data threats and how SQL Servers design protects against them. You will then learn about SQL Server and Windows integrated authentication. Then see how SQL Server provides an authorization system to control access to data and objects.

Lesson 1:

• Security Overview
• The Threats
• Security Design Philosophy
• The Two Stages of Security
• Key SQL Server Security Terms.

Lesson 2:

• Authentication
• Integrated Authentication
• Security Settings
• Demo: Server Authentication
• Demo: Setting Validation
• Demo: Adding a User As a Login
• Demo: Assigning Permissions
• Demo: Adding Users Via Script.

Lesson 3:

• Demo: Create SQL Login
• Windows and SQL Server Logins
• Beware of the sa Login
• Password Policy & Enforcement
• Demo: Account Policies
• Demo: Login Properties.

Lesson 4:

• Database Authentication
• Demo: How to Enable Contained Databases
• Demo: Change Authorization
• Contained DB Authentication.

Lesson 5:

• Authorization
• Principals
• Fixed Server Roles
• Demo: Assigning a Login
• User-Defined Server Roles
• Demo: Create a New Server Role
• Fixed Database Roles
• Demo: Add a Back-up Operator
• The Public Role
• The dbo (Database Owner) Role
• User-Defined Database Roles
• Demo: Create a Database Role
• Securable Objects.