eBook PDF Download Digital Library
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.
Author: Gokhan Ozar
Publisher: Packt Publishing Ltd
Published: 2012-09-13
Total Pages: 182
ISBN-13: 1849687471
DOWNLOAD EBOOK →Master the tools you thought you knew and discover the features you never knew existed.
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.
Author: Tim King
Publisher: "O'Reilly Media, Inc."
Published: 2002-04-23
Total Pages: 445
ISBN-13: 1449316786
DOWNLOAD EBOOK →MySQL is a popular and robust open source database product that supports key subsets of SQL on both Linux and Unix systems. MySQL is free for nonprofit use and costs a small amount for commercial use. Unlike commercial databases, MySQL is affordable and easy to use. This book includes introductions to SQL and to relational database theory. If you plan to use MySQL to build web sites or other Linux or Unix applications, this book teaches you to do that, and it will remain useful as a reference once you understand the basics. Ample tutorial material and examples are included throughout. This book has all you need to take full advantage of this powerful database management system. It takes you through the whole process from installation and configuration to programming interfaces and database administration. This second edition has a greatly enhanced administration chapter that includes information on administrative tools, server configuration, server startup and shutdown, log file management, database backup and restore, and database administration and repair. In addition, a new chapter on security describes data, server, and client-server security, while a chapter on extending MySQL provides an overview of MySQL internals and describes the use of MySQL user-defined functions. If you know C/C++, Java, Perl, PHP, or Python, you can write programs to interact with your MySQL database. In addition, you can embed queries and updates directly in an HTML file so that a web page becomes its own interface to the database. Managing and Using MySQL includes chapters on the programming language interfaces, and it also includes a complete reference section with specific function calls for each language. Also included in the reference section are references to the SQL language, and details of the MySQL system variables, programs, and utilities. New to the second edition is a reference to the internal MySQL tables, which will be of particular interest to those who want to work extensively with MySQL security.
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.
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.
Author: Rick F. van der Lans
Publisher: Pearson Education
Published: 2007-04-20
Total Pages: 1032
ISBN-13: 9780132715898
DOWNLOAD EBOOK →The Most Complete and Practical Guide to MySQL Version 5’s Powerful SQL Dialect MySQL version 5 offers a SQL dialect with immense power. In SQL for MySQL Developers, Rick F. van der Lans helps you master this version ofSQL and take advantage of its full potential. Using case study examplesand hands-on exercises, van der Lans illuminates every key concept,technique, and statement–including advanced features that make iteasier to create even the most complex statements and programs. Drawing on decades of experience as an SQL standards team member and enterprise consultant, he reveals exactly why MySQL’s dialect works as it does–and how to get the most out of it. You’ll gain powerful insight into everything from basic queries to stored procedures, transactions to data security. Whether you’re a programmer, Web developer, analyst, DBA, or database user, this book can take you from “apprentice” to true SQL expert. If you’ve used SQL in older versions of MySQL, you’ll become dramatically more effective–and if you’re migrating from other database platforms, you’ll gain practical mastery fast.
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
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.
