Managing & Using MySQL

Managing & Using MySQL PDF

Author: George Reese

Publisher: "O'Reilly Media, Inc."

Published: 2002

Total Pages: 445

ISBN-13: 0596002114

DOWNLOAD EBOOK →

MySQL is a robust open source database product that supports key subsets of SQL on both Linux and Unix systems. This text goes through the whole process from installation and configuration to programming interfaces and database administration.

Database Design Manual: using MySQL for Windows

Database Design Manual: using MySQL for Windows PDF

Author: Matthew Norman

Publisher: Springer Science & Business Media

Published: 2006-04-18

Total Pages: 213

ISBN-13: 1852338598

DOWNLOAD EBOOK →

Essential SQL fast provides a comprehensive guide to SQL, using the Windows-based version of MySQL. MySQL is a freely available, multi-platform database management system, making it ideal for learning the techniques and concepts of database design. Using numerous worked examples and illustrations, Matthew Norman describes how to set up the database management system MySQL. In doing so he covers various topics, including: installing and testing MySQL; using the graphical tools; database design techniques and concepts; retrieving, changing and deleting data; and how to make other products communicate with MySQL.

MySQL and MSQL

MySQL and MSQL PDF

Author: Randy Jay Yarger

Publisher: O'Reilly Media

Published: 1999

Total Pages: 522

ISBN-13:

DOWNLOAD EBOOK →

A guide to the SQL-based database applications covers installation, configuration, interfaces, and administration.

MySQL Reference Manual

MySQL Reference Manual PDF

Author: Michael Widenius

Publisher: "O'Reilly Media, Inc."

Published: 2002

Total Pages: 822

ISBN-13: 9780596002657

DOWNLOAD EBOOK →

This comprehensive reference guide offers useful pointers for advanced use of SQL and describes the bugs and workarounds involved in compiling MySQL for every system.

MySQL Pocket Reference

MySQL Pocket Reference PDF

Author: George Reese

Publisher: "O'Reilly Media, Inc."

Published: 2003

Total Pages: 95

ISBN-13: 059600446X

DOWNLOAD EBOOK →

Easy to take and use anywhere, this little book provides instant reminders on how to use important MySQL functions in conjunction with key parts of the LAMP open source infrastructure.

Learning MySQL

Learning MySQL PDF

Author: Seyed Tahaghoghi

Publisher: "O'Reilly Media, Inc."

Published: 2007-11-28

Total Pages: 620

ISBN-13: 0596008643

DOWNLOAD EBOOK →

This new book in the popular Learning series offers an easy-to-use resource for newcomers to the MySQL relational database. This tutorial explains in plain English how to set up MySQL and related software from the beginning, and how to do common tasks.

Murach's MySQL

Murach's MySQL PDF

Author: Joel Murach

Publisher: Mike Murach & Associates

Published: 2015

Total Pages: 0

ISBN-13: 9781890774820

DOWNLOAD EBOOK →

This practical, hands-on tutorial/reference/guide to MySQL is perfect for beginners, but it also works for experienced developers who are not getting the most from MySQL. As you would expect, this book shows how to code all of the essential SQL statements for creating and working with a MySQL database. But beyond that, this book also shows how to design a database, including how to use the graphical MySQL Workbench to create an EER model. It shows how to take advantage of relatively new MySQL features such as foreign keys, transactions, stored procedures, stored functions, triggers, and events. It even presents a starting set of skills for a database administrator (DBA), including how to secure and back up databases. And like all Murach books, it uses the distinctive "paired pages" format, which breaks the material into manageable skills to speed up both learning and reference. A great help for MySQL users at any level.

MySQL Workbench: Data Modeling & Development

MySQL Workbench: Data Modeling & Development PDF

Author: Michael McLaughlin

Publisher: McGraw Hill Professional

Published: 2013-05-06

Total Pages: 481

ISBN-13: 0071791892

DOWNLOAD EBOOK →

The only Oracle Press guide to MySQL Workbench explains how to design and model MySQL databases. MySQL Workbench Data Modeling and Development helps developers learn how to effectively use this powerful product for database modeling, reverse engineering, and interaction with the database without writing SQL statements. MySQL Workbench is a graphical user interface that can be used to create and maintain MySQL databases without coding. The book covers the interface and explains how to accomplish each step by illustrating best practices visually. Clear examples, instructions, and explanations reveal, in a single volume, the art of database modeling. This Oracle Press guide shows you how to get the tool to do what you want. Annotated screen shots demonstrate all interactions with the tool, and text explains the how, what, and why of each step. Complete coverage Installation and Configuration; Creating and Managing Connections; Data Modeling Concepts; Creating an ERD; Defining the Physical Schemata; Creating and Managing Tables; Creating and Managing Relationships; Creating and Managing Views; Creating and Managing Routines; Creating and Managing Routine Groups; Creating and Managing User & Groups; Creating and Managing SQL Scripts; Generating SQL Scripts; Forward Engineering a Data Model; Synchronize a Model with a Database; Reverse Engineering a Database; Managing Differences in the Data Catalog; Creating and Managing Model Notes; Editing Table Data; Editing Generated Scripts; Creating New Instances; Managing Import and Export; Managing Security; Managing Server Instances