589689.xyz

Lynda - SQLite 3 with PHP Essential Training

  • 收录时间:2018-03-21 07:28:41
  • 文件大小:775MB
  • 下载次数:15
  • 最近下载:2020-12-27 20:07:17
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 0. Introduction/01. Welcome.wmv 42MB
  2. 14. PHP Interfaces/04. Creating a library.wmv 28MB
  3. 2. Getting Started/05. Using the command-line tools.wmv 27MB
  4. 1. Quick Start/02. Creating and using a database.wmv 24MB
  5. 1. Quick Start/03. Inserting data into a table.wmv 21MB
  6. 4. SQLite Data Types/05. Storing large data with BLOB.wmv 19MB
  7. 2. Getting Started/04. Setting up SID and exercise files on a PC.wmv 17MB
  8. 2. Getting Started/03. Setting up SID and exercise files on a Mac.wmv 17MB
  9. 4. SQLite Data Types/01. Taking care with data types in SQLite.wmv 15MB
  10. 1. Quick Start/07. Creating a database library.wmv 15MB
  11. 11. Transactions/02. Using transactions in SQLite.wmv 14MB
  12. 2. Getting Started/01. Installing XAMPP on a Mac.wmv 14MB
  13. 13. Triggers/02. Automatically updating a table with a trigger.wmv 13MB
  14. 3. Creating a Database/02. Creating a database.wmv 13MB
  15. 3. Creating a Database/03. Setting permissions for a database.wmv 12MB
  16. 16. An Application for Web Site Testimonials/01. An overview of the testimonials application.wmv 12MB
  17. 3. Creating a Database/07. Indexing ID fields.wmv 12MB
  18. 7. SQLite Core Functions/11. Creating user-defined functions.wmv 11MB
  19. 5. Storing and Reading Data/03. Reading data with SELECT.wmv 11MB
  20. 2. Getting Started/02. Installing XAMPP on a PC.wmv 11MB
  21. 1. Quick Start/05. Updating data in a table.wmv 11MB
  22. 1. Quick Start/04. Getting data from a table.wmv 11MB
  23. 10. Sorting and Indexing/06. Understanding how to use the INTEGER PRIMARY KEY function.wmv 11MB
  24. 5. Storing and Reading Data/04. Reading data from multiple tables with JOIN.wmv 11MB
  25. 16. An Application for Web Site Testimonials/02. Managing the database in PHP.wmv 10MB
  26. 1. Quick Start/06. Deleting data from a table.wmv 10MB
  27. 6. SQLite Expressions/03. Matching patterns with LIKE.wmv 10MB
  28. 15. A Simple CRUD Application/03. Using PHP to insert into a SQLite database.wmv 10MB
  29. 12. Subselects and Views/04. Searching within a joined result.wmv 9MB
  30. 3. Creating a Database/06. Creating indexes.wmv 9MB
  31. 1. Quick Start/01. Getting the most out of the quick start.wmv 9MB
  32. 6. SQLite Expressions/02. Comparing values with comparison operators.wmv 9MB
  33. 6. SQLite Expressions/06. Choosing from multiple conditions with the CASE expression.wmv 9MB
  34. 4. SQLite Data Types/02. Storing numbers with INTEGER.wmv 9MB
  35. 15. A Simple CRUD Application/02. Using PHP to open and use a SQLite database.wmv 8MB
  36. 15. A Simple CRUD Application/01. Defining CRUD.wmv 8MB
  37. 8. SQLite Aggregate Functions/04. Finding minimum and maximum values with MIN and MAX.wmv 8MB
  38. 13. Triggers/05. Preventing unintended updates with triggers.wmv 8MB
  39. 9. SQLite Date and Time Functions/01. Understanding SQLite support for dates and times.wmv 8MB
  40. 14. PHP Interfaces/03. Using the PDO interface.wmv 7MB
  41. 7. SQLite Core Functions/12. Building aggregate user-defined functions.wmv 7MB
  42. 3. Creating a Database/05. Creating a table in PHP.wmv 7MB
  43. 13. Triggers/03. Logging transactions with triggers.wmv 7MB
  44. 16. An Application for Web Site Testimonials/03. Displaying the testimonials using PHP.wmv 7MB
  45. 5. Storing and Reading Data/05. Deleting data with DELETE.wmv 7MB
  46. 10. Sorting and Indexing/05. Working with primary key indexes.wmv 7MB
  47. 4. SQLite Data Types/07. Storing dates and times.wmv 7MB
  48. 9. SQLite Date and Time Functions/03. Getting high-resolution dates and times with JULIANDAY.wmv 7MB
  49. 14. PHP Interfaces/02. Using the SQLite3 interface.wmv 7MB
  50. 5. Storing and Reading Data/04. Storing data with INSERT.wmv 6MB
  51. 9. SQLite Date and Time Functions/02. Getting readable, sortable dates and times.wmv 6MB
  52. 8. SQLite Aggregate Functions/02. Counting rows with COUNT.wmv 6MB
  53. 13. Triggers/04. Improving performance with triggers.wmv 6MB
  54. 13. Triggers/06. Adding automatic time stamps.wmv 6MB
  55. 15. A Simple CRUD Application/04. Using PHP to read from a SQLite database.wmv 6MB
  56. 9. SQLite Date and Time Functions/04. Formatting dates and times with STRFTIME.wmv 6MB
  57. 5. Storing and Reading Data/02. Updating data with UPDATE.wmv 5MB
  58. 4. SQLite Data Types/04. Storing text.wmv 5MB
  59. 10. Sorting and Indexing/04. Understanding indexes.wmv 5MB
  60. 12. Subselects and Views/02. Creating a simple subselect.wmv 5MB
  61. 12. Subselects and Views/03. Searching within a result set.wmv 5MB
  62. 12. Subselects and Views/06. Searching within a joined view.wmv 5MB
  63. 6. SQLite Expressions/04. Building simple math with arithmetic operators.wmv 5MB
  64. 6. SQLite Expressions/05. Matching values in a list with IN.wmv 5MB
  65. 0. Introduction/03. Using the exercise files.wmv 4MB
  66. 6. SQLite Expressions/07. Forcing a data type with CAST.wmv 4MB
  67. 7. SQLite Core Functions/03. Reading parts of a string with SUBSTR.wmv 4MB
  68. 6. SQLite Expressions/01. Understanding expressions in SQLite.wmv 4MB
  69. 10. Sorting and Indexing/02. Sorting results with ORDER BY.wmv 4MB
  70. 10. Sorting and Indexing/03. Removing duplicate results with DISTINCT.wmv 4MB
  71. 8. SQLite Aggregate Functions/07. Selecting for aggregation with HAVING.wmv 4MB
  72. 8. SQLite Aggregate Functions/01. Understanding aggregate functions.wmv 4MB
  73. 4. SQLite Data Types/06. Storing booleans.wmv 4MB
  74. 8. SQLite Aggregate Functions/06. Grouping results with GROUP BY.wmv 4MB
  75. 3. Creating a Database/04. Defining a table in SQL.wmv 4MB
  76. 12. Subselects and Views/05. Creating a view.wmv 4MB
  77. 7. SQLite Core Functions/02. Changing case with UPPER and LOWER.wmv 4MB
  78. 4. SQLite Data Types/03. Storing numbers with REAL.wmv 4MB
  79. 3. Creating a Database/01. Understanding databases and tables in SQLite.wmv 3MB
  80. 7. SQLite Core Functions/01. Finding the LENGTH of a string.wmv 3MB
  81. 7. SQLite Core Functions/05. Trimming blank spaces with TRIM.wmv 3MB
  82. 8. SQLite Aggregate Functions/03. Building with the SUM and TOTAL functions.wmv 3MB
  83. 8. SQLite Aggregate Functions/05. Finding averages with AVG.wmv 3MB
  84. 15. A Simple CRUD Application/06. Using PHP to delete from a SQLite database.wmv 3MB
  85. 7. SQLite Core Functions/07. Rounding values with ROUND.wmv 3MB
  86. 12. Subselects and Views/01. Understanding subselects.wmv 3MB
  87. 15. A Simple CRUD Application/05. Using PHP to update a SQLite database.wmv 3MB
  88. 0. Introduction/02. What is SQLite and what are the prerequisites.wmv 3MB
  89. 7. SQLite Core Functions/04. Changing parts of a string with REPLACE.wmv 2MB
  90. 7. SQLite Core Functions/08. Finding the data type of an expression with TYPEOF.wmv 2MB
  91. 14. PHP Interfaces/01. Choosing an interface.wmv 2MB
  92. 7. SQLite Core Functions/09. Finding the last inserted record with LAST_INSERT_ROWID.wmv 2MB
  93. 7. SQLite Core Functions/10. Getting the version of your SQLite library.wmv 2MB
  94. 7. SQLite Core Functions/06. Reading absolute values with ABS.wmv 2MB
  95. 10. Sorting and Indexing/01. Understanding collation.wmv 2MB
  96. 11. Transactions/01. Understanding transactions.wmv 2MB
  97. 13. Triggers/01. Understanding triggers in SQLite.wmv 1MB
  98. ExerciseFiles/SQL/world-sqlite3.sql 374KB
  99. ExerciseFiles/Chap04/bigfile.txt 312KB
  100. ExerciseFiles/SQL/world.db 230KB
  101. ExerciseFiles/Chap04/olives.jpg 139KB
  102. ExerciseFiles/Chap11/inserts.sql 70KB
  103. ExerciseFiles/CRUD/crud.php 28KB
  104. ExerciseFiles/SID/sid.php 15KB
  105. ExerciseFiles/Testimonials/db.php 8KB
  106. ExerciseFiles/SQL/album-sqlite3.sql 8KB
  107. ExerciseFiles/Testimonials/lib/bwSQLite3.php 8KB
  108. ExerciseFiles/lib/bwSQLite3.php 8KB
  109. ExerciseFiles/Chap14/test-bwSQLite3.php 6KB
  110. ExerciseFiles/lib/test-bwSQLite3.php 6KB
  111. ExerciseFiles/Chap13/13_examples.sql 6KB
  112. ExerciseFiles/SQL/album.db 5KB
  113. ExerciseFiles/SQL/test.db 5KB
  114. ExerciseFiles/Chap01/simpledb.php 4KB
  115. ExerciseFiles/Testimonials/data/testimonials.db 4KB
  116. ExerciseFiles/Chap01/delete-end.php 4KB
  117. ExerciseFiles/Chap01/insert-end.php 4KB
  118. ExerciseFiles/Chap01/update-end.php 4KB
  119. ExerciseFiles/Chap01/retrieve-end.php 4KB
  120. ExerciseFiles/Chap11/11_examples.sql 4KB
  121. ExerciseFiles/Chap07/07_examples.sql 3KB
  122. ExerciseFiles/CRUD/css/main.css 3KB
  123. ExerciseFiles/Chap01/create-end.php 3KB
  124. ExerciseFiles/Chap01/start.php 3KB
  125. ExerciseFiles/assets/main.css 3KB
  126. ExerciseFiles/SID/css/main.css 3KB
  127. ExerciseFiles/Chap12/12_examples.sql 3KB
  128. ExerciseFiles/Chap14/14-example-SQLite3.php 3KB
  129. ExerciseFiles/Chap14/14-example-PDO.php 3KB
  130. ExerciseFiles/Chap04/blob-end.php 2KB
  131. ExerciseFiles/Testimonials/assets/db.css 2KB
  132. ExerciseFiles/Chap03/createdatabase-bwSQLite3.php 2KB
  133. ExerciseFiles/Chap03/createdatabase-PDO.php 2KB
  134. ExerciseFiles/Chap03/createdatabase-SQLite3.php 2KB
  135. ExerciseFiles/Chap01/create-start.php 2KB
  136. ExerciseFiles/Chap03/createtable-end.php 2KB
  137. ExerciseFiles/Testimonials/testimonials.php 2KB
  138. ExerciseFiles/Chap05/05_examples.sql 2KB
  139. ExerciseFiles/SQL/test-sqlite3.sql 2KB
  140. ExerciseFiles/Chap06/06_examples.sql 2KB
  141. ExerciseFiles/Chap04/start.php 2KB
  142. ExerciseFiles/start.php 2KB
  143. ExerciseFiles/Chap03/start.php 2KB
  144. ExerciseFiles/Testimonials/testpage.php 2KB
  145. ExerciseFiles/Chap09/09_examples.sql 2KB
  146. ExerciseFiles/Chap10/10_examples.sql 2KB
  147. ExerciseFiles/CRUD/assets/main.php 1KB
  148. ExerciseFiles/Chap08/08_examples.sql 1KB
  149. ExerciseFiles/Testimonials/assets/main.css 1KB
  150. ExerciseFiles/CRUD/assets/bw.ico 1KB
  151. ExerciseFiles/SID/assets/bw.ico 1KB
  152. ExerciseFiles/assets/bw.ico 1KB
  153. ExerciseFiles/Testimonials/assets/main.php 778B
  154. ExerciseFiles/Testimonials/assets/edit.php 736B
  155. ExerciseFiles/SID/assets/main.php 714B
  156. ExerciseFiles/Testimonials/assets/recline.php 673B
  157. ExerciseFiles/Testimonials/assets/delconfirm.php 564B
  158. ExerciseFiles/CRUD/assets/header.php 484B
  159. ExerciseFiles/assets/header.php 469B
  160. ExerciseFiles/SID/assets/header.php 461B
  161. ExerciseFiles/SID/assets/test-header.php 460B
  162. ExerciseFiles/Testimonials/assets/header.php 414B
  163. ExerciseFiles/Testimonials/assets/footer.php 377B
  164. ExerciseFiles/SID/css/index.html 260B
  165. ExerciseFiles/CRUD/css/index.html 260B
  166. ExerciseFiles/CRUD/assets/index.html 260B
  167. ExerciseFiles/assets/index.html 260B
  168. ExerciseFiles/SID/assets/index.html 260B
  169. ExerciseFiles/assets/footer.php 245B
  170. ExerciseFiles/SID/assets/footer.php 239B
  171. ExerciseFiles/CRUD/assets/footer.php 207B
  172. ExerciseFiles/SID/assets/test-footer.php 161B
  173. ExerciseFiles/CRUD/assets/plain.php 151B
  174. ExerciseFiles/SID/assets/test-main.php 130B
  175. ExerciseFiles/assets/body.php 130B
  176. ExerciseFiles/Testimonials/assets/nextprev.php 130B