
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Learning DATABASE fundamentals just got a whole lot EASIER! Now you can design, build, and manage a fully functional database with ease. Thoroughly updated to cover the latest technologies and techniques, Databases Demystified , Second Edition gives you the hands-on help you need to get started. Written in a step-by-step format, this practical guide covers methods that can be used with any database, including Microsoft Access, MySQL, Microsoft SQL Server, and Oracle. You'll learn about relational database components, database queries, SQL, the database life cycle, logical database design using normalization, and physical database design. Data and process modeling, database security, Online Analytical Processing (OLAP), and XML are also covered. Detailed examples and concise explanations make it easy to understand the material, and end-of-chapter quizzes and a final exam help reinforce learning. It's a no-brainer! You'll find out how to: Create and run database queries using the forms-based query tool in Microsoft Access Write SQL statements and queries Use entity relationship diagrams (ERDs) for data modeling Design physical tables Connect databases to users, computer systems, and applications Secure database data Handle cursor processing, transaction management, and performance tuning Integrate XML documents and objects into databases Simple enough for a beginner, but challenging enough for an advanced student, Databases Demystified , Second Edition is your self-paced guide to learning universal database concepts. Review: Required for class, but it was actually something I’d buy on my own - This was required for a grad course that taught MySQL and aside from being required, I found the book to be pretty helpful. If I hadn’t needed it for the course and were inclined to learn about database design, I would have purchased it anyway. I’m pretty happy with this pick. Review: Recommended - I bought the book because of the good reviews given in desertcart. I am totally satisfied with the book. It gives clear, concise and precise explanation about concepts involving database design. The book should be in the collection of everyone who wants to learn database design. A very good reference for those who wants to refresh their memories about database design. I hope the author could write a continuation of this book to discuss more complicated designs such as the full design of the TLA University Academic Tracking etc.
| Best Sellers Rank | #1,183,965 in Books ( See Top 100 in Books ) #59 in Microsoft Access Database Guides #675 in Database Storage & Design #14,239 in Education (Books) |
| Customer Reviews | 4.3 out of 5 stars 96 Reviews |
M**E
Required for class, but it was actually something I’d buy on my own
This was required for a grad course that taught MySQL and aside from being required, I found the book to be pretty helpful. If I hadn’t needed it for the course and were inclined to learn about database design, I would have purchased it anyway. I’m pretty happy with this pick.
F**E
Recommended
I bought the book because of the good reviews given in Amazon. I am totally satisfied with the book. It gives clear, concise and precise explanation about concepts involving database design. The book should be in the collection of everyone who wants to learn database design. A very good reference for those who wants to refresh their memories about database design. I hope the author could write a continuation of this book to discuss more complicated designs such as the full design of the TLA University Academic Tracking etc.
B**S
Significant Insights Offered in This Database Introductory Text
I must say that I truly love this book. It is easy to follow and also easy to read. The quizzes at the end of each chapter are really engaging and they do require the reader to think. Even though this book is not as "deep" as something you might pick up by CJ Date, you can tell that the writer of this book has truly implemented several database technologies, and is aware of all of the nuances as they exist in the different database programs out there.
D**R
A Decent Overview of DB Concepts
Needed this for a college class. It's a decent book, a little heavy on history (nice to know, but . . .). It provides good detail on queries in Access and SQL. After that it's an overview of DB concepts that you will get in detail if that is your career destination. The section on joins is a little sparse, and I found some simple explanations online that would have fit nicely into the book. One other gripe is that the author uses jargon too early. "A . . . command-line client tool for submitting SQL statements" is in the first sentence of the SQL "getting started" section. Now I know what all that means, but four months ago it made me feel like an idiot.
A**D
Simple and concise, just what I was looking for
For someone who never had any official courses or training in databases, only bits and pieces from things I had to do in work or in university exercises, this book was just what I was looking for. It's simple and gets right to the point. It gives good examples and is really thorough with them, covering a lot of permutations to give the reader the proper intuition in how to deal with the material learned. Overall I am extremely satisfied with this book and highly recommend it.
N**T
Very narrow use of examples and very application specific
I was dissappointed with this book. I found myself skipping whole chapters because they were so application specific (Access) and I just couldn't extrapolate the bigger concepts from the narrow use of applications. It was also a lot more technical then I expected, so I would recommend this book to someone that uses Access specifically, and who has the basics down pretty well, and is looking for a pehaps shorter version of a much more technical book. I haven't quite finished it, so if I find a particularly useful hidden "gem", that makes it more star-worthy I will come back and update.
K**E
A good investment
Excellent, straightforward introduction to databases. It keeps explanations simple, highlights what's most important, and is well structured with each lesson building on the last.
S**M
Databases DeMystified
Exactly as described, good condition. Would order from seller again.
Trustpilot
2 months ago
2 months ago