Lynda.com - SQLite 3 with PHP Essential Training

Tutorial & e-learning. October 21, 2010 by bomb.

Lynda.com - SQLite 3 with PHP Essential Training | 773 MB
English | WMV | 960x540 | 15 fps | AVC 130 kbps | AAC 128 kbps
Genre: eLearning

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 experience developers up and running fast.

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

*** Note: Exercise files for this tutorial are free. You can download them from Lynda homepage.


Screenshot



Download File

Here you can download files online. Unlimited access to all sources file with one click direct download link!
Share
  • Featured link
  • [21-10-2010]
thanks dear ;)

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Comment