Shareittips.com

Author: Bill Weinman

Topics include:

• Installing and configuring MySQL

• Creating and using databases

• Using numeric, string, and full-text search functions

• Using the command line interface to access MySQL’s powerful security model

• Inserting and retrieving data

• Choosing a storage engine

Table of Contents:

1. Introducing MySQL

• Welcome
• What is MySQL?
• Important terminology
• Using the exercise files

2. Installing the Test Environment

• Installation overview
• Installing XAMPP on Windows
• Installing XAMPP on a Mac

3. Configuring MySQL

• Using the MySQL Command Line Interface on Win
• Using the MySQL Command Line Interface on a Mac
• Setting up the root user
• Setting up a regular user
• Importing databases on Windows
• Importing databases on a Mac

4. Using the SQL Interactive Demonstrator (SID)

• Using SID
• Installing SID on Windows
• Installing SID on a Mac

5. Creating a Database

• Creating a database
• Creating a table

6. MySQL Data Types

• What are data types?
• Numeric types
• String types
• Large storage types
• Date and time types
• Bit type
• .Boolean values
• Enumeration types

7. MySQL Functions

• MySQL functions
• String functions
• Numeric functions
• Date and time functions
• Time zones in MySQL
• Installing time zone support in MySQL in Windows
• Installing time zone support in MySQL on a Mac
• Aggregate functions
• Full-text search

8. PHP’s MySQLi Interface

• PHP programming interfaces
• Introducing CRUD
• Connecting to the database
• Prepared statements
• Fetching results
• Auto-increment IDs

9. PHP’s PDO Interface with MySQL

• PDO is multi-platform
• Connecting to the database
• Prepared statements
• Fetching results
• Auto-increment IDs

10. Conclusion

Download Hot File

Akash Padhiyar

I am Akash Padhiyar Founder of Shareittips.com,BCA MCA Tutor ,Running Web development compnay "AkashInfoTech".

More Posts - Website - Twitter - Facebook