Pearson: MySQL - Developer's Library
(pearson-mysql)
/ ISBN: 9781616914646
This course includes
Lessons
Pearson: MySQL - Developer's Library
Lessons
-
23+ Lessons
- 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
×