 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft SQL Server 2000 Programming Part 1
Course Aims
This course along with our "Microsoft SQL Server 2000 Programming Part 2" course will introduce readers to the major topics of building database applications with Microsoft SQL Server 2000. The key focus of the course is on server database design and implementation using SQL Server 2000, but it also covers some client development - including Access 2000's ADP format, Visual Basic using ADO, and ASP with XML. The course will help readers to design and implement a server-side database, implement all the tables and indexes, implement server-side validation through rules and triggers and to build stored procedures to put complex parts of the application server-side. Three different client platforms - Access 2000, Visual Basic and Front Page - are used to build front-ends for the application. |
Assumed Knowledge
A good working knowledge of the 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
This course has been created for readers who are using or planning to use SQL Server 2000 in their applications or who wish to take the Microsoft Certified Professional exam for SQL Server. It should be useful both to people that are new to SQL Server and to those who have experience with an earlier version. |
|
Table of Contents
|
SQL Server Feature Overview and History
|
What is Microsoft SQL Server 2000?
|
|
Client/Server Architecture
|
|
Microsoft SQL Server ~ A Brief History
|
|
The Sybase-Ashton Tate-Microsoft Deal
|
|
The Sybase-Microsoft split
|
|
Microsoft SQL Server 7.0 ~ "The Defining Release"
|
|
Microsoft SQL Server 2000 ~ "The Intended Release"?
|
|
Relational Database Enhancements
|
|
XML Integration of Relational Data
|
|
Graphical Administration Enhancements
|
|
Data Transformation Services Enhancements
|
|
What's New in Analysis Services
|
|
What's New in Meta Data Services
|
|
What's New in English Query
|
|
|
|
Data Storage Management
|
Creating Databases and Logs
|
|
Create New Databases Through Enterprise Manager
|
|
Creating Fault Tolerance Databases
|
|
Use Templates to Create Databases
|
|
Script a CREATE DATABASE Command
|
|
What Happens When you Create a Database?
|
|
How SQL Server Stores Data
|
|
Manage Database Availability
|
|
Upgrade Access MSDE Files to SQL Server
|
|
Database Collation Options
|
|
|
|
Tables with Integrity
|
Designing Tables with the Database Diagram
|
|
Creating a New Database Diagram
|
|
Generating Database Scripts
|
|
Creating Tables Through Enterprise Manager and the Basic CREATE TABLE Syntax
|
|
SQL Server Built-in Data types
|
|
Creating and Using User-Defined Data Types
|
|
Adding and Dropping Datatypes
|
|
Using Column-Level Collations
|
|
|
|
Transact SQL Queries
|
What is SQL and Transact SQL?
|
|
Standard SQL Command Groupings
|
|
Transact SQL Built-In Functions
|
|
Numeric and Date Functions
|
|
|
Management of Indexes
|
Clustered Versus Non-Clustered Indexes
|
|
Using Composite Indexes to Cover Queries
|
|
The Distribution Page and UPDATE STATISTICS
|
|
Using FILLFACTOR Correctly
|
|
|
|
|
Views
|
|
|
Transactions
|
How Data is Changed in SQL Server 2000
|
|
Inserting and Copying Records
|
|
Transaction Processing Commands
|
|
|
|
Programming with Transact SQL
|
The Query Analyser as a Programming Environment
|
|
Using the Object Browser and Templates
|
|
Transact SQL Batch and Script Rules
|
|
Control of Flow Statements
|
|
Global Variables (System Functions)
|
|
Using the EXEC() Function
|
|
|
|
Stored Procedures
|
SQL Server 2000 Query Caching & Related Features
|
|
Uses for Stored Procedures
|
|
Creating Stored Procedures
|
|
Returning Values and Updating Parameters
|
|
Compilation Problems and Methods
|
|
Temporary Procedures and AutoStart Procedures
|
|
|
|
User-Defined Functions
|
In-Line Table-Valued Functions
|
|
Multi-Statement Table-Valued Functions
|
|
Creating System Functions
|
|
|
|
Using Triggers
|
Basic Trigger Assumptions and Syntax
|
|
Improving Trigger Performance
|
|
Checking the Number of Rows Affected
|
|
|
|
|
|
