Using Microsoft SQL Server 7.0

Course Objectives: This course introduces the functions of Microsoft SQL Server 7.0 and familiarizes students with its development environment for multiple users' concurrent access to the data base.

Course Outlines:
Developing Application with ODBC API
ODBC Architecture Review
Configuring an ODBC Data Source
Developing Applications with RDO, OLE DB and ADO
Overview RDO, OLE DB, ADO Architecture
Adding RDO Objects to Visual Basic
Using RDO Objects with Visual Basic
Adding ADO Objects with Visual Basic
Using ADO Objects with Visual Basic
Locking
Row-Level vs. Page-Level Locking
Concurrency and Consistency Tradeoffs
Resolving Blocking Problem
Resolving Deadlock Problems
Creating Useful Indexes