xyz軟體王

TIC3080--SQL達人的工作現場攻略筆記 PDF電子書 一本告訴您如何正確編寫與思考SQL的書籍 繁體中文版
DVD27695--72節課：跟李銳學Excel 從入門到精通 中文教學版(DVD一片裝)
DVD27696--Docker與微服務實戰 2022版 中文教學版(DVD一片裝)
DVD27697--零基礎玩轉Linux+Ubuntu實戰視頻課程 MP4格式 中文教學版(DVD一片裝)
DVD27221--15堂占星入門全攻略：探秘占星師 開啟有錢有趣又有閒的迷人職業 MP4格式 中文教學版(DVD一片裝)

軟體簡介:

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