Lynda com SQLite with PHP Essential Training | 320709EA1DDE37BE3F718B213BAD0287377B4B67

Lynda com SQLite with PHP Essential Training

Name	Lynda.com - SQLite 3 with PHP Essential Training	DOWNLOAD Copy Link
Total Size	811.9 MB
Total Files	98
Hash	320709EA1DDE37BE3F718B213BAD0287377B4B67

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