資料介紹

• 數據庫SQL Server/Oracle/MySQL/DB2教程
• PHP教程/視頻教程
• 計算機資料

資源簡介

語言：英語
網址：http://www.lynda.com/home/DisplayCourse.aspx?lpk2=66386
類別：教程

Lynda.com 出品的長達6小時02分的 SQLite 3結合PHP開發基礎培訓 視頻教程。由 Bill Weinman 講解了在PHP環境中SQLite的主要特性。包括詳細的概述了其特有的數據庫系統，表達式，函數，事務，函數定義的視圖和觸發事件。本教程附帶練習文件。

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