Implementing Security for SQL in C# .NET Applications

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number

---

Overview/Description
To determine how to secure SQL connections, select the most appropriate strategy to protect against SQL injection attacks, and handle user input using various validation and error handling techniques

Target Audience
All organizations, businesses, or individual .NET application developers desiring to learn how to develop and implement secure applications

Prerequisites
Ability to develop applications in C# .NET, knowledge of Web Services, and a broad knowledge of the .NET Framework

Expected Duration (hours)
2.8

Lesson Objectives

Implementing Security for SQL in C# .NET Applications

identify best practices for securing SQL connections.

connect to SQL Server using different modes of authentication.

determine how to secure SQL connections, given a scenario.

recognize behaviors that put databases at risk of SQL injection attacks.

identify ways to reduce the risk of SQL injection attacks.

determine the most appropriate strategy for protecting against SQL injection attacks in a given scenario.

apply appropriate techniques for validating SQL user input in C# .NET applications in given situations.

handle SQL errors and exceptions.

implement SQL data validation and error handling techniques.

Course Number:
230980_eng