No comments about Diseo de Bases de Datos Relacionales.

No comments about Problem solving for MDX for SQL Server 2005.

No comments about SQL and Relational Databases (Lance a Leventhal Microtrend Series).

No comments about Pro SQL Server 2008 Integration Services.

No comments about Replication and English Query - Essential Reference For Anyone Working With Microsoft SQL Server 2000.

4 comments about Oracle DBA SQL Quick Reference (The Prentice Hall Ptr Oracle Series).

1. Remember the early days of Oracle's products? Now we've reached the heights of Oracle 9i. How things are grown. The multiple table joins; the many obscure syntactical variants added by what are now centuries of person years of coding. Perhaps it is inevitable that any successful software will continually add refinements that increase its capabilities, but usually this is done at a concomitant loss of simplicity. Typically you as a database administrator will rarely use most features. But how to find the occasional rarity that you need, and have forgotten (or perhaps never knew)?

   By definition, the vendor's manuals are authoritative. But often these fall short in usability or pedagogy. (Oracle is by no means alone in this.) So here, Russel and Cordingley give you an independent, simple index into 9i. A quick perusal shows no index. But a second look shows that the entire book is really a graphical index into, and a refresher of, the command syntax. Like conventional indices, the book does not attempt to explain its entries. For example, on page 146, we see a graph for "add hash substitution". They assume you know what this means, but that you need a quick reminder of HOW to invoke it. Given that you have the database and its online help accessible (otherwise why would you need this book?), this is a fair assumption. Clearly, you can consult the online or hardcopy documentation for more information. The stress in the book is on simplicity.

   There is a little irony here. A database is a means whereby you can store data in a silo and easily get summaries and subsets ("views") of it. When you strip away the technical jargon, every database package aspires to this. If you regard the commands and capabilities of a database as data (or metadata), then you cannot usually change these. But how do you get summaries and views of THIS data? That is what the vendor's online help and documentation is all about.

   The irony about this book is not that it was written, but that it was not written by Oracle. The vendor's raison d'etre is to provide tools for access to information. But here, others have seen a need to write another tool to get at the vendor's own data.




2. 80% of this book are flowchart diagrams. 20% of the book are useless tables. There are zero explanations of Oracle or any of the SQL and PL\SQL commands the book professes to explain (only through the flowchart diagrams and tables of course). I would have never bought this book if I had perused through it first. Buyer beware, this book is contains no useful information to the Oracle DBA.



3. The book is truly what the title suggest - a quick reference guide. It makes an Oracle user's life easy by putting SQL commands in a clear concise manner.
   If you are an Oracle user, who uses Oracle extensively using SQL command interface and not the GUI, this book is for you.



4. Type this in Google: "oracle9i sql reference contents".
   You will find better reference, which matches your Oracle version perfectly and contain examples, unlike this book. I bet that this book is a printed version of a similar web site as well, because I found a lot of underlined words in it; some of them links to somewhere in the book, some not.

2 comments about Complete SQL Server 7 Training Course, The.

1. I have not had much experience with SQL Server (as an administrator). Also I was not aware of some tricks defined in this book. Moreover I learnt about the various fancy joins and how to use them.

   GOOD book for beginners to intermediate readers!!




2. This all-in-one multimedia training course is all you need to pass Microsoft's SQL Server 7 exam 70-028. Includes the browser-based "SQL Server 7 Multimedia Cyber Classroom"--over 100 digital videos and over two hours of expert audio demonstrating hundreds of key procedures; the bestselling book "MCSE: Administering Microsoft SQL Server 7"--a complete expert tutorial; and coverage of SQL Server 7 installation, configuration, security, logical structures and more. But I still think that u should read other books as well in order to gain more knowledge because the more books u read the more knowledge u gain, give it try. I am giving it four stars because not a single can be complete u have to take a look to others too.

1 comments about Course ILT: Exam 70-228 MCSE SQL Server 2000 Implementation.

1. I used this book to learn the Microsoft SQL Server and their T-SQL language. I felt that it was a good book and overall I have little ill to say about it. The examples are well written and do a good job of reinforcing what you read in the chapter. You read a little then do an example, then read some more, then add to the example and so on. You don't need any Programming experience to use this book just a decent understanding of database logic. The only criticism I could offer is that the editor should have used arrows when content is being continued on a new line for reasons of page space so that readers will know and understand (beginners can have trouble with this). It's a good book for learning SQL Server as a whole from the ground up and for this reason it's worth the money. It's not an overnight crash course (if that is what you are looking for).

No comments about Using MySQL on Linux.

No comments about SQL. Einstieg und Anwendung..