Lynda.com - SQLite 3 with PHP Essential Training
File List
- 0. Introduction/01. Welcome.wmv 42.4 MB
- 14. PHP Interfaces/04. Creating a library.wmv 28.4 MB
- 2. Getting Started/05. Using the command-line tools.wmv 27.0 MB
- 1. Quick Start/02. Creating and using a database.wmv 24.5 MB
- 1. Quick Start/03. Inserting data into a table.wmv 20.8 MB
- 4. SQLite Data Types/05. Storing large data with BLOB.wmv 18.8 MB
- 2. Getting Started/04. Setting up SID and exercise files on a PC.wmv 16.7 MB
- 2. Getting Started/03. Setting up SID and exercise files on a Mac.wmv 16.6 MB
- 4. SQLite Data Types/01. Taking care with data types in SQLite.wmv 15.4 MB
- 1. Quick Start/07. Creating a database library.wmv 15.2 MB
- 11. Transactions/02. Using transactions in SQLite.wmv 13.7 MB
- 2. Getting Started/01. Installing XAMPP on a Mac.wmv 13.6 MB
- 13. Triggers/02. Automatically updating a table with a trigger.wmv 13.3 MB
- 3. Creating a Database/02. Creating a database.wmv 13.0 MB
- 3. Creating a Database/03. Setting permissions for a database.wmv 11.9 MB
- 16. An Application for Web Site Testimonials/01. An overview of the testimonials application.wmv 11.8 MB
- 3. Creating a Database/07. Indexing ID fields.wmv 11.7 MB
- 7. SQLite Core Functions/11. Creating user-defined functions.wmv 11.3 MB
- 5. Storing and Reading Data/03. Reading data with SELECT.wmv 11.1 MB
- 2. Getting Started/02. Installing XAMPP on a PC.wmv 11.0 MB
- 1. Quick Start/05. Updating data in a table.wmv 10.9 MB
- 1. Quick Start/04. Getting data from a table.wmv 10.8 MB
- 10. Sorting and Indexing/06. Understanding how to use the INTEGER PRIMARY KEY function.wmv 10.7 MB
- 5. Storing and Reading Data/04. Reading data from multiple tables with JOIN.wmv 10.6 MB
- 16. An Application for Web Site Testimonials/02. Managing the database in PHP.wmv 9.9 MB
- 1. Quick Start/06. Deleting data from a table.wmv 9.9 MB
- 6. SQLite Expressions/03. Matching patterns with LIKE.wmv 9.7 MB
- 15. A Simple CRUD Application/03. Using PHP to insert into a SQLite database.wmv 9.6 MB
- 12. Subselects and Views/04. Searching within a joined result.wmv 9.4 MB
- 3. Creating a Database/06. Creating indexes.wmv 9.1 MB
- 1. Quick Start/01. Getting the most out of the quick start.wmv 8.9 MB
- 6. SQLite Expressions/02. Comparing values with comparison operators.wmv 8.8 MB
- 6. SQLite Expressions/06. Choosing from multiple conditions with the CASE expression.wmv 8.8 MB
- 4. SQLite Data Types/02. Storing numbers with INTEGER.wmv 8.8 MB
- 15. A Simple CRUD Application/02. Using PHP to open and use a SQLite database.wmv 8.5 MB
- 15. A Simple CRUD Application/01. Defining CRUD.wmv 7.8 MB
- 8. SQLite Aggregate Functions/04. Finding minimum and maximum values with MIN and MAX.wmv 7.7 MB
- 13. Triggers/05. Preventing unintended updates with triggers.wmv 7.7 MB
- 9. SQLite Date and Time Functions/01. Understanding SQLite support for dates and times.wmv 7.5 MB
- 14. PHP Interfaces/03. Using the PDO interface.wmv 7.2 MB
- 7. SQLite Core Functions/12. Building aggregate user-defined functions.wmv 7.2 MB
- 3. Creating a Database/05. Creating a table in PHP.wmv 7.2 MB
- 13. Triggers/03. Logging transactions with triggers.wmv 7.1 MB
- 16. An Application for Web Site Testimonials/03. Displaying the testimonials using PHP.wmv 7.0 MB
- 5. Storing and Reading Data/05. Deleting data with DELETE.wmv 6.9 MB
- 10. Sorting and Indexing/05. Working with primary key indexes.wmv 6.9 MB
- 4. SQLite Data Types/07. Storing dates and times.wmv 6.9 MB
- 9. SQLite Date and Time Functions/03. Getting high-resolution dates and times with JULIANDAY.wmv 6.9 MB
- 14. PHP Interfaces/02. Using the SQLite3 interface.wmv 6.7 MB
- 5. Storing and Reading Data/04. Storing data with INSERT.wmv 6.4 MB
- 9. SQLite Date and Time Functions/02. Getting readable, sortable dates and times.wmv 6.0 MB
- 8. SQLite Aggregate Functions/02. Counting rows with COUNT.wmv 5.6 MB
- 13. Triggers/04. Improving performance with triggers.wmv 5.6 MB
- 13. Triggers/06. Adding automatic time stamps.wmv 5.6 MB
- 15. A Simple CRUD Application/04. Using PHP to read from a SQLite database.wmv 5.5 MB
- 9. SQLite Date and Time Functions/04. Formatting dates and times with STRFTIME.wmv 5.5 MB
- 5. Storing and Reading Data/02. Updating data with UPDATE.wmv 5.2 MB
- 4. SQLite Data Types/04. Storing text.wmv 5.2 MB
- 10. Sorting and Indexing/04. Understanding indexes.wmv 5.2 MB
- 12. Subselects and Views/02. Creating a simple subselect.wmv 5.2 MB
- 12. Subselects and Views/03. Searching within a result set.wmv 4.9 MB
- 12. Subselects and Views/06. Searching within a joined view.wmv 4.8 MB
- 6. SQLite Expressions/04. Building simple math with arithmetic operators.wmv 4.8 MB
- 6. SQLite Expressions/05. Matching values in a list with IN.wmv 4.6 MB
- 0. Introduction/03. Using the exercise files.wmv 4.3 MB
- 6. SQLite Expressions/07. Forcing a data type with CAST.wmv 4.1 MB
- 7. SQLite Core Functions/03. Reading parts of a string with SUBSTR.wmv 4.1 MB
- 6. SQLite Expressions/01. Understanding expressions in SQLite.wmv 4.0 MB
- 10. Sorting and Indexing/02. Sorting results with ORDER BY.wmv 3.9 MB
- 10. Sorting and Indexing/03. Removing duplicate results with DISTINCT.wmv 3.8 MB
- 8. SQLite Aggregate Functions/07. Selecting for aggregation with HAVING.wmv 3.8 MB
- 8. SQLite Aggregate Functions/01. Understanding aggregate functions.wmv 3.8 MB
- 4. SQLite Data Types/06. Storing booleans.wmv 3.8 MB
- 8. SQLite Aggregate Functions/06. Grouping results with GROUP BY.wmv 3.7 MB
- 3. Creating a Database/04. Defining a table in SQL.wmv 3.7 MB
- 12. Subselects and Views/05. Creating a view.wmv 3.7 MB
- 7. SQLite Core Functions/02. Changing case with UPPER and LOWER.wmv 3.6 MB
- 4. SQLite Data Types/03. Storing numbers with REAL.wmv 3.5 MB
- 3. Creating a Database/01. Understanding databases and tables in SQLite.wmv 3.5 MB
- 7. SQLite Core Functions/01. Finding the LENGTH of a string.wmv 3.5 MB
- 7. SQLite Core Functions/05. Trimming blank spaces with TRIM.wmv 3.3 MB
- 8. SQLite Aggregate Functions/03. Building with the SUM and TOTAL functions.wmv 3.3 MB
- 8. SQLite Aggregate Functions/05. Finding averages with AVG.wmv 3.0 MB
- 15. A Simple CRUD Application/06. Using PHP to delete from a SQLite database.wmv 2.9 MB
- 7. SQLite Core Functions/07. Rounding values with ROUND.wmv 2.7 MB
- 12. Subselects and Views/01. Understanding subselects.wmv 2.6 MB
- 15. A Simple CRUD Application/05. Using PHP to update a SQLite database.wmv 2.6 MB
- 0. Introduction/02. What is SQLite and what are the prerequisites.wmv 2.6 MB
- 7. SQLite Core Functions/04. Changing parts of a string with REPLACE.wmv 2.1 MB
- 7. SQLite Core Functions/08. Finding the data type of an expression with TYPEOF.wmv 2.1 MB
- 14. PHP Interfaces/01. Choosing an interface.wmv 1.9 MB
- 7. SQLite Core Functions/09. Finding the last inserted record with LAST_INSERT_ROWID.wmv 1.9 MB
- 7. SQLite Core Functions/10. Getting the version of your SQLite library.wmv 1.8 MB
- 7. SQLite Core Functions/06. Reading absolute values with ABS.wmv 1.8 MB
- 10. Sorting and Indexing/01. Understanding collation.wmv 1.8 MB
- 11. Transactions/01. Understanding transactions.wmv 1.7 MB
- 13. Triggers/01. Understanding triggers in SQLite.wmv 1.1 MB
- Ex_Files_SQLite_PHP_EssT.zip 441.5 KB
Download Torrent
Related Resources
Copyright Infringement
If the content above is not authorized, please contact us via anywarmservice[AT]gmail.com. Remember to include the full url in your complaint.