Client-Server
Concepts
Client-server
architecture | Cursors
| Concurrency & locking | Transactions & referential integrity
| Validation techniques | Stored procedures | Batch updates
Overview
of SQL Server
Devices
& databases | Stored procedures | Transact-SQL
Visual
Basic 6 Database Tools
Data
Link window | Data Environment | Transact-SQL
Accessing
SQL Server from VB
Overview of ADO, DAO and RDO | ODBC | OLE DB | ActiveX Data
Objects (ADO)
ActiveX Data Objects (ADO) In Depth
The ADO object model | Connection, Recordsrt, Command,
& Field objects | The ADO event model | Dealing with errors
| Hierarchical recordset | Disconnected recordsets & RDS
(Remote Data Services)
Server-Side
Programming
Creating
stored procedures with Transact-SQL | Implementing triggers
| Declarative
referential integrity | The transact-SQL Debugger
Client-Side
Programming
Connecting
to the server | Data maintenance | Client-side validation
| Handling stored procedures: input & output parameters,
return codes | Batch updates | Concurrency & locking issues
| Error handling
Creating
Business Objects & Servers
Splitting
up a "traditional" application | The Presentation, business
& data services tiers | Designing classes - properties &
methods | Implementing in-process & out-of-process services
| Creating the "business server" | COM & DCOM performance
issues | Distributing objects with DCOM
Microsoft
Transaction Server (MTS)
MTS
concepts | Implementing a server in MTS
