[www.ed2k.online]下載基地為您提供軟件、遊戲、圖書、教育等各種資源的ED2K電驢共享下載和MAGNET磁力鏈接下載。
設為首頁
加入收藏
首頁 圖書資源 軟件資源 游戲資源 教育資源 其他資源
 電驢下載基地 >> 其他资源 >> 電腦基礎 >> 《SQLite 3結合PHP開發基礎培訓視頻教程》(Lynda.com SQLite 3 with PHP Essential Training)[光盤鏡像]
《SQLite 3結合PHP開發基礎培訓視頻教程》(Lynda.com SQLite 3 with PHP Essential Training)[光盤鏡像]
下載分級 其他资源
資源類別 電腦基礎
發布時間 2017/7/13
大       小 -
《SQLite 3結合PHP開發基礎培訓視頻教程》(Lynda.com SQLite 3 with PHP Essential Training)[光盤鏡像] 簡介: 中文名 : SQLite 3結合PHP開發基礎培訓視頻教程 英文名 : Lynda.com SQLite 3 with PHP Essential Training 資源格式 : 光盤鏡像 發行日期 : 2010年10月 地區 : 美國 對白語言 : 英語 文字語言 : 英文 簡介 : 資源簡介 語言:英語 網址:http://www.lynda.com/home/D
電驢資源下載/磁力鏈接資源下載:
全選
"《SQLite 3結合PHP開發基礎培訓視頻教程》(Lynda.com SQLite 3 with PHP Essential Training)[光盤鏡像]"介紹
中文名: SQLite 3結合PHP開發基礎培訓視頻教程
英文名: Lynda.com SQLite 3 with PHP Essential Training
資源格式: 光盤鏡像
發行日期: 2010年10月
地區: 美國
對白語言: 英語
文字語言: 英文
簡介:

資源簡介
語言:英語
網址:http://www.lynda.com/home/DisplayCourse.aspx?lpk2=66386
類別:教程
Lynda.com 出品的長達6小時02分的 SQLite 3結合PHP開發基礎培訓 視頻教程。由 Bill Weinman 講解了在PHP環境中SQLite的主要特性。包括詳細的概述了其特有的數據庫系統,表達式,函數,事務,函數定義的視圖和觸發事件。本教程附帶練習文件。

簡介翻譯轉自 xuehui@TLF 感謝

