 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft SQL Server 6.5 Programming
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; to promote good design and development techniques. |
Assumed Knowledge
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
|
SQL Server 6.x Feature Overview and History
|
Creating Databases and Logs
|
|
Optimal Placement of Data and Logs
|
|
Managing Growth of Data and Log Space
|
|
|
|
Tables and Constraints
|
Creating Tables through Enterprise Manager
|
|
Primary Key, Foreign Key and Check and Default Constraints
|
|
|
|
SQL Server Data Types
|
Creating and Using User-Defined Data Types
|
|
BCP the Lowest Common Denominator
|
|
|
|
Transfer Manager
|
Using Access to Transfer Data
|
|
Setting up Databases for Distributable Media
|
|
|
|
Transact SQL
|
Basic Select Statement and the Where Clause
|
|
Transact SQL Built in Functions
|
|
Summary Queries and Sub-Queries
|
|
|
|
Copying and Inserting Records
|
Changing Existing Records and Removing Records Management of Indexes in SQL Server
|
|
Clustered versus Non-Clustered Indexes
|
|
Creating Indexes and Composite Indexes
|
|
Problem Solving and Surrogate Keys
|
|
|
Programming Basics
|
Transact SQL Batch and Script Rules
|
|
Transaction Processing Commands
|
|
Using Variables and Global Variables
|
|
Control of Flow Statements
|
|
Temporary Tables and the EXEC() Function
|
|
|
|
|
Stored Procedure
|
|
|
The Create Procedure Statement
|
The Create Procedure Statement
|
|
|
|
Compilation Problems and Methods
|
Returning Values and Updating Parameters
|
|
Temporary Procedures and AutoStart Procedures
|
|
|
|
Writing Triggers
|
Basic Trigger Assumptions and Syntax
|
|
Checking the Number of Rows Affected
|
|
|
|
SQL 6.0 Development - Server Side
|
Adding to the Devices Collection
|
|
|
|
|
|
