Standard SQL guarantees that no matter what the database implementation, the features of the language will be applicable across all platforms.Over 200 completely solved problems plus 200 supplementary problems reinforce students' understanding and skills.Features the syntax used by the most important database developers, Oracle and Microsoft, to familiarize students with this common language.Includes labs and practice tests like those used in database certification exams.
Good affordable Schaums's outlines book. If you have MySQL installed, upload the sample data from the URL given in the book...before you know it, you have learned the nitty-gritty of SQL fundamentals.Schaum's Outline of Fundamentals of SQL Programming
for new DBAs
Published by Thriftbooks.com User , 20 years ago
Are you a new database administrator? Trying to be one? Or needing to pass a certification exam in one of the main proprietary databases, like Oracle, IBM's db2 or Microsoft SQL Server? And you need to prepare for that exam. Well, there are third party books devoted to each vendor's exam. You should probably get an appropriate one and study it carefully. But you can also improve your chances of passing any of those exams by tackling the problems in this book. Mata-Toledo offers some 400 problems. With the answers to half of these in the book. He tests virtually the entire syntax of SQL; an industry standard. Everything from arithmetic functions to group functions to making complex queries, and more. Of course, it will take you time to go through these problems. But that is the point of the book, after all. Also, the book is cheap compared to the other books that specialise in a given database vendor's exam.
ThriftBooks sells millions of used books at the lowest everyday prices. We personally assess every book's quality and offer rare, out-of-print treasures. We deliver the joy of reading in recyclable packaging with free standard shipping on US orders over $15. ThriftBooks.com. Read more. Spend less.