v

您的位置:VeryCD教育计算机


《SQLite 3结合PHP开发基础培训视频教程》(Lynda.com SQLite 3 with PHP Essential Training)[光盘镜像]

  • 状态: 精华资源
  • 摘要:
    发行日期2010年10月
    对白语言英语
    文字语言英文
  • 时间: 2010/10/31 20:58:06 发布 | 2010/11/01 20:53:50 更新
  • 分类: 教育  计算机 

xiaochenjia

精华资源: 673

全部资源: 675

相关: 分享到新浪微博   转播到腾讯微博   分享到开心网   分享到人人   分享到QQ空间   订阅本资源RSS更新   美味书签  subtitle
该内容尚未提供权利证明,无法提供下载。
中文名SQLite 3结合PHP开发基础培训视频教程
英文名Lynda.com SQLite 3 with PHP Essential Training
资源格式光盘镜像
发行日期2010年10月
地区美国
对白语言英语
文字语言英文
简介

IPB Image

资源简介

语言:英语
网址: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
未经过安装测试与安全检测,使用者后果自负与本论坛无关
软件版权归原作者及其公司所有,如果你喜欢,请购买正版

引用
资源来自网络收集 未经过一一的质量 安全等检测
只是把收集的资源和各位驴友分享 仅作网络学习交流使用 请勿用于商业用途 !
希望各位下载的驴友能多多参与分流保源 happy.gif

正在读取……

这里是其它用户补充的资源(我也要补充):

暂无补充资源
正在加载,请稍等...

点击查看所有30网友评论

 

(?) [公告]留口水、评论相关规则 | [活动]每日签到 轻松领取电驴经验

    小贴士:
  1. 类似“顶”、“沙发”之类没有营养的文字,对勤劳贡献的楼主来说是令人沮丧的反馈信息。
  2. 提问之前请再仔细看一遍楼主的说明,或许是您遗漏了。
  3. 勿催片。请相信驴友们对分享是富有激情的,如果确有更新版本,您一定能搜索到。
  4. 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦,又没人会搭理,于人于己都无利。
  5. 如果您发现自己的评论不见了,请参考以上4条。