Introduction to SQL Server 2000 Desktop Engine

A Photo of our Operator Corey

Questions?


live help

  1. Call us toll-free:

    (866) 894-0705


FREE TUTORIALS


Introduction to SQL Server 2000 Desktop Engine

Introduction to SQL Server 2000 Desktop Engine

By William Rouck

Running Time: 1 hours, 18 minutes

Overview

In this video series, William Rouck teaches the fundamentals of SQL Server 2000 Desktop Engine (MSDE 2000), including installing the software, building a database, querying the database, performing stored procedures, and much more.

Detailed Video Descriptions

  1 - Introduction to Series (Running Time: 1:45)

Bill provides an overview of the content of this video series.

  2 - Introduction to SQL Server 2000 Desktop Engine (Running Time: 7:07)

Bill starts the series explaining what the SQL Server Desktop Engine is, as well as its appropriate uses, limitations, and licensing issues you should be aware of.

  3 - Obtaining and Installing SQL Server Desktop Engine (Running Time: 7:22)

This video is a detailed demonstration of obtaining and installing SQL Server 2000 Desktop Engine, in particular the setup script and verifying the installation was successful.

  4 - OSQL.EXE and Other Included Tools (Running Time: 5:01)

This video demonstrates the use of OSQL.EXE and other tools included in the MSDE 2000 package. It begins with an overview of OSQL.EXE, then shows the SQL Server Network Utility and related Windows Services.

  5 - Creating a Sample Database (Running Time: 12:32)

Bill steps through the creation of a sample database, which not only provides test data to work with through the rest of the Series, but also demonstrates the use of SQL Server 2000 Desktop Engine's included tools.

  6 - External Tools (Running Time: 7:49)

In this video, Bill shows us a few examples of using SQL Server Desktop Engine with other packages, such as SQL Server 2000 Enterprise Edition and Microsoft Access. Included here is a detailed example of creating an ODBC alias for our sample database. Bill also suggests a third party query and administration tool.

  7 - Configuration and Administration (Running Time: 19:17)

As with any other database system, SQL Server 2000 Desktop Engine databases have administration considerations. Bill demonstrates methods for user administration, backup and restore, scheduled backups, and security considerations.

 8 - Running Queries in MSDE 2000 (Running Time: 8:20)

In this video, Bill shows examples of queries using OSQL.EXE and MSDE 2000, including use of batch commands in a text file as input to OSQL.EXE.

  9 - Stored Procedures (Running Time: 2:50)

Bill demonstrates how to implement a simple stored procedure in SQL Server 2000 Desktop Engine.

  10 - MSDE 2000 and ASP.NET (Running Time: 5:25)

This video demonstrates the use of ASP.NET-enabled code to link to and display information from a SQL Server 2000 Desktop Engine database.

 11 - Conclusion (Running Time: 0:45)

top

Our Risk-Free Lifetime Money-Back
Guarantee

moneyback guarantee

Purchase as many videos as you like. If you discover that the videos do not completely and successfully train you on that subject, simply contact us anytime at support@technicallead.com and we will give you a complete refund.

Why such a generous guarantee? It is simple. We know how powerful the videos are and we know that they will help you. It is our way of assuring you that - in the case that you do not receive maximum benefit from the videos or if for whatever reason you are not completely satisfied - you won't have to pay for something you can't use.

However, you will never know until you try. That's why we are giving you as much time as you need to evaluate the videos. If they don't live up to your expectations you are not out a dime.


Option 1. Introduction to SQL Server 2000 Desktop Engine Video Tutorials You can start learning SQL right now with our video training for just $147.00 $67.00. That's $80.00 off the regular price.

Here's a summary of Option 1:

  • You get the Introduction to SQL Server 2000 Desktop Engine videos. That's almost 1 hours of video training you can download immediately.
  • We will also ship you all the videos on CD so you will have a back-up.

Option 2. Introduction to SQL Server 2000 Desktop Engine Video Tutorials DOWNLOAD ONLY - You can start learning SQL right now with our video training for just $127.00 $47.00. That's $80.00 off the regular price.

Here's a summary of Option 2:

  • You get the Introduction to SQL Server 2000 Desktop Engine videos. That's almost 1 hours of video training you can download immediately.

ALSO NOW AVAILABLE, TWO BIG WAYS TO SAVE ON OUR TRAINING!

1. Our New Flash Definitive Membership. Save over 82% on ALL of our Flash Training PLUS you will get ALL future Flash releases while you are a member!


2. Our Flash CS3 Complete Training Bundle - This training bundle includes six of our best titles. Get our Flash CS3 Complete Training Bundle NOW for just $282.00 $197.00. That's a savings of almost $85.


Yes, I can't wait to start learning SQL like the pros...

and I know there is no time to lose. Thanks for the lifetime guarantee - that takes all the pressure off my decision. In fact, it allows me to see everything for free, if I choose.

Option 1. Introduction to SQL Server 2000 Desktop Engine Video Tutorials (CD and DOWNLOAD) - You can start learning SQL today for just $147.00 $67.00. That's $80.00 off the regular price.

Click Here To Start Option 1 Securely

Option 2. Introduction to SQL Server 2000 Desktop Engine Video Tutorials Package DOWNLOAD ONLY - You can start learning SQL today for just $127.00 $47.00. That's $80.00 off the regular price.

Click Here To Start Option 2 Securely

For corporate and educational multi-licenses, please contact our sales department at (866) 894-0705 for more information.





TechnicalLead.Com, Inc. © 2009 • Privacy Policy | Terms Of Use