Explain the different security modes available to Microsoft SQL Server. Create Windows NT accounts and Windows NT groups. Implement security using Windows NT and SQL tools. Create a simple stored procedure. Call a stored procedure from Visual Basic code. Debug a stored procedure. Create SQL stored procedure variables. Write SQL control-of-flow statements for stored procedures. Embed SQL tranactions in stored procedures. Write SQL stored procedures for passing arguments and accepting return values
Unit 1: Implementing Data Security
- Security Mechanisms
- SQL Server Security Modes
- Windows NT Logons and Groups
- Using SQL Security
Unit 2: Introduction to Stored Procedures
- Overview of SQL Stored Procedures
- Integrity Checking
- Using Stored Procedures
Unit 3: Advanced Stored Procedures
- Programming SQL Variables
- Using Control-of-Flow Language
- SQL Transactions
- Creating Stored Procedures