MySQL.基礎教程 Lynda.com.MySQL.Essential.Training 英文 CD

MySQL是目前中小網站上最受歡迎的數據庫管理軟件.在MySQL基礎訓練教程中,BillWeinman將會簡單明了的介紹建立和維護數據庫所需要的工具.BillWeinman也會為大家介紹MySQL所支持的各種數據庫類型,並為大家講述MySQL的功能,使大家能充分利用MySQL.BillWeinman還展示了MySQL中可以用作建立網頁應用程序的的PHP接口.本課程包含練習文件.

Description
MySQLisbyfarthemostpopulardatabasemanagementsystemforsmall-tomedium-sizedwebprojects.InMySQLEssentialTraining,instructorBillWeinmanprovidesclear,conciseinstructioninthetoolsneededtocreateandmaintainadatabase.BillexploresthedifferentdatatypesMySQLsupports,andthefunctionsitprovides,enablingtheusertogetthemostoutofthem.HeevenshowstheMySQLPHPinterfacesthatcanbeusedtocreatewebapplications.Exercisefilesaccompanythecourse.


目錄:

06:241.IntroducingMySQL
Welcome01:01
WhatisMySQL?00:54
Importantterminology02:53
Usingtheexercisefiles01:36
15:182.InstallingtheTestEnvironment
Installationoverview03:50
InstallingXAMPPonWindows05:12
InstallingXAMPPonaMac06:16
28:053.ConfiguringMySQL
UsingtheMySQLCommandLineInterfaceonWindows04:20
UsingtheMySQLCommandLineInterfaceonaMac01:03
Settinguptherootuser04:01
Settinguparegularuser06:33
ImportingdatabasesonWindows05:35
ImportingdatabasesonaMac06:33
08:534.UsingtheSQLInteractiveDemonstrator(SID)
UsingSID01:19
InstallingSIDonWindows04:19
InstallingSIDonaMac03:15
04:495.CreatingaDatabase
Creatingadatabase01:21
Creatingatable03:28
23:236.MySQLDataTypes
Whataredatatypes?00:54
Numerictypes05:24
Stringtypes01:28
Largestoragetypes01:08
Dateandtimetypes02:25
Bittype03:20
Booleanvalues01:08
Enumerationtypes07:36
56:397.MySQLFunctions
MySQLfunctions01:27
Stringfunctions10:44
Numericfunctions09:13
Dateandtimefunctions03:26
TimezonesinMySQL05:11
InstallingtimezonesupportinMySQLinWindows05:32
InstallingtimezonesupportinMySQLonaMac07:49
Aggregatefunctions04:46
Full-textsearch08:31
13:588.PHP'sMySQLiInterface
PHPprogramminginterfaces00:56
IntroducingCRUD02:59
Connectingtothedatabase04:22
Preparedstatements02:23
Fetchingresults02:17
Auto-incrementIDs01:01
07:309.PHP'sPDOInterfacewithMySQL
PDOismulti-platform00:38
Connectingtothedatabase02:36
Preparedstatements01:02
Fetchingresults02:10
Auto-incrementIDs01:04
01:03Conclusion
Goodbye01:03