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