Reddit reviews Database Systems: The Complete Book (2nd Edition)
We found 11 Reddit comments about Database Systems: The Complete Book (2nd Edition). Here are the top ones, ranked by their Reddit score.
The best way I know how is by solving problems yourself and looking at good solutions of others.
You could consider going back to "fundamentals".
Most programming courses, IMO, don't have nearly as many exercises I think they should have. Some books are particularly good on their exercises list, for example K&R2, SICP, and TC++PL. Deitel's has long exercises lists, but I don't think they're particularly challenging.
There are some algorithms/DS books which focus on the sort of problem solving which is about finding solutions to problems in context (not always a "realistic" one). Like the "Programming Challenges" book. In a book like that, a problem won't be presented in a simple abstract form, like "write an algorithm to sort numbers". It'll be inside some context, like a word problem. And to solve that "word problem", you'll have to find out which traditional CS problems you could solve/combine to get the solution. Sometimes, you'll just have to roll something on your own. Like a new algorithm for the problem at hand. In general, this helps you work out your reduction skills, for once. It also helps you spotting applications to those classical CS problems, like graph traversal, finding shortest plath, and so forth.
Most algorithms/DS books though will present problems in a pretty abstract context. Like Cormen's.
I think, however, people don't give enough credit to the potential of doing the exercises on the books I've mentioned in the beginning.
Some books I think are worth reading which also have good exercises:
I imagine the other Stroustrupp programming book also has good exercises, but I've never read it. Brian Kernighan is not only the author of K&R2, but of many other books. You could look at his stuff.
Depending on what you mean by good code, though, you could look at other books.
There are also the math books. I'd not discard those. And also, there are other programming books as well. Some I've never read, but want to, like Programming Pearls:
Not only those, but, anyway... The point is that you can look at those books to find examples of good code, good exercises, challenges and so forth.
Here are some books I've mentioned previously:
By the way, there are websites with programming challenges for you to look at too. Like https://projecteuler.net/ and others. Just start looking this up and you'll find plenty. They all tend to start dumb easy and move up the difficulty to pretty damn difficult stuff from what I've heard.
Edit: SICP is available for free (http://mitpress.mit.edu/sicp/) together with videos from the course taught at MIT in 85 (http://ocw.mit.edu/courses/electrical-engineering-and-computer-science/6-001-structure-and-interpretation-of-computer-programs-spring-2005/video-lectures/).
Please put the title/name of what you're linking to so everyone doesn't have to follow an opaque link to find out.
The link is to: Database Systems: The Complete Book (2nd Edition) by Garcia-Molina, Ullman, and Widom.
(I've never read or head of this book, I'm just giving the name not recommending it).
RAID
"How they [databases] work:"
Fundamentals of Database Systems
Database Systems: The Complete Book
https://www.amazon.com/gp/product/0131873253/
I used this one, and thought it did a good job. http://www.amazon.com/Database-Systems-Complete-Book-Edition/dp/0131873253
If you're self-studying I'd recommend following MIT open courseware, or something similar. It will help guide you through projects, etc. http://ocw.mit.edu/courses/electrical-engineering-and-computer-science/6-830-database-systems-fall-2010/
If you like operating on the formal/theoretical side, I recommend this book:
http://www.amazon.com/Database-Systems-Complete-Book-2nd/dp/0131873253/ref=sr_1_2?ie=UTF8&s=books&qid=1239395498&sr=8-2
Although the price is a bit high these days. Perhaps you can find a used copy at a good price.
Two books to checkout could be:
I'm not sure if these recommendations would be of much help. I'm not an expert either. However, though I'd put the names out there just in case.
> MSCA: SQL Server
Is a good choice. At the same time I see such programs and certificates as credentials for those who already have some experience.
If you
> have a good working knowledge of relational databases in general and know the general dialect of SQL pretty well already
it might be the right choice. It is not perfect but quite good.
> I've done a bunch of practice on sqlzoo.net and gone through a few database/SQL courses on Lynda.com
Take a look at https://lagunita.stanford.edu/courses/Home/Databases/Engineering/about and https://academy.vertabelo.com/blog/18-best-online-resources-for-learning-sql-and-database-concepts/ also.
A bit more:
Books from
https://en.wikipedia.org/wiki/Christopher_J._Date
https://www.amazon.com/Seven-Databases-Weeks-Modern-Movement/dp/1934356921/
https://www.amazon.com/Database-Systems-Complete-Book-2nd/dp/0131873253
I think an example might be, do laundry: repeat every 1 week or so.
So your primary table would be something like this:
CREATE TABLE task (
User string varchar(255) NOT NULL,
TaskName varchar(255) NOT NULL,
Date DateTime DEFAULT(getdate()),
... any other fields you want
PRIMARY KEY (User, TaskName, DateTime)
)
Forgive me if my syntax is wrong, I don't sql all too often.
Anyway, suppose a user logs in. When they login you are able to:
SELECT * FROM task where User=/username/
Excellent, you can now render this on your front end and update it as needed. Just remember, if you make changes on your front end, you need to update it on your back end :).
If you are interested in getting some of the theory behind DBs, I would recommend checking a book out. I used this in school. It treated me pretty well, but there is no need to read every chapter! (seriously, unless you want to be a DBA). I would look up the important subject covered in some schools curriculum and go from there. Learn some relation algebra, ddl, dml then data normalization and you're off. DBs are pretty easy to work with.
The book that I used in grad school is this.
The first 8 chapters are good for what is typically covered in an undergrad course. We reviewed those chapters in the first few weeks of the grad course. I did a very academic career path, so mostly what I know is books.
http://www.amazon.com/Database-Systems-Complete-Book-2nd/dp/0131873253
teaches you theory, implementation, design, sql.....