• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X
• Y
• Z

MySQL is by far the most popular database management system for small- to medium-sized web projects. In MySQL Essential Training, instructor Bill Weinman provides clear, concise instruction in the tools needed to create and maintain a database. Bill explores the different data types MySQL supports, and the functions it provides, enabling the user to get the most out of them. He even shows the MySQL PHP interfaces that can be used to create web applications. Exercise files accompany the course.

Course MySQL Essential Training Author Bill Weinman SKU ISBN Release Date 2009-08-04 Duration 2.46 hrs / 47 tutorials Work files Yes Price $ 49.95 Retail price $ 99.95 Language Tags MySQL, Web Development

2. Installing the Test Environment Installation overview 03:50 Installing XAMPP on Windows 05:12 Installing XAMPP on a Mac 06:16 3. Configuring MySQL Using the MySQL Command Line Interface on Windows 04:20 Using the MySQL Command Line Interface on a Mac 01:03 Setting up the root user 04:01 Setting up a regular user 06:33 Importing databases on Windows 05:35 Importing databases on a Mac 06:33 4. Using the SQL Interactive Demonstrator (SID) Using SID 01:19 Installing SID on Windows 04:19 Installing SID on a Mac 03:15 5. Creating a Database Creating a database 01:21 Creating a table 03:28 6. MySQL Data Types What are data types? 00:54 Numeric types 05:24 String types 01:28 Large storage types 01:08 Date and time types 02:25 Bit type 03:20 Boolean values 01:08 Enumeration types 07:36 7. MySQL Functions

Aggregate functions 04:46 Full-text search 08:31 8. PHP's MySQLi Interface PHP programming interfaces 00:56 Introducing CRUD 02:59 Connecting to the database 04:22 Prepared statements 02:23 Fetching results 02:17 Auto-increment IDs 01:01 9. PHP's PDO Interface with MySQL PDO is multi-platform 00:38 Connecting to the database 02:36 Prepared statements 01:02 Fetching results 02:10 Auto-increment IDs 01:04 Conclusion Goodbye 01:03