Would you like to tell us about a lower price? If you are a seller for this product, would you like to suggest updates through seller support? Database management. It may sound daunting, but it doesn't have to be, even if you've never programmed before.
|Published (Last):||3 August 2015|
|PDF File Size:||7.22 Mb|
|ePub File Size:||16.55 Mb|
|Price:||Free* [*Free Regsitration Required]|
As dynamic, database-driven Web sites become the standard, more and more nonprogrammers just like yourself are being forced to work with database information and create and edit database objects. After going over the relational database model and SQL syntax in the first few chapt. After going over the relational database model and SQL syntax in the first few chapters, veteran author Chris Fehily launches into the tasks that will get you comfortable with SQL fast.
In addition to explaining SQL basics, this updated reference covers the ANSI SQL standard and contains a wealth of brand-new information, including a new chapter on set operations and common tasks, well-placed optimization tips to make your queries run fast, sidebars on advanced topics, and added IBM DB2 coverage.
On the companion Web site, you can download the SQL scripts and sample database for all these systems and put your knowledge to work immediately on a real database.. Goodreads helps you keep track of books you want to read.
Want to Read saving…. Want to Read Currently Reading Read. Other editions. Enlarge cover. Error rating book. Refresh and try again. Open Preview See a Problem? Details if other :. Thanks for telling us about the problem. Return to Book Page. After going over the relational database model and SQL syntax in the first few chapt As dynamic, database-driven Web sites become the standard, more and more nonprogrammers just like yourself are being forced to work with database information and create and edit database objects.
Get A Copy. Paperback , Second Edition , pages. Published May 12th by Peachpit Press first published July 29th More Details Original Title. Other Editions 9. Friend Reviews. To see what your friends thought of this book, please sign up. To ask other readers questions about SQL , please sign up. Lists with This Book. This book is not yet featured on Listopia. Community Reviews. Showing Average rating 3.
Rating details. More filters. Sort order. Ok wow nobody is going to care about this review and I promise I'll review an actual book soon my copy of I Hate Everyone But You just came in the mail! But I felt like this was very basic?? Like just simple select queries, creating tables, etc.
Not even anything about sto Ok wow nobody is going to care about this review and I promise I'll review an actual book soon my copy of I Hate Everyone But You just came in the mail! Not even anything about stored procedures. In conclusion: I'm very smart thank you and goodnight.
Nice book covering basics of SQL. May be good choice for quick recap. What I liked are: a lot of examples based on the same simple dataset which makes them clear and easy to compare and showing differences between most popular DBMS for each and every functionality described.
The book covered a variety of DBMSs, which is mostly a distraction but could be a benefit if you are unsure what DBMS you want to dedicate yourself to for a time and so would like to try a few before making a greater commitment. It did its job as an introductory book but not all material was accurate according to a more experienced developer I have talked to on it. There was a fair amount of practice material, but not in a very useful format. If the exercises were in a format with a given proble The book covered a variety of DBMSs, which is mostly a distraction but could be a benefit if you are unsure what DBMS you want to dedicate yourself to for a time and so would like to try a few before making a greater commitment.
If the exercises were in a format with a given problem and a defined but separate solution then that would be more practical for learning than simply giving up the answers. This book is a lesson in good educational design. It was a perfect match, at least, for the way that I learn. That's high praise for a reference book from , but SQL isn't complicated enough to warrant a step-by-step approach and it was more than enough to show me what's possible, how it's generally done, and how to tailor the SQL statements for different DBMS.
There were only a few occasions on which I had to scroll down to the 'fine print' in Microsoft's Access documentation to troubleshoot This book is a lesson in good educational design. There were only a few occasions on which I had to scroll down to the 'fine print' in Microsoft's Access documentation to troubleshoot a statement. View 2 comments. It's been 4 or 5 years since I've done anything with SQL, so I was hoping to use this to shake off the rust.
Related topics seem to be scattered about rather than grouped together, which makes it difficult to go through from start to finish. Its explanations and examples are also fairly wordy, which makes this difficult to use as a reference. I ended up having to rely on an older SQL book and searching the internet for updates to the language to get back up to speed.
Jan 04, Mohamad Fazeli rated it really liked it. It is fairly short but comprehensive introduction to standard SQL, the book has fair amount of examples, that illustrate concepts well enough. Feb 16, Kevin rated it really liked it. Still use this is a reference book while working, highly recommended if you're kind of slow like me. A really handy reference and good learning tool. Hard to get passionate about a textbook but this is easy to read and useful. Scott rated it really liked it Nov 16, Scott rated it liked it Dec 24, Mark Bergdahl rated it it was amazing Mar 10, Brooke Wurtz rated it really liked it Nov 18, Lillian Fleming rated it it was amazing Oct 05, Kim Buchanan rated it really liked it Mar 12, Saurabh Gupta rated it liked it Apr 26, Greg Wilson rated it liked it Dec 29, Andrew Savva rated it really liked it Apr 28, Monica Bell rated it really liked it Jan 07, Will rated it liked it Sep 03, Spirit Crusher rated it it was amazing Jul 20, Joe rated it it was amazing Mar 29, Hong rated it really liked it Aug 18, Matt N rated it it was amazing Feb 20, Charles rated it really liked it Sep 18, Brandon Kessler rated it really liked it Jan 02, Mollie Echeverria rated it liked it Dec 28, There are no discussion topics on this book yet.
Readers also enjoyed. Goodreads is hiring! If you like books and love to build cool products, we may be looking for you. About Chris Fehily. Chris Fehily. Books by Chris Fehily.
As dedicated readers already know, some of the best and most innovative stories on the shelves come from the constantly evolving realm of young ad Read more Trivia About SQL. No trivia or quizzes yet. Quotes from SQL. More-complex UDTs are similar to classes in object-oriented programming languages such as Java or Python.
Search your DBMS documentation for user-defined type. Welcome back. Just a moment while we sign you in to your Goodreads account.
ISBN 13: 9780321553577
SQL is a standard interactive and programming language for querying and modifying data and managing databases. This task-based tutorial and reference guide takes the mystery out learning and applying SQL. After going over the relational database model and SQL syntax in the first few chapters, veteran author Chris Fehily immediately launches into the tasks that will get readers comfortable with SQL. In addition to covering all the SQL basics, this thoroughly updated reference contains a wealth of in-depth SQL knowledge and serves as an excellent reference for more experienced users. Chris Fehily is a statistical consultant and bestselling technical author. Convert currency. Add to Basket.
SQL (Visual QuickStart Guide)