Overview

Full Product Details

Author:   Randy Yarger & Tim King George Reese ,  George Reese ,  Tim King
Publisher:   O'Reilly Media
Imprint:   O'Reilly Media
Edition:   2nd edition
Dimensions:   Width: 17.80cm , Height: 2.20cm , Length: 23.30cm
Weight:   0.703kg
ISBN:  

9780596002114

ISBN 10:   0596002114
Pages:   430
Publication Date:   28 May 2002
Audience:   College/higher education ,  Professional and scholarly ,  Undergraduate ,  Postgraduate, Research & Scholarly
Format:   Paperback
Publisher's Status:   Active
Availability:   In Print  
This item will be ordered in for you from one of our suppliers. Upon receipt, we will promptly dispatch it out to you. For in store availability, please contact us.

Table of Contents

Part I Introduction - MySQL - relational databases, the history of MySQL, MySQL design, MySQL features, MySQL applications, what you get; installation - preparation, Unix installation, Windows installation; SQL according to MySQL - SQL basics database creation, table management, MySQL data types, indexing, managing data, queries, SQL operators, advanced features; database administration - configuration server startup and shutdown, logging, backup, recovery, table maintenance and crash recovery. Part II MySQL administration: performance tuning - an approach to performance tuning, application tuning, database server tuning, operating system/hardware tuning; security - database security, system security, application security; database design - database design primer, normalization, a logical data-modelling methodology, physical database design. Part III MySQL programming: database applications - architecture connections and transactions, object/relational modelling; Perl - introduction to DBI, DBI and CGI, a general model for maintainable Perl programs; Python - DB-API, proprietary operations, applied DB-API; PHP - introducing PHP, installing PHP, accessing the MySQL DBMS with PHP, securing user data, managing sessions - writing data with PHP, using the HTML format environment, where to find out more; C API - API overview, the C API in practice, advanced issues; Java - the JDBC API, simple database access, dynamic database access, a guest book servlet; extending MySQL - user-defined functions, alternative character sets. Part IV MySQL reference: SQL syntax for MySQL - basic syntax, SQL commands, MySQL data types, numeric data types string data types, date data types, complex data types; operators and functions - operators, functions; MySQL PHP API reference - data types functions; C reference - data types, functions; the Python DB-API Module - MySQLdb.

Reviews

Author Information

George Reese is well known for his superb O'Reilly book, Database Programming with JDBC and Java . He specializes in the development of Internet-oriented Java enterprise systems, and he is the author of the world's first JDBC driver, the mSQL-JDBC driver for mSQL. He currently works as an enterprise systems architect in Minneapolis. Randy Jay Yarger is a senior solutions developer at US Web/CKS in Southfield, Michigan. He combines expertise in database construction and interaction with extensive knowledge of the Internet to create world-class web applications. Tim King is a software consultant in San Francisco, specializing in database and web technologies.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions