MySQL: Visual QuickStart Guide (2nd Edition)-->Table of Contents
- Introduction
- Chapter 1: Installing MySQL
- General Installation Steps
- Installing MySQL on Windows
- Configuring MySQL on Windows
- Installing MySQL on Macintosh
- Installing MySQL on Linux
- Basic Configuration Options
- Upgrading MySQL
- Chapter 2: Running MySQL
- Running MySQL on Windows and Windows NT
- Running MySQL on Mac OS X
- Running MySQL on Linux and Unix
- Using mysqladmin
- Setting the Root User Password
- Using the mysql Client
- Users and Privileges
- Chapter 3: Database Design
- Normalization
- Understanding Keys
- Understanding Relationships
- First Normal Form
- Second Normal Form
- Third Normal Form
- Chapter 4: Creating a MySQL Database
- MySQL Data Types
- Extra Column Characteristics
- Introduction to Indexes
- Finalizing a Table's Design
- Choosing a Storage Engine
- Character Sets and Collations
- Creating Databases
- Creating Tables
- Modifying Tables
- Chapter 5: Basic SQL
- Using Values in Queries
- Inserting Dtaa
- Selecting Data
- Using Conditionals
- Using LIKE and NOT LIKE
- Performing Joins
- Sorting Query Results
- Limiting Query Results
- Updating Data
- Deleting Data
- Chapter 6: MySQL Functions
- Text Functions
- Concatenation and Aliases
- Numeric Functions
- Date and Time Functions
- Formatting the Date and Time
- Encryption Functions
- Grouping Functions
- Other Functions
- Chapter 7: MySQL and PHP
- Connecting to MySQL and Selecting a Database
- Executing Simple Queries
- Retrieving Query Results
- Using mysql_insert_id()
- Error Handling
- Security Considerations
- Chapter 8: MySQL and Perl
- Installing Perl with MySQL Support on Windows
- Installing Perl Support for MySQL on Unix and Mac OS X
- Testing Perl and MySQL
- Connecting to MySQL
- Retrieving Query Results
- Executing Simple Queries
- Retrieving the Insert ID
- Error Handling
- Security Considerations
- Using Prepared Statements
- Chapter 9: MySQL and Java
- Installing Java Support for MySQL
- Connecting to the Database
- Executing Simple Queries
- Retrieving Query Results
- Retrieving the Insert ID
- Using Prepared Statements
- Chapter 10: Advanced SQL and MySQL
- Performing Transactions
- Full-Text Searching
- Regular Expressions
- User-Defined Variables
- Introducing Unions
- Chapter 11: MySQL 5 Features
- Stored Routines
- Using OUT Parameters
- Triggers
- Views
- Chapter 12: Techniques for Programming
- Storing and Retrieving Binary Data
- Making Query Result Pages
- Using Transactions with Perl
- Chapter 13: MySQL Administration
- The MySQL Administrator
- Backing Up Databases
- Importing Data
- MySQL Logging
- Database Maintenance
- Improving Performance
- Using Batch Files
- Appendix A: Troubleshooting
- Installation
- Starting MySQL
- Accessing MySQL
- mysql.sock Problems
- Queries That Return Strange Results
- Authentication Protocol Problems
- Resetting the Root Password
- Appendix B: SQL and MySQL References
- Basic SQL
- ALTER Commands
- SQL Clauses
- MySQL Privileges
- MySQL Data Types
- MySQL Functions
- Other References
- Appendix C: Resources
- MySQL-Specific
- Third-Party MySQL Applications
- SQL
- PHP
- Perl
- Java
- Other
- Index
Search This Book!
(October 23, 2008)
(October 7, 2008)
(September 2, 2008)
Newsletter #16 Sent
Newsletter #16 just went out today after a long delay. It's a bigger one but there's lots of good stuff in there. You can read it online at http://www.dmcinsights.com/newsletter.php if you're not subscribed to receive it via email.(October 23, 2008)
Ruby: Visual QuickStart Guide Complete!
I'm very happy to announce that I've completed my Ruby: Visual QuickStart Guide. The book should be available in about three weeks or so (around early November 2008). The book turned out well, I think, and it should hopefully be a nice addition to the relatively small catalog of Ruby books that are available. In particular, I think that the Ruby on Rails chapter is really nice. I was able to develop a real-world example that demonstrates many aspects of the Rails framework. It also covers Rails 2.1, which has some significant changes from the 1.x version of Rails. More news about this book to come in future newsletters and on this site!(October 7, 2008)
Newsletter #15 Released
Newsletter #15 went out in early August but I've been remiss in posting this update about it. It's relatively short, with most of the discussion on the business side of creating your own business. You can read it online at http://dmcinsights.com/newsletter.php. The next newsletter should go out in a few days.(September 2, 2008)
