SQLite 3 with PHP Essential Training by Lynda.com
Date: 8 June 2011 | Posted by: masterjan
Year: 2010
Author: Bill Weinman
Duration: 6:02 h
Level: Beginner
Language: English
VideoFormat: .WMV
Exercise Files: included
Size: 774 Mb
Author: Bill Weinman
Duration: 6:02 h
Level: Beginner
Language: English
VideoFormat: .WMV
Exercise Files: included
Size: 774 Mb
SCREENSHOTS
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. 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
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
See full article