Lynda.com MySQL Essential Training

Aug

9

Lynda.com MySQL Essential Training

edit 090875fcourseimagegateway.aspxcourseid770imgsrc770185x185.gifftlt Lynda.com MySQL Essential Training
Description

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.
Software works on: Mac and Windows.
Released on: 8/4/2009
Size : 194.18 MB (203,610,599 Bytes)

Exercise Files
Exercise Files are copies of the identical files (documents, photos, etc.) the author uses throughout this course. These files will help you make the most of your learning experience by providing you the opportunity to open them in your own software.
Exercise files accompany this course.

Table of contents

1. Introducing MySQL
Welcome 1:01 15.4 MB
What is MySQL? 0:54 0.6 MB
Important terminology 2:53 3.2 MB
Using the exercise files 1:36 1.9 MB
2. Installing the Test Environment
Installation overview 3:50 6.2 MB
Installing XAMPP on Windows 5:12 7.9 MB
Installing XAMPP on a Mac 6:16 7.3 MB
3. Configuring MySQL
Using the MySQL Command Line Interface on Windows 4:20 5.2 MB
Using the MySQL Command Line Interface on a Mac 1:03 0.9 MB
Setting up the root user 4:01 3.6 MB
Setting up a regular user 6:33 6.6 MB
Importing databases on Windows 5:35 7.0 MB
Importing databases on a Mac 6:33 5.4 MB
4. Using the SQL Interactive Demonstrator (SID)
Using SID 1:19 0.9 MB
Installing SID on Windows 4:19 4.3 MB
Installing SID on a Mac 3:15 3.4 MB
5. Creating a Database
Creating a database 1:21 1.1 MB
Creating a table 3:28 2.7 MB
6. MySQL Data Types
What are data types? 0:54 0.6 MB
Numeric types 5:24 3.8 MB
String types 1:28 1.2 MB
Large storage types 1:08 0.8 MB
Date and time types 2:25 1.9 MB
Bit type 3:20 2.4 MB
Boolean values 1:08 0.9 MB
Enumeration types 7:36 5.4 MB
7. MySQL Functions
MySQL functions 1:27 1.1 MB
String functions 10:44 9.2 MB
Numeric functions 9:13 8.4 MB
Date and time functions 3:26 2.7 MB
Time zones in MySQL 5:11 4.2 MB
Installing time zone support in MySQL in Windows 5:32 7.3 MB
Installing time zone support in MySQL on a Mac 7:49 8.1 MB
Aggregate functions 4:46 4.7 MB
Full-text search 8:31 6.7 MB
8. PHP’s MySQLi Interface
PHP programming interfaces 0:56 0.7 MB
Introducing CRUD 2:59 5.4 MB
Connecting to the database 4:22 6.7 MB
Prepared statements 2:23 3.7 MB
Fetching results 2:17 3.6 MB
Auto-increment IDs 1:01 1.4 MB
9. PHP’s PDO Interface with MySQL
PDO is multi-platform 0:38 1.4 MB
Connecting to the database 2:36 3.6 MB
Prepared statements 1:02 1.6 MB
Fetching results 2:10 3.9 MB
Auto-increment IDs 1:04 1.6 MB
Conclusion
Goodbye 1:03 1.3 MB