Lynda - SQLite 3 with PHP Essential Training

1. 0. Introduction/01. Welcome.wmv42.42MB
2. 14. PHP Interfaces/04. Creating a library.wmv28.43MB
3. 2. Getting Started/05. Using the command-line tools.wmv26.99MB
4. 1. Quick Start/02. Creating and using a database.wmv24.48MB
5. 1. Quick Start/03. Inserting data into a table.wmv20.81MB
6. 4. SQLite Data Types/05. Storing large data with BLOB.wmv18.82MB
7. 2. Getting Started/04. Setting up SID and exercise files on a PC.wmv16.75MB
8. 2. Getting Started/03. Setting up SID and exercise files on a Mac.wmv16.56MB
9. 4. SQLite Data Types/01. Taking care with data types in SQLite.wmv15.42MB
10. 1. Quick Start/07. Creating a database library.wmv15.18MB
11. 11. Transactions/02. Using transactions in SQLite.wmv13.72MB
12. 2. Getting Started/01. Installing XAMPP on a Mac.wmv13.61MB
13. 13. Triggers/02. Automatically updating a table with a trigger.wmv13.3MB
14. 3. Creating a Database/02. Creating a database.wmv13.03MB
15. 3. Creating a Database/03. Setting permissions for a database.wmv11.88MB
16. 16. An Application for Web Site Testimonials/01. An overview of the testimonials application.wmv11.8MB
17. 3. Creating a Database/07. Indexing ID fields.wmv11.72MB
18. 7. SQLite Core Functions/11. Creating user-defined functions.wmv11.3MB
19. 5. Storing and Reading Data/03. Reading data with SELECT.wmv11.13MB
20. 2. Getting Started/02. Installing XAMPP on a PC.wmv10.96MB
21. 1. Quick Start/05. Updating data in a table.wmv10.88MB
22. 1. Quick Start/04. Getting data from a table.wmv10.75MB
23. 10. Sorting and Indexing/06. Understanding how to use the INTEGER PRIMARY KEY function.wmv10.68MB
24. 5. Storing and Reading Data/04. Reading data from multiple tables with JOIN.wmv10.63MB
25. 16. An Application for Web Site Testimonials/02. Managing the database in PHP.wmv9.91MB
26. 1. Quick Start/06. Deleting data from a table.wmv9.89MB
27. 6. SQLite Expressions/03. Matching patterns with LIKE.wmv9.7MB
28. 15. A Simple CRUD Application/03. Using PHP to insert into a SQLite database.wmv9.62MB
29. 12. Subselects and Views/04. Searching within a joined result.wmv9.43MB
30. 3. Creating a Database/06. Creating indexes.wmv9.07MB
31. 1. Quick Start/01. Getting the most out of the quick start.wmv8.91MB
32. 6. SQLite Expressions/02. Comparing values with comparison operators.wmv8.83MB
33. 6. SQLite Expressions/06. Choosing from multiple conditions with the CASE expression.wmv8.82MB
34. 4. SQLite Data Types/02. Storing numbers with INTEGER.wmv8.78MB
35. 15. A Simple CRUD Application/02. Using PHP to open and use a SQLite database.wmv8.5MB
36. 15. A Simple CRUD Application/01. Defining CRUD.wmv7.8MB
37. 8. SQLite Aggregate Functions/04. Finding minimum and maximum values with MIN and MAX.wmv7.68MB
38. 13. Triggers/05. Preventing unintended updates with triggers.wmv7.66MB
39. 9. SQLite Date and Time Functions/01. Understanding SQLite support for dates and times.wmv7.53MB
40. 14. PHP Interfaces/03. Using the PDO interface.wmv7.24MB
41. 7. SQLite Core Functions/12. Building aggregate user-defined functions.wmv7.22MB
42. 3. Creating a Database/05. Creating a table in PHP.wmv7.17MB
43. 13. Triggers/03. Logging transactions with triggers.wmv7.07MB
44. 16. An Application for Web Site Testimonials/03. Displaying the testimonials using PHP.wmv6.96MB
45. 5. Storing and Reading Data/05. Deleting data with DELETE.wmv6.95MB
46. 10. Sorting and Indexing/05. Working with primary key indexes.wmv6.95MB
47. 4. SQLite Data Types/07. Storing dates and times.wmv6.93MB
48. 9. SQLite Date and Time Functions/03. Getting high-resolution dates and times with JULIANDAY.wmv6.89MB
49. 14. PHP Interfaces/02. Using the SQLite3 interface.wmv6.74MB
50. 5. Storing and Reading Data/04. Storing data with INSERT.wmv6.45MB
51. 9. SQLite Date and Time Functions/02. Getting readable, sortable dates and times.wmv6.04MB
52. 8. SQLite Aggregate Functions/02. Counting rows with COUNT.wmv5.64MB
53. 13. Triggers/04. Improving performance with triggers.wmv5.64MB
54. 13. Triggers/06. Adding automatic time stamps.wmv5.58MB
55. 15. A Simple CRUD Application/04. Using PHP to read from a SQLite database.wmv5.52MB
56. 9. SQLite Date and Time Functions/04. Formatting dates and times with STRFTIME.wmv5.5MB
57. 5. Storing and Reading Data/02. Updating data with UPDATE.wmv5.23MB
58. 4. SQLite Data Types/04. Storing text.wmv5.22MB
59. 10. Sorting and Indexing/04. Understanding indexes.wmv5.22MB
60. 12. Subselects and Views/02. Creating a simple subselect.wmv5.17MB
61. 12. Subselects and Views/03. Searching within a result set.wmv4.86MB
62. 12. Subselects and Views/06. Searching within a joined view.wmv4.85MB
63. 6. SQLite Expressions/04. Building simple math with arithmetic operators.wmv4.81MB
64. 6. SQLite Expressions/05. Matching values in a list with IN.wmv4.64MB
65. 0. Introduction/03. Using the exercise files.wmv4.34MB
66. 6. SQLite Expressions/07. Forcing a data type with CAST.wmv4.11MB
67. 7. SQLite Core Functions/03. Reading parts of a string with SUBSTR.wmv4.1MB
68. 6. SQLite Expressions/01. Understanding expressions in SQLite.wmv3.96MB
69. 10. Sorting and Indexing/02. Sorting results with ORDER BY.wmv3.88MB
70. 10. Sorting and Indexing/03. Removing duplicate results with DISTINCT.wmv3.82MB
71. 8. SQLite Aggregate Functions/07. Selecting for aggregation with HAVING.wmv3.77MB
72. 8. SQLite Aggregate Functions/01. Understanding aggregate functions.wmv3.76MB
73. 4. SQLite Data Types/06. Storing booleans.wmv3.75MB
74. 8. SQLite Aggregate Functions/06. Grouping results with GROUP BY.wmv3.72MB
75. 3. Creating a Database/04. Defining a table in SQL.wmv3.7MB
76. 12. Subselects and Views/05. Creating a view.wmv3.65MB
77. 7. SQLite Core Functions/02. Changing case with UPPER and LOWER.wmv3.64MB
78. 4. SQLite Data Types/03. Storing numbers with REAL.wmv3.53MB
79. 3. Creating a Database/01. Understanding databases and tables in SQLite.wmv3.5MB
80. 7. SQLite Core Functions/01. Finding the LENGTH of a string.wmv3.49MB
81. 7. SQLite Core Functions/05. Trimming blank spaces with TRIM.wmv3.35MB
82. 8. SQLite Aggregate Functions/03. Building with the SUM and TOTAL functions.wmv3.26MB
83. 8. SQLite Aggregate Functions/05. Finding averages with AVG.wmv3.04MB
84. 15. A Simple CRUD Application/06. Using PHP to delete from a SQLite database.wmv2.93MB
85. 7. SQLite Core Functions/07. Rounding values with ROUND.wmv2.71MB
86. 12. Subselects and Views/01. Understanding subselects.wmv2.62MB
87. 15. A Simple CRUD Application/05. Using PHP to update a SQLite database.wmv2.59MB
88. 0. Introduction/02. What is SQLite and what are the prerequisites.wmv2.57MB
89. 7. SQLite Core Functions/04. Changing parts of a string with REPLACE.wmv2.12MB
90. 7. SQLite Core Functions/08. Finding the data type of an expression with TYPEOF.wmv2.06MB
91. 14. PHP Interfaces/01. Choosing an interface.wmv1.93MB
92. 7. SQLite Core Functions/09. Finding the last inserted record with LAST_INSERT_ROWID.wmv1.91MB
93. 7. SQLite Core Functions/10. Getting the version of your SQLite library.wmv1.81MB
94. 7. SQLite Core Functions/06. Reading absolute values with ABS.wmv1.76MB
95. 10. Sorting and Indexing/01. Understanding collation.wmv1.75MB
96. 11. Transactions/01. Understanding transactions.wmv1.73MB
97. 13. Triggers/01. Understanding triggers in SQLite.wmv1.14MB