×
Home
Menu Items
0
Your cart is empty
Continue Shopping
View Cart
LOGIN or SIGNUP
Support
Help
Keyboard Shortcuts
Send Feedback
Request
Demo
Cart
0
Your cart is empty
Continue Shopping
View Cart
Hello Guest
Login or Signup
Feedback & Support
Support
Keyboard Shortcuts
Send Feedback
Scroll to top button
Pearson: MySQL - Developer's Library
ISBN : 9781616914646
Here's what you will get
Here's what you will learn
Lessons
Lessons
23
+
Lesson 1: Getting Started with MySQL
How SQL Can Help You
A Sample Database
Basic Database Terminology
A MySQL Tutorial
Tips for Interacting with mysql
Where to Now?
Lesson 2: Using SQL to Manage Data
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
Lesson 3: Data Types
Data Value Categories
MySQL Data Types
How MySQL Handles Invalid Data Values
Working with Sequences
Expression Evaluation and Type Conversion
. Choosing Data Types
Lesson 4: Views and Stored Programs
Using Views
Using Stored Programs
Security for Views and Stored Programs
Lesson 5: Query Optimization
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
Lesson 6: Introduction to MySQL Programming
Why Write Your Own MySQL Programs?
APIs Available for MySQL
Choosing an API
Lesson 7: Writing MySQL Programs Using C
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
Lesson 8: Writing MySQL Programs Using Perl DBI
Perl Script Characteristics
Perl DBI Overview
Putting DBI to Work
Using DBI in Web Applications
Lesson 9: Writing MySQL Programs Using PHP
PHP Overview
Putting PHP to Work
Lesson 10: Introduction to MySQL Administration
MySQL Components
General MySQL Administration
Access Control and Security
Database Maintenance, Backups, and Replication
Lesson 11: The MySQL Data Directory
The Data Directory Location
Structure of the Data Directory
Relocating Data Directory Contents
Lesson 12: General MySQL Administration
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
Lesson 13: Security and Access Control
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
Lesson 14: Database Maintenance, Backups, and Replication
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
Lesson 15: Appendix A: Software Required to Use This Book
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
Lesson 16: Appendix B: Data Type Reference
B.1. Numeric Types
B.2. String Types
B.3. Temporal (Date and Time) Types
Lesson 17: Appendix C: Operator and Function Reference
C.1. Operators
C.2. Functions
C.2.3. Numeric Functions
Lesson 18: Appendix D: System, Status, and User Variable Reference
D.1. System Variables
D.2. Status Variables
D.3. User-Defined Variables
Lesson 19: Appendix E: SQL Syntax Reference
E.1. SQL Statement Syntax (Noncompound Statements)
E.2. SQL Statement Syntax (Compound Statements)
E.3. Comment Syntax
Lesson 20: Appendix F: MySQL Program Reference
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
Lesson 21: Appendix G: C API Reference
G.1. Compiling and Linking
G.2. C API Data Structures
G.3. C API Functions
Lesson 22: Appendix H: Perl DBI API Reference
H.1. Writing Scripts
H.2. DBI Methods
H.3. DBI Utility Functions
H.4. DBI Attributes
H.5. DBI Environment Variables
Lesson 23: Appendix I: PHP API Reference
I.1. Writing PHP Scripts
I.2. PDO Classes
I.3. PDO Methods
pearson-mysql-pro
pearson-mysql
Share
Download course outline
Are you an Instructor?
Teach using uCertify products
Request free evalution copy
×
Share with your friends and colleagues
×