【Lynda】SQLite 3 with PHP Essential Training【CHN】中英文字幕[SRT]
==========教程信息=====================================================
教程名称：SQLite 3 with PHP Essential Training
作者：Bill Weinman
主题：Developer, Web
使用软件：SQLite 3
难度等级：初级
时长： 6h 2m
发布日期： Oct 20, 2010
┏ACELY STUDIO，2012
┃更多资源请访问
┃◆唯一发布站：ACELY.CN
┗◆我的博客：http://blog.sina.com.cn/u/1991840741
==========教程目录文件列表=============================================
SQLite 3 with PHP Essential Training[SRT]
├─◆0. Introduction
│ └─◇ 0001 Welcome.srt
│ └─◇ 0002 What is SQLite and what are the prerequisites.srt
│ └─◇ 0003 Using the exercise files.srt
├─◆1. Quick Start
│ └─◇ 0101 Getting the most out of the quick start.srt
│ └─◇ 0102 Creating and using a database.srt
│ └─◇ 0103 Inserting data into a table.srt
│ └─◇ 0104 Getting data from a table.srt
│ └─◇ 0105 Updating data in a table.srt
│ └─◇ 0106 Deleting data from a table.srt
│ └─◇ 0107 Creating a database library.srt
├─◆2. Getting Started
│ └─◇ 0201 Installing XAMPP on a Mac.srt
│ └─◇ 0202 Installing XAMPP on a PC.srt
│ └─◇ 0203 Setting up SID and exercise files on a Mac.srt
│ └─◇ 0204 Setting up SID and exercise files on a PC.srt
│ └─◇ 0205 Using the command-line tools.srt
├─◆3. Creating a Database
│ └─◇ 0301 Understanding databases and tables in SQLite.srt
│ └─◇ 0302 Creating a database.srt
│ └─◇ 0303 Setting permissions for a database.srt
│ └─◇ 0304 Defining a table in SQL.srt
│ └─◇ 0305 Creating a table in PHP.srt
│ └─◇ 0306 Creating indexes.srt
│ └─◇ 0307 Indexing ID fields.srt
├─◆4. SQLite Data Types
│ └─◇ 0401 Taking care with data types in SQLite.srt
│ └─◇ 0402 Storing numbers with INTEGER.srt
│ └─◇ 0403 Storing numbers with REAL.srt
│ └─◇ 0404 Storing text.srt
│ └─◇ 0405 Storing large data with BLOB.srt
│ └─◇ 0406 Storing booleans.srt
│ └─◇ 0407 Storing dates and times.srt
├─◆5. Storing and Reading Data
│ └─◇ 0501 Storing data with INSERT.srt
│ └─◇ 0502 Updating data with UPDATE.srt
│ └─◇ 0503 Reading data with SELECT.srt
│ └─◇ 0504 Reading data from multiple tables with JOIN.srt
│ └─◇ 0505 Deleting data with DELETE.srt
├─◆6. SQLite Expressions
│ └─◇ 0601 Understanding expressions in SQLite.srt
│ └─◇ 0602 Comparing values with comparison operators.srt
│ └─◇ 0603 Matching patterns with LIKE.srt
│ └─◇ 0604 Building simple math with arithmetic operators.srt
│ └─◇ 0605 Matching values in a list with IN.srt
│ └─◇ 0606 Choosing from multiple conditions with the CASE expression.srt
│ └─◇ 0607 Forcing a data type with CAST.srt
├─◆7. SQLite Core Functions
│ └─◇ 0701 Finding the LENGTH of a string.srt
│ └─◇ 0702 Changing case with UPPER and LOWER.srt
│ └─◇ 0703 Reading parts of a string with SUBSTR.srt
│ └─◇ 0704 Changing parts of a string with REPLACE.srt
│ └─◇ 0705 Trimming blank spaces with TRIM.srt
│ └─◇ 0706 Reading absolute values with ABS.srt
│ └─◇ 0707 Rounding values with ROUND.srt
│ └─◇ 0708 Finding the data type of an expression with TYPEOF.srt
│ └─◇ 0709 Finding the last inserted record with LAST_INSERT_ROWID.srt
│ └─◇ 0710 Getting the version of your SQLite library.srt
│ └─◇ 0711 Creating user-defined functions.srt
│ └─◇ 0712 Building aggregate user-defined functions.srt
├─◆8. SQLite Aggregate Functions
│ └─◇ 0801 Understanding aggregate functions.srt
│ └─◇ 0802 Counting rows with COUNT.srt
│ └─◇ 0803 Building with the SUM and TOTAL functions.srt
│ └─◇ 0804 Finding minimum and maximum values with MIN and MAX.srt
│ └─◇ 0805 Finding averages with AVG.srt
│ └─◇ 0806 Grouping results with GROUP BY.srt
│ └─◇ 0807 Selecting for aggregation with HAVING.srt
├─◆9. SQLite Date and Time Functions
│ └─◇ 0901 Understanding SQLite support for dates and times.srt
│ └─◇ 0902 Getting readable, sortable dates and times.srt
│ └─◇ 0903 Getting high-resolution dates and times with JULIANDAY.srt
│ └─◇ 0904 Formatting dates and times with STRFTIME.srt
├─◆10. Sorting and Indexing
│ └─◇ 1001 Understanding collation.srt
│ └─◇ 1002 Sorting results with ORDER BY.srt
│ └─◇ 1003 Removing duplicate results with DISTINCT.srt
│ └─◇ 1004 Understanding indexes.srt
│ └─◇ 1005 Working with primary key indexes.srt
│ └─◇ 1006 Understanding how to use the INTEGER PRIMARY KEY function.srt
├─◆11. Transactions
│ └─◇ 1101 Understanding transactions.srt
│ └─◇ 1102 Using transactions in SQLite.srt
├─◆12. Subselects and Views
│ └─◇ 1201 Understanding subselects.srt
│ └─◇ 1202 Creating a simple subselect.srt
│ └─◇ 1203 Searching within a result set.srt
│ └─◇ 1204 Searching within a joined result.srt
│ └─◇ 1205 Creating a view.srt
│ └─◇ 1206 Searching within a joined view.srt
├─◆13. Triggers
│ └─◇ 1301 Understanding triggers in SQLite.srt
│ └─◇ 1302 Automatically updating a table with a trigger.srt
│ └─◇ 1303 Logging transactions with triggers.srt
│ └─◇ 1304 Improving performance with triggers.srt
│ └─◇ 1305 Preventing unintended updates with triggers.srt
│ └─◇ 1306 Adding automatic time stamps.srt
├─◆14. PHP Interfaces
│ └─◇ 1401 Choosing an interface.srt
│ └─◇ 1402 Using the SQLite3 interface.srt
│ └─◇ 1403 Using the PDO interface.srt
│ └─◇ 1404 Creating a library.srt
├─◆15. A Simple CRUD Application
│ └─◇ 1501 Defining CRUD.srt
│ └─◇ 1502 Using PHP to open and use an SQLite database.srt
│ └─◇ 1503 Using PHP to insert into an SQLite database.srt
│ └─◇ 1504 Using PHP to read from an SQLite database.srt
│ └─◇ 1505 Using PHP to update an SQLite database.srt
│ └─◇ 1506 Using PHP to delete from an SQLite database.srt
├─◆16. An Application for Web Site Testimonials
│ └─◇ 1601 An overview of the testimonials application.srt
│ └─◇ 1602 Managing the database in PHP.srt
│ └─◇ 1603 Displaying the testimonials using PHP.srt
├─◆Conclusion
│ └─◇ Goodbye.srt
◇
【本字幕由ACELY.CN独家制作发布】
┏
┃本套教程字幕包含中文字幕
┃中文字幕使用机器翻译，对翻译结果中不当内容不承担任何责任！
┃更多中文字幕请访问唯一发布站【ACELY.CN】
┃本站中文字幕未经允许一律严禁转载！
┗