Flylib.com
MySQL: Essential Skills
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
MySQL: Essential Skills
ISBN: 0072255137
EAN: 2147483647
Year: 2006
Pages: 109
Authors:
John Horn
,
Michael Grey
,
LLC Interstate Software
BUY ON AMAZON
Crystal Reports 9 on Oracle (Database Professionals)
Connectivity, Authentication, and Privileges
Oracle Advanced SELECT Options
Optimizing: The Oracle Side
Data Dictionary Report
Appendix A Common Issues
Cisco IOS in a Nutshell (In a Nutshell (OReilly))
Token Ring Interfaces
ATM
Distance-Vector and Link-State Routing Protocols
Older Queuing Methods
A.3. IPv6
MySQL Clustering
The Structure of config.ini
Troubleshooting Backups
Security for MySQL Cluster
Cluster Topographies
Logging Commands
Wireless Hacks: Tips & Tools for Building, Extending, and Securing Your Network
Hack 1. Set Up Bluetooth on Linux
Hack 43. Control Wireless Access by MAC
Hack 56. Send Power over Your Ethernet
Hack 87. Primestar Dish with Waveguide Feed
Section A.9. FRS and GMRS: Super Walkie-Talkies
Ruby Cookbook (Cookbooks (OReilly))
Testing Whether an Object Is String-Like
Using Complex Numbers
Finding Todays Date
Declaring Constants
Automating Backups
Lean Six Sigma for Service : How to Use Lean Speed and Six Sigma Quality to Improve Services and Transactions
Seeing Services Through Your Customers Eyes-Becoming a customer-centered organization
Phase 2 Engagement (Creating Pull)
First Wave Service Projects
Raising the Stakes in Service Process Improvement
Designing World-Class Services (Design for Lean Six Sigma)
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies