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
ERP and Data Warehousing in Organizations: Issues and Challenges
Challenging the Unpredictable: Changeable Order Management Systems
The Second Wave ERP Market: An Australian Viewpoint
The Effects of an Enterprise Resource Planning System (ERP) Implementation on Job Characteristics – A Study using the Hackman and Oldham Job Characteristics Model
Healthcare Information: From Administrative to Practice Databases
Development of Interactive Web Sites to Enhance Police/Community Relations
Inside Network Security Assessment: Guarding Your IT Infrastructure
Process for Assessing Risk
Foundations and Principles of Security
Security Requires Information Classification
Determining What Tools to Use
Appendix D. Dealing with Consultants and Outside Vendors
C++ GUI Programming with Qt 3
Implementing the File Menu
XML
Translating Applications
Providing Online Help
Tooltips, Status Tips, and Whats This? Help
An Introduction to Design Patterns in C++ with Qt 4
Input and Output
Generics and Templates
Regular Expressions
Standard Expression Conversions
Selection Statements
Sap Bw: a Step By Step Guide for Bw 2.0
Basic Concept of Data Warehousing
Creating Update Rules for the InfoCube
Operational Data Store (ODS)
BW Statistics
Object Transport
Digital Character Animation 3 (No. 3)
Chapter Four. Basics of Animation
Beyond Walking
Transitions
Acting Vs. Animating
Chapter Ten. Directing and Filmmaking
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