Master today's SQL programming principles and learn how to most effectively apply your SQL skills with Shellman/Afyouni/Pratt/Last's A GUIDE TO SQL, Tenth Edition. This edition's leading approach combines straightforward instruction and extensive hands-on exercises with a strong foundation and emphasis on today's actual business applications. This edition introduces basic SQL commands in the context of an intriguing, ongoing case in which a business uses SQL to manage orders, items, customers and sales reps. This edition emphasizes how to apply fundamental principles and strengthen your programming practices, regardless of the database environment. You work with examples from the latest versions of MySQL, the world's most popular open source, free database, as well as Oracle and Microsoft SQL Server. In addition, MindTap digital learning solution is available to help you strengthen your SQL skills.
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.