Helping You to Learn 

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

  FEELPCS
In god we trust