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
Learn more about lynda.com
Ready to join?
subscribe
Members who watched this also viewed
show more
Video player
Choose your preferred video player. Check our FAQs for help with technical problems.
Closed captioning
update preferences
