中文名: MySQL 基礎教程
英文名: Lynda.com MySQL Essential Training
資源格式: 壓縮包
學校: Lynda.com
主講人: Bill Weinman
發行日期: 2009年08月04日
地區: 美國
對白語言: 英語
文字語言: 英文
簡介:

簡介
MySQL是目前中小網站上最受歡迎的數據庫管理軟件. 在 MySQL基礎訓練教程中, Bill Weinman將會簡單明了的介紹建立和維護數據庫所需要的工具. Bill Weinman也會為大家介紹MySQL所支持的各種數據庫類型, 並為大家講述MySQL的功能, 使大家能充分利用MySQL. Bill Weinman還展示了MySQL中可以用作建立網頁應用程序的的PHP接口. 本課程包含練習文件.
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. Exercise files accompany the course.
目錄:
06:24 1. Introducing MySQL
Welcome 01:01
What is MySQL? 00:54
Important terminology 02:53
Using the exercise files 01:36
15:18 2. Installing the Test Environment
Installation overview 03:50
Installing XAMPP on Windows 05:12
Installing XAMPP on a Mac 06:16
28:05 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
08:53 4. Using the SQL Interactive Demonstrator (SID)
Using SID 01:19
Installing SID on Windows 04:19
Installing SID on a Mac 03:15
04:49 5. Creating a Database
Creating a database 01:21
Creating a table 03:28
23:23 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
56:39 7. MySQL Functions
MySQL functions 01:27
String functions 10:44
Numeric functions 09:13
Date and time functions 03:26
Time zones in MySQL 05:11
Installing time zone support in MySQL in Windows 05:32
Installing time zone support in MySQL on a Mac 07:49
Aggregate functions 04:46
Full-text search 08:31
13:58 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
07:30 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
01:03 Conclusion
Goodbye 01:03