[Lynda.com]MySQL Essential Training

MySQL Essential Training

 

with Bill Weinman

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.

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

show more

author

Bill Weinman

subject

Developer, Databases

software

MySQL

level

Beginner

duration

2h 46m

released

Aug 04, 2009

DVD

purchase

• table of contents
• exercise files
• transcript
• author
• preferences
• FAQs

subscribelearn more

Get immediate access to the entire library!

expand all | collapse all

viewed duration

1. Introducing MySQL6m 24s

Welcome1m 1s  

What is MySQL?54s  

Important terminology2m 53s  

Using the exercise files1m 36s  

2. Installing the Test Environment15m 18s

Installation overview3m 50s  

Installing XAMPP on Windows5m 12s  

Installing XAMPP on a Mac6m 16s  

3. Configuring MySQL28m 5s

Using the MySQL Command Line Interface on Windows4m 20s  

Using the MySQL Command Line Interface on a Mac1m 3s  

Setting up the root user4m 1s  

Setting up a regular user6m 33s  

Importing databases on Windows5m 35s  

Importing databases on a Mac6m 33s  

4. Using the SQL Interactive Demonstrator (SID)8m 53s

Using SID1m 19s  

Installing SID on Windows4m 19s  

Installing SID on a Mac3m 15s  

5. Creating a Database4m 49s

Creating a database1m 21s  

Creating a table3m 28s  

6. MySQL Data Types23m 23s

What are data types?54s  

Numeric types5m 24s  

String types1m 28s  

Large storage types1m 8s  

Date and time types2m 25s  

Bit type3m 20s  

Boolean values1m 8s  

Enumeration types7m 36s  

7. MySQL Functions56m 39s

MySQL functions1m 27s  

String functions10m 44s  

Numeric functions9m 13s  

Date and time functions3m 26s  

Time zones in MySQL5m 11s  

Installing time zone support in MySQL in Windows5m 32s  

Installing time zone support in MySQL on a Mac7m 49s  

Aggregate functions4m 46s  

Full-text search8m 31s  

8. PHP's MySQLi Interface13m 58s

PHP programming interfaces56s  

Introducing CRUD2m 59s  

Connecting to the database4m 22s  

Prepared statements2m 23s  

Fetching results2m 17s  

Auto-increment IDs1m 1s  

9. PHP's PDO Interface with MySQL7m 30s

PDO is multi-platform38s  

Connecting to the database2m 36s  

Prepared statements1m 2s  

Fetching results2m 10s  

Auto-increment IDs1m 4s  

Conclusion1m 3s

Goodbye1m 3s