Layout Table~~~~3512~3512~~

6 Sessions - 18 Hours of Interactive Training~
LearnKey’s Visual Basic with SQL Server 2000 for Developers training course will teach experienced Visual Basic developers the conceptual understanding and practical skills required for building successful database applications with Visual Basic and SQL Server. Experts Andy Baron and Mary Chipman teach you how to write stored procedures on the server, how to build maintainable middle-tier objects in Visual Basic, and how to marshal data using ADO recordsets or XML. At the conclusion of this training course, you will understand how to build scalable and maintainable n-tiered applications that work efficiently with SQL Server.

Prerequisites: Previous programming experience and some knowledge of Visual Basic helpful.

Benefits
• Increase your earning potential and technical credibility.
• Enhance employment opportunities with in-demand web development knowledge.
• LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner. .~~~3512~3513~~

Course Outline Table~~~~3512~3514~~

Session 1~Section A: Database Applications
· Introduction to Database Applications
· Common Needs
· The Basic Tiers
· Tier Organization
· Marshalling Data Between Tiers
· HTTP/XML Marshalling
· HTTP/XML Marshalling (long)
· "Reach" vs. "Rich"
· N-Tier is Component-Oriented
· Tools for Building N-Tier Applications
· Advantages of N-Tier Component Design

Section B: Data Tier
· Enterprise Manager
· Shark Database
· Stored Procedures
· "Created" Procedures
· Query Analyzer

Section C: VB Middle Tier
· Prerequisites
· Project Group
· Form Helper
· Methods
· Data Access Helper
· Connection String
· ADO & OLEDB
· Tread Lightly
· Handling Errors
· Get Order Details

Section D: Presentation Tier
· Combo Box Wrapper
· Item Data
· No Selection
· Advantages of Combo Wrapper
· Efficient Data Access
· Keeping Track of Forms

Section E: Know Your Server
· The SQL Server Engine
· Data Storage
· Security
· Security Roles
· Create New Login
· Permissions
· Built-in Accounts~~~3512~3515~~

Session 2~Section A: Web Services in ASP.NET
· Evolution of Web Services
· Web Service in Visual Studio
· Creating a Web Method
· Test the Web Service

Section B: Working with WebForm Controls
· Setting Attributes
· Adding Additional Labels
· View Solution Explorer
· View Client Source
Section C: Simple Input Controls
· TextBox Controls
· CheckBox Controls
· RadioButton Controls
· Group Name Property
· Button & Hyperlink Controls
· Setup Hyperlink
· Button Controls
· Linkbutton Controls
· Image Control

Section D: List Controls
· Add List Items
· Add Items Code
· Handling Selections & PostBacks
· Clear Selection
· Remove Items

Section E: Types of Validation Controls
· Validation Process
· Validation Messages
· Client-Side Validation
· Range Validations
· Custom Validations
· Expression Validations
· Validation Properties
· Multiple Validators
· Client-Side Validation
· JavaScript Validator

Section F: Simple Validation Controls
· RequiredFieldValidator
· View RequiredField Source
· Initial Value Property
· Display Property
· Range Validator Control
· Compare Validator
· Compare Type Properties

Section G: Complex Validation Controls
· Regular Expression
· Regular Expression Editor
· Regular Expression Library
· Custom Validator Control
· Server-Side Validation
· Client-Side Validation
· Validation Summary Control~~~3512~3516~~

Session 3~Section A: Action Stored Procedures - Updating Data
· Handle Data Conflicts
· Update Procedure
· Validate Input
· Start Transaction
· Create or Delete Stored Procedure
· Error Checking

Section B: VB Data Tools & Debugging
· Data Environment Cons
· Create Data Link
· Data View Window
· Working with Database Diagram
· Create New Table
· Create Stored Procedures
· Procedure Creation
· Debug Stored Procedures
· Using the Debug Tool
· Complex Procedure in Debug Tool
· Fixing Code
· Check Fixes
· Fixing Table in Query Analyzer

Section C: Using ADO with SQL Server
· Create Recordset
· Set Active Connection
· Statelessness
· Source & Open
· Close Recordset
· Error Handling

