Managing & Using MySQL

作者簡介

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.

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.

Managing & Using MySQL

基本介紹

作者簡介

目錄

相關詞條

熱門詞條