MySQL: Essential Skills
MySQL: Essential Skills
ISBN: 0072255137
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 109
Pages: 109
- 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
MySQL: Essential Skills
ISBN: 0072255137
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 109
Pages: 109