Lynda.com.SQLite.3.With.PHP.Essential.Training



Course Summary

Description

Course name:
SQLite 3 with PHP Essential Training

Author:
Bill Weinman

Duration (hr:min):
6:02

Released on:
10/20/2010

Exercise files:
Yes

Software works on:
Mac and Windows


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



Links:

كود:
http://hotfile.com/dl/83820066/1b75a31/lynda.com.sqlite.3.with.php.essential.training-jgtiso.part1.rar.html
http://hotfile.com/dl/83820111/42da27b/lynda.com.sqlite.3.with.php.essential.training-jgtiso.part2.rar.html
http://hotfile.com/dl/83820118/82e3ec0/lynda.com.sqlite.3.with.php.essential.training-jgtiso.part3.rar.html
http://hotfile.com/dl/83820122/fdf3ff9/lynda.com.sqlite.3.with.php.essential.training-jgtiso.part4.rar.html
http://hotfile.com/dl/83820124/fc2c0e8/lynda.com.sqlite.3.with.php.essential.training-jgtiso.part5.rar.html