|
Provided by: Serebra Learning Corporation Visual Basic 6 0 Advanced Enterprise Client Server Dev Part IMicrosoft Visual Basic (VB) |
 |
Training
Provided by Serebra Learning Corporation
This course discusses database security implementations to aid a developer in correctly programming components that access data without compromising security. The different security modes available to Microsoft SQL Server 7.0 and previous versions of SQL Server are explained, as well as their respective advantages. It also explains creating Windows NT accounts and user groups. This course discusses the merits of using SQL stored procedures for business services and data integrity checks. It describes how to create, write, and debug stored procedures, as well as how to call them from Visual Basic code. Finally, this course discusses how to create SQL stored procedures for passing arguments and accepting return values. It also explains how to write SQL control-of-flow statements and embed SQL transactions in stored procedures.Related Exam: Microsoft Exam #070-175: Designing and Implementing Distributed Applications with Visual Basic 6.0. This course is designed for intermediate to advanced Visual Basic application programmers.
|
|
||||||||||
Visual Basic 6 0 Advanced Enterprise Client Server Dev Part I
Audience
This course is designed for intermediate to advanced Visual Basic application programmers.
Topics
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 Stor
Objectives
Upon completion of this course, the student will be able to: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
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1, 825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
