Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Provider Logo

SQL Server: Security for Developers

via LinkedIn Learning

Overview

Learn how to protect databases and preserve the integrity of an organization's data by configuring security settings in SQL Server.

Learn how to protect databases and preserve the integrity of an organization's data by configuring the security settings in SQL Server. This course covers how to use built-in options on Microsoft platforms, including Azure AD, to secure database and network infrastructure. Learn about establishing users, assigning roles, and granting privileges. Find out how to prevent SQL Server from malicious injection by addressing vulnerabilities. Discover how to encrypt data at rest and in-transit. See how to build a robust security model for your applications. Additionally, learn how to encrypt connections and secure a network.

Syllabus

Introduction
  • Build secure applications in SQL Server
  • Course software
1. Roles and Privileges in SQL Server
  • Logins and users
  • Azure AD and SQL authentication
  • Demo: Create a user in SQL Server
  • Roles and privileges overview
  • Least privileges principal
  • Building custom roles in SQL Server
  • Demo: Building custom roles
  • Predefined roles in SQL Server
  • Roles in Azure SQL Database
  • Contained users and their benefits
  • Demo: Contained users
2. SQL Injection
  • Overview of SQL injection
  • SQL injection vulnerabilities
  • Writing proper SQL procedures
  • Demo: Stored procedures vs. dynamic SQL
  • Dynamic SQL and input checking
  • Demo: Dynamic SQL parameterization
  • External protection around SQL injection
3. Securing Your Network
  • Network security
  • Encrypting connections to SQL Server
  • TLS 1.0 vs. TLS 1.2
  • Upgrading TLS with SQL Server
  • Linked server security
  • Demo: Linked servers
  • Azure SQL Database firewalls
  • Demo: Azure SQL Database firewalls
Conclusion
  • Next steps

Taught by

Joey D'Antoni

Related Courses

Reviews

0.0 rating, based on 0 reviews

Start your review of SQL Server: Security for Developers

Never stop learning Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free