Lynda SQLite with PHP Essential Training | B686651AAEB56B9471CAAAD10AAD7D22CC0A1748

Lynda SQLite with PHP Essential Training

Name	Lynda - SQLite 3 with PHP Essential Training	DOWNLOAD Copy Link
Total Size	812.8 MB
Total Files	176
Hash	B686651AAEB56B9471CAAAD10AAD7D22CC0A1748

/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
/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
/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
/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
/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
/11. Transactions/
02. Using transactions in SQLite.wmv	14.4 MB
01. Understanding transactions.wmv	1.8 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
/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
/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
/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
/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
/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
/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
/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
/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
/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
/ExerciseFiles/SQL/
world-sqlite3.sql	383.3 KB
world.db	235.5 KB
album-sqlite3.sql	8.0 KB
album.db	5.1 KB
test.db	5.1 KB
test-sqlite3.sql	2.1 KB
/ExerciseFiles/Chap04/
bigfile.txt	320.0 KB
olives.jpg	142.3 KB
blob-end.php	2.6 KB
start.php	2.0 KB
/ExerciseFiles/Chap11/
inserts.sql	72.0 KB
11_examples.sql	3.6 KB
/ExerciseFiles/CRUD/
crud.php	28.3 KB
/ExerciseFiles/SID/
sid.php	15.3 KB
/ExerciseFiles/Testimonials/
db.php	8.3 KB
testimonials.php	2.1 KB
testpage.php	1.8 KB
/ExerciseFiles/Testimonials/lib/
bwSQLite3.php	8.0 KB
/ExerciseFiles/lib/
bwSQLite3.php	8.0 KB
test-bwSQLite3.php	5.9 KB
/ExerciseFiles/Chap14/
test-bwSQLite3.php	5.9 KB
14-example-SQLite3.php	2.9 KB
14-example-PDO.php	2.8 KB
/ExerciseFiles/Chap13/
13_examples.sql	5.7 KB
/ExerciseFiles/Chap01/
simpledb.php	4.6 KB
delete-end.php	4.0 KB
insert-end.php	4.0 KB
update-end.php	3.9 KB
retrieve-end.php	3.7 KB
create-end.php	3.2 KB
start.php	3.2 KB
create-start.php	2.3 KB
/ExerciseFiles/Testimonials/data/
testimonials.db	4.1 KB
/ExerciseFiles/Chap07/
07_examples.sql	3.5 KB
/ExerciseFiles/CRUD/css/
main.css	3.4 KB
index.html	0.3 KB
/ExerciseFiles/assets/
main.css	3.1 KB
bw.ico	1.1 KB
header.php	0.5 KB
index.html	0.3 KB
footer.php	0.2 KB
body.php	0.1 KB
/ExerciseFiles/SID/css/
main.css	3.1 KB
index.html	0.3 KB
/ExerciseFiles/Chap12/
12_examples.sql	3.0 KB
/ExerciseFiles/Testimonials/assets/
db.css	2.5 KB
main.css	1.2 KB
main.php	0.8 KB
edit.php	0.7 KB
recline.php	0.7 KB
delconfirm.php	0.6 KB
header.php	0.4 KB
footer.php	0.4 KB
nextprev.php	0.1 KB
/ExerciseFiles/Chap03/
createdatabase-bwSQLite3.php	2.4 KB
createdatabase-PDO.php	2.4 KB
createdatabase-SQLite3.php	2.4 KB
createtable-end.php	2.2 KB
start.php	1.9 KB
/ExerciseFiles/Chap05/
05_examples.sql	2.1 KB
/ExerciseFiles/Chap06/
06_examples.sql	2.1 KB
/ExerciseFiles/
start.php	2.0 KB
/ExerciseFiles/Chap09/
09_examples.sql	1.8 KB
/ExerciseFiles/Chap10/
10_examples.sql	1.6 KB
/ExerciseFiles/CRUD/assets/
main.php	1.5 KB
bw.ico	1.1 KB
header.php	0.5 KB
index.html	0.3 KB
footer.php	0.2 KB
plain.php	0.2 KB
/ExerciseFiles/Chap08/
08_examples.sql	1.3 KB
/ExerciseFiles/SID/assets/
bw.ico	1.1 KB
main.php	0.7 KB
header.php	0.5 KB
test-header.php	0.5 KB
index.html	0.3 KB
footer.php	0.2 KB
test-footer.php	0.2 KB
test-main.php	0.1 KB
Total files 176