Advice on learning web page creation and database integration

[lmaurer]

Hi all,

I have been charged with learning how to create web pages that will
function as data capturing tools. From the research I have done, it
looks like I need to learn ASP.net and SQL Server (langauge and how to
create databases in SQL Server). My question is where is the best
place to start learning these tools? Are courses in ASP.NET and Intro
to SQL server where I should start or are there even more basic items
I need to learn first? FYI, I do know how to develop databases in
Access and I have dabbled a little in SQL Server 2000 although my
confidence level is not the highest in SQL. I do have Dreamweaver 8.0
and I am thinking about downloading SQL Server 2005 Express Edition
because it is free. Any thoughts and advice would be greatly
appreicated.

Thanks!
Lauren

[mark4asp]

On Thu, 05 Jul 2007 10:24:02 -0700, lm*****@dorland.com wrote:

>Hi all,

I have been charged with learning how to create web pages that will
function as data capturing tools. From the research I have done, it
looks like I need to learn ASP.net and SQL Server (langauge and how to
create databases in SQL Server). My question is where is the best
place to start learning these tools? Are courses in ASP.NET and Intro
to SQL server where I should start or are there even more basic items
I need to learn first? FYI, I do know how to develop databases in
Access and I have dabbled a little in SQL Server 2000 although my
confidence level is not the highest in SQL. I do have Dreamweaver 8.0
and I am thinking about downloading SQL Server 2005 Express Edition
because it is free. Any thoughts and advice would be greatly
appreicated.

Thanks!
Lauren

Apart from SQL Server 2005 Express there are many other free databases.
(Oracle Express, DB2 Express, Postgres, Firebird, mySQL)

SQL Server 2005 Express is the best one to use if you are writing
ASP.NET.

I like Robert Viera's books on MSSQL - he is very comprehensive. I
suppose that the new one on beginning SQL Server 2005 would be good
because his books on MSSQL 2000 and MSSQL 7 were both very good.

The revievers at amazon give him 4.5 stars so I guess this is up to his
previous high standards
<http://www.amazon.com/Beginning-Server-2005-Programming-Programmer/dp/0764584332/ref=pd_bbs_sr_2/103-3192375-8572607?ie=UTF8&s=books&qid=1183946938&sr=1-2>

ASP.NET is a pretty big thing. Although you can nearly write
applications without code behind - it's pretty difficult as there always
seems to be something you need to do in the code.

What programming languages do you know? ASP.NET primarily uses VB.NET
or C# (it's very similar to java) for code behind. A very comprehensive
book on ASP.NET is Stephen Walther's "ASP.NET Unleashed" - he walks you
through all aspects of writing ASP.NET with very little server side
code. But it's a huge book - nearly 2000 pages! That's my second
recommendation.
<http://www.amazon.com/ASP-NET-2-0-Unleashed-Stephen-Walther/dp/0672328232/ref=pd_bbs_sr_1/103-3192375-8572607?ie=UTF8&s=books&qid=1183947388&sr=1-1>

Don't use Dreamweaver 8.0 for ASP.NET development unless it has
debugging tools build in. WebMatrix <http://asp.net/webmatrix/is a
free ASP.NET IDE which you should try before Dreamweaver 8.0.

Checkout these newsgroups if you have more questions:

news:microsoft.public.sqlserver.programming

news:microsoft.public.dotnet.framework.aspnet

[lmaurer]

On Jul 8, 10:20 pm, mark4asp <[e-mail]:

On Thu, 05 Jul 2007 10:24:02 -0700, [e-mail] wrote:

Hi all,

I have been charged with learning how to create web pages that will
function as data capturing tools. From the research I have done, it
looks like I need to learn ASP.net and SQL Server (langauge and how to
create databases in SQL Server). My question is where is the best
place to start learning these tools? Are courses in ASP.NET and Intro
to SQL server where I should start or are there even more basic items
I need to learn first? FYI, I do know how to develop databases in
Access and I have dabbled a little in SQL Server 2000 although my
confidence level is not the highest in SQL. I do have Dreamweaver 8.0
and I am thinking about downloading SQL Server 2005 Express Edition
because it is free. Any thoughts and advice would be greatly
appreicated.

Thanks!
Lauren

Apart from SQL Server 2005 Express there are many other free databases.
(Oracle Express, DB2 Express, Postgres, Firebird, mySQL)

SQL Server 2005 Express is the best one to use if you are writing
ASP.NET.

I like Robert Viera's books on MSSQL - he is very comprehensive. I
suppose that the new one on beginning SQL Server 2005 would be good
because his books on MSSQL 2000 and MSSQL 7 were both very good.

The revievers at amazon give him 4.5 stars so I guess this is up to his
previous high standards
<http://www.amazon.com/Beginning-Server-2005-Programming-Programmer/dp...>

ASP.NET is a pretty big thing. Although you can nearly write
applications without code behind - it's pretty difficult as there always
seems to be something you need to do in the code.

What programming languages do you know? ASP.NET primarily uses VB.NET
or C# (it's very similar to java) for code behind. A very comprehensive
book on ASP.NET is Stephen Walther's "ASP.NET Unleashed" - he walks you
through all aspects of writing ASP.NET with very little server side
code. But it's a huge book - nearly 2000 pages! That's my second
recommendation.
<http://www.amazon.com/ASP-NET-2-0-Unleashed-Stephen-Walther/dp/067232...>

Don't use Dreamweaver 8.0 for ASP.NET development unless it has
debugging tools build in. WebMatrix <http://asp.net/webmatrix/is a
free ASP.NET IDE which you should try before Dreamweaver 8.0.

Checkout these newsgroups if you have more questions:

news:microsoft.public.sqlserver.programming

news:microsoft.public.dotnet.framework.aspnet- Hide quoted text -

- Show quoted text -

Thank you so much for you thoughts!

I am an absolute beginner when it comes to writing code so the answer
to your question is I don't really know any code. Basically I have
been charged to learn how to build websites that can integrate with a
database. We use SQL 2000 currently but we most likely will be
upgrading to SQL 2005 next year. I know I have a lot to learn so I am
sure I will be asking lots of questions, doing lots of reading and
lots of practicing! Anyway, with no money for training in the budget,
I need to rely on any resources that are either free or are what I can
afford. I am happy that advice from you and others are out there so
that I can get some idea of where to begin!

Thanks again!
Lauren