Hundreds
of hours of video From Microsoft Co.
ASP.NET For Beginners
ASP.NET SECURITY
ADO.NET Data Services
SQL Server 2005 for Beginners
================================================== =============
ASP.NET 2.0 Beginners
Contents
Lesson 1: Getting Started with Visual Web Developer Express
In this lesson, you will begin to get familiar with Visual Web Developer Express
Edition, and look at the workflow involved in using the program to build dynamic
ASP.NET Web sites.
Duration: 28 minutes, 40 seconds
Download
(http://download.microsoft.com/download/1/a/a/1aa25ebb-b259-48e6-b8ab-db01ebeb5a78/01%20-%20Getting%20Started%20with%20Visual%20Web%20Devel
oper%202005%20Express%20Edition.zip)
================================================== =
Lesson 2: Creating a Web Forms User Interface
In this lesson, you will explore the various ASP.NET 2.0 server controls
available in Visual Web Developer Express Edition. In addition, you will begin
to get familiar with the windows in Visual Web Developer.
Duration: 49 minutes, 20 seconds
Download
(http://download.microsoft.com/download/1/a/a/1aa25ebb-b259-48e6-b8ab-db01ebeb5a78/02%20-%20Creating%20a%20Web%20Forms%20User%20Interface_c
sharp.zip)
================================================== =
Lesson 3: Understanding More About Events and Postback
In this lesson, you will learn how events can be used in your code, and how to
react when those events occur.
Duration: 17 minutes, 24 seconds
Download
(http://download.microsoft.com/download/1/a/a/1aa25ebb-b259-48e6-b8ab-db01ebeb5a78/03%20-%20Understanding%20More%20about%20Events%20and%20P
ostBack_csharp.zip)
================================================== =
Lesson 4: Understanding Web Application State
In this lesson, you will see how to maintain state in ASP.NET, including the
various objects you can use to store information for your ASP.NET 2.0
applications.
Duration: 40 minutes, 42 seconds
Download
(http://download.microsoft.com/download/1/a/a/1aa25ebb-b259-48e6-b8ab-db01ebeb5a78/04%20-%20Understanding%20Web%20Application%20State_cshar
p.zip
)
================================================== =
Lesson 5: Debugging and Tracing Your Website
In this lesson, you will learn how to debug and monitor your ASP.NET 2.0 Web
applications.
Duration: 29 minutes, 7 seconds
Download
(http://download.microsoft.com/download/1/a/a/1aa25ebb-b259-48e6-b8ab-db01ebeb5a78/05%20-%20Debugging%20and%20Tracing%20Your%20Website_csha
rp.zip)
================================================== =
Lesson 6: Working with Stylesheets and Master Pages
In this lesson, you will begin to learn how style sheets and MasterPages can be
used to maintain a consistent appearance for all pages in a web application.
Duration: 24 minutes, 18 seconds
Download
(http://download.microsoft.com/download/1/a/a/1aa25ebb-b259-48e6-b8ab-db01ebeb5a78/06%20-%20Working%20with%20Style%20Sheets%20and%20Master%
20Pages_csharp.zip)
================================================== =
Lesson 7: Databinding to User Interface Controls
In this lesson, you will learn how to display data in your ASP.NET 2.0 web
applications through some of the new databound controls.
Duration: 22 minutes, 58 seconds
Download
(http://download.microsoft.com/download/1/a/a/1aa25ebb-b259-48e6-b8ab-db01ebeb5a78/07%20-%20Databinding%20to%20User%20Interface%20Controls_
csharp.zip)
================================================== =
Lesson 8: Working with the GridView and FormView
In this lesson, you will learn about the GridView and FormView controls and how
you can use some of the features of these controls to make editing and
displaying of database content easier.
Duration: 30 minutes, 35 seconds
Download
(http://download.microsoft.com/download/1/a/a/1aa25ebb-b259-48e6-b8ab-db01ebeb5a78/08%20-%20Working%20with%20the%20GridView%20and%20FormVie
w%20Controls_csharp.zip)
================================================== =
Lesson 9: Securing your Web Site with Membership and Login Controls
In this lesson, you will explore the new membership capabilities of ASP.NET 2.0.
In addition, you will learn about role-based security, and how you can use roles
to control access to your web site.
Duration: 33 minutes, 31 seconds
Download
(http://download.microsoft.com/download/1/a/a/1aa25ebb-b259-48e6-b8ab-db01ebeb5a78/09%20-%20Securing%20your%20Website%20with%20Membership%2
0and%20Login%20Controls.zip)
================================================== =
Lesson 10: Configuring, Building and Deploying a Web Site
In this lesson, you will see what is required to make your ASP.NET applications
available to everyone. This includes configuring, building, and deploying your
web site.
Duration: 15 minutes, 0 seconds
Download
(http://download.microsoft.com/download/1/a/a/1aa25ebb-b259-48e6-b8ab-db01ebeb5a78/10%20-%20Configuring%20Building%20and%20Deploying%20your
%20Web%20Application.zip)
================================================== =
Lesson 11: Building a Quiz Engine 1
In this lesson, you will begin to see the creation of the Quiz Engine. This will
allow you to exercise the skills developed in the earlier videos.
Duration: 22 minutes, 32 seconds
Download
(http://download.microsoft.com/download/1/a/a/1aa25ebb-b259-48e6-b8ab-db01ebeb5a78/11%20-%20ASP.NET%202.0%20Quiz%20Engine%20Project%20-%20Designing%20and%20Planning.zip)
================================================== =
Lesson 12: Building a Quiz Engine 2
In this lesson, you will begin to lay out the web pages for the Quiz Engine and
create some of the initial code required. This will allow you to exercise the
skills developed in the earlier videos.
Duration: 29 minutes, 20 seconds
Download
(http://download.microsoft.com/download/1/a/a/1aa25ebb-b259-48e6-b8ab-db01ebeb5a78/12%20-%20ASP.NET%202.0%20Quiz%20Engine%20Project%20-%20Early%20Development.zip)
================================================== =
Lesson 13: Building a Quiz Engine 3
In this lesson, you will continue the work on the Quiz Engine, adding the
ability to save test results and other functionality. This will allow you to
exercise the skills developed in the earlier videos.
Duration: 25 minutes, 27 seconds
Download
(http://download.microsoft.com/download/1/a/a/1aa25ebb-b259-48e6-b8ab-db01ebeb5a78/13%20-%20ASP.NET%202.0%20Quiz%20Engine%20Project%20-%20Refining%20Application%20Functionality.zip)
================================================== =
Lesson 14: Building a Quiz Engine 4
In this lesson, you will complete the Quiz Engine project, adding theme support,
cleaning up the code, and deploying the project.
Duration: 31 minutes, 34 seconds
Download
(http://download.microsoft.com/download/1/a/a/1aa25ebb-b259-48e6-b8ab-db01ebeb5a78/14%20-%20ASP.NET%202.0%20Quiz%20Engine%20Project%20-%20Enabling%20Themes,%20Handling%20Exceptions%20an
d%20Deploying.zip)
================================================== ==============
ASP.NET SECURITY
Lesson 1: Using Basic Forms Authentication in ASP.NET
Authentication programmatically with ASP.NET.
Duration: 23 minutes, 24 seconds
Download
(http://download.microsoft.com/download/9/8/f/98f7ee03-4224-45ee-9034-7fa799e69ddd/WinVideo-SEC-001-FormsLogin.zip)
================================================== =
Lesson 2 : How to Change the Forms Authentication Properties
how to change the authentication period for the ASP.NET application
Duration: 7 minutes, 11 seconds
Download
(http://download.microsoft.com/download/a/a/6/aa6afae8-3ec8-4fae-bceb-cccc9a74ccef/WinVideo-SEC-002-FormsLogin-TimeOut.zip)
================================================== =
Lesson 3 :How to Setup and Use ******-less Authentication in an ASP.NET
Application
how to use ******-less authentication.
Duration: 4 minutes, 13 seconds
Download
(http://download.microsoft.com/download/c/f/a/cfac5771-091b-4ef3-9d8a-45dc664f3d91/WinVideo-SEC-003-FormsLogin-******less.zip)
================================================== =
Lesson 4 : ASP Forms Login Relocation
uses the previous code example to continue customizing the ASP.NET
authentication by relocating and renaming the login functionality of the ASP.NET
application.
Duration: 4 minutes, 35 seconds
Download
(http://download.microsoft.com/download/c/f/5/cf5b451e-bfb9-40ab-bb15-d1e3d9712db6/WinVideo-SEC-004-FormsLogin-RelocateLogin.zip)
================================================== =
Lesson 5 : Forms Login Custom Key Configuration
examine the machine key setting in your ASP.NET application.
Duration: 7 minutes, 32 seconds
Download
(http://download.microsoft.com/download/6/d/3/6d342f90-573a-47a3-95f6-0f3538139fff/WinVideo-SEC-005-FormsLogin-CustomKeys.zip)
================================================== =
Lesson 6: Add Custom Data to the Authentication Method
continue the exploration of ASP.NET authentication by configuring the
authentication method to add custom data to the authentication ticket that is
used by ASP.NET.
Duration: 14 minutes, 33 seconds
Download
(http://download.microsoft.com/download/4/2/8/428147d4-7869-4cf5-a3e0-de3eed152dbc/WinVideo-SEC-006-AddDataToAuthTicket.zip)
================================================== =
Lesson 7 : Use Custom Principal Objects
how to implement custom identity in principal objects in order to store user
authentication data
Duration: 22 minutes, 46 seconds
Download
(http://download.microsoft.com/download/7/2/d/72dfb11d-3107-41dd-888b-8bddbbf3dcdd/WinVideo-SEC-007-UseCustomPrincipal.zip)
================================================== =
Lesson 8 : Understanding ASP.NET Memberships
working with the built-in providers, available to ASP.NET developers, for
membership.
Duration: 22 minutes, 46 seconds
Download
(http://download.microsoft.com/download/d/b/f/dbfdb548-1f83-4450-93b5-889b6c73d03b/WinVideo-SEC-008-UnderstandMembershipDefaults.zip)
================================================== =
Lesson 9 : Configuring SQL To Work with Membership Schemas
how to configure a SQL instance to work with a specific ASP Services Membership
Profile; as well as configure the application to specifically use this SQL
instance and not the default settings in the machine.cgf file
Duration: 18 minutes, 56 seconds
Download
(http://download.microsoft.com/download/1/b/c/1bc8fd07-b432-4567-9f77-5d8413e13df5/WinVideo-SEC-009-CreateMembershipSchema.zip)
================================================== =
Lesson 10 : Changing Membership Settings in the Default Membership Schema
how to change the default settings of the membership schema to conform to the
specific needs of an custom application.
Duration: 9 minutes, 36 seconds
Download
(http://download.microsoft.com/download/e/4/a/e4a24198-bea4-45e9-ba1f-c970affe4db6/WinVideo-SEC-010-ChangeMembershipSettings.zip)
================================================== =
Lesson 11 : Creating User Accounts with the Create User Wizard
how to create users with the Create User Wizard that comes with the Login
Control Collection in ASP.NET and Visual Studio.
Duration: 9 minutes, 55 seconds
Download
(http://download.microsoft.com/download/2/8/1/28173323-8d6b-4b79-9f08-882612465620/winvideo-SEC-011-CreateUserWizarda.zip)
================================================== =
Lesson 12 : Creating User Accounts Programmatically
how to create a custom create user web form programmatically while not using the
Create User wizard.
Duration: 19 minutes, 32 seconds
Download
(http://download.microsoft.com/download/f/f/d/ffdc1c70-e16f-42c3-97a0-5a76491cedba/WinVideo-SEC-012-CreateUser.zip)
================================================== =
Lesson 13 : Validating Users Manually
how to create your own web form and process the authentication request manually.
Duration: 13 minutes, 24 seconds
Download
(http://download.microsoft.com/download/2/2/1/221e8c73-16d8-4c78-a872-6d74b6446464/winvideo-SEC-013-ValidatingUsers.zip)
================================================== =
Lesson 14 : Validating Users with the Login Control
explores an alternative method of user authentication rather then creating a
custom form and calling the API to authenticate a user. He uses the Login
Control that ships with ASP.NET 2 and above
Duration: 5 minutes, 7 seconds
Download
(http://download.microsoft.com/download/7/d/c/7dc80121-d6bf-429c-b43c-2b7995128790/WinVideo-SEC-014-ValidatingUsers-LoginContol.zip)
================================================== =
ADO.NET Data Services
Contents
Lesson 1: Data Access Layers in ASP.NET Applications
creates a data access layer using a typed data set for a simple ASP.NET
application.
Duration: 11 minutes, 50 seconds
Download
(http://download.microsoft.com/download/0/3/e/03e0f41a-9ca8-4924-8512-2cd2c84d1fe6/WinVideo-DAT-001-DataAccessLayer.zip)
================================================== =
Lesson 2 : How to Manually Bind a Dataset to a Datagrid
uses the sample ASP application created in part one, to demonstrate how to
manually bind a dataset to a datagrid.
Duration: 7 minutes, 28 seconds
Download
(http://download.microsoft.com/download/e/b/8/eb8ea14d-5082-400f-bc08-0e6bf956a9e4/WinVideo-DAT-002-DSGridBind.zip)
================================================== =
Lesson 3 : How to Work with Datasets and Filters from an ASP Application
how to return a filtered set of data from the overall application dataset.
Duration: 6 minutes, 1 seconds
Download
(http://download.microsoft.com/download/b/8/2/b8264c2a-dda3-404a-af36-d4087dcf2d0a/WinVideo-DAT-003-DALSelectParam.zip)
================================================== =
SQL Server 2005 for Beginners
Lesson 1 : What is a Database?
This introduction covers the questions and terminology SQL Server beginners need
to create and manage databases, such as: What is a SQL Server database? How is a
SQL Server database different from an Excel spreadsheet? What do SQL Server
databases do in my website or software applications? What's SQL Server Express'
relation to Visual Studio Express? What do terms like "ADO.NET" mean?
Duration: 28 minutes, 15 seconds
Download
(http://download.microsoft.com/download/3/D/B/3DB1DBCF-D8A5-4FE6-8304-088187F25813/sql_01.zip)
================================================== =
Lesson 2 : Understanding Database Tables and Records
SQL Server beginners will learn about tables and definitions of data types,
properties, keys, etc. in this second video. Find out how table rows, columns,
and fields interrelate and whether columns can be empty.
Duration: 24 minutes, 56 seconds
Download
(http://download.microsoft.com/download/3/D/B/3DB1DBCF-D8A5-4FE6-8304-088187F25813/sql_02.zip)
================================================== =
Lesson 3 : More about Column Data Types and Other Properties
SQL Server beginners will explore data integrity, learn which data types to use
for what, and avoid common data type pitfalls.
Duration: 21 minutes, 37 seconds
Download
(http://download.microsoft.com/download/3/D/B/3DB1DBCF-D8A5-4FE6-8304-088187F25813/sql_03.zip)
================================================== =
Lesson 4 : Designing Relational Database Tables
Why are relational databases the most popular? SQL Server beginners will learn
to differentiate between primary and foreign keys, design relational database
tables, and learn about normalization rules and de-normalization.
Duration: 34 minutes, 10 seconds
Download
(http://download.microsoft.com/download/3/D/B/3DB1DBCF-D8A5-4FE6-8304-088187F25813/sql_04.zip)
================================================== =
Lesson 5 : Manipulating Database Data
SQL Server beginners will learn about ADO.NET objects and execution of SQL
statement from ADO.NET. Explore SQL and learn about insert, update, and delete
statements.
Duration: 40 minutes, 20 seconds
Download
(http://download.microsoft.com/download/3/D/B/3DB1DBCF-D8A5-4FE6-8304-088187F25813/sql_05.zip)
================================================== =
Lesson 6 : More Structured Query Language
SQL Server beginners will discover more SQL statements like sub-select and learn
stored procedures and their counterparts in C# and VB methods.
Duration: 23 minutes, 13 seconds
Download
(http://download.microsoft.com/download/3/D/B/3DB1DBCF-D8A5-4FE6-8304-088187F25813/sql_06.zip)
================================================== =
Lesson 7 : Understanding Security and Network Connectivity
SQL Server beginners will learn to differentiate between SQL Server database
files and SQL Server processes. Explore scenarios for connecting to SQL Server
Express databases, enabling and disabling user instances, login permissions, and
other security precautions.
Duration: 40 minutes, 59 seconds
Download
(http://download.microsoft.com/download/3/D/B/3DB1DBCF-D8A5-4FE6-8304-088187F25813/sql_07.zip)
================================================== =
Lesson 8 : Connecting your Web Application to SQL Server 2005 Express Edition
SQL Server beginners will walkthrough the entire workflow of creating a database
driven Web application and use visual tools to quickly create an administration
application.
Duration: 5 minutes, 58 seconds
Download
(http://download.microsoft.com/download/3/D/B/3DB1DBCF-D8A5-4FE6-8304-088187F25813/sql_08.zip)
================================================== =
Lesson 9 : Using SQL Server Management Studio
SQL Server Management Studio Express will typically be your main interface into
SQL Server Express. This lesson demonstrates the essential techniques and skills
you'll need to successfully connect to database instances, navigate the query
window and scripting database objects, attaching, detaching and backing up
databases, and much more.
Duration: 40 minutes, 26 seconds
Download
(http://download.microsoft.com/download/3/D/B/3DB1DBCF-D8A5-4FE6-8304-088187F25813/sql_09.zip)
================================================== =
Lesson 10 : Getting Started with Reporting Services
SQL Server Reporting Services allows you to design and deploy nicely formatted
and interactive reports representative of your data. Suitable for print or
online distribution, these reports and it allows you to get professional results
very quickly. This video demonstrates how to set up Reporting Services and the
Business Intelligence Development Studio to build reports using the wizards and
designers, and deploy them to your Report Server.
Duration: 32 minutes, 51 seconds
Download
(http://download.microsoft.com/download/3/D/B/3DB1DBCF-D8A5-4FE6-8304-088187F25813/sql_10.zip)
================================================== =
Lesson 11 : Building and Customizing Reports in Business Intelligence
Development Studio
Building on the previous lesson, we dive into building reports from scratch and
modifying the reports that were created using the wizards and designers. We also
demonstrate how to embed your reports into your ASP.NET Web Form applications.
Duration: 44 minutes, 50 seconds
Download
(http://download.microsoft.com/download/3/D/B/3DB1DBCF-D8A5-4FE6-8304-088187F25813/sql_11.zip)
================================================== =
Lesson 12 : Creating and Using Stored Procedures
This video expands on the topic of Stored Procedures which was introduced
several lessons ago. In this video we explain the basic syntax to create and
update stored procedures, using input and output parameters, return values,
declaring variables and adding other T-SQL programming elements into you stored
procedures, how to execute your stored procedures from the query window, and
finally the Visual Basic and C# syntax required to utilize stored procedures in
your own applications.
Duration: 42 minutes, 34 seconds
Download
(http://download.microsoft.com/download/3/D/B/3DB1DBCF-D8A5-4FE6-8304-088187F25813/sql_12.zip)
================================================== =
Lesson 13 : Enabling Full-Text Search in your Text Data
Full-Text search allows you to save large portions of text - even Microsoft Word
documents, or other file formats - into your database and perform complex
queries based on this textual data while expecting great performance. This
lesson demonstrates how to set up Full-Text search paying particular attention
to the nuances of setting it up within SQL Server Express. Then we move to
creating full-text indexes, configuring the index population settings, and
performing queries that demonstrate the power of the CONTAINS predicate and its
many, many variations.
Duration: 38 minutes, 25 seconds
Download
(http://download.microsoft.com/download/3/D/B/3DB1DBCF-D8A5-4FE6-8304-088187F25813/sql_13.zip)
From: microsoft.com