Introduction to T-SQL

SQL Server Database Design and Development 

Introduction to SQL Server 2000 Desktop Engine

By William Rouck
Running Time: 1 Hour, 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)

Our Risk-Free Lifetime Money-Back 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.

Introduction to SQL Server 2000 Desktop Engine Video Tutorials - You can take advantage of our unique video tutorials for just $47.00.

Here's what you get with Option 1:

* You get the Introduction to SQL Server 2000 Desktop Engine videos. That's over 1 hour of video training you can download immediately.
* We will also ship you the videos on CDs so you will have a back-up.