suggestions for books

[nemo]

I would be teaching an applied database course to buisness major
undergrads. I'm looking for a book that introduces database concepts
using SQLServer as the database. I would really appreciate if you could
recommend me a few such books.

Thanks
Nemo

[David Portas]

nemo wrote:

I would be teaching an applied database course to buisness major
undergrads. I'm looking for a book that introduces database concepts
using SQLServer as the database. I would really appreciate if you could
recommend me a few such books.

Thanks
Nemo

I would not recommend any book or course that used SQL Server to
introduce database concepts. Take a look at "Introduction to Database
Systems" by C.J.Date. "Database In Depth" by the same author is a
shorter summary but it does assume some prior knowledge.

Begin with SQL Server AFTER learning the concepts.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/m...S,SQL.90).aspx
--

[nemo]

David Portas wrote:

nemo wrote:

I would be teaching an applied database course to buisness major
undergrads. I'm looking for a book that introduces database concepts
using SQLServer as the database. I would really appreciate if you could
recommend me a few such books.

Thanks
Nemo

I would not recommend any book or course that used SQL Server to
introduce database concepts. Take a look at "Introduction to Database
Systems" by C.J.Date. "Database In Depth" by the same author is a
shorter summary but it does assume some prior knowledge.

Begin with SQL Server AFTER learning the concepts.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/m...S,SQL.90).aspx
--

Thanks David. I guess what I'm looking for is a book on database
concepts that has samples or exercises tailored for SQL Server. I've
seen many such books written with MS Access in mind.

thanks
Nemo

[David Portas]

nemo wrote:

>
Thanks David. I guess what I'm looking for is a book on database
concepts that has samples or exercises tailored for SQL Server.

That would be a SQL concepts course then, not a database concepts
course. SQL Server is only one example of a database system. Anyway my
recommendation stands. If you want concepts get a concepts book rather
than a product tutorial.

I've seen many such books written with MS Access in mind.

It's true that there are plenty of bad books about. Teaching database
concepts using Access would be rather like trying to teach English
Literature using a Speak and Spell machine - you wouldn't have the
apparatus.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/m...S,SQL.90).aspx
--

[nemo]

David Portas wrote:

nemo wrote:

Thanks David. I guess what I'm looking for is a book on database
concepts that has samples or exercises tailored for SQL Server.

That would be a SQL concepts course then, not a database concepts
course. SQL Server is only one example of a database system. Anyway my
recommendation stands. If you want concepts get a concepts book rather
than a product tutorial.

I've seen many such books written with MS Access in mind.

It's true that there are plenty of bad books about. Teaching database
concepts using Access would be rather like trying to teach English
Literature using a Speak and Spell machine - you wouldn't have the
apparatus.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/m...S,SQL.90).aspx
--

Thanks David. Your points well taken. - Nemo.