Lynda-com-SQLite-3-with--2Hkb
0. Introductio. Welcome.wmv42.42MB
0. Introduction03. Using the exercise files.wmv4.34MB
0. Introduction02. What is SQLite and what are the prerequisites.wmv2.57MB
1. Quick Start02. Creating and using a database.wmv24.48MB
1. Quick Start03. Inserting data into a table.wmv20.81MB
1. Quick Start07. Creating a database library.wmv15.18MB
1. Quick Start05. Updating data in a table.wmv10.88MB
1. Quick Start04. Getting data from a table.wmv10.75MB
1. Quick Start06. Deleting data from a table.wmv9.89MB
1. Quick Start01. Getting the most out of the quick start.wmv8.91MB
10. Sorting and Indexing06. Understanding how to use the INTEGER PRIRY KEY function.wmv10.68MB
10. Sorting and Indexing05. Working with priry key indexes.wmv6.95MB
10. Sorting and Indexing04. Understanding indexes.wmv5.22MB
10. Sorting and Indexing02. Sorting results with ORDER BY.wmv3.88MB
10. Sorting and Indexing03. Removing duplicate results with DISTINCT.wmv3.82MB
10. Sorting and Indexing01. Understanding collation.wmv1.75MB
11. Transactions02. Using transactions in SQLite.wmv13.72MB
11. Transactions01. Understanding transactions.wmv1.73MB
12. Subselects and Views04. Searching within a joined result.wmv9.43MB
12. Subselects and Views02. Creating a simple subselect.wmv5.17MB
12. Subselects and Views03. Searching within a result set.wmv4.86MB
12. Subselects and Views06. Searching within a joined view.wmv4.85MB
12. Subselects and Views05. Creating a view.wmv3.65MB
12. Subselects and Views01. Understanding subselects.wmv2.62MB
13. Triggers02. Autotically updating a table with a trigger.wmv13.30MB
13. Triggers05. Preventing unintended updates with triggers.wmv7.66MB
13. Triggers03. Logging transactions with triggers.wmv7.07MB
13. Triggers04. Improving perfornce with triggers.wmv5.64MB
13. Triggers06. Adding autotic time stamps.wmv5.58MB
13. Triggers01. Understanding triggers in SQLite.wmv1.14MB
14. PHP Interfaces04. Creating a library.wmv28.43MB
14. PHP Interfaces03. Using the PDO interface.wmv7.24MB
14. PHP Interfaces02. Using the SQLite3 interface.wmv6.74MB
14. PHP Interfaces01. Choosing an interface.wmv1.93MB
15. A Simple CRUD Application03. Using PHP to insert into a SQLite database.wmv9.62MB
15. A Simple CRUD Application02. Using PHP to open and use a SQLite database.wmv8.50MB
15. A Simple CRUD Applicatio. Defining CRUD.wmv7.80MB
15. A Simple CRUD Application04. Using PHP to read from a SQLite database.wmv5.52MB
15. A Simple CRUD Application06. Using PHP to delete from a SQLite database.wmv2.93MB
15. A Simple CRUD Application05. Using PHP to update a SQLite database.wmv2.59MB
16. An Application for Web Site Testimonials01. An overview of the testimonials application.wmv11.80MB
16. An Application for Web Site Testimonials02. naging the database in PHP.wmv9.91MB
16. An Application for Web Site Testimonials03. Displaying the testimonials using PHP.wmv6.96MB
2. Getting Started05. Using the comnd-line tools.wmv26.99MB
2. Getting Started04. Setting up SID and exercise files on a PC.wmv16.75MB
2. Getting Started03. Setting up SID and exercise files on a c.wmv16.56MB
2. Getting Started01. Installing XAMPP on a c.wmv13.61MB
2. Getting Started02. Installing XAMPP on a PC.wmv10.96MB
3. Creating a Database02. Creating a database.wmv13.03MB
3. Creating a Database03. Setting permissions for a database.wmv11.88MB
3. Creating a Database07. Indexing ID fields.wmv11.72MB
3. Creating a Database06. Creating indexes.wmv9.07MB
3. Creating a Database05. Creating a table in PHP.wmv7.17MB
3. Creating a Database04. Defining a table in SQL.wmv3.70MB
3. Creating a Database01. Understanding databases and tables in SQLite.wmv3.50MB
4. SQLite Data Types05. Storing large data with BLOB.wmv18.82MB
4. SQLite Data Types01. Taking care with data types in SQLite.wmv15.42MB
4. SQLite Data Types02. Storing numbers with INTEGER.wmv8.78MB
4. SQLite Data Types07. Storing dates and times.wmv6.93MB
4. SQLite Data Types04. Storing text.wmv5.22MB
4. SQLite Data Types06. Storing booleans.wmv3.75MB
4. SQLite Data Types03. Storing numbers with REAL.wmv3.53MB
5. Storing and Reading Data03. Reading data with SELECT.wmv11.13MB
5. Storing and Reading Data04. Reading data from multiple tables with JOIN.wmv10.63MB
5. Storing and Reading Data05. Deleting data with DELETE.wmv6.95MB
5. Storing and Reading Data04. Storing data with INSERT.wmv6.45MB
5. Storing and Reading Data02. Updating data with UPDATE.wmv5.23MB
6. SQLite Expressions03. tching patterns with LIKE.wmv9.70MB
6. SQLite Expressions02. Comparing values with comparison operators.wmv8.83MB
6. SQLite Expressions06. Choosing from multiple conditions with the CASE expression.wmv8.82MB
6. SQLite Expressions04. Building simple th with arithmetic operators.wmv4.81MB
6. SQLite Expressions05. tching values in a list with IN.wmv4.64MB
6. SQLite Expressions07. Forcing a data type with CAST.wmv4.11MB
6. SQLite Expressions01. Understanding expressions in SQLite.wmv3.96MB
7. SQLite Core Functions11. Creating user-defined functions.wmv11.30MB
7. SQLite Core Functions12. Building aggregate user-defined functions.wmv7.22MB
7. SQLite Core Functions03. Reading parts of a string with SUBSTR.wmv4.10MB
7. SQLite Core Functions02. Changing case with UPPER and LOWER.wmv3.64MB
7. SQLite Core Functions01. Finding the LENGTH of a string.wmv3.49MB
7. SQLite Core Functions05. Trimming blank spaces with TRIM.wmv3.35MB
7. SQLite Core Functions07. Rounding values with ROUND.wmv2.71MB
7. SQLite Core Functions04. Changing parts of a string with REPLACE.wmv2.12MB
7. SQLite Core Functions08. Finding the data type of an expression with TYPEOF.wmv2.06MB
7. SQLite Core Functions09. Finding the last inserted record with LAST_INSERT_ROWID.wmv1.91MB
7. SQLite Core Functions10. Getting the version of your SQLite library.wmv1.81MB
7. SQLite Core Functions06. Reading absolute values with ABS.wmv1.76MB
8. SQLite Aggregate Functions04. Finding minimum and ximum values with MIN and MAX.wmv7.68MB
8. SQLite Aggregate Functions02. Counting rows with COUNT.wmv5.64MB
8. SQLite Aggregate Functions07. Selecting for aggregation with HING.wmv3.77MB
8. SQLite Aggregate Functions01. Understanding aggregate functions.wmv3.76MB
8. SQLite Aggregate Functions06. Grouping results with GROUP BY.wmv3.72MB
8. SQLite Aggregate Functions03. Building with the SUM and TOTAL functions.wmv3.26MB
8. SQLite Aggregate Functions05. Finding erages with AVG.wmv3.04MB
9. SQLite Date and Time Functions01. Understanding SQLite support for dates and times.wmv7.53MB
9. SQLite Date and Time Functions03. Getting high-resolution dates and times with JULIANDAY.wmv6.89MB
9. SQLite Date and Time Functions02. Getting readable, sortable dates and times.wmv6.04MB
9. SQLite Date and Time Functions04. Fortting dates and times with STRFTIME.wmv5.50MB
Ex_Files_SQLite_PHP_EssT.zip441.50KB
- CreateTime2017-08-03
- UpdateTime2017-08-03
- FileTotalCount98
- TotalSize775.30MBHotTimes5ViewTimes15DMCA Report EmailmagnetLinkThunderTorrent DownBaiduYunLatest Search: 1.MIBD-524 2.OSR-005 3.FETI-022 4.UMD-043 5.AD-261 6.KTDS-513 7.MIBD-638 8.MCSR-073 9.HITMA-136 10.DSZS-07335 11.KCPZ-006 12.DVH-613 13.EMBM-005 14.MKCK-055 15.ASW-093 16.QEDZ-004 17.IDBD-266 18.RKI-140 19.ONSD-699 20.ONSD-189 21.MIBD-530 22.ONSD-620 23.ONSD-422 24.ONSD-590 25.EVDV-56101 26.SBR-001 27.SOE-725 28.MADV-224 29.OKAS-077 30.ONSD-491 31.INU-048 32.MIBD-486 33.MKCK-035 34.GLAM-002 35.IESP-214 36.SBB-085 37.IESP-416 38.SBNS-075 39.KIBD-073 40.MDYD-686 41.KIBD-045 42.FSET-409 43.RKI-241 44.JUSD-513 45.SCH-008 46.MVSD-190 47.NATR-114 48.MVMD-031 49.MIBD-463 50.RAM-003 51.ADV-0155 52.QXL-31 53.MMND-042 54.HODV-00193 55.DD-082 56.ALD-374 57.IMG-158 58.HS-115 59.IDBD-024 60.DYAN-005 61.GHFL-001 62.JTDV-012 63.ALX-413 64.CAD-1861 65.BTWD-007 66.ARMG-056 67.RD-032 68.MVD-066 69.KND-002 70.JUMP-086 71.265 72.20551 73.455 74.184 75.348 76.430 77.09 78.008 79.156 80.636 81.658 82.131 83.036 84.012 85.117 86.337 87.017 88.00661 89.227 90.659 91.101 92.754 93.017 94.286 95.001 96.024 97.447 98.273 99.039 100.047 101.226 102.650 103.001 104.112 105.316 106.016 107.567 108.724 109.016 110.006 111.63 112.850 113.082 114.047 115.06 116.200 117.67 118.716 119.026 120.220 121.119 122.025 123.806 124.110 125.003 126.35 127.485 128.028 129.088 130.050 131.131 132.020 133.009 134.013 135.044 136.001 137.017 138.300 139.012 140.147