SQL Server: Security for Developers

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.

Learning objectives
Building secure applications in SQL Server
Configuring authentication in Azure AD
Assigning user roles and privileges
Building custom roles
Creating contained users
Protecting SQL Server from injection
Identifying vulnerabilities
Writing strong procedures
Checking inputs
Using dynamic parameterization
Encrypting network connections
Securing linked servers
Configuring firewalls