dotNet, Access, SQL Server and Database Design Tutorials
Newcastle University offers the following training and tutorials for ASP and dot Net web connectivity with Access; SQL Server support and good practice; and Database Design techniques and tutorials. Some of this is targeted to the university setting, but you should be able to glean some good nuggets and coding techniques with these tutorials and web references.
ASP and .NET with Microsoft Access and SQL Server on the Web:
www.campus.ncl.ac.uk/databases/dotnet/
Using ASP.NET to Connect Databases to the Web,
Part 1 - the Basics:
www.campus.ncl.ac.uk/databases/dotnet/aspdotnet.html
Using ASP.NET to Connect Databases to the Web,
Part 2 - More Examples and Code:
www.campus.ncl.ac.uk/databases/dotnet/aspdotnet2.html
Using ASP.NET to Connect Databases to the Web,
Part 3 - Links to Examples and Code:
www.campus.ncl.ac.uk/databases/dotnet/aspdotnet3.html
References and Links:
www.campus.ncl.ac.uk/databases/dotnet/refs.html
SQL Server Support and Good Practice:
www.campus.ncl.ac.uk/databases/sqlser/
Good practice is advice gleaned from experiences running servers and from the substantial literature on SQL Server about security and performance.
Designing and Creating a Relational Database:
www.campus.ncl.ac.uk/databases/design/
Examples:
www.campus.ncl.ac.uk/databases/design/example.html
Understand other people's solutions - these are the ones covered in the hands-on tutorials.
More Examples:
www.campus.ncl.ac.uk/databases/design/example2.html
These are various other examples with some interesting features.
Tutorial on Getting the Data into the Right Place:
www.campus.ncl.ac.uk/databases/design/design.html
A step-by-step tutorial on design - the main part of these pages.
Creating a Database from the Design:
www.campus.ncl.ac.uk/databases/design/create.html
This mostly covers Access, but also applies to any relational database.
References:
www.campus.ncl.ac.uk/databases/design/references.html
Links and books and other resources found useful
If you have never used a database - start with this tutorial on Access, which shows what a database can look like and how to query it: www.campus.ncl.ac.uk/databases/acc/
Related Posts: