Flylib.com
Books
Software
Computers & Technology
Home Computing
Business & Culture
Programming
Software
Web Development
Certification
Networking
Security & Encryption
Computer Science
Operating Systems
Microsoft
Hardware
Databases
Graphic Design
Apple
Digital Music
Digital Photography & Video
Games & Strategy Guides
Project Management
Mobile & Wireless Computing
Education & Reference
Encyclopedias
Test Preparation
Studying & Workbooks
Schools & Teaching
Writing, Research & Publishing Guides
Foreign Language Study & Reference
Atlases & Maps
Dictionaries & Thesauruses
Words, Language & Grammar
College & University
Trivia & Fun Facts
Consumer Guides
Business & Investing
Industries & Professions
Management & Leadership
Organizational Behavior
Personal Finance
Small Business & Entrepreneurship
Popular Economics
Marketing & Sales
Finance
Skills
Business Life
Economics
Job Hunting & Careers
Biography & History
Reference
International
Real Estate
Investing
Women & Business
Science & Math
Mathematics
Technology
Reference
Earth Sciences
Physics
Biological Sciences
Behavioral Sciences
Nature & Ecology
Astronomy & Space Science
History & Philosophy
Experiments, Instruments & Measurement
Agricultural Sciences
Category list
Computers & Technology
Software
Databases
Category list
Education & Reference
MySQL: Essential Skills - page 1
Buy on amazon.com >>
Horn J. W.
,
Grey M.
<< Previous book
Next page >>
1
2
Table of Contents
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
1
2
Buy on amazon.com >>
Horn J. W.
,
Grey M.
<< Previous book
Next page >>