· Append
· Stored Procedures as Methods
· Security
· UDL
· By-Ref Parameters

Section D: ADO Stored Procedure Add-In
· Register
· Documentation
· Reference
· Insert Stored Procedure
· Add Variables
· Add Payment Method~~~3512~3517~~

Session 4~Section A: Interfaces & Co-Classes
· Exploring the Group
· Exploring the Code
· Visual Basic & COM+
· Stateless Method Calls
· Concrete Class
· Using Implements & Private Function
· Project Properties
· Add New Project to Class
· Plan for Scalability

Section B: Using a Database to Support Polymorphism
· Create SQL Table
· SQL Code Explanation
· ADO Recordset

Section C: Versioning By Adding Interfaces
· Add Project/Interface
· Planning for Backwards Compatibility
· Code for New Interface
· Test the Project
· Troubleshoot & Fix the Project

Section D: Extending Combo Box Functionality
· Combo Wrapper Class
· Using the Combo Box
· Combo Box Events
· Code for Combo Box
· Code for List in Box
· VB & Windows API
· ItemData vs. ListIndex
· Code to Create Object
· Recordsets
· Bind Records to Combo Box
· Combo Wrapper Code
· Create Custom Event~~~3512~3518~~

Session 5~Section A: Using the Combo Wrapper
· Forms & Hidden Controls
· Code for Adding Data to Box
· Enumerating
· Store Data Locally with XML File
· Recordset Types

Section B: Hierarchical FlexGrid
· Load Order Button Code
· Concurrency ID
· Handling Data Changes
· Setting Up the FlexGrid
· Working in the FlexGrid

Section C: Searching for Records
· Search in Shark
· Design View
· Stored Procedure
· Procedure Code
· Dynamic SQL
· Table Sort
· Handling Parameters

Section D: Overlaying Controls on MSHFlexGrid
· Working in the Grid
· Saving Changes
· "Dirty" Forms
· Error Handling
· Middle Tier Object
· Build String from Order Details
· Reload Form
· Keeping the Display Straight
· IsNew & IsDirty
· Captions (States)
· Adjust Display
· Fix Up Grid
· Alignment
· Grid
· Tab Router
· Tab Router Code~~~3512~3519~~

Session 6~Section A: Overview of COM+
· Windows NT4
· Windows 2000
· Security Concepts
· User Account
· Securing Objects
· Creating Middle Tier Objects
· In-Process vs. Out-of-Process
· Testing

Section B: Moving the Middle Tier to COM+
· Component Services Manager
· Install Wizard
· Components
· Configuring COM+
· Roles
· Role Security
· Activate Role Security
· Add Users & Groups

Section C: Testing COM+ Security
· Project References
· Test as Administrator
· Test as Mary

Section D: Client Deployment
· Export Wizard
· VB Package & Deploy Wizard
· Create Client Package
Section E: HTTP/XML
· HTTP
· XML
· Defining XML Grammars
· Using a Local Web Page
· Example of Attribute XML
· Example of Object XML
· Advantages of HTTP/XML
· Clients & Configuration
· Stateless/Load Balancing

Section F: HTTP/XML Technology Options
· Active Server Pages
· MSXML
· SOAP
· SQL 2000
· Annotated Schemas

Section G: Building an XML-Based Middle Tier
· SQL Support for XML
· Setup Virtual Directory
· Retrieve Data Over HTTP
· FOR XML AUTO/RAW
· XML Template for SQL Server
· Using Parameters
· XSL Stylesheet & XML
· VB Using XML~~~3512~3520~~

Ordering~~~~3512~3521~~

Visual Basic with SQL Server 2000 For Developers Training Course by LearnKey~Per Seat Licencing Available

Call 01223 894 136 for quotes for MULTIPLE USERS and Training Centre/Bootcamp & Education Solutions!~~PER USER%3A CD Course|440628|PER USER%3A ONLINE Course|!78833|LIBRARY LICENCE%3A CD Course|440625|~3512~3522~N+ exam certification~