---

MySQL: Essential Skills

ISBN: 0072255137
EAN: 2147483647

Year: 2006
Pages: 109

Authors: John Horn, Michael Grey, LLC Interstate Software

BUY ON AMAZON

• Table of Contents
• BackCover
• MySQL - Essential Skills
• Introduction
• Module 1: Installing MySQL
• Critical Skill 1.1 Know Basic Database Terms
• Critical Skill 1.2 Understand the Open Source and MySQL Relationship
• Critical Skill 1.3 Choose Your Development and Deployment Environments
• Critical Skill 1.4 Install MySQL on Windows
• Project 1 - 1 Install MySQL on Windows and Start the MySQL Service
• Project 1 - 2 Download and Install MyODBC on Windows
• Critical Skill 1.5 Install MySQL on Linux
• Project 1 - 3 Download and Install MySQL on Linux
• Critical Skill 1.6 Learn How to Use the Command Line
• Critical Skill 1.7 Know Your Resources
• Module 1 Mastery Check
• Module 2: Defining a Database
• Critical Skill 2.2 Plan Your Database
• Critical Skill 2.3 Create Your Database and Tables
• Project 2-1 Create a Database and Tables with Data
• Critical Skill 2.4 Insert Data into Tables
• Project 2-2 Insert Data in Tables
• Module 2 Mastery Check
• Module 3: Manipulating the Database
• Project 3 - 1 Create Tables Using Existing Table Data
• Critical Skill 3.2 Change a Table s Structure and Add an Index
• Critical Skill 3.3 Change Table Data
• Project 3 - 2 Make Changes to a Database
• Critical Skill 3.4 Remove a Table or Records
• Project 3 - 3 Remove Data and Revisit Changing Data
• Module 3 Mastery Check
• Module 4: Basic Reporting
• Critical Skill 4.2 Refine Your Data Selection
• Project 4 - 1 Create Reports Using SELECT...WHERE to Refine Data
• Module 4 Mastery Check
• Module 5: Advanced Reporting
• Project 5 - 1 Use MySQL Functions to Create Reports
• Critical Skill 5.2 Order and Group Data
• Project 5 - 2 Use ORDER BY and GROUP BY
• Critical Skill 5.3 Join Data in Multiple Tables
• Project 5-3 Combine Table Data with JOIN
• Module 5 Mastery Check
• Module 6: GUIs for Data Handling and Administration
• Critical Skill 6.1 Use MySQL Administrator
• Project 6 - 1 Download and Install MySQL Administrator on Windows
• Project 6 - 2 Download and Install MySQL Administrator on Linux
• Critical Skill 6.2 Use MySQL Control Center
• Project 6-3: Download and Install MySQL Control Center on Windows
• Project 6-4 Download and Install MySQL Control Center on Linux
• Module 6 Mastery Check
• Module 7: Interfacing with Programs
• Project 7-1: Create a Web Interface to Accept and Display Information
• Project 7-2 Create a Web Interface for a Database
• Critical Skill 7.2 Separate Database Functions from Application Code
• Critical Skill 7.3 Import MySQL Data into Access and Excel
• Project 7-3 Import and Link MySQL Data in Access
• Module 7 Mastery Check
• Module 8: Basic Administration and Backups
• Project 8-1 Set Privileges
• Critical Skill 8.2 Make Backups
• Project 8-2 Back Up a Database
• Critical Skill 8.3 Recover from a Disaster
• Project 8-3 Simulate Damage and Restore a Table
• Module 8 Mastery Check
• Appendix A: Answers to Mastery Checks
• Module 2: Defining a Database
• Module 3: Manipulating a Database
• Module 4: Basic Reporting
• Module 5: Advanced Reporting
• Module 6: GUI Interfaces for Data Handling and Administration
• Module 7: Interfacing with Programs
• Module 8: Basic Administration and Backups
• Appendix B: Reserved Words
• Appendix C: PHP Installation and Basic Syntax
• PHP Setup
• PHP in HTML
• PHP Syntax
• Project C-1 Displaying and Inserting Data in MySQL
• Index
• Index_A
• Index_B
• Index_C
• Index_D
• Index_E
• Index_F
• Index_G
• Index_H
• Index_I
• Index_J
• Index_K
• Index_L
• Index_M
• Index_N
• Index_O
• Index_P
• Index_Q
• Index_R
• Index_S
• Index_T
• Index_U
• Index_V
• Index_W
• Index_X
• Index_Y
• Index_Z
• List of Figures
• List of Tables
• List of Sidebars