Intelligentedu Best New Free Computer IT Training Tutorial Resources

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/

Popularity: 10% [?]