In SQLite 3 with PHP Essential Training, Bill Weinman addresses all of SQLite’s major features in the context of the PHP environment. This course covers the fundamentals of SQLite, including a thorough overview of its unique data type system, expressions, functions, transactions, views, and event triggers. A functional CRUD application and web site testimonial engine are demonstrated, and a quick-start guide is included to get experienced developers up and running fast. Exercise files are included in the course.
Topics include:
Creating a database
Setting permissions for a database
Storing data with SQLite data types
Using SQL statements like SELECT and UPDATE
Understanding expressions in SQLite
Matching patterns and values
Working with core functions
Counting, finding, and grouping with aggregates
Formatting dates and times
Sorting and indexing
Reusing queries with subselects and views
Automating queries with triggers
目錄:
Introduction
Welcome 01:26
What is SQLite and what are the prerequisites? 01:49
Using the exercise files 02:29
41:36 1. Quick Start
Getting the most out of the quick start 04:08
Creating and using a database 10:33
Inserting data into a table 08:17
Getting data from a table 04:38
Updating data in a table 04:31
Deleting data from a table 04:12
Creating a database library 05:17
39:19 2. Getting Started
Installing XAMPP on a Mac 05:59
Installing XAMPP on a PC 04:45
Setting up SID and exercise files on a Mac 09:10
Setting up SID and exercise files on a PC 08:12
Using the command-line tools 11:13
30:44 3. Creating a Database
Understanding databases and tables in SQLite 02:34
Creating a database 05:45
Setting permissions for a database 05:24
Defining a table in SQL 02:21
Creating a table in PHP 03:34
Creating indexes 04:38
Indexing ID fields 06:28
36:35 4. SQLite Data Types
Taking care with data types in SQLite 09:33
Storing numbers with INTEGER 05:17
Storing numbers with REAL 02:15
Storing text 03:15
Storing large data with BLOB 09:31
Storing booleans 02:24
Storing dates and times 04:20
22:47 5. Storing and Reading Data
Storing data with INSERT 04:01
Updating data with UPDATE 03:12
Reading data with SELECT 06:14
Reading data from multiple tables with JOIN 05:29
Deleting data with DELETE 03:51
24:45 6. SQLite Expressions
Understanding expressions in SQLite 02:31
Comparing values with comparison operators 04:36
Matching patterns with LIKE 04:28
Building simple math with arithmetic operators 03:13
Matching values in a list with IN 02:22
Choosing from multiple conditions with the CASE expression 04:45
Forcing a data type with CAST 02:50
24:38 7. SQLite Core Functions
Finding the LENGTH of a string 01:52
Changing case with UPPER and LOWER 02:15
Reading parts of a string with SUBSTR 02:34
Changing parts of a string with REPLACE 01:17
Trimming blank spaces with TRIM 01:59
Reading absolute values with ABS 01:06
Rounding values with ROUND 01:42
Finding the data type of an expression with TYPEOF 01:14
Finding the last inserted record with LAST_INSERT_ROWID 01:07
Getting the version of your SQLite library 01:16
Creating user-defined functions 04:51
Building aggregate user-defined functions 03:25
18:58 8. SQLite Aggregate Functions
Understanding aggregate functions 02:15
Counting rows with COUNT 03:30
Building with the SUM and TOTAL functions 02:09
Finding minimum and maximum values with MIN and MAX 04:33
Finding averages with AVG 01:50
Grouping results with GROUP BY 02:23
Selecting for aggregation with HAVING 02:18
13:54 9. SQLite Date and Time Functions
Understanding SQLite support for dates and times 04:31
Getting readable, sortable dates and times 03:36
Getting high-resolution dates and times with JULIANDAY 02:49
Formatting dates and times with STRFTIME 02:58
18:07 10. Sorting and Indexing
Understanding collation 01:00
Sorting results with ORDER BY 01:30
Removing duplicate results with DISTINCT 02:05
Understanding indexes 03:18
Working with primary key indexes 04:12
Understanding how to use the INTEGER PRIMARY KEY function 06:02
07:52 11. Transactions
Understanding transactions 01:10
Using transactions in SQLite 06:42
16:06 12. Subselects and Views
Understanding subselects 01:29
Creating a simple subselect 03:18
Searching within a result set 02:35
Searching within a joined result 03:59
Creating a view 02:17
Searching within a joined view 02:28
15:56 13. Triggers
Understanding triggers in SQLite 00:52
Automatically updating a table with a trigger 05:18
Logging transactions with triggers 02:41
Improving performance with triggers 02:03
Preventing unintended updates with triggers 02:50
Adding automatic time stamps 02:12
16:25 14. PHP Interfaces
Choosing an interface 01:21
Using the SQLite3 interface 02:41
Using the PDO interface 03:00
Creating a library 09:23
16:33 15. A Simple CRUD Application
Defining CRUD 04:05
Using PHP to open and use an SQLite database 03:36
Using PHP to insert into an SQLite database 04:18
Using PHP to read from an SQLite database 02:20
Using PHP to update an SQLite database 01:02
Using PHP to delete from an SQLite database 01:12
11:32 16. An Application for Web Site Testimonials
An overview of the testimonials application 04:48
Managing the database in PHP 04:05
Displaying the testimonials using PHP 02:39
00:33 Conclusion
Goodbye 00:33

下載鏈接來自TLF
未經過安裝測試與安全檢測,使用者後果自負與本論壇無關
軟件版權歸原作者及其公司所有,如果你喜歡,請購買正版


資源來自網絡收集 未經過一一的質量 安全等檢測
只是把收集的資源和各位驢友分享 僅作網絡學習交流使用 請勿用於商業用途 !
希望各位下載的驢友能多多參與分流保源


相關資源:

免責聲明:本網站內容收集於互聯網,本站不承擔任何由於內容的合法性及健康性所引起的爭議和法律責任。如果侵犯了你的權益,請通知我們,我們會及時刪除相關內容,謝謝合作! 聯系信箱:[email protected]

Copyright © 電驢下載基地 All Rights Reserved