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
Postfix: The Definitive Guide
Mail Delivery
Postfix Delivery Transports
Separate Domains with Virtual Accounts
Mailing-List Managers
C.2. Postfix Compiling Primer
C & Data Structures (Charles River Media Computer Engineering)
Control Structures
The scanf Function
Arrays
Problems in Trees
Miscellaneous Problems
Cisco CallManager Fundamentals (2nd Edition)
Miscellaneous Solutions
H.323 Endpoint Devices
Architecture and Functionality of the Media Control Layer
Accessing CDR Data in the Central CDR Database
Application Protocols
Service-Oriented Architecture (SOA): Concepts, Technology, and Design
Introducing SOA
The continuing evolution of SOA (standards organizations and contributing vendors)
Web Services and Contemporary SOA (Part II: Advanced Messaging, Metadata, and Security)
Service-Oriented Design (Part IV: Business Process Design)
SOA support in .NET
Special Edition Using Crystal Reports 10
Selecting and Grouping Data
Understanding the Value of Parameters
Using Report Templates
Introduction
Taking Advantage of the Crystal Enterprise Distributed Architecture
FileMaker 8 Functions and Scripts Desk Reference
Time Functions
Get(RecordModificationCount)
Get(RequestCount)
KanaHankaku()
About FileMaker Scripting
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