xyz軟體王

AppDev Visual Basic and SQL Server 2000 英文光碟正式版 (6片裝)

軟體簡介:

AppDev Visual Basic and SQL Server 2000 英文光碟正式版 (6片裝)


AppDev是一家相當有名的教育光碟出版公司，而這片教學光碟所要介紹的就是如何
利用搭配微軟Visual Basic 與SQL 2000 搭配來建立或是設計你的資料庫的應用程
式，這已經是現在時下最盛行的建置方法之一，因為現在使用資料庫應用程式已經
是一個既定的模式了，而搭配市場佔有率最高的MS SQL Server 2000是使用Visual
Basic 設計的唯一也是最佳的組合。

This course teaches programming with SQL Server 2000. You’ll learn the
fundamentals of how to write code to work with SQL Server 2000 and ActiveX
Data Objects (ADO). This course also focus on building client/server
applications. You’ll learn how to build true middle-tier applications
that scale up to the Web.

SESSION 1 (103 min)
N-Tier Architecture
Building N-Tier Applications
Exploring the Shark Application
SQL Server Essentials
Know the Server

SESSION 2 (108 min)
SQL Server Essentials (cont.)
Database Design
Understanding Transactions
Intelligent Indexing
Monitoring Performance
Stored Procedures and Functions
Using Stored Procedures and User-Defined Functions
Data Retrieval
Action Stored Procedures

SESSION 3 (104 min)
Stored Procedures and Functions (cont.)
More on Action Stored Procedures
Visual Database Tools
Using the Visual Basic Data Tools
The Data View Window
Debugging Stored Procedures
The Middle Tier
Using ADO with Stored Procedures
Using the ADO Stored Procedure Add-In

SESSION 4 (100 min)
The Middle Tier (cont.)
Using Interface Classes
Displaying Data in the Presentation Tier
Data Binding Options
Extending Combo Box Functionality

SESSION 5 (109 min)
Displaying Data in the Presentation Tier (cont.)
More on Extending Combo Box Functionality
Using Local Storage for Lookup Data
Presenting Transactional Data
Searching and Paging
Searching for Records
The Stored Procedures
Editing Data in the Presentation Tier
Building Data Entry Applications
Working with the MSHFlexGrid Control
Creating a New Order
Handling Multi-User Editing
Deleting Orders
Managing Form State
Allowing Users to Tab Through the Grid

SESSION 6 (117 min)
Deploying Components with COM+
Overview of COM+
Configuring a Middle Tier DLL under COM+
Configuring Components in COM+
Deploying the Completed Application
Marshaling Data as XML Over HTTP
A Quick Overview of HTTP and XML
XML Examples
Building an XML-Based Middle Tier
Outlines are subject to change