原始網址 : http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx

Video Series: SQL Server 2005 Express Edition for Beginners

Getting Started with SQL Server Express

This video series is designed specifically for SQL Server beginners—individuals who are interested in learning the basics of how to create, manage, and connect to SQL Server Express databases. Whether you’re just a beginner or somewhat familiar with databases, these video lessons will help you get better acquainted with SQL Server 2005 Express.

Getting Started

The series includes almost 9 hours of video-based instruction that walks SQL Server beginners through the steps of learning about SQL Server databases to actually connecting a SQL Server database to a Web application. Select your starting point below based on your skill set.

Introduction

   Learning Video 1: What is a database?

Designing Tables

   Learning Video 2: Understanding Database Tables and Records

   Learning Video 3: More about Column Data Types and Other Properties

   Learning Video 4: Designing Relational Database Tables

Database Functions

   Learning Video 5: Manipulating Database Data

   Learning Video 6: More Structured Query Language

   Learning Video 12: Creating and Using Stored Procedures

   Learning Video 13: Enabling Full-Text Search in your Text Data

Creating and Using Reports

   Learning Video 10: Getting Started with Reporting Services

   Learning Video 11: Embedding, Packaging and Deploying SQL Server Express Reporting Services

Database Security

   Learning Video 7: Understanding Security and Network Connectivity

Database Management

   Learning Video 9: Using SQL Server Management Studio Express

Publishing to the Web

   Learning Video 8: Connecting your Web Application to SQL Server 2005 Express Edition