A GUIDE TO SQL, 8E, illustrates the basics of SQL programming using straightforward instruction and extensive hands-on exercises. Phil Pratt and Mary Last continue to present basic SQL commands in a business context using Oracle. A new running case, for a total of three, presents lessons in a real-world context for managing orders, parts, customers, and sales reps. The text provides hands-on projects at the end of each chapter, including review questions, running cases, and extensive exercises, providing students with the opportunity to solve problems and apply skills from each chapter.
For a textbook, it had its moments. I don't think I've ever read a textbook so thoroughly in my life, so I feel justified in putting it in my GR library.
Screen shot examples were very difficult to visually see. Ended up dropping the class because I could not visually see the text to get assignments done. The color scheme of content was not a good choice.
Solid way to learn SQL. If I had to read the whole thing for school, you bet it’s going in Goodreads! 😂😂 I don’t think I’ve ever read a textbook cover to cover the way I read this. I’m glad I did!
This is only good for extremely basic SQL queries. It has examples of every single query, so it's great as a reference, but it doesn't get into anything that's slightly complicated if you wanted to build your own database. However, I've heard that there are no good intro-to-SQL books, that's they're all way too easy, like this one, or they're way too difficult to understand. I guess I could give it three stars. It's an average book.
All exercise in this book basically made and followed in Oracle form. But I am not an oracle person, I can only know MS SQL and I tried 'em on MS SQL way.