* Shows how to take advantage of MySQL's built-in functions, minimizing the need to process data once it's been retrieved from the database.
* Demonstrates how to write and use advanced and complex queries to cut down on (middleware) application logic, including nested sub-queries and virtual tables (added since MySQL 4.1).
* Points out database design do's and don'ts, including many real-world examples of bad database designs and how the databases were subsequently improved.
* Includes a review of MySQL fundamentals and essential theory, such as naming conventions and connections, for quick reference purposes.
Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.
Chad Russell is a programmer and network administrator who owns his own Internet hosting company. He previously has written on MySQL, PHP, and other topics.
Nearly every non-trivial application requires data persistence, and for an application of any significant size and scope, persistence is typically achieved using a database. If you’re building or maintaining any significant application and are using MySQL, this book is for you. For open source and other types of projects, the MySQL database is a very popular choice: it’s free, fast, robust, and scalable, and it runs on all of the major platforms, allowing maximum use of available hardware resources. But it’s easy to disregard MySQL’s speed and other advantages if your database design is inefficient. Needlessly duplicating data, using improper types for columns, overloading a single table where multiple tables should be used, failing to leverage the calculation features of MySQL, and making multiple queries instead of an efficient single query are some of the common mistakes. Beginning MySQL Database Design and Optimization shows you how to identify, overcome, and avoid gross inefficiencies. It demonstrates how to maximize the many data manipulation features that MySQL includes. This book explains how to include tests and branches in your queries, how to normalize your database, and how to issue concurrent queries to boost performance, among many other design and optimization topics. You’ll also learn about some features new to MySQL 4.1 and 5.0 like subqueries, stored procedures, and views, all of which will help you build even more efficient applications.
Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.
Da: BooksRun, Philadelphia, PA, U.S.A.
Paperback. Condizione: Very Good. First Edition. It's a well-cared-for item that has seen limited use. The item may show minor signs of wear. All the text is legible, with all pages included. It may have slight markings and/or highlighting. Codice articolo 1590593324-11-1
Quantità: 2 disponibili
Da: Better World Books Ltd, Dunfermline, Regno Unito
Condizione: Very Good. 1st Edition. Former library copy. Pages intact with possible writing/highlighting. Binding strong with minor wear. Dust jackets/supplements may not be included. Includes library markings. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good. Codice articolo 10329865-20
Quantità: 1 disponibili
Da: Lakeside Books, Benton Harbor, MI, U.S.A.
Condizione: New. Brand New! Not Overstocks or Low Quality Book Club Editions! Direct From the Publisher! We're not a giant, faceless warehouse organization! We're a small town bookstore that loves books and loves it's customers! Buy from Lakeside Books! Codice articolo OTF-Y-9781590593325
Quantità: Più di 20 disponibili
Da: GreatBookPrices, Columbia, MD, U.S.A.
Condizione: New. Codice articolo 2495760-n
Quantità: 15 disponibili
Da: BargainBookStores, Grand Rapids, MI, U.S.A.
Paperback or Softback. Condizione: New. Beginning MySQL Database Design and Optimization: From Novice to Professional. Book. Codice articolo BBS-9781590593325
Quantità: 5 disponibili
Da: GreatBookPrices, Columbia, MD, U.S.A.
Condizione: As New. Unread book in perfect condition. Codice articolo 2495760
Quantità: 15 disponibili
Da: California Books, Miami, FL, U.S.A.
Condizione: New. Codice articolo I-9781590593325
Quantità: Più di 20 disponibili
Da: Chiron Media, Wallingford, Regno Unito
PF. Condizione: New. This item is printed on demand. Brand new book, sourced directly from publisher. Dispatch time is 6-7 days from our warehouse. Book will be sent in robust, secure packaging to ensure it reaches you securely. Codice articolo 6666-IUK-9781590593325
Quantità: 20 disponibili
Da: Kennys Bookshop and Art Galleries Ltd., Galway, GY, Irlanda
Condizione: New. 2004. First Edition. paperback. . . . . . Codice articolo V9781590593325
Quantità: 15 disponibili
Da: Half Price Books Inc., Dallas, TX, U.S.A.
paperback. Condizione: Very Good. Connecting readers with great books since 1972! Used books may not include companion materials, and may have some shelf wear or limited writing. We ship orders daily and Customer Service is our top priority! Codice articolo S_490145154
Quantità: 1 disponibili