News for hackers. Stuff that matters.

Learn the Basics of RBD and SQL

Hi. Since I have just finished my degree in CS I was looking for my first job. Now my biggest concern is my poor knowledge about the SQL and Relational Databases. I am looking for good and concrete courses fast to read but difficult to understand. The level of the courses I am looking for are the same as the papers: "A relational model of data for large shared data banks" and "The entity relationship model". The roots of RDB.

Could you help me?

( 3 comments | 5 points | on HN )
Re:Learn the Basics of RBD and SQL by bartonfink on Sunday March 25, 2012 @07:56PM (#3754270)
http://www.db-book.com/

It's a website that's meant to accompany a textbook I used in college, but you don't really need the textbook. This site has slides that cover the material well enough to get started. Note that it's relationally-specific almost to a fault, so you won't get a whole lot of insight into NoSQL if you decide you want to go that route later.

Re:Learn the Basics of RBD and SQL by bgilroy26 on Sunday March 25, 2012 @09:13PM (#3754474)
I got a lot out of Anthony Molinaro's SQL Cookbook, it had a surprising amount of theory in it.

It doesn't sound like you're looking for a cookbook type book though, what I think you're looking for is books by C.J. Date and Joe Celko.

Re:Learn the Basics of RBD and SQL by macarthy12 on Monday March 26, 2012 @06:41AM (#3756004)
Free online course on DB from standford

http://www.db-class.org/course/auth/welcome