Scroll to top button

Pearson: MySQL - Developer's Library

ISBN : 9781616914646

Lessons
Lessons
23+
  • How SQL Can Help You
  • A Sample Database
  • Basic Database Terminology
  • A MySQL Tutorial
  • Tips for Interacting with mysql
  • Where to Now?
  • The Server SQL Mode
  • MySQL Identifier Syntax and Naming Rules
  • Case Sensitivity in SQL Statements
  • Character Set Support
  • Selecting, Creating, Dropping, and Altering Databases
  • Creating, Dropping, Indexing, and Altering Tables
  • Obtaining Database Metadata
  • Performing Multiple-Table Retrievals with Joins
  • Performing Multiple-Table Retrievals with Subqueries
  • Performing Multiple-Table Retrievals with UNION
  • Multiple-Table Deletes and Updates
  • Performing Transactions
  • Foreign Keys and Referential Integrity
  • Using FULLTEXT Searches
  • Data Value Categories
  • MySQL Data Types
  • How MySQL Handles Invalid Data Values
  • Working with Sequences
  • Expression Evaluation and Type Conversion
  • . Choosing Data Types
  • Using Views
  • Using Stored Programs
  • Security for Views and Stored Programs
  • Using Indexing
  • The MySQL Query Optimizer
  • Choosing Data Types for Efficient Queries
  • Choosing Table Storage Formats for Efficient Queries
  • Loading Data Efficiently
  • Scheduling, Locking, and Concurrency
  • Why Write Your Own MySQL Programs?
  • APIs Available for MySQL
  • Choosing an API
  • Compiling and Linking Client Programs
  • Connecting to the Server
  • Handling Errors and Processing Command Options
  • Processing SQL Statements
  • An Interactive Statement-Execution Program
  • Writing Clients That Include SSL Support
  • Using Multiple-Statement Execution
  • Using Server-Side Prepared Statements
  • Using Prepared CALL Support
  • Perl Script Characteristics
  • Perl DBI Overview
  • Putting DBI to Work
  • Using DBI in Web Applications
  • PHP Overview
  • Putting PHP to Work
  • MySQL Components
  • General MySQL Administration
  • Access Control and Security
  • Database Maintenance, Backups, and Replication
  • The Data Directory Location
  • Structure of the Data Directory
  • Relocating Data Directory Contents
  • Securing a New MySQL Installation
  • Arranging for MySQL Server Startup and Shutdown
  • Using System and Status Variables
  • The Plugin Interface
  • Storage Engine Configuration
  • Globalization Issues
  • Server Tuning
  • Server Logs
  • Running Multiple Servers
  • Updating MySQL
  • Securing Filesystem Access to MySQL
  • Managing MySQL User Accounts
  • Grant Table Structure and Contents
  • How the Server Controls Client Access
  • Setting Up Secure Connections Using SSL
  • Principles of Preventive Maintenance
  • Performing Database Maintenance with the Server Running
  • General Preventive Maintenance
  • Making Database Backups
  • Copying Databases to Another Server
  • Checking and Repairing Database Tables
  • Using Backups for Data Recovery
  • Setting Up Replication Servers
  • A.1. Obtaining the sampdb Sample Database Distribution
  • A.2. Obtaining MySQL and Related Software
  • A.3. MySQL Installation Notes
  • A.4. Perl DBI Installation Notes
  • A.5. PHP and PDO Installation Notes
  • B.1. Numeric Types
  • B.2. String Types
  • B.3. Temporal (Date and Time) Types
  • C.1. Operators
  • C.2. Functions
  • C.2.3. Numeric Functions
  • D.1. System Variables
  • D.2. Status Variables
  • D.3. User-Defined Variables
  • E.1. SQL Statement Syntax (Noncompound Statements)
  • E.2. SQL Statement Syntax (Compound Statements)
  • E.3. Comment Syntax
  • F.1. Displaying a Program's Help Message
  • F.2. Specifying Program Options
  • F.3. myisamchk
  • F.4. mysql
  • F.5. mysql.server
  • F.6. mysql_config
  • F.7. mysql_install_db
  • F.8. mysql_upgrade
  • F.9. mysqladmin
  • F.10. mysqlbinlog
  • F.11. mysqlcheck
  • F.12. mysqld
  • F.13. mysqld_multi
  • F.14. mysqld_safe
  • F.15. mysqldump
  • F.16. mysqlimport
  • F.17. mysqlshow
  • F.18. perror
  • G.1. Compiling and Linking
  • G.2. C API Data Structures
  • G.3. C API Functions
  • H.1. Writing Scripts
  • H.2. DBI Methods
  • H.3. DBI Utility Functions
  • H.4. DBI Attributes
  • H.5. DBI Environment Variables
  • I.1. Writing PHP Scripts
  • I.2. PDO Classes
  • I.3. PDO Methods
×