 |
|
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 1
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
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 7.0 Overview and History
|
Relational Database Overview
|
|
Organising Data into Tables
|
|
Client/Server Architecture
|
|
|
|
Data Storage and Management
|
Mapping of Databases onto Disks
|
|
SQL Server Files and File Groups
|
|
Using Striped Sets for Data Devices
|
|
How Data is Organised within Files
|
|
Creating Databases and Logs
|
|
Post-Installation Databases
|
|
Creating New Databases through Enterprise Manager
|
|
Creating a Database using Transact SQL
|
|
Using FileGroups to Position Objects
|
|
Positioning Tables and Non-Clustered Indexes
|
|
|
|
Programming With Transact SQL
|
Creating Tables through Enterprise Manager & the Basic CREATE TABLE Syntax
|
|
SQL Server Built-In Data Types
|
|
PRIMARY KEY & FOREIGN KEY, CHECK & DEFAULT Constraints
|
|
Creating and Using User-Defined Data Types
|
|
Adding and Dropping Datatypes
|
|
Legacy Rules and Defaults
|
|
Creating Rules Through Transact SQL
|
|
Creating Defaults Programmatically
|
|
|
|
Importing and Exporting with DTS & Linked Servers
|
BCP The Lowest Common Denominator
|
|
When to Drop Indexes on BCP
|
|
Copying To/From a Temporary Table
|
|
Using Backup & Restore to Transfer Databases
|
|
Data Transformation Services
|
|
DTS Import / Export Wizards
|
|
Querying MS SQL Server 7.0 Tables
|
|
Standard SQL Based on Set Theory
|
|
Standard SQL Command Groupings
|
|
Retrieving Data with SELECT
|
|
Selecting and Ordering Fields
|
|
Including Lateral Values, Calculations & Expressions
|
|
Generating Alternative Headings
|
|
Transact SQL Built-in Functions
|
|
Fully Qualified Table Names
|
|
TOPn [PERCENT} [WITH TIES]
|
|
On-Line Analytical Processing (OLAP) SQL Extensions
|
|
Effect of the WHERE Clause in a GROUP BY Query
|
|
Restricting Summary Rows Returned
|
|
The Importance of Rules and Using Sub-Queries
|
|
Correlated Sub-Queries and Their Uses
|
|
Correlated Sub-Queries in the SELECT Statement
|
|
Inserting and Copying Records
|
|
Inserting into Tables with IDENTITY Columns
|
|
Copying Data to an Existing Table with INSERT SELECT
|
|
Copying Data to a New Table with SELECT INTO Statement
|
|
Changing and Removing Existing Records;
|
|
Using SQL Server Join Syntax
|
|
|
SQL Server 7.0 Views
|
Create & Access Limitations
|
|
|
|
Management of Indexes in SQL Server 7.0
|
Types Performance Improvement
|
|
Clustered v. Non-Clustered
|
|
Clustered Indexes and Primary Keys
|
|
Primary Indexes on Identify Columns
|
|
The Distribution Page and UPDATE STATISTICS
|
|
Using FILLFACTOR Correctly
|
|
|
|
Management of Locking and Transactions
|
Transaction Processing Commands
|
|
Optimiser Hints Affecting Locking & Locking Optimiser Hints
|
|
Setting Transaction Isolation Level
|
|
Setting Programming with Transact SQL
|
|
Transact SQL Batch and Script Rules
|
|
Control of Flow Statements
|
|
Scrolling using SQL and Variables
|
|
Updating Data Through Cursors
|
|
|
|
|
|
