Start learning with our library of video tutorials taught by experts. Get started
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.
Hi! I'm Bill Weinman, and welcome to SQLite 3 with PHP Essential Training. In this course, we'll explore the world of SQLite 3, a full-featured, relational database engine, entirely self-contained in a driver. SQLite has really changed the way people think of a database engine. It's a small, fast, reliable, ACID- compliant, fully transactional database engine that can run a busy web site, or fit in a phone. I'll explain the major features of SQLite, and its usage in a PHP environment, focusing on real-world examples to aid you in implementing this amazing little database engine in your applications.
I'll show you the details of its SQL usage, core and aggregate functions, its unique manifest typing scheme, and even how to create user-defined functions in PHP. I'll demonstrate how to use subselects, views, and triggers to improve performance, compliance, and security in your database applications. This course is a great introduction to SQLite 3, but some programming and database experience will really help you get the most out of these technologies.
I've been a programmer for more than 30 years, and I have rarely been this excited about a database engine. So, let's get under the hood with SQLite 3 with PHP Essential Training.
There are currently no FAQs about SQLite 3 with PHP Essential Training.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.