Which books to get to learn databases design ?

[roni]

All right,

I found an internship where database knowledge is required.
I was told that I can take a college course or learn it on my own. I figured I'll be able to do it on my own and was wondering if you guys could help me pick a book to start with.

This is what they told me to know:

- - SQL and relational database design
-- IIS
- - C#.Net, asp.net, html and css
- - Monitoring of .Net web applications

Looks like these are four different topics. Am I correct ?
Can I learn all of them (the basics of course) by reading one database designs book?
Can you please tell me where I should start ?

I will also need to program in C# (I know some C++ so this part shouldn't be a big deal) and I figured that this internship can be good for me to develop my programming knowledge before going into the MFE program, and I don't really want to miss the opportunity...

Thanks,
Roni

 

[alain]

do you want to learn relational database design or just SQL?

IIS? IMHO, IIS is a piece of garbage but maybe things have changed since the last time I used it.

BTW, none of this has anything to do with finance.

 

[roni]

do you want to learn relational database design or just SQL?

IIS? IMHO, IIS is a piece of garbage but maybe things have changed since the last time I used it.

BTW, none of this has anything to do with finance.

Looks like both SQL and relational database design.

I don't know if IIS is garbage or not, I just copied everything they wanted...

And, I know this internship is not related to finance, but it is related to programming (which is my goal in getting this internship)...

So, where should I start ?

Thanks.

 

[Andy Nguyen]

There are couple of books under SQL PROGRAMMING section in the master reading list. I used them when I was learning how to write sql query
Master reading list for Quants, MFE (Financial Engineering) students - Forum | Quant Network

 

[roni]

There are couple of books under SQL PROGRAMMING section in the master reading list. I used them when I was learning how to write sql query
Master reading list for Quants, MFE (Financial Engineering) students - Forum | Quant Network

I actually went over this list before posting here...
I think the SQL PROGRAMMING section is empty.
However, I found this book named "The Art of SQL" by Stephane Faroult, am not sure if this is for beginners, though...

Thanks.

 

[Andy Nguyen]

There are 3 books under that section
Amazon.com: The Gurus Guide to Transact-SQL (0785342615760): Ken Henderson, Joe Celko: Books
Amazon.com: Joe Celkos SQL for Smarties: Advanced SQL Programming Third Edition (The Morgan Kaufmann Series in Data Management Systems) (9780123693792): Joe Celko: Books
Amazon.com: Joe Celkos Trees and Hierarchies in SQL for Smarties, (The Morgan Kaufmann Series in Data Management Systems) (9781558609204): Joe Celko: Books

 

[alain]

you will be able to pick up standard SQL fast. Nuances of each database are going to be a different story. Optimization of queries, index design, etc, could be a challenge.

The same applies to DB design.

---------- Post added at 11:18 PM ---------- Previous post was at 11:05 PM ----------

If you want to learn DB tuning, I highly recommend:

http://www.amazon.com/Database-Tuning-Principles-Experiments-Troubleshooting/dp/1558607536/ref=ntt_at_ep_dpi_4

 

[roni]

There are 3 books under that section
Amazon.com: The Gurus Guide to Transact-SQL (0785342615760): Ken Henderson, Joe Celko: Books
Amazon.com: Joe Celkos SQL for Smarties: Advanced SQL Programming Third Edition (The Morgan Kaufmann Series in Data Management Systems) (9780123693792): Joe Celko: Books
Amazon.com: Joe Celkos Trees and Hierarchies in SQL for Smarties, (The Morgan Kaufmann Series in Data Management Systems) (9781558609204): Joe Celko: Books

For some reason I don't see them... weird...
gotta try a different browser...
thanks for the links...

---------- Post added at 01:30 AM ---------- Previous post was at 01:30 AM ----------

you will be able to pick up standard SQL fast. Nuances of each database are going to be a different story. Optimization of queries, index design, etc, could be a challenge.

The same applies to DB design
If you want to learn DB tuning, I highly recommend:

http://www.amazon.com/Database-Tuni...bleshooting/dp/1558607536/ref=ntt_at_ep_dpi_4

I see...
thank you for the help, I'll check this book out..

 

[tylor]

maybe talk to a local college about their database design courses and buy the textbooks they use to teach it.

 

[const451]

For some reason I don't see them... weird...
gotta try a different browser...
thanks for the links...

For some reason I do not see anything either under the * Sql Programming section, and I am using the latest and greatest FireFox.

As far as the book goes, since they want you to know IIS and C# you'll most likely be using MS Sql Server. I have this book, it is very detailed and it covers absolutely everything, it's good for learning and reference. A lot of dba's are using it.

Amazon.com: Professional Microsoft SQL Server 2008 Programming (Wrox Programmer to Programmer) (9780470257029): Robert Vieira: Books

 

[roni]

For some reason I do not see anything either under the * Sql Programming section, and I am using the latest and greatest FireFox.

As far as the book goes, since they want you to know IIS and C# you'll most likely be using MS Sql Server. I have this book, it is very detailed and it covers absolutely everything, it's good for learning and reference. A lot of dba's are using it.

Amazon.com: Professional Microsoft SQL Server 2008 Programming (Wrox Programmer to Programmer) (9780470257029): Robert Vieira: Books

I guess that's the ad blocker of FF, I can see them with IE.
And you are right, they said they are using MS programs...
And, the book you offered is for those with knowledge in SQL and databases, I don't think Im in this category (yet :\)

---------- Post added at 09:09 PM ---------- Previous post was at 09:08 PM ----------

maybe talk to a local college about their database design courses and buy the textbooks they use to teach it.

good idea...
will go check it now...
thanks

 

[Chamfort]

Database Education

There is a fairly new site that is dedicated to database education (videos). It's konagora There is a free video on database design here (that said, don't expect much in 12 minutes, which is the duration of the video), and there is an SQL course for beginners that is partly free.
I've seen "The Art of SQL" mentioned in another post, the same author is behind the SQL course.

HTH

 

[Alexei]

This will give you both - the theory and practical application:
SQL Videos: The Official Microsoft ASP.NET Site
Reading books won't help as much as doing something real for your purpose.