+612 9045 4394
My SQL : Essential Skills - John W. Horn


Essential Skills

Paperback Published: 23rd June 2004
ISBN: 9780072255133
Number Of Pages: 388

Share This Book:


RRP $74.00
Ships in 7 to 10 business days

Dr. John W. Horn is a MySQL trainer at Interstate Software where he trains people like you everyday. Michael Grey is an IT professional and writer who provides courseware development for Interstate Software, Inc. Interstate Software (Independence, MO) is a gold partner with MySQL AB, the commercial MySQL company founded by the creators of the MySQL database server. Interstate Software provides authorized MySQL training and consulting.

Acknowledgmentsp. xiii
Introductionp. xv
Installing MySQLp. 1
Know Basic Database Termsp. 2
Understand the Open Source and MySQL Relationshipp. 3
Open Source vs. Proprietary Softwarep. 4
MySQL as Open Sourcep. 5
Choose Your Development and Deployment Environmentsp. 5
Applying Broad Criteriap. 6
Narrowing the Decisionp. 6
Install MySQL on Windowsp. 8
Install MySQL on Windows and Start the MySQL Servicep. 9
The WinMySQLAdmin Toolp. 15
Download and Install MyODBC on Windowsp. 19
Install MySQL on Linuxp. 25
Download and Install MySQL on Linuxp. 25
Learn How to Use the Command Linep. 28
Using the Command Prompt in Windowsp. 29
Using the Command Prompt in Linuxp. 32
Know Your Resourcesp. 35
Downloadsp. 35
Documentationp. 36
Support & Consultingp. 37
Companyp. 37
Module 1 Mastery Checkp. 38
Defining a Databasep. 39
Understand MySQL Data Typesp. 40
Number Data Typesp. 41
Text Data Typesp. 45
DATE and TIME Data Typesp. 47
Defined Group Data Types: ENUM and SETp. 51
Plan Your Databasep. 53
Naming Your Databasep. 53
Naming Your Tablesp. 53
Naming and Defining Fieldsp. 54
Understanding Table Typesp. 56
Create Your Database and Tablesp. 61
Creating a Databasep. 62
Creating a Tablep. 62
Correcting Mistakes in Commandsp. 63
Formatting Table Datap. 64
Create a Database and Tables with Datap. 64
Insert Data into Tablesp. 67
Insert Data in Tablesp. 69
Module 2 Mastery Checkp. 76
Manipulating the Databasep. 77
Add Data to Your Databasep. 78
Copying a Tablep. 78
Inserting Data from a Text Filep. 80
Create Tables Using Existing Table Datap. 81
Change a Table's Structure and Add an Indexp. 91
Altering a Tablep. 91
Creating an Indexp. 92
Change Table Datap. 95
Replacing Datap. 95
Using the safe-updates Optionp. 97
Updating Datap. 97
Make Changes to a Databasep. 99
Remove a Table or Recordsp. 108
Dropping a Tablep. 108
Deleting Table Contentsp. 108
Truncating Tablesp. 109
Remove Data and Revisit Changing Datap. 110
Module 3 Mastery Checkp. 117
Basic Reportingp. 119
Shape the Data from Your Tables to Fit Your Needsp. 120
Testing with the SELECT Commandp. 120
Shaping Data with the SELECT Commandp. 123
Refine Your Data Selectionp. 126
Focusing on Smaller Areas of Your Databasep. 126
Using WHERE to Narrow Your Focusp. 126
Create Reports Using SELECT ... WHERE to Refine Datap. 129
Module 4 Mastery Checkp. 138
Advanced Reportingp. 141
Use Functions in MySQLp. 142
Using Universal Functionsp. 142
Using Control Flow Functionsp. 145
Using Aggregate Functionsp. 147
Calculating with Mathematical Functionsp. 149
Manipulating Strings with String Functionsp. 155
Using Date Functionsp. 164
Getting Information with Null-related Functionsp. 167
Use MySQL Functions to Create Reportsp. 169
Order and Group Datap. 176
Using the GROUP BY and ORDER BY Clausesp. 176
Using Grouping Functionsp. 177
Screening Results with HAVINGp. 179
Use ORDER BY and GROUP BYp. 181
Join Data in Multiple Tablesp. 183
Understanding Cartesian Proudct vs. Simple Join Operationsp. 184
Deciding Whether to Use LEFT JOIN or RIGHT JOINp. 185
Combine Table Data with JOINp. 187
Module 5 Mastery Checkp. 190
GUIs for Data Handling and Administrationp. 191
Use MySQL Administratorp. 192
Choosing MySQL Administrator Menu Optionsp. 193
Setting MySQL Administrator Optionsp. 194
Viewing Information in MySQL Administratorp. 197
Download and Install MySQL Administrator on Windowsp. 217
Download and Install MySQL Administrator on Linuxp. 221
Use MySQL Control Centerp. 222
Choosing MySQLCC Menu Optionsp. 223
Selecting MySQLCC Optionsp. 224
Using the Console Managerp. 224
Download and Install MySQL Control Center on Windowsp. 234
Download and Install MySQL Control Center on Linuxp. 239
Module 6 Mastery Checkp. 240
Interfacing with Programsp. 241
Use PHP and MySQLp. 242
Introducing PHPp. 242
Create a Web Interface to Accept and Display Informationp. 243
Connecting to a Databasep. 245
Create a Web Interface for a Databasep. 254
Handling Errorsp. 256
Good Design Conceptsp. 258
Maintaining Web Securityp. 259
Using the MySQL Improved Interface (PHP 5 only)p. 263
Separate Database Functions from Application Codep. 265
Installing PEAR::DBp. 266
Connecting to a Databasep. 266
Executing Queriesp. 267
Fetching Resultsp. 269
Import MySQL Data into Access and Excelp. 270
Importing MySQL Data into Excelp. 271
Importing MySQL Data into Accessp. 273
Import and Link MySQL Data in Accessp. 273
Module 7 Mastery Checkp. 275
Basic Administration and Backupsp. 277
Set Privilegesp. 278
Understanding the Levels of Securityp. 278
Granting and Revoking User Privilegesp. 281
Set Privilegesp. 289
Make Backupsp. 292
Reviewing the Causes of System Failurep. 292
Planning and Preparing for Backupp. 293
Understanding the Backup Methodsp. 294
Back Up a Databasep. 299
Recover from a Disasterp. 301
Knowing the Restore Procedurep. 301
Dealing with Damaged Tablesp. 302
Performing Preventative Maintenance: A Stitch in Timep. 306
Simulate Damage and Restore a Tablep. 307
Project Summaryp. 311
Module 8 Mastery Checkp. 311
Answers to Mastery Checksp. 313
Module 1: Installing MySQLp. 314
Module 2: Defining a Databasep. 315
Module 3: Manipulating a Databasep. 316
Module 4: Basic Reportingp. 318
Module 5: Advanced Reportingp. 320
Module 6: GUI Interfaces for Data Handling and Administrationp. 321
Module 7: Interfacing with Programsp. 322
Module 8: Basic Administration and Backupsp. 323
Reserved Wordsp. 325
PHP Installation and Basic Syntaxp. 329
PHP and MySQLp. 330
PHP Setupp. 331
Checking for PHP Activationp. 331
Verifying PHP Installationp. 331
PHP in HTMLp. 332
PHP Syntaxp. 333
Variablesp. 334
Operatorsp. 338
Functionsp. 341
Control Structuresp. 342
Displaying and Inserting Data in MySQLp. 345
Indexp. 353
Table of Contents provided by Ingram. All Rights Reserved.

ISBN: 9780072255133
ISBN-10: 0072255137
Series: Beginner's Guide
Audience: Professional
Format: Paperback
Language: English
Number Of Pages: 388
Published: 23rd June 2004
Publisher: McGraw-Hill Education - Europe
Country of Publication: US
Dimensions (cm): 23.5 x 19.0  x 2.0
Weight (kg): 0.67