Lynda - SQLite 3 with PHP Essential Training with Bill Weinman
Subjects: Business, Developer, Web,
Software: SQLite
6h 2m Beginner Oct 20, 2010 | Uploaded in Feb 12, 2015 by 2boweb
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
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\