CS X402 - Securing Databases
Validation error
You must correct the following errors to continue:
Course Description
This course consists of two parts, database security principles and the most common security vulnerabilities faced by databases today, and an introduction to building secure applications in SQL Server. You begin with the study of principles and practices of implementing computer database security in modern businesses and industries, including:
- database security principles
- database auditing
- security implementation
- database reliability
For the second part of the course, you will learn how to protect databases, and preserve the integrity of an organization's data by configuring the security settings in SQL Server. 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.
Learner Outcomes
- Describe and determine database security requirements
- Implement basic database security
- Discover basic security configuration issues
- Build secure applications in SQL Server
- Configure authentication in Azure AD
- Assign user roles and privileges
- Build custom roles
- Create contained users
- Protect SQL Server from injection
- Identify vulnerabilities
- Write strong procedures
- Check inputs
- Use dynamic parameterization
- Encrypt network connections
- Secure linked servers
- Configure firewalls
Prerequisites
Instructors
Applies Towards the Following Certificates
- Applied Cybersecurity : Required
- Applied Cybersecurity Fundamentals : Required