VTC Microsoft SQL Server tutorials and training courses via the online university, master this application in days fast learning and cost effective

Please select your country

Online Adobe Photoshop CS Tutorials
Macromedia Dreamweaver Training and Tutorials

			Microsoft SQL Server tutorials

Microsoft SQL Server 7.0 Tutorials

Microsoft SQL Server 7.0 Tutorials
Author Name		Mike Haines
Total Movies		67
ISBN		1930519400
Duration		6.5 Hours

Try before you buy

Click on any movie link in the first 3 chapters, to watch a free demo

To allow faster streaming over the web the sound and video quality has been reduced, this ensures faster download

The quality of the movies on the CDs is much better.

Please ensure that you have downloaded and installed the Apple QuickTime Plugin if needed, this is required to play the tutorial movies. If you are experiencing any problems please contact tech support . All our CD Tutorials and Online Moives are produced by expert authors and trainers, we try to design the content to represents problems that you would encounter in a real work environment. As a customer we value your comments and depend on your feed back to improve our products

Mirosoft's SQL Server 7 is the data management and analysis solution for the agile business. It is the fastest way to deliver enterprise database solutions for the Web. Allow Mike Haines to explain the basic concepts of SQL Server 7 in this Virtual Training Company tutorial. He guides you through scripting tables and databases, creating schema diagrams, and running queries. He uses working examples to show you how to work with triggers, and much more. You can start learning right away by clicking one of the chapters below.

The links below are free Microsoft SQL Server tutorials The entire contents may be purchased either on CD or watched via the Online University

Concepts
Concepts
EnterPriseManager
QueryAnalyser
Stop_StartServices
Databases
NT Integration andServices
Wizards and Help

Databases
CreateDB
Database Objects
Fixing Up the Column
Database Files/Options
Scripting a Table
Scripting a Database

Creating and Managing Tables
Table Design Intro
Defaults-What the User Sees
Creating a Child Table
Creating Schema Diagrams
Primary Key
Unique Constraint
Foreign Keys
Disabling Constraints
Many to Many
Invoice Detail Table

Query Analyser
Running Queries
Referring to Objects

Meta Data
SysTables
Sys StoredProcedures
Information Schema Views

VIEWS
Views an Intro
Creating a View
Using a View in Access
With Encryption
Views and DML
Views and Security

Stored Procedures
Stored Procedures an Intro
Creating a Stored Procedure
Executing a Stored Procedure
Input Parametres and Security A
Input Parametres And Security B
Passing By Reference or Position
OutPut Parametres
In and Output Parametres
Using the RETURN Keyword
Error Messages
@@error Function

Data and Queries
Inner and Outer Joins
Tempory Tables
Updating
Nested twice

Triggers
Triggers an Intro
Working Examples A
Working Examples B
Code Slices A
Cdoe Slice B
Code Slice C
Code Slice D
An Update Trigger

SQL and Visual Basic
Chapter Intro
Making a connection A
Making a Connection B
Populating a Control
Stored Procedure Calls A
Stored Procedure Calls B
Trusted Connections Via DSNs
Trapping Errors A
Trapping Errors B
Roles
Using Roles in VB

Macromedia Dreamweaver Illustrator Macromedia Flash Macromedia Freehand Mac OS X PHP MySQL PageMaker 7 3D Studio Max Digidesign Pro Tools Macromedia Fireworks

List all tutorials Graphic and page layout Internet and Web Design Animation and 3D Multimedia and Video Operating Systems Business Applications Programming

All our titles play on PC or Mac, the application does not need to be installed on the system for our program to be used. Our products are being used in distance learning applications by large companies, Banks, Schools, Colleges and Universites. To get the best out of our product you may wish to down load the movie / video player, Apple QuickTime is also required. Online Tutorials and training courses