SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL (2nd Edition) [Kindle Edition]
Author: John L. Viescas | Language: English | ISBN: B000WJOWGM
| Format: PDF, EPUB
SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL Free PDF
Free download SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL Free PDF from mediafire, rapishare, and mirror link This is the eBook version of the printed book.
Over the last several decades, SQL has evolved from a language known only to computer specialists to a widely used international standard of the computer industry. The number of new applications deployed each year using SQL now totals in the millions. If you are accessing corporate information from the Internet or from an internal network, you are probably using SQL. This new edition of SQL Queries for Mere Mortals helps new users learn the foundations of SQL queries, and is an essential reference guide for intermediate and advanced users. Download latest books on mediafire and other links compilation SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL Free PDF
- File Size: 23170 KB
- Print Length: 672 pages
- Simultaneous Device Usage: Up to 5 simultaneous devices, per publisher limits
- Publisher: Addison-Wesley Professional; 2 edition (September 24, 2007)
- Sold by: Amazon Digital Services, Inc.
- Language: English
- ASIN: B000WJOWGM
- Text-to-Speech: Enabled
- Lending: Not Enabled
- Amazon Best Sellers Rank: #165,234 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
It's easy to find a good book that will provide definitions and examples for inner joins vs. outer joins, subqueries, etc. You can read them and understand the definitions and/or examples, however, when you come across a 10 - 20 line query in your job or have to create your own complicated query from scratch you realize just how tenuous your gut-level understanding of this mysterious thing called SQL really is.
This book will give you the gut-level understanding you so desperately crave - and need if you are working with databases.
The authors provide clear explanations of the various SQL constructs for both the SQL Standard and real world levels (which are oftentimes two different things). They further deconstruct real-world issues by also describing the anomalies between some of the more popular databases.
But you can get all this from just about any other good SQL book. Where this one really shines is the way it leads you from simple to more and more complex queries via well-crafted and well-explained examples. They progress from simple queries to queries containing expressions to filtering data with a 'where' clause to inner joins to outer joins to unions to subqueries to aggregate functions to grouping data and then filtering that data by 'having' clauses. They end up by covering updating, inserting, and deleting data.
They give tons of examples that illustrate how to solve common problems and the more trickier "gotchas" that you're likely to run into. These examples occur both within the meat of the chapter, i.e. where they are explaining terms and concepts, and at the end of the chapter where they describe how and why they put the queries together the way they did.
The queries are all against 5 databases containing from 6 to 13 tables each.
I was in the process of teaching myself SQL. At first I went on the tutorial on the mysql website, which was good, but the examples were very small. You could cut & paste data from the web page into a file and then LOAD DATA LOCAL ... the data into a table, but the data wasn't quite formatted right and you had to massage it. And all the examples were pretty small, and the tutorial ran through the material pretty quickly.
I went to a bookstore and paid $65 for this book, (I could have gotten it from Amazon a lot cheaper than that, but I was in a hurry). I feel it was a good investment. The CD-Rom contains several example databases, and they're pretty big and complex. Another reviewer pointed out that getting the files off the CD isn't always easy. My mysql installation is on linux, and I couldn't see the files on the CD, but I also have an XP box, and was able to download the files there and transfer them over to my Linux box.
The text always refers to the databases on the CD rom, and it has a LOT of examples, so you can try any of the given examples and modify your query to see what else happens. Each chapter has many examples in the text, but at least a dozen further examples at the end of each chapter. What's more, there are solutions to the examples on the CD Rom. Having large, complex databases to work with interactively was great, as was having a lot of examples.
The pace of the text is slow, which is fine, if you feel you understand what they're saying you can skim forward. In the examples in the text, they use pretty verbose SQL -- they tell you, for example, what a natural join is, and what "using" means, but after that they never use these techniques in subsequent examples, though it would shorten the solutions a bit.
SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL DownloadPlease Wait...