Microsoft SQL Server 2000 Programming Tutorials

Details

Highly Effective Microsoft SQL Server tutorials on video CD, learn from your own desk at a pace that suits you. Low cost high quality training at an affordable price. Works on PC and Mac.

 

Macromedia Dreamweaver MX2004 Tutorials Adobe Photoshop video Tutorials
Close
Microsoft SQL Server Training CD / DVD Contents
Professionally created, comprehensive training that's easy to follow at an unbelivable price.

See the quality for yourself. Try a FREE Demo.

The blue links below are Free Microsoft SQL Server Tutorial Videos.

Try for FREE - NOW
To help you evaluate this training CD / DVD the first 3 chapters are available for free, click on any of the links below for a FREE DEMO.

Read before watching the free videos
The sound quality and frame rate of free online tutorials has been reduced to allow for faster streaming. The quality on CD / DVD is far higher.
Quicktime
*QuickTime is needed to view the videos. Some titles have been converted to play via Flash.
SQL Server Overview Course Intro Demo
SQL Server Terminology Demo
SQL 2000 & Windows 2000 Demo
SQL 2000 Features Demo
SQL Applications (2/3/n Tier) Demo
Transact SQL Demo Course Description Course Description Demo Logical Data Modeling Logical Database Design Demo
Naming Conventions Demo
Normalization Demo
Logical Layers Demo
Accessing Data Demo
We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.
$99.95
Creating a Database Creating a Database
Database Parameters
Data File Placement
Creating Tables
Data Types Explained
Data Types Used
NULLS
Altering Tables
Generating Values
Generating Scripts Data Integrity Types of Data Integrity
Enforcing Data Integrity
Primary Key
Foreign Key
Unique Constraints
Check Constraints
Default Constraints
Disabling Constraints
Cascading Referential Integrity Using Transact SQL Query Analyzer
Transact SQL Elements
Language Elements
Functions
Controlling Logic Flow
Commenting TSQL
Batches
Transactions
Scripts
XML (Brief XML tutorial) Transact SQL Specifics SELECT
Grouping Data with SELECT
Summarizing Data with SELECT
INSERT
UPDATE
DELETE
XML (XML in query) Data Import/Export Importing and Exporting Data
Data Import/Export Methods
Using DTS Heterogenous Data Distributed Queries
Linked Servers
OPENQUERY
OPENROWSET/OPENXML Stored Procedures What Is a Stored Procedure?
Creating and Executing Stored Procedures
Altering and Dropping Stored Procedures
Input Parameters
Returning Values with Output Parameters
Recompiling Stored Procedures
Error Handling
Permissions Required
Guidelines for Stored Procedures User Defined Functions What is a UDF?
Creating a UDF
UDF Guidelines
Scalar UDF
Multi-Statement UDF
InLine UDF Triggers What is a Trigger?
When to Use Triggers/Considerations
Creating a Trigger
Under the Hood
Nesting Triggers Views What is a View?
Creating and Using a View
Advantages of Views Indexes Index Basics
Indexes in SQL Server 2000
Guidelines for Indexing
Selectivity
Creating an Index
Index Options
Maintaining Indexes
Rebuilding Indexes
Statistics
Index Tuning Wizard
Graphical Query Plan Query Optimizer Query Optimizer
Cost Limit
Viewing STATISTICS
Graphical Execution
General Query Guidelines SQL Profiler SQL Profiler
Using the SQL Profiler Locking Database Locking
Locking Levels
Lock Types
Session Locking Options
Deadlocks
Displaying Locking Info

Microsoft SQL Server Training CD Information

Title : Microsoft SQL Server
Tutor : Mark Long
Other tutorials and training by this author
Movies : 102 Lessons- Video run time: 8 Hours
Availability : Immediate Dispatch
Compatibility: Vista, 98, 2000, NT, XP, Mac OS, OSX
Released 2002-08-20
Price US / Canadian Sales $99.95

124 In Stock

Add to Cart

Why use this method of video training ?
  • Learn Microsoft SQL Server from an accredited expert in days.
  • Ideal for beginners, easy to follow videos that offer visual clarity.
  • Master a full application for a fraction of the cost of classroom based training.
  • Unique teaching method that offers accelerated learning and high retention.
  • Used by many large companies, schools, universities,
  • Learn from your own desk at a speed that suits you
  • Cost effective tuition from leading experts
  • You control the pace, training can be stopped, rewound or fast forwarded as required.

Associated Titles:

Free Certificate. Prove your credentials
online people


We now offer all customers a free certificate to verify they have undertaken a Microsoft SQL Server course, the unique certification number allows third parties to check the authenticity of your certificate online. After your purchase you can download your Microsoft SQL Server certificate without delay.

Online University Access all our Training for only $30.00

Not sure which training CD titles to purchase ? Why not join our Online University and have unlimited access to all our titles for one low price ?

online people

over 4000 hours of high quality online training for only $30.00. Unlimited access

learn from your own desk -expert tutorials - affordable tuition.
No minimum sign up period.
Want to see how good our online university is? - Why not try a free Demo

For low monthly fee you have unlimited access to all the 300+ training titles in our range, that's over 35,000 tutorials covering 4000 hours+! Watch when ever you like, from any computer - NO LIMITS.

Join Today and learn quicker and cheaper than you ever thought possible.

Become a expert without having to read a book or attend expensive training courses.

Where else can you find step-by-step training for over 300 software applications delivered to your own desk, from a leading expert, for less then a Dollar a day ?

Want to see how good our online university is? - Why not try a free Demo, and if all that's not enough, we add new video tutorials each month for no extra charge!

Free Newsletter

If you would like to be notified as we release new video tutorials, run special offers, or promotions.
Sign up now. Your details are kept secure and never sold rented or used by any other 3rd parties.

Microsoft SQL Server Related Product Groups:

FileMaker Pro | Excel Tutorials | MySQL Access Tutorials | Oracle PL/SQL | Microsoft SQL Server 2000 Admin Microsoft SQL Server 2000 Programming | Online Microsoft SQL Server Training Courses