Lynda com SQLite with PHP Essential Training | 63908F3781228DB127330C824386BB939C0E6EF8

Lynda com SQLite with PHP Essential Training

Name	Lynda.com - SQLite 3 with PHP Essential Training	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	811.9 MB
Total Files	98
Hash	63908F3781228DB127330C824386BB939C0E6EF8

/0. Introduction/
01. Welcome.wmv	44.5 MB
02. What is SQLite and what are the prerequisites.wmv	2.7 MB
03. Using the exercise files.wmv	4.5 MB
/1. Quick Start/
01. Getting the most out of the quick start.wmv	9.3 MB
02. Creating and using a database.wmv	25.7 MB
03. Inserting data into a table.wmv	21.8 MB
04. Getting data from a table.wmv	11.3 MB
05. Updating data in a table.wmv	11.4 MB
06. Deleting data from a table.wmv	10.4 MB
07. Creating a database library.wmv	15.9 MB
/10. Sorting and Indexing/
01. Understanding collation.wmv	1.8 MB
02. Sorting results with ORDER BY.wmv	4.1 MB
03. Removing duplicate results with DISTINCT.wmv	4.0 MB
04. Understanding indexes.wmv	5.5 MB
05. Working with primary key indexes.wmv	7.3 MB
06. Understanding how to use the INTEGER PRIMARY KEY function.wmv	11.2 MB
/11. Transactions/
01. Understanding transactions.wmv	1.8 MB
02. Using transactions in SQLite.wmv	14.4 MB
/12. Subselects and Views/
01. Understanding subselects.wmv	2.7 MB
02. Creating a simple subselect.wmv	5.4 MB
03. Searching within a result set.wmv	5.1 MB
04. Searching within a joined result.wmv	9.9 MB
05. Creating a view.wmv	3.8 MB
06. Searching within a joined view.wmv	5.1 MB
/13. Triggers/
01. Understanding triggers in SQLite.wmv	1.2 MB
02. Automatically updating a table with a trigger.wmv	13.9 MB
03. Logging transactions with triggers.wmv	7.4 MB
04. Improving performance with triggers.wmv	5.9 MB
05. Preventing unintended updates with triggers.wmv	8.0 MB
06. Adding automatic time stamps.wmv	5.9 MB
/14. PHP Interfaces/
01. Choosing an interface.wmv	2.0 MB
02. Using the SQLite3 interface.wmv	7.1 MB
03. Using the PDO interface.wmv	7.6 MB
04. Creating a library.wmv	29.8 MB
/15. A Simple CRUD Application/
01. Defining CRUD.wmv	8.2 MB
02. Using PHP to open and use a SQLite database.wmv	8.9 MB
03. Using PHP to insert into a SQLite database.wmv	10.1 MB
04. Using PHP to read from a SQLite database.wmv	5.8 MB
05. Using PHP to update a SQLite database.wmv	2.7 MB
06. Using PHP to delete from a SQLite database.wmv	3.1 MB
/16. An Application for Web Site Testimonials/
01. An overview of the testimonials application.wmv	12.4 MB
02. Managing the database in PHP.wmv	10.4 MB
03. Displaying the testimonials using PHP.wmv	7.3 MB
/2. Getting Started/
01. Installing XAMPP on a Mac.wmv	14.3 MB
02. Installing XAMPP on a PC.wmv	11.5 MB
03. Setting up SID and exercise files on a Mac.wmv	17.4 MB
04. Setting up SID and exercise files on a PC.wmv	17.6 MB
05. Using the command-line tools.wmv	28.3 MB
/3. Creating a Database/
01. Understanding databases and tables in SQLite.wmv	3.7 MB
02. Creating a database.wmv	13.7 MB
03. Setting permissions for a database.wmv	12.5 MB
04. Defining a table in SQL.wmv	3.9 MB
05. Creating a table in PHP.wmv	7.5 MB
06. Creating indexes.wmv	9.5 MB
07. Indexing ID fields.wmv	12.3 MB
/4. SQLite Data Types/
01. Taking care with data types in SQLite.wmv	16.2 MB
02. Storing numbers with INTEGER.wmv	9.2 MB
03. Storing numbers with REAL.wmv	3.7 MB
04. Storing text.wmv	5.5 MB
05. Storing large data with BLOB.wmv	19.7 MB
06. Storing booleans.wmv	3.9 MB
07. Storing dates and times.wmv	7.3 MB
/5. Storing and Reading Data/
02. Updating data with UPDATE.wmv	5.5 MB
03. Reading data with SELECT.wmv	11.7 MB
04. Reading data from multiple tables with JOIN.wmv	11.2 MB
04. Storing data with INSERT.wmv	6.8 MB
05. Deleting data with DELETE.wmv	7.3 MB
/6. SQLite Expressions/
01. Understanding expressions in SQLite.wmv	4.2 MB
02. Comparing values with comparison operators.wmv	9.3 MB
03. Matching patterns with LIKE.wmv	10.2 MB
04. Building simple math with arithmetic operators.wmv	5.0 MB
05. Matching values in a list with IN.wmv	4.9 MB
06. Choosing from multiple conditions with the CASE expression.wmv	9.2 MB
07. Forcing a data type with CAST.wmv	4.3 MB
/7. SQLite Core Functions/
01. Finding the LENGTH of a string.wmv	3.7 MB
02. Changing case with UPPER and LOWER.wmv	3.8 MB
03. Reading parts of a string with SUBSTR.wmv	4.3 MB
04. Changing parts of a string with REPLACE.wmv	2.2 MB
05. Trimming blank spaces with TRIM.wmv	3.5 MB
06. Reading absolute values with ABS.wmv	1.8 MB
07. Rounding values with ROUND.wmv	2.8 MB
08. Finding the data type of an expression with TYPEOF.wmv	2.2 MB
09. Finding the last inserted record with LAST_INSERT_ROWID.wmv	2.0 MB
10. Getting the version of your SQLite library.wmv	1.9 MB
11. Creating user-defined functions.wmv	11.8 MB
12. Building aggregate user-defined functions.wmv	7.6 MB
/8. SQLite Aggregate Functions/
01. Understanding aggregate functions.wmv	3.9 MB
02. Counting rows with COUNT.wmv	5.9 MB
03. Building with the SUM and TOTAL functions.wmv	3.4 MB
04. Finding minimum and maximum values with MIN and MAX.wmv	8.1 MB
05. Finding averages with AVG.wmv	3.2 MB
06. Grouping results with GROUP BY.wmv	3.9 MB
07. Selecting for aggregation with HAVING.wmv	4.0 MB
/9. SQLite Date and Time Functions/
01. Understanding SQLite support for dates and times.wmv	7.9 MB
02. Getting readable, sortable dates and times.wmv	6.3 MB
03. Getting high-resolution dates and times with JULIANDAY.wmv	7.2 MB
04. Formatting dates and times with STRFTIME.wmv	5.8 MB
/
Ex_Files_SQLite_PHP_EssT.zip	452.1 KB
Total files 98