Managing & using MySQL
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 introduct...
| Autor principal: | |
|---|---|
| Otros Autores: | , , |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, California ; Farnham :
O'Reilly
2012.
2002. |
| Edición: | 2nd ed |
| Colección: | Safari electronic books.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627098206719 |
Tabla de Contenidos:
- Table of Contents; Preface; Audience; Purpose; Using This Book; Conventions Used in This Book; Comments and Questions; Acknowledgments; From Randy Yarger; From George Reese; From Tim King; Part I; MySQL; Relational Databases; The History of MySQL; MySQL Design; MySQL Features; MySQL Applications; What You Get; Installation; Preparation; Unix Installation; Binary (Tarball) Distributions; Binary (RPM) Distributions; Source Distributions; Windows Installation; Windows 9x Startup; Windows NT/2000 Startup; SQL According to MySQL; SQL Basics; The SQL Story; The Design of SQL; Sending SQL to MySQL
- Database CreationTable Management; MySQL Data Types; Numeric Types; Character Types; Binary Data Types; Enumerations and Sets; Other Kinds of Data; Indexing; Managing Data; Inserts; Sequence Generation; Updates; The WHERE Clause; Deletes; Queries; Joins; Aliasing; Ordering and Grouping; Basic ordering; Localized sorting; Grouping; Limiting Results; SQL Operators; Logical Operators; Null's Idiosyncrasies; Membership Tests; Pattern Matching; Advanced Features; Full Text Searching; The Basics; Relevance values; Boolean mode; Tips; Transactions; Table Locking; Functions; Date functions
- String functionsOuter Joins; Unions; Batch Processing; Command-line loads; The LOAD command; Pulling data from MySQL; Database Administration; Configuration; File Locations; File Content; Server Startup and Shutdown; Unix/Linux; SVR4; Other Unix; Mac OS X; Windows NT/2000; Logging; The Error Log; The Binary Log; The Slow Query Log; Log Rotation; Backup; mysqldump; mysqlhotcopy; Recovery; mysqldump Recovery; mysqlhotcopy Recovery; Table Maintenance and Crash Recovery; Checking a Table; Repairing a Table; Scheduled Table Checking; Part II; Performance Tuning; An Approach to Performance Tuning
- Application TuningHost Application Tuning; SQL Query Tuning; Index guidelines; EXPLAIN SELECT; Other options; Database Server Tuning; Operating System/Hardware Tuning; Security; Database Security; User Management; Privilege Management; GRANT and REVOKE; The security tables; Recovering from Password and Permission Problems; System Security; Operating System Security; Hardware Security; Network Security; Network topology; Encryption; Direct compromise; Application Security; The Application Server; User management; Resource protection; Client Applications; Database Design; Database Design Primer
- Database EntitiesEntity Attributes; Data Model; Normalization; First Normal Form; The Unique Identifier; Relationships; Second Normal Form; Kinds of Relationships; Refining Relationships; More 2NF; Third Normal Form; A Logical Data-Modeling Methodology; Physical Database Design; Tables and Columns; Foreign Keys; Part III; Database Applications; Architecture; Client/Server Architecture; Application logic; Fat and thin clients; Distributed Application Architecture; Web Architecture; Connections and Transactions; Connections; Transactions; Transaction isolation levels; Using READ UNCOMMITTED
- Object/Relational Modeling
