 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft SQL Server 7.0 Programming Part 2
Course Aims
This intensive course is designed to introduce new MS SQL developers to some of the more advanced features and facilities of this software. To encourage confidence, control and creative use of MS SQL by taking a structured look at some of the more advanced functions. To help developers plan their applications systematically, efficiently and economically and to promote good design and development techniques. |
Assumed Knowledge
The readers should have worked through the "Microsoft SQL Server 7.0 Programming Part 1" course. They should also have a good working knowledge of the MS SQL interface, table creation, basic query and report writing functions, macro development and relational database concepts gained from practical experience in developing simple applications with another RDBMS is assumed. Previous programming experience is essential. |
Course Audience
New, recent or intending MS SQL developers who need an in-depth understanding of the programming features available in this RDBMS software product. |
|
Table of Contents
|
Writing Stored Procedures
|
Uses for Stored Procedures
|
|
Reducing Locking Problems
|
|
Structuring your Application
|
|
Create Procedure Statement
|
|
Modifying Existing Stored Procedures
|
|
Creating Procedures Through Enterprise Manager
|
|
Returning Values and Updating Parameters
|
|
Compilation Problems and Methods
|
|
Temporary Procedures & AutoStart Procedures
|
|
|
|
Implementing Triggers
|
Basic Trigger Assumptions and Syntax
|
|
Improving Trigger Performance
|
|
Checking the Number of Rows Affected
|
|
|
|
SQL Server 7.0 Development - Server-Side
|
DMO Overview; Connecting to SQL Server
|
|
Creating Databases Through DMO
|
|
|
|
Microsoft SQL Server - Client Side Development
|
Client-Side Development - Choosing the Appropriate Tool
|
|
Using Access & the Upsizing Tool
|
|
Using Access as a Prototyping & Development Tool
|
|
Upsizing from Access to SQL Server
|
|
Modifying Upsizing Tool Settings
|
|
Using the Access Upsizing Tool
|
|
What the Upsizing Tool Does
|
|
How the Upsizing Tool Creates Primary Key Indexes
|
|
Troubleshooting the Upsizing Tool
|
|
Post-Upsizing Considerations
|
|
Rapid Application Development with Access
|
|
Using Visual Basic Programming Access through VBA
|
|
|
|
Simple Client-Side Development with JET & DAO
|
Why Use JET & Data Access Objects (DAO)
|
|
Strengths & Weaknesses of JET
|
|
The Data Access Objects Model
|
|
Connecting Through DAO Programmatically
|
|
Importing SQL Server Data for Local Seeking
|
|
Importing Data through DAO
|
|
Creating Indexes through SQL
|
|
Compacting the Jet Database
|
|
Getting at Data Through Recordset Objects
|
|
Navigating Through a Recordset
|
|
Editing Data in a Recordset
|
|
Handling SQL Server Errors on the Client
|
|
Bypassing ODBC with Pass-Through Queries
|
|
|
Using Remote Data Objects & ODBC Direct
|
The Remote Data Object Model
|
|
|
|
Using ActiveX Data Objects
|
The ActiveX Data Object Model
|
|
|
|
Generating Web Pages Automatically From SQL Server 7.0
|
Static Web Pages - a HTML Primer
|
|
Generating Web Pages from SQL Server
|
|
|
|
|
|
