Your email was sent successfully. Check your inbox.

An error occurred while sending the email. Please try again.

Proceed reservation?

Export
  • 1
    Online Resource
    Online Resource
    Database design for mere mortals : a hands-on guide to relational database design (2013)
    Upper Saddle River, NJ : Addison-Wesley
    Details
    ISBN: 9780133122282 , 013312228X
    Language: English
    Pages: 1 online resource (1 v.) , ill.
    Edition: 3rd ed.
    Parallel Title: Erscheint auch als
    Keywords: Database design ; Relational databases ; Electronic books ; Electronic books ; local
    Abstract: The #1 Easy, Commonsense Guide to Database Design! Michael J. Hernandez's best-selling Database Design for Mere Mortals® has earned worldwide respect as the clearest, simplest way to learn relational database design. Now, he's made this hands-on, software-independent tutorial even easier, while ensuring that his design methodology is still relevant to the latest databases, applications, and best practices. Step by step, Database Design for Mere Mortals ® , Third Edition, shows you how to design databases that are soundly structured, reliable, and flexible, even in modern web applications. Hernandez guides you through everything from database planning to defining tables, fields, keys, table relationships, business rules, and views. You'll learn practical ways to improve data integrity, how to avoid common mistakes, and when to break the rules. Coverage includes Understanding database types, models, and design terminology Discovering what good database design can do for you-and why bad design can make your life miserable Setting objectives for your database, and transforming those objectives into real designs Analyzing a current database so you can identify ways to improve it Establishing table structures and relationships, assigning primary keys, setting field specifications, and setting up views Ensuring the appropriate level of data integrity for each application Identifying and establishing business rules Whatever relational database systems you use, Hernandez will help you design databases that are robust and trustworthy. Never designed a database before? Settling for inadequate generic designs? Running existing databases that need improvement? Start here.
    Note: Includes bibliographical references and index. - Description based on print version record
    URL: https://learning.oreilly.com/library/view/-/9780133122282/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 2
    Online Resource
    Online Resource
    SQL queries for mere mortals : a hands-on guide to data manipulation in SQL (2014)
    Upper Saddle River, NJ : Addison-Wesley
    Details
    ISBN: 9780133824889 , 0133824888
    Language: English
    Pages: 1 online resource (1 v.) , ill.
    Edition: 3rd ed.
    Series Statement: For mere mortals series
    Keywords: SQL (Computer program language) ; Database searching ; Electronic books ; Electronic books ; local
    Abstract: The #1 Easy, Common-Sense Guide to SQL Queries-Updated for Today's Databases, Standards, and Challenges SQL Queries for Mere Mortals ® has earned worldwide praise as the clearest, simplest tutorial on writing effective SQL queries. The authors have updated this hands-on classic to reflect new SQL standards and database applications and teach valuable new techniques. Step by step, John L. Viescas and Michael J. Hernandez guide you through creating reliable queries for virtually any modern SQL-based database. They demystify all aspects of SQL query writing, from simple data selection and filtering to joining multiple tables and modifying sets of data. Three brand-new chapters teach you how to solve a wide range of challenging SQL problems. You'll learn how to write queries that apply multiple complex conditions on one table, perform sophisticated logical evaluations, and think "outside the box" using unlinked tables. Coverage includes -- Getting started: understanding what relational databases are, and ensuring that your database structures are sound -- SQL basics: using SELECT statements, creating expressions, sorting information with ORDER BY, and filtering data using WHERE -- Summarizing and grouping data with GROUP BY and HAVING clauses -- Drawing data from multiple tables: using INNER JOIN, OUTER JOIN, and UNION operators, and working with subqueries -- Modifying data sets with UPDATE, INSERT, and DELETE statements Advanced queries: complex NOT and AND, conditions, if-then-else using CASE, unlinked tables, driver tables, and more Practice all you want with downloadable sample databases for today's versions of Microsoft Office Access, Microsoft SQL Server, and the open source MySQL database. Whether you're a DBA, developer, user, or student, there's no better way to master SQL. informit.com/aw forMereMortals.com
    Note: Includes bibliographical references and index. - Description based on online resource; title from title page (Safari, viewed June 19, 2014)
    URL: https://learning.oreilly.com/library/view/-/9780133824889/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 3
    Online Resource
    Online Resource
    Database design for mere mortals : a hands-on guide to relational database design (1997)
    Reading, Mass. : Addison-Wesley Developers Press | Boston, MA :Safari,
    Details
    Language: English
    Pages: xl, 440 p. , ill. ; , 23 cm
    DDC: 005.75/6
    Keywords: Database design ; Relational databases ; Electronic books ; local
    Abstract: Sound design can save you hours of development time before you write a single line of code. Based on the author's years of experience teaching this material, Database Design for Mere Mortals is a straightforward, platform-independent tutorial on the basic principles of relational database design. Database design expert Michael J. Hernandez introduces the core concepts of design theory and method without the technical jargon. Database Design for Mere Mortals will provide any developer with a common-sense design methodology for developing databases that work. 0201694719B04062001
    Note: Includes bibliographical references (p. 433) and index
    URL: https://learning.oreilly.com/library/view/-/0201694719/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 4
    Online Resource
    Online Resource
    Database design for mere mortals : a hands-on guide to relational database design (2003)
    Boston : Addison-Wesley | Boston, MA :Safari,
    Details
    Language: English
    Pages: lii, 611 p. , ill. ; , 24 cm. +
    Edition: 2nd ed.
    DDC: 005.75/6
    Keywords: Database design ; Relational databases ; Electronic books ; local
    Abstract: "This book takes the somewhat daunting process of database design and breaks it into completely manageable and understandable components. Mike's approach whilst simple is completely professional, and I can recommend this book to any novice database designer." - Sandra Barker , Lecturer, University of South Australia, Australia "Databases are a critical infrastructure technology for information systems and today's business. Mike Hernandez has written a literate explanation of database technology-a topic that is intricate and often obscure. If you design databases yourself, this book will educate you about pitfalls and show you what to do. If you purchase products that use a database, the book explains the technology so that you can understand what the vendor is doing and assess their products better." - Michael Blaha , consultant and trainer, author of A Manager's Guide to Database Technology "If you told me that Mike Hernandez could improve on the first edition of Database Design for Mere Mortals I wouldn't have believed you, but he did! The second edition is packed with more real-world examples, detailed explanations, and even includes database-design tools on the CD-ROM! This is a must-read for anyone who is even remotely interested in relational database design, from the individual who is called upon occasionally to create a useful tool at work, to the seasoned professional who wants to brush up on the fundamentals. Simply put, if you want to do it right, read this book!" - Matt Greer , Process Control Development, The Dow Chemical Company "Mike's approach to database design is totally common-sense based, yet he's adhered to all the rules of good relational database design. I use Mike's books in my starter database-design class, and I recommend his books to anyone who's interested in learning how to design databases or how to write SQL queries." - Michelle Poolet , President, MVDS, Inc. "Slapping together sophisticated applications with poorly designed data will hurt you just as much now as when Mike wrote his first edition, perhaps even more. Whether you're just getting started developing with data or are a seasoned pro; whether you've read Mike's previous book or this is your first; whether you're happier letting someone else design your data or you love doing it yourself-this is the book for you. Mike's ability to explain these concepts in a way that's not only clear, but fun, continues to amaze me." -From the Foreword by Ken Getz , MCW ...
    Note: Includes bibliographical references (p. 599-600) and index
    URL: https://learning.oreilly.com/library/view/-/0201752840/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 5
    Online Resource
    Online Resource
    SQL queries for mere mortals : a hands-on guide to data manipulation in SQL (2007)
    Upper Saddle River, N.J. : Addison-Wesley | Boston, Mass. :Safari Books Online
    Details
    ISBN: 9780321444431 , 0321444434
    Language: English
    Edition: 2nd ed.
    Keywords: SQL (Computer program language) ; Database searching ; Electronic books ; local
    Abstract: Unless you are working at a very advanced level, this is the only SQL book you will ever need. The authors have taken the mystery out of complex queries and explained principles and techniques with such clarity that a "Mere Mortal" will indeed be empowered to perform the superhuman. Do not walk past this book! --Graham Mandeno, Database Consultant SQL Queries for Mere Mortals provides a step-by-step, easy-to-read introduction to writing SQL queries. It includes hundreds of examples with detailed explanations. This book provides the tools you need to understand, modify, and create SQL queries --Keith W. Hare, Convenor, ISO/IEC JTC1 SC32 WG3--the International SQL Standards Committee I learned SQL primarily from the first edition of this book, and I am pleased to see a second edition of this book so that others can continue to benefit from its organized presentation of the language. Starting from how to design your tables so that SQL can be effective (a common problem for database beginners), and then continuing through the various aspects of SQL construction and capabilities, the reader can become a moderate expert upon completing the book and its samples. Learning how to convert a question in English into a meaningful SQL statement will greatly facilitate your mastery of the language. Numerous examples from real life will help you visualize how to use SQL to answer the questions about the data in your database. Just one of the "watch out for this trap" items will save you more than the cost of the book when you avoid that problem when writing your queries. I highly recommend this book if you want to tap the full potential of your database. --Kenneth D. Snell, Ph.D., Database Designer/Programmer I don't think they do this in public schools any more, and it is a shame, but do you remember in the seventh and eighth grades when you learned to diagram a sentence? Those of you who do may no longer remember how you did it, but all of you do write better sentences because of it. John Viescas and Mike Hernandez must have remembered because they take everyday English queries and literally translate them into SQL. This is an important book for all database designers. It takes the complexity of mathematical Set Theory and of First Order Predicate Logic, as outlined in E. F. Codd's original treatise on relational database design, and makes it easy for anyone to understand. If you want an elementary- through intermediate-level course on SQL, this is the one...
    Note: Includes bibliographical references and index
    URL: https://learning.oreilly.com/library/view/-/9780321444431/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
Close ⊗
This website uses cookies and the analysis tool Matomo. More information can be found here...