Lynda.com - SQLite 3 with PHP Essential Training





Lynda.com - SQLite 3 with PHP Essential Training
Work files incl. | Released: 10/20/2010 | 534 mb
lynda.com/home/displaycourse.aspx?lpk2=66386
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

كود:
كود PHP:
http://hotfile.com/dl/107328365/4f7b6a0/clslit3php.part1.rar.html http://hotfile.com/dl/107330751/950daa7/clslit3php.part2.rar.html http://hotfile.com/dl/107334902/ee49aa7/clslit3php.part3.rar.html